Oracle Password file suspected invalid
Joey TanJul 25 2012 — edited Aug 22 2012Hi ,
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.