DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Sunday, March 20, 2016

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

SQL>grant sysdba to an_user;

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


cd $ORACLE_HOME/dbs/

Move or delete old password file.

Create new password file.

orapwd file=orapwPROD entries=10 password=k1cka$$123


SQL>grant sysdba to an_user;

Grant succeded.

To figure out which users has SYSDBA privilege query:

SQL>select * from v$pwfile_users

No comments: