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

Oracle Error Message

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

Reason for the Error

The operation failed either because the INIT.ORA parameter REMOTE_LOGIN_PASSWORDFILE was set to NONE or else because the password file was missing.

Solution

Create the password file using the orapwd tool and set the INIT.ORA parameter REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE.