Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Pw file on different location

594902Jan 22 2008 — edited Jan 22 2008
Hello Every Body.

I m using Windows XP Sp1 and oracle 9.2.0.1.0.

I have some confusion regarding password file authentication when the password file is situated on any other location then default. I don't want to use OS authentication ..
My SID name is ORCL90

To do this I placed a new registery entry ora_orcl90_pwfile=c:\pwdorcl90.ora. This file was newly created

but I could not log in.

When I give this registry entry ora_pwfile=c:\pwdorcl90.orcl ... It works

But documentation says :


In search of the password file, Oracle9i looks in the registry for the value of parameter ORA_SID_PWFILE. If no value is specified, then it looks in the registry for the value of parameter ORA_PWFILE, which points to a file containing usernames, passwords, and privileges. If that is not set, then it uses the default:

ORACLE_BASE\ORACLE_HOME\DATABASE\PWDsid.ORA.



So why my first registry value could not solve though second did.

Pl. tell me.

Thanks

Message was edited by: oraboy
ora-boy
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2008
Added on Jan 22 2008
#general-database-discussions
2 comments
652 views