While granting SYSDBA role to a database user, got below error.

SQL> grant sysdba to DEV_DB;
grant sysdba to DEV_DB
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled

SOLUTION:

This error says, that the password file is not present for the database, which is used for authenticating SYSDBA users remotely.

We can see no entries are present in v$pwfile_users table.

To fix this, create the password file

Now grant sysdba to the user:

Now working fine as expected.:)

 

SEE ALSO – orapwd tool for password file in oracle