Friday, January 20, 2012

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

You try to grant sysdba privilege to a user. You can see below error
ORA-01994: GRANT failed: password file missing or disabled.

User doesn’t have sysdba privilege
Solutions
1.      Log  on to the server

$orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=password entries=10

2.      Grant Sysdba privilege to the user 
      grant sysdba to <user>

3.      Check v$pwfile_users to verify the prvilege

4.       Check owner,group  of orapw$ORACLE_SID

5.      If it is not   to oracle and  dba , then change the ownership
chown oracle:dba orapw$ORACLE_SID

No comments:

Post a Comment