Home » RDBMS Server » Server Administration » ORA-01990
ORA-01990 [message #51700] Sat, 08 June 2002 04:25 Go to next message
Silviu
Messages: 6
Registered: April 2002
Junior Member
Hi,
My server operating system is Linux.
I follow these steps:
- create a password file with orapwd in $ORA_HOME/dbs. Name of file is orapwtestdb and was created successful.
- set in init.ora: remote_login_passwordfile = exclusive.
- set the SO variables ORA_sid_PWFILE and ORA_PWFILE with name of password file (with path in first try and without path in second try).
- start svrmgrl, connect internal and startup the database.

I receive following message:
ORA-01990: error opening password file '/u01/app/oracle/product/8.0.5/dbs/orapw'

Can anybody tell me what is wrong or what is missing?
Thanks.
Silviu.
Re: ORA-01990 [message #51701 is a reply to message #51700] Sat, 08 June 2002 05:10 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I beleive it may be a typo!

as per your posting
create a password file with orapwd in $ORA_HOME/dbs. Name of file is orapwtestdb and was created successful

but the error message is
ORA-01990: error opening password file '/u01/app/oracle/product/8.0.5/dbs/orapw'
here oracle is looking for a file orapw!!.
so pls, check the filenames
Re: ORA-01990 [message #51709 is a reply to message #51700] Sun, 09 June 2002 21:48 Go to previous messageGo to next message
Silviu
Messages: 6
Registered: April 2002
Junior Member
Hi,

You were right. I deleted the old password file and afterwards I recreated it with "orapw" name. Error message did not appear any more.
On the other hand remain a question 'how can I use a custom file name'?.

Silviu.
Re: ORA-01990 [message #51720 is a reply to message #51709] Mon, 10 June 2002 10:23 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
here a file orapwdev is created.

orapwd file=/opt/oracle/dbs/orapwdev password=manager entries=10
Re: ORA-01990 [message #51725 is a reply to message #51709] Mon, 10 June 2002 21:21 Go to previous messageGo to next message
Silviu
Messages: 6
Registered: April 2002
Junior Member
I know this syntax and I used. Problem is, when I create a password file with name different than "orapw", I received error message :
ORA-01990: error opening password file '/u01/app/oracle/product/8.0.5/dbs/orapw'.
Maybe problem is a Linux environment variable witch must by set.
Thanks.
Re: ORA-01990 [message #161449 is a reply to message #51700] Sat, 04 March 2006 06:12 Go to previous messageGo to next message
asif198
Messages: 1
Registered: December 2005
Location: karachi
Junior Member

can please inform me how can i change the value of
ORA_sid_PWFILE and ORA_PWFILE in windows environment
thanks
Re: ORA-01990 [message #255523 is a reply to message #51700] Wed, 01 August 2007 02:07 Go to previous messageGo to next message
pooja_g
Messages: 56
Registered: December 2005
Location: India
Member
I am getting the following error when starting the database
Quote:

SQL> startup
ORACLE instance started.

Total System Global Area 370108240 bytes
Fixed Size 735056 bytes
Variable Size 150994944 bytes
Database Buffers 218103808 bytes
Redo Buffers 274432 bytes
ORA-01990: error opening password file '/ora92/dbs/orapw'
ORA-27037: unable to obtain file status
HP-UX Error: 2: No such file or directory
Additional information: 3


The os is HP-UX,oracle 9i db
I have set the remote_logon_password to exclusive,and created the password file as orapwSID,but during startup i am getting this error.Can anyone help me out here?

Regards,


Re: ORA-01990 [message #255527 is a reply to message #255523] Wed, 01 August 2007 02:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64127
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What are the values of ORA*PWFILE environment variables?
What is the value of ORACLE_SID environment variable?
Post result of "env | egrep 'PWFILE|ORACLE_SID'"

Regards
Michel

Re: ORA-01990 [message #255534 is a reply to message #51700] Wed, 01 August 2007 02:25 Go to previous messageGo to next message
pooja_g
Messages: 56
Registered: December 2005
Location: India
Member
Thanks Michel,
Result of 'env | egrep 'PWFILE|ORACLE_SID'

Quote:
ORACLE_SID=sibdb



This is the correct oracle_sid,we set the SID dynamically as the server hosts multiple databases.

How do i check ORA*PWFILE environment variable?

Regards,
Re: ORA-01990 [message #255539 is a reply to message #255534] Wed, 01 August 2007 02:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64127
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
How do i check ORA*PWFILE environment variable?

The previous command did it.
I forgot to ask for ORACLE_HOME, so add it to the command:
env | egrep 'PWFILE|ORACLE' | sort

Add 'ls -l $ORACLE_HOME/dbs | grep orapw'

Regards
Michel
Re: ORA-01990 [message #255561 is a reply to message #51700] Wed, 01 August 2007 03:56 Go to previous messageGo to next message
pooja_g
Messages: 56
Registered: December 2005
Location: India
Member
Hi,
I am enclosing the result for your reference,
Quote:
$ env | egrep 'PWFILE|ORACLE' | sort
ORACLE_BASE=/ora92
ORACLE_HOME=/ora92
ORACLE_SID=sibdb
ORACLE_TERM=xterm
$


Quote:
$ ls -l $ORACLE_HOME/dbs | grep orapw
-rwSr----- 1 oracle dba 3072 May 29 14:23 orapwADSDB
-rwSr----- 1 oracle dba 3072 May 30 17:15 orapwCONDB
-rwSr----- 1 oracle dba 3072 May 30 17:55 orapwDWHDB
-rwSr----- 1 oracle dba 3072 May 28 16:58 orapwODSDB
-rwSr----- 1 oracle dba 3072 Aug 1 12:45 orapwSIBDB.ora
-rwSr----- 1 oracle dba 3072 May 25 18:04 orapwSIBDB_backup
$
Re: ORA-01990 [message #255579 is a reply to message #255561] Wed, 01 August 2007 04:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64127
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ah! your password file has wrong name.
Fix it.

Regards
Michel
icon5.gif  Re: ORA-01990 [message #255584 is a reply to message #51700] Wed, 01 August 2007 04:27 Go to previous messageGo to next message
pooja_g
Messages: 56
Registered: December 2005
Location: India
Member
Wrong name?Do you mean the ".ora" extension?Or the upper case name if SID?
Re: ORA-01990 [message #255590 is a reply to message #255584] Wed, 01 August 2007 04:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64127
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Both.

Regards
Michel
icon10.gif  Re: ORA-01990 [message #255596 is a reply to message #51700] Wed, 01 August 2007 04:39 Go to previous message
pooja_g
Messages: 56
Registered: December 2005
Location: India
Member
Hi,
I have created now a pw file as orapwsibdb .The database is opening now.Seems a very silly mistake. Cool .Initially i had created that but it didnot work,now it is.

THANKS a LOT Michel
Previous Topic: Grant Role/Grant Privilege
Next Topic: Controlfile expansion
Goto Forum:
  


Current Time: Wed Dec 07 06:45:51 CST 2016

Total time taken to generate the page: 0.11419 seconds