Home » Infrastructure » Linux » ORA-01994: GRANT failed: password file missing or disabled (Oracle 11g, 11.1.0.6.0 Linux 5.5)
ORA-01994: GRANT failed: password file missing or disabled [message #550070] Thu, 05 April 2012 14:10 Go to previous message
basmith
Messages: 6
Registered: April 2012
Junior Member
I have read the postings on this error but none address the problem I am seeing. When I create the orapwd file the sys user is not in the file, why not?
The problem started when I tried to grant sysdba priviledges to sys
[oracle@bg2mo08i3 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Apr 5 18:47:06 2012

Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.1.0.6.0 - 64bit Production

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

SQL> shutdown immediate;

From the postings I read I shutdown the DB and I created a new orapwd file:
$ orapwd file=$ORACLE_HOME/dbs/orapwSID password=password entries=30 force=y

SQL> startup;

Started the DB, verified that the password parameter is set to EXCLUSIVE.

SQL>show parameter password;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
SQL>

SQL> select * from v$pwfile_users;
no rows selected
SQL>

Shouldn't the sys user be listed in the v$pwfile_users?

[oracle@bg2mo08i3 dbs]$ ls -l ora*
-rw-r----- 1 oracle oinstall 1536 Apr 5 18:02 orapwSID
Are these permissions and ownership correct?

I can connect using sys's password:
SQL> connect sys/sysPASSWORD as sysdba
Connected
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: character datafile naming oracle 18c o1_mf_system dbf
Next Topic: Shell script to check Oracle Availability
Goto Forum:
  


Current Time: Fri Mar 29 04:56:14 CDT 2024