Re: How to name the password?

From: Frank <fvanbortel_at_netscape.net>
Date: Sat, 26 Apr 2003 16:38:45 +0200
Message-ID: <3EAA99F5.5040005@netscape.net>

Sybrand Bakker wrote:
> On Thu, 24 Apr 2003 20:56:39 +0200, Frank <fvanbortel_at_netscape.net>
> wrote:
>
>

>>Pete's wrote:
>>
>>>On unix, the name should be the following:
>>>  orapwORACLE_SID
>>>and should be placed in the $ORACLE_HOME/dbs directory.  For NT/2000,
>>>it should be similar.  In fact, I believe you can specify any name you
>>>want.
>>>
>>
>>No - for M$ it's pwd[oracle_sid].ora
>>To stay with another example, the instance ORCL would have a
>>password file PWDorcl.ora.
>>Location is correct.

>
>
> Not 100 percent correct. There is a registry variable which has the
> exact name of the passwordfile.
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

OK - so I looked thru the registry, and found none. It's a non-standard entry, I suppose, like tns_admin. Then searched the docu, and even in Oracle8i Configuration Parameters and the Registry (Appendix C - Windows Admin Guide) there is no mention of such entry in the registry.

The Windows manuals for 9iR2 state there's a value ORA_SID_PWFILE (http://download-west.oracle.com/docs/cd/B10501_01/win.920/a95491/admin.htm#1006254) Searching back of ora_sid_pwfile, the only mention of such an evironment setting for 8i is in the error manual: look up ora-1990.

So it is rather ill documented for 8i, so say the least. Did not bother to check for 9iR1

-- 
Regards, Frank van Bortel

Received on Sat Apr 26 2003 - 09:38:45 CDT