Grant SYSDBA Fails With "ORA-01994: GRANT Failed: Password File Missing Or Disabled"

 Grant SYSDBA Fails With "ORA-01994: GRANT Failed: Password File Missing Or Disabled" 

You have set the database parameter REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE and you have created a password file using the "orapwd" utility
but when you execute the following statement it fails:

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

The password file was created using this command:

% orapwd file=$ORACLE_HOME/dbs/orapworcl password=<password> entries=10

but ORACLE_SID was set to ORCL.

The $ORACLE_SID part of the password file name is case sensitive.

SOLUTION 

Re-create the password file:

% orapwd file=$ORACLE_HOME/dbs/orapwORCL password=<password> entries=10

or

% orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=<password> entries=10

and then execute the grant again:

SQL> grant SYSDBA to SYS;

for Multitenant Archicture 

SQL> grant sysdba to c##RMANWYCDB container=all;

Grant succeeded.