ORA-01994 - And MetaLink is wrong 1

[DrSeussFreak]

I am running a grant and look below for all the details

SQL> grant sysdba to <USER>;
grant sysdba to <USER>
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled

Meta-Link says

Error: ORA 1994
Text: GRANT failed: cannot add users to public password file
-------------------------------------------------------------------------------
Cause: A grant failed because a user could not be added to the password file.
This is because the value of the <Parameter:REMOTE_LOGIN_PASSWORDFILE>
initialization parameter is not set to EXCLUSIVE
Action: To add a user to the password file, shutdown the database, change the
REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE and
restart the database.

but when I look at the parameter, I get

SQL> show parameter REMOTE_LOGIN_PASSWORDFILE

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
SQL>

Any ideas?

 

[DrSeussFreak]

nevermind, we recently upgraded from oracle 10.1 to 10.2 and since we made a new oracle home, I had to copy the oracle pw file from the old home to the new home.

 

[SantaMufasa]

ORA-01994 - And MetaLink is wrong

To be more precise, the error description is probably incomplete. The missing cause, in your case, is very likely that the password file itself does not exist. Have you, in fact, created an Oracle password file for the database instance in question?


If you do not know, with certainty, whether or not a valid Oracle password file exists, you can check for it in your "ORACLE_HOME/database" directory. The file name should be in the form "PWD<SID>.ORA", where <SID> is the name of your Oracle Instance.

If it exists (but you are not certain if it is valid), then you can recreate it by, first, deleting that file, then re-creating that file. To recreate that file, use this utility command at your o/s prompt:

orapwd file=%ORACLE_HOME%\database\pwd<sid>.ora password=<SYSDBA password> entries=<Max # of SYSDBAs>

In the above format, replace all entries inside of "<...>" with values specific to your environment. Also pay attention to proper "direction" of slashes for your o/s.

You can obtain basic help on the "orapwd" command by simply issuing the command, without arguments, at your o/s prompt (Example):

C:\>orapwd
Usage: orapwd file=<fname> password=<password> entries=<users>

  where
    file - name of password file (mand),
    password - password for SYS (mand),
    entries - maximum number of distinct DBA and OPERs (opt),
  There are no spaces around the equal-to (=) character.

C:\>

Let us know if you have additional questions.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[SantaMufasa]

Sorry...I didn't see your earlier "Never mind..." posting...So...

Never mind. <grin>

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[DrSeussFreak]

I appreciate the response anyways