About Oracle Login failures with Administrator account

Source: Internet
Author: User
Tags administrator password

I built the Oracle database in the debugging of their own stored procedures to write the prompt for the lack of debug Connect session permissions, under the general circumstances under this prompt directly with the Administrator account log in, execute

Grant debug connect session to ' Your user name ' sql is OK, but the problem comes, when I use Sqlplus/nolog in the Command Prompt window, and then use the Conn/as sysdba command to log in, will prompt Ora-01031:insufficient privileges Invalid permissions such an error,

Have encountered before, the Internet to find a lot of relevant content, but eventually did not fix.

This problem has finally been solved today and is now put in place so that others can see similar problems.

In fact, this issue involves the password file reset problem, as long as the password reset, and then you can use Conn Sys/yournewcode as sysdba such form of login Administrator account, and then to the ordinary user authorization corresponding permissions can solve the problem.

  The first step is to reset the password file , first find the installation path of your Oracle's password file, and the path to my installation directory is: C:\app\Wei\product\11.2.0\dbhome_1\database\ Pwdorcl2.ora, here I'm going to put my own map of the local installation path,

Open a Command Prompt window, and then execute the following command:

OPW-00001: Unable to open the password file, there is a hint that you do not use the Administrator login command prompt, so, then use administrator to log in

Command Prompt window, and then execute the command to reset the password file, as follows,

There is no error, indicating that the password file reset was successful. Note Orapwd File=c:/app/wei/product/11.2.0/dbhome_1/database/pwdorcl2.ora password=admin entries=40 force=y;

This line of command in the Password=admin Admin, this password is your future administrator password, of course, if you forget the password, you can also re-execute this command,

Change the password to the one you want.

The second step is to use the DBA Administrator account to log in to Oracle and authorize the user.

Conn Sys/admin as Sysdba the admin in this command is the first step to use

Orapwd File=c:/app/wei/product/11.2.0/dbhome_1/database/pwdorcl2.ora password=admin entries=40 force=y;

The admin in this command.

Step is divided into these two steps. Note: Be sure to log in to the command prompt with administrator when resetting the password file.

About Oracle Login failures with Administrator account

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.