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

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

Environment: Database 11.2.0.2 , OS Solaris 10

Problem: 
I hit this error when I was trying to give sysdba privilege to one of the database application user account which need to install BAM. I logged in locally from the host as sys user.

SQL> grant sysdba to abc_admin;

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

 run the script and make sure the file is not there

select username,sysdba,sysoper,sysasm from v$pwfile_users;
 

Check the  $ oracle/home/database/   below file if not create it.

 
 

 

Solution:

1. Create a password file from os:

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