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 

Unknown disk space consumed window 7/ C drive frequently growing ..

Reduce the volume shadow copy size in windows

vssadmin list shadowstorage

vssadmin resize shadowstorage /for=C: /on=C: /Maxsize=1000MB

DpRTmPrepareReq: network error of client T21, NiBufReceive (-6: NIECONN_BROKEN), dp_tm_status=3

DpRTmPrepareReq: network error of client T21, NiBufReceive (-6: NIECONN_BROKEN), dp_tm_status=3

solution--


Kernel file mismatch

update  the kernel file