DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Sunday, July 16, 2017

      ORA-01994: GRANT failed: password file missing or disabled  



Granting sysdba privilege to user requires password file or else it would throw an error as ORA-01994.


Problem:

I hit this error when I was trying to give sysdba privilege to one of the database user account which need to configure the snapshot backup from OS level.


 SQL> grant sysdba to snapshot;
ORA-01994: GRANT failed: password file missing or disabled

Solution:

1. Create a password file from os:

orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=test2sys entries=5 force=y

And now grant the user 

SQL> grant sysdba to snapshot;


To verify:


SQL> select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP
------------------------------ ----- -----
SYS                                    TRUE  TRUE
SNAPSHOT                       TRUE  FALSE

Before if you have crosschecked this v$pwfile_users it doesn't show snapshot user . 





No comments: