Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Password file suspected invalid

Joey TanJul 25 2012 — edited Aug 22 2012
Hi ,
Im trying to grant a user with a SYSDBA privillage. I encounter this error ERROR at line 1:ORA-01994: GRANT failed: password file missing or disabled.
I know is a common error. But I check from the web and metalink but none helps. I have created the file with ,
orapwd file=/u01/app/oracle/product/11.2.0/db_bi1/dbs/orapwUBISIT.ora password=sysdba entries=30 force=y

Check the file really exist in linux. The file permission is 4640. Is own by oracle:dba . The ORACLE_SID is UBISIT. Tried creating the password file with $UBISIT.ora and $UBISITwithout the .ora . But none avail. Base on the command below I found select * from v$pwfile_users; is not returning an rows record.
Suspected it couldnt find the oracle password file. Is there any way to determine that my oracle is pointing to the file ? Any command like show passwordfile directory or something like this ?

-----
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 26 10:28:55 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.

SQL> conn as sysdba
Enter user-name: sysdba
Enter password:
Connected.

SQL> grant SYSDBA o to SIEBELDW;
grant SYSDBA to SIEBELDW
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled


SQL> select * from v$pwfile_users;

no rows selected

SQL> show parameter password;

NAME TYPE VALUE
remote_login_passwordfile string EXCLUSIVE
SQL>

-----


Thanks You
Joey Tan.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 19 2012
Added on Jul 25 2012
3 comments
1,774 views