| ORA-01990 [message #51700] |
Sat, 08 June 2002 04:25  |
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 #51709 is a reply to message #51700] |
Sun, 09 June 2002 21:48  |
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 #51725 is a reply to message #51709] |
Mon, 10 June 2002 21:21 |
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 |
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 |
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 #255534 is a reply to message #51700] |
Wed, 01 August 2007 02:25 |
pooja_g
Messages: 56
Registered: December 2005
Location: India
|
Member |
|
|
Thanks Michel,
Result of 'env | egrep 'PWFILE|ORACLE_SID'
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 #255561 is a reply to message #51700] |
Wed, 01 August 2007 03:56 |
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
$
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
.Initially i had created that but it didnot work,now it is.