Path: news.cambrium.nl!textnews.cambrium.nl!feeder1.cambriumusenet.nl!feed.tweaknews.nl!193.141.40.65.MISMATCH!npeer.de.kpn-eurorings.net!npeer-ng0.de.kpn-eurorings.net!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.oracle.server Subject: Re: ORA_PWFILE Date: Sat, 2 Feb 2013 20:14:34 +0000 (UTC) Organization: solani.org Lines: 44 Message-ID: References: <9a742339-dc12-443a-9e34-5b92b6a1108b@i2g2000pbi.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: solani.org 1359836074 28468 eJwFwQkBwDAIA0BL4wm0cgID/xJ6BwuJTg+EY7EpH1B6O2sw9y8ttg6EdlYptTuVbnpoSfIBJw4R3g== (2 Feb 2013 20:14:34 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Sat, 2 Feb 2013 20:14:34 +0000 (UTC) User-Agent: Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2) X-User-ID: eJwNytERACEIA9GWDjVBy4GT9F+C/O2bWUwaf18EFwQldnqWTuCYRaq7Bsd2Y+LqQ/Ujb8atiQc38xH+ Cancel-Lock: sha1:iUbkptPfTLa9G9g81iU4hdmm2Ik= X-NNTP-Posting-Host: eJwNwoERgDAIA8CVQJJg54Fm/xH071lKTUMUaHorfOLyVTkd6Tk0sPffBhsPZletjLmoDx2LEQ4= Xref: news.cambrium.nl On Wed, 30 Jan 2013 00:47:31 +0000, Mladen Gogala wrote: > On Tue, 29 Jan 2013 15:06:35 -0800, joel garry wrote: > >> On Jan 29, 12:22 pm, Mladen Gogala wrote: >>> Oracle 11G no longer uses this variable to look for the password file. >>> Has anyone else noticed that? I haven't tried with >>> ORA_$ORACLE_SID_PWFILE >>> >>> --http://mgogala.byethost5.com >> >> It's still in the docs: >> http://docs.oracle.com/cd/E11882_01/win.112/e10845/admin.htm#NTQRF221 >> >> Are you on Windows? >> >> There is a mention of an unpublished bug in WIN: Checklist for >> Resolving CONNECT AS SYSDBA Issues [ID 114384.1] but that article does >> say specific to Version 9.2.0.8 to 11.1.0.7 on 32-bit. >> >> jg > > > No, I was trying to move the password file to +DGDATA// > orapw. The database is 11.2.0.3. I was able to copy the file > using the new feature in asmcmd which allows copying to and from file > system, but setting ORA_PWFILE didn't help. > Password file is used when the instance is down, to do nasty things like > a cold backup. I am now convinced that the problem is in the nature of > the file location. +DGDATA is an ASM disk group. ORA_PWFILE is definitely not used on a plain vanilla file system based Oracle 11G instance. I tested. I renamed my orapwO11 orapwO11.old and tried setting both ORA_PWFILE and ORA_O11_PWFILE (ORACLE_SID=O11) to orapwO11.old. It didn't work. This is now apparently only used on Windows. It used to be an environment variable available on Unix, too. -- Mladen Gogala The Oracle Whisperer http://mgogala.byethost5.com