Re: ORA_PWFILE

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sat, 2 Feb 2013 20:14:34 +0000 (UTC)
Message-ID: <pan.2013.02.02.20.14.26_at_gmail.com>

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 <gogala.mla..._at_gmail.com> 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/<dbname>/
> orapw<dbname>. 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

Received on Sat Feb 02 2013 - 21:14:34 CET