ora - 01994
orapwd file=orapwdfile entries=5
My database showed
SQL> show parameter remote_login_passwordfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
When I try to grant sysdba to a particular user, I am getting the ora - 01994 error
SQL> connect / as sysdba
Connected.
SQL> grant sysdba to rmanbk_admin;
grant sysdba to rmanbk_admin
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled
I am not sure what step I missed. This is for oracle database version 11.2.0.3 on solaris 11. The only thing that worth mention is that this is an ebs instance. Please advice. Thank you very much.