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