| Problems with passwordfile - 9.0.1 on linux [message #51525] |
Tue, 28 May 2002 13:26  |
Thomas
Messages: 67
Registered: September 1999
|
Member |
|
|
Hi!
I'm having a strange problem creating the passwordfile for an oracle 9i instance (carolina) on my linux-box.
First I create the passwordfile with:
orapwd file=pwdcarolina.pwd password=admin entries=10
I set remote_login_passwordfile to exclusive and start the instance.
This is what oracle responds:
ORA-01990: error opening password file '/usr/oracle/9i/dbs/orapw'
ORA-27037: unable to obtain file status
Linux error: 2: No such file or directory
Additional information: 3
I understand that oracle can't locate the file, but the path is correct. in the errormessage the filename is cut off. it should be
'/usr/oracle/9i/dbs/orapwdcarolina.pwd'
after some trial and error i asked a linux-guy if he had any clues. he told me to try to make a symbolic link to the path that oracle seemed to ask for.
i created a symbolic link using
ln -s orapwdcarolina.pwd orapw
to match the filename oracle was missing.
This worked fine and i could add users to the passwordfile by granting sysdba to users.
My question is:
Why do I have to create the symbolic link?
what am i missing out here?
(I've tried using the full path in the orapwd-statement...same results. a shorter name did not help...)
kind regards thomas
|
|
|
|
| Re: Problems with passwordfile - 9.0.1 on linux [message #51560 is a reply to message #51525] |
Thu, 30 May 2002 11:21  |
Farrukh
Messages: 15
Registered: February 2002
Location: Pakistan
|
Junior Member |
|
|
Hi Thomas,
I think, you don't have to put extension (.pwd) with the password file creation and also don't have to create link with the file.
just enter:
orapwd file=pwdcarolina password=admin entries=10
Regards,
Farrukh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
