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


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