Re: ORA_PWFILE
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 30 Jan 2013 00:47:31 +0000 (UTC)
Message-ID: <ke9qj1$5j8$1_at_solani.org>
On Tue, 29 Jan 2013 15:06:35 -0800, joel garry wrote:
>
> 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
Date: Wed, 30 Jan 2013 00:47:31 +0000 (UTC)
Message-ID: <ke9qj1$5j8$1_at_solani.org>
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.
-- http://mgogala.byethost5.comReceived on Wed Jan 30 2013 - 01:47:31 CET