OraFAQ Forum: Linux » ORA-01994: GRANT failed: password file missing or disabled

Home » Infrastructure » Linux » ORA-01994: GRANT failed: password file missing or disabled (Oracle 11g, 11.1.0.6.0 Linux 5.5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01994: GRANT failed: password file missing or disabled [message #550070]

Thu, 05 April 2012 14:10

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

Report message to a moderator

Re: ORA-01994: GRANT failed: password file missing or disabled [message #550079 is a reply to message #550070]

Thu, 05 April 2012 18:02

cookiemonster
Messages: 13952
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.

Report message to a moderator

Re: ORA-01994: GRANT failed: password file missing or disabled [message #550080 is a reply to message #550079]

Thu, 05 April 2012 18:08

BlackSwan
Messages: 26766
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:~$

Report message to a moderator

Re: ORA-01994: GRANT failed: password file missing or disabled [message #550110 is a reply to message #550070]

Fri, 06 April 2012 01:20

Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: ORA-01994: GRANT failed: password file missing or disabled [message #550157 is a reply to message #550079]

Fri, 06 April 2012 07:42

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?

Report message to a moderator

Re: ORA-01994: GRANT failed: password file missing or disabled [message #550159 is a reply to message #550157]

Fri, 06 April 2012 07:58

John Watson
Messages: 8960
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.

Report message to a moderator

Re: ORA-01994: GRANT failed: password file missing or disabled [message #550160 is a reply to message #550159]

Fri, 06 April 2012 08:01

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

Report message to a moderator

Re: ORA-01994: GRANT failed: password file missing or disabled [message #550161 is a reply to message #550160]

Fri, 06 April 2012 08:04

Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: ORA-01994: GRANT failed: password file missing or disabled [message #550165 is a reply to message #550159]

Fri, 06 April 2012 08:10

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]$

Report message to a moderator

Re: ORA-01994: GRANT failed: password file missing or disabled [message #550166 is a reply to message #550165]

Fri, 06 April 2012 08:12

Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Post result of:

env | grep ORACLE
ps -eaf | grep pmon

Regards
Michel

Report message to a moderator

Re: ORA-01994: GRANT failed: password file missing or disabled [message #550167 is a reply to message #550166]

Fri, 06 April 2012 08:13

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]$

Report message to a moderator

Re: ORA-01994: GRANT failed: password file missing or disabled [message #550169 is a reply to message #550167]

Fri, 06 April 2012 08:17

Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...

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

basmith
Messages: 6
Registered: April 2012

Junior Member

Thank you for helping me find that!!!

Report message to a moderator

Re: ORA-01994: GRANT failed: password file missing or disabled [message #673381 is a reply to message #550169]

Sun, 18 November 2018 23:59

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

Report message to a moderator

Re: ORA-01994: GRANT failed: password file missing or disabled [message #673384 is a reply to message #673381]

Mon, 19 November 2018 00:51

Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 12 14:32:36 CST 2024