ORA-01994 : Grant failed: passwd file missing or disabled

[tekpr00]

Hello All,

I recently upgraded my database from 10.2.03 to 10.2.04....

there are several databases on the server..I noticed that my OEM is continuing to run backup job for some and the not others. The OEM errored out with "Database is closed" for the failed back up jobs. I know for a fact that the database is open. I went to log into the databases from my desktop using connect sys@mydb I got ERROR ORA-O1031: insufficient privileges..

So, I logged on to the database server and logged in as sysdba...I querried:
select * from v$pwfile_users

no rows selected..

grant SYSDBA to SYS ;
ORA-001994 GRANT failed assword file is missing or disabled.
so, I made sure my $ORACLE_SID=mydb, and went to $ORCLE_HOME where I issued;
orapwd file=orapwmydb passwd=pwd entries=5
surprisingly it created the orapwmydb in $ORACLE_HOME/bin instead of $ORACLE_HOME/dbs... but I copied the file over to $ORACLE_HOME/dbs and restarted the instance.

However, I'm still getting the error

ORA-001994 GRANT failed assword file is missing or disabled.


please help

 

[Turkbear]

Hi,
This site seems to indicate a second step - add info to the init<sid>.ora file:

http://ora-01994.ora-code.com/

To Paraphrase:"The Help you get is proportional to the Help you give.."