How to fix the Oracle error ORA-01994: GRANT failed: password file missing or disabled?

In this post, you’ll learn more about the Oracle ErrorORA-01994: GRANT failed: password file missing or disabled with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error ORA-01994: GRANT failed: password file missing or disabled

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

How to fix the Error ORA-01994: GRANT failed: password file missing or disabled ?

You can fix this error in Oracle by following the below steps

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