Errors that occur when a user is authorized:
# Sqlplus/as sysdba
SQL> grant sysdba to sys_user_admin;
Grant sysdba to sys_user_admin
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled
SQL> show parameters pass
NAME TYPE VALUE
-----------------------------------------------------------------------------
Remote_login_passwordfile string EXCLUSIVE
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:
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.!!
SQL>! Mv orapwDBSID orapwdbsid
SQL> select * from v $ pwfile_users;
USERNAME SYSDB SYSOP SYSAS
---------------------------------------------
SYS TRUE FALSE
SYS_USER_ADMIN TRUE FALSE