Oracle DBA, How To, Error, Cause and Action

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

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




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




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