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

This article will give you a summary of the ORA-01994: GRANT failure: the password file is missing or the problem has been disabled solution, here is the main permission problem, the following are some solutions for GRANT failure.

Errors that occur when a user is authorized:

The Code is as follows:	Copy code
Sys @ ORCL> grant sysdba to sys; Grant sysdba to sys

*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled

The Code is as follows:

Copy code

Sys @ ORCL> show parameters pass NAME TYPE VALUE --------------------------------------------------------------------------------------------------- Remote_login_passwordfile string EXCLUSIVE Sys @ ORCL> SQL>! Ls-l $ ORACLE_HOME/dbs Total 52 -Rw -- 1 oracle oinstall 1552 Sep 21 hc_dbsid.dat -Rw-r -- 1 oracle oinstall 12920 May 3 2001 initdw. ora -Rw-r -- 1 oracle oinstall 8385 Sep 11 1998 init. ora -Rw-r -- 1 oracle oinstall 24 Jul 21 2009 lkDBSID -Rw-r -- 1 oracle oinstall 2560 Sep 21 orapwDBSID -Rw-r -- 1 oracle oinstall 10752 Sep 21 spfileDBSID. ora

Can see the password file exists, but how will happen ORA-01994 !!

When I found the password file, I used:

The Code is as follows:	Copy code
Orapwd file = $ ORACLE_HOME/dbs/orapw $ ORACLE_SID entries = 10 force = y While $ ORACLE_SID = DBSID

The orapwDBSID file is generated. In linux, files are case sensitive !!

The Code is as follows:	Copy code
SQL>! Mv orapwDBSID orapwdbsid Sys @ ORCL> r 1 * select * from v $ pwfile_users USERNAME SYSDBA SYSOPER SYSASM --------------------------------------------------------- SYS TRUE FALSE