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 next 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
Re: ORA-01994: GRANT failed: password file missing or disabled [message #550079 is a reply to message #550070] Thu, 05 April 2012 18:02 Go to previous messageGo to next message
cookiemonster
Messages: 13747
Registered: September 2008
Location: Rainy Manchester
Senior Member
Sys is different to other users. Unless I'm missing something it's always sysdba so trying to grant that role to it is pointless.
Re: ORA-01994: GRANT failed: password file missing or disabled [message #550080 is a reply to message #550079] Thu, 05 April 2012 18:08 Go to previous messageGo to next message
BlackSwan
Messages: 26640
Registered: January 2009
Location: SoCal
Senior Member
bcm@bcm-laptop:~$ ls -l $OH/dbs
total 9712
-rw-r--r-- 1 oracle dba       0 2011-09-26 17:50 Alter
-rw-rw---- 1 oracle dba    1544 2010-06-09 08:31 hc_DBUA0.dat
-rw-rw---- 1 oracle dba    1544 2012-04-05 06:37 hc_v112.dat
-rw-r--r-- 1 oracle dba    1075 2011-09-10 19:18 init_110910.ora
-rw-r--r-- 1 oracle dba    2851 2009-05-15 14:35 init.ora
-rw-r--r-- 1 oracle dba    1038 2012-02-07 11:07 initv112.ora
-rw-r----- 1 oracle dba      24 2010-05-07 11:17 lkV112
-rw-r----- 1 oracle dba    2048 2012-03-31 15:29 orapwv112
-rw-r----- 1 oracle dba 9912320 2010-05-20 18:33 snapcf_v112.f
-rw-r----- 1 oracle dba    3584 2012-04-05 06:37 spfilev112.ora
bcm@bcm-laptop:~$ echo $ORACLE_SID
v112
bcm@bcm-laptop:~$ 
Re: ORA-01994: GRANT failed: password file missing or disabled [message #550110 is a reply to message #550070] Fri, 06 April 2012 01:20 Go to previous messageGo to next message
Michel Cadot
Messages: 66714
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
orapwd file=$ORACLE_HOME/dbs/orapwSID password=password entries=30 force=y


Your ORACLE_SID is really SID?

Regards
Michel
Re: ORA-01994: GRANT failed: password file missing or disabled [message #550157 is a reply to message #550079] Fri, 06 April 2012 07:42 Go to previous messageGo to next message
basmith
Messages: 6
Registered: April 2012
Junior Member
My object is to issue the following:

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

To correct this error I need to create the password file with the following command:

$orapwd file=$ORACLE_HOME/dbs/orapwIPPROT password=password entries=30 force=y

File gets created and I try the command again:

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

Same error, I veiw v$pwdfile_users:

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

I am not a DBA, but from what I have read when the password file is created "SYS" in in the file by default. My questions is why is it not there?
Re: ORA-01994: GRANT failed: password file missing or disabled [message #550159 is a reply to message #550157] Fri, 06 April 2012 07:58 Go to previous messageGo to next message
John Watson
Messages: 8075
Registered: January 2010
Location: Global Village
Senior Member
What is the name of your instance?

select instance_name from v$instance;

It is case sensitive.
Re: ORA-01994: GRANT failed: password file missing or disabled [message #550160 is a reply to message #550159] Fri, 06 April 2012 08:01 Go to previous messageGo to next message
basmith
Messages: 6
Registered: April 2012
Junior Member
The name of my instance is IPPORT. In creating the password file I used the name e.g.,

$orapwd file=$ORACLE_HOME/dbs/orapwIPPROT password=[sys password] entries=30 force=y
Re: ORA-01994: GRANT failed: password file missing or disabled [message #550161 is a reply to message #550160] Fri, 06 April 2012 08:04 Go to previous messageGo to next message
Michel Cadot
Messages: 66714
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
The name of my instance is IPPORT


Copy and paste the result of John's query.
Copy and paste the result of BlackSwan's command

Regards
Michel
Re: ORA-01994: GRANT failed: password file missing or disabled [message #550165 is a reply to message #550159] Fri, 06 April 2012 08:10 Go to previous messageGo to next message
basmith
Messages: 6
Registered: April 2012
Junior Member
John's query:

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
IPPROT

SQL>

Blackswan's command:

[oracle@bg2mo08i3 ~]$ cd $ORACLE_HOME/dbs
[oracle@bg2mo08i3 dbs]$ ls -l ora*
-rw-r----- 1 oracle dba 16629760 Apr 6 13:09 ora_control1
-rw-r----- 1 oracle dba 16629760 Apr 6 13:09 ora_control2
-rw-r----- 1 oracle dba 1536 Apr 5 18:02 orapwIPPROT
[oracle@bg2mo08i3 dbs]$
Re: ORA-01994: GRANT failed: password file missing or disabled [message #550166 is a reply to message #550165] Fri, 06 April 2012 08:12 Go to previous messageGo to next message
Michel Cadot
Messages: 66714
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post result of:
env | grep ORACLE
ps -eaf | grep pmon

Regards
Michel
Re: ORA-01994: GRANT failed: password file missing or disabled [message #550167 is a reply to message #550166] Fri, 06 April 2012 08:13 Go to previous messageGo to next message
basmith
Messages: 6
Registered: April 2012
Junior Member
[oracle@bg2mo08i3 dbs]$ env | grep ORACLE
ORACLE_SID=IPPROT
ORACLE_BASE=/opt/app
ORACLE_HOME=/opt/app/product/11g
[oracle@bg2mo08i3 dbs]$ ps -eaf | grep pmon
root 8747 1 0 Apr04 ? 00:00:00 ora_pmon_catdb
root 18093 1 0 Apr05 ? 00:00:00 ora_pmon_IPPROT
oracle 25388 25336 0 13:12 pts/0 00:00:00 grep pmon
[oracle@bg2mo08i3 dbs]$
Re: ORA-01994: GRANT failed: password file missing or disabled [message #550169 is a reply to message #550167] Fri, 06 April 2012 08:17 Go to previous messageGo to next message
Michel Cadot
Messages: 66714
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The problem is there:
root 18093 1 0 Apr05 ? 00:00:00 ora_pmon_IPPROT

Instances should be started with oracle account (or other one from dba group), NOT with root.

Regards
Michel

[Updated on: Fri, 06 April 2012 08:18]

Report message to a moderator

Re: ORA-01994: GRANT failed: password file missing or disabled [message #550172 is a reply to message #550169] Fri, 06 April 2012 08:22 Go to previous messageGo to next message
basmith
Messages: 6
Registered: April 2012
Junior Member
Thank you for helping me find that!!!
Re: ORA-01994: GRANT failed: password file missing or disabled [message #673381 is a reply to message #550169] Sun, 18 November 2018 23:59 Go to previous messageGo to next message
suhail.khattak
Messages: 1
Registered: November 2018
Junior Member
i HAVE THE SAME ISSUE ON WINDOWS 2012 WITH 11G R2. How can i fix it?


Michel Cadot wrote on Fri, 06 April 2012 08:17
The problem is there:
root 18093 1 0 Apr05 ? 00:00:00 ora_pmon_IPPROT

Instances should be started with oracle account (or other one from dba group), NOT with root.

Regards
Michel

Re: ORA-01994: GRANT failed: password file missing or disabled [message #673384 is a reply to message #673381] Mon, 19 November 2018 00:51 Go to previous message
Michel Cadot
Messages: 66714
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You can't have EXACTLY the same problem on Windows as the root of this one was specific to Linux (or Unix).

Create a new topic in Windows forum coping and pasting what you do and see using SQL*Plus.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Indent the code, use code tags and align the columns in result.
If you don't know how to format the code, learn it using SQL Formatter.
Use the "Preview Message" or "Preview Quick Reply" button to verify.
Also always post your Oracle version, with 4 decimals, as solution depends on it.

[Updated on: Mon, 19 November 2018 00:53]

Report message to a moderator

Previous Topic: character datafile naming oracle 18c o1_mf_system dbf
Next Topic: Shell script to check Oracle Availability
Goto Forum:
  


Current Time: Sat Dec 07 07:05:30 CST 2019