Re: ASM Upgrade from 10.2 to 11.2 erroring with ORA-01034: ORACLE not available

From: De DBA <dedba_at_tpg.com.au>
Date: Mon, 05 Jul 2010 21:28:33 +1000
Message-ID: <4C31C1E1.8020700_at_tpg.com.au>

Funny that, I got that same ORA-600 and ORA-15240 error combination last week, when playing around with Dataguard on 10gR2 (newly created test databases).

Dataguard is in "High Availability Mode" (set via Enterprise Manager GC). In my case someone had opened the standby (alter database open), thinking that it was the primary. Redo apply of course stopped. The error started popping up on the primary *after* the standby was closed and mounted and Dataguard started again. Bouncing the primary stopped it, but apart from the message no ill effects were apparent. I did extensively search google and MOS but sould not find a clear explanation.

All on Windows 2003, EMGC is 10gR5, Primary and Standby on different machines, 10.2.0.2.

Cheers,
Tony

Peter Hitchman wrote:
> Hi Tyfanie,
> I believe I have the same problem, but I am migrating between 11.1 and
> 11.2 on Linux 64 bit platfom. I tried a couple of time to migrate and
> one time the asmca failed the other time it said it worked, but in
> fact failed. In the ASM alert log I see the error:
>
> ORA-00600: internal error code, arguments: [kfeInvokeLockCallback06],
> [30], [], [], [], [], [], [], [], [], [], []
> ORA-15240: attribute name SAGE_ONLY is invalid
>
> Basically the ASM instance shutsdown, but the OUI does not recognzie
> this and blindly stumbles on outputing "Oracle not available" in the
> logs.
>
> I have an SR open with Oracle but so far no response. Also I started a
> thread on the list last week and a patch was suggested, but I thought
> I should go via Oracle Support to be sure! I would be interested to
> know if you see something similar in your ASM alert log.
>
> One other thing, having the environment variable ORA_CRS_HOME set to
> the original CRS home will also break the migration, because the wrong
> crsctl programme gets called, assuming of course you are on a *nix
> platform.
>
> Regards
> Pete
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 05 2010 - 06:28:33 CDT