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

  • March 19, 2016 | 14 views
  • Comments