Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!newsfeed2.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!skynet.be!skynet.be!213.51.129.3.MISMATCH!newshub1.home.nl!home.nl!not-for-mail From: Frank Newsgroups: comp.databases.oracle.misc Subject: Re: How to name the password? Date: Sat, 26 Apr 2003 16:38:45 +0200 Organization: @Home Benelux Lines: 45 Message-ID: <3EAA99F5.5040005@netscape.net> References: <6724a51f.0304240540.171288b7@posting.google.com> <3EA83367.4000904@netscape.net> NNTP-Posting-Host: cc28855-a.hnglo1.ov.home.nl Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Trace: news1.tilbu1.nb.home.nl 1051367787 2981 217.121.193.81 (26 Apr 2003 14:36:27 GMT) X-Complaints-To: abuse@home.nl NNTP-Posting-Date: Sat, 26 Apr 2003 14:36:27 +0000 (UTC) User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.2) Gecko/20030208 Netscape/7.02 X-Accept-Language: en-us, en Xref: core-easynews comp.databases.oracle.misc:97026 X-Received-Date: Sat, 26 Apr 2003 07:36:04 MST (news.easynews.com) Sybrand Bakker wrote: > On Thu, 24 Apr 2003 20:56:39 +0200, Frank > 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