| problem with password file [message #223650] |
Sat, 10 March 2007 01:27  |
aboodlardy
Messages: 80
Registered: November 2006
Location: India
|
Member |
|
|
Hi
Friend i created a database with password file authentication to some users. But unfortunately the password file is deleted while database is still mounted.
Now I am unable to authenticate any user using password file even after creating new password file. I have set remote_login_passwordfile=exclusive(for ur information)
Please help me.
Is there way to solve this problem?
|
|
|
|
|
|
| Re: problem with password file [message #223765 is a reply to message #223659] |
Sun, 11 March 2007 03:48  |
aboodlardy
Messages: 80
Registered: November 2006
Location: India
|
Member |
|
|
Hi Taj
Thanks for ur reply.
I do not know "net stop Oracle_Service<sid>" like command, what it does. when i execute these commands it gives its options help list on my macine.
what it does? Do u want me to stop all services on my machine which start with oracle or ora? if yes please give me a command which does that.
I try google to searh for a solution to stop the database, i found
STEPS: i> lsnrctl stop listener ii> dbshut ( i have tried this but still i am unable to create the user with sysdba priviledge) the error is " passwordfile missing or disabled
Please help
|
|
|
|
|
|
| Re: problem with password file [message #223768 is a reply to message #223659] |
Sun, 11 March 2007 04:09 |
aboodlardy
Messages: 80
Registered: November 2006
Location: India
|
Member |
|
|
HI
Thanks for ur reply.
My Machine is Red Hat Linux ES.
One more thing is that after deleting my old passwordfile, i created the new one with different name but in the same location
does this cause any problem.Because i forget the name of old password file, does this passwordfile uses any environment variable to check the location of file?
Please help
regards
Abood
[Updated on: Sun, 11 March 2007 04:15] Report message to a moderator |
|
|
|
|
|
| Re: problem with password file [message #223792 is a reply to message #223781] |
Sun, 11 March 2007 10:50 |
aboodlardy
Messages: 80
Registered: November 2006
Location: India
|
Member |
|
|
Hi
Thank you for ur reply.
Yes Taj, I have corrected the file name, infact i have created a brand new one in the form "pwd<sid>.ora" in $ORACLE_HOEM/dbs.
and set remote_login_passwordfile=exclusive.
But still it gives same error i.e. "passwordfile is missing or disabled" when i give the following command
SQL>GRANT SYSDBA TO SCOTT;
PLEASE HELP
REGARDS
ABOOD
|
|
|
|
| Re: problem with password file [message #223793 is a reply to message #223792] |
Sun, 11 March 2007 11:13 |
aboodlardy
Messages: 80
Registered: November 2006
Location: India
|
Member |
|
|
Hi Taj
I get it, Thanks for ur all replies.
Actually, the name of passwordfile on windows must be pwd<sid>.ora
But on unix system( like mine, Linux) it is "orapw<sid>"
Thanks
regards
Abood
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
