Re: ORA-600 after July PSU apply -- production down.

From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Thu, 24 Aug 2017 20:18:16 +0200
Message-ID: <CALH8A91bAj52n4YRG3oD2ys2SP-eaTGi8DJ1mqKwj-d_bpk7jQ_at_mail.gmail.com>



have you checked
Oracle Database Patch Set Update 11.2.0.4.170718 Known Issues (Doc ID 2264627.1)
...
1 Known Issues

*1.1 In some environments the Database may fail to startup or take over 20 minutes longer to perform a clean startup*

  • After installing the Jul2017 Database BP 12.1.0.2.170718 patch, in some environments the Database may fail to startup or take an additional 20 minutes to perform a clean startup. A clean startup means a startup that requires no recovery such as a startup after a shutdown normal.
  • This issue will be resolved by the Database BP 12.1.0.2.170814 patch.

...

maybe
Patch 26609445: DATABASE PATCH SET UPDATE 11.2.0.4.170814

helps? (pure guessing, untested!)

2017-08-24 19:33 GMT+02:00 MacGregor, Ian A. <ian_at_slac.stanford.edu>:

> I was curious and ran
>
> oracle_at_fermi-oracle02 $ find ./ -name "kgfm*” the top directory was
> $ORACLE_HOME
>
> a typical response was
>
> ./.patch_storage/18522509_Jun_30_2014_08_14_42/files/lib/
> libasmclntsh11.a/kgfm.o
>
> This on a server with internal disks and not using ASM so there is no GI
> applied. It seems the problem may lie
> with ASM. Do the servers which did not fail also use ASM.
>
> Ian MacGregor
> SLAC National Accelerator Laboratory
>
>
> On Aug 24, 2017, at 8:32 AM, De DBA <dedba_at_tpg.com.au> wrote:
>
> Even starting in nomount mode gives ORA-600.
>
> I just attempted to create a dummy instance with a init.ora file with only
> 1 line in it (db_name = ORCL) - no ASM, no spfile in play. Starting that
> also failed with the same ORA-600 [kgfmGetCtx0].
>
> Cheers,
> Tony
>
> On 25/08/17 01:11, Powell, Mark wrote:
>
> >> ORA-01078 <01%20078>: failure in processing system parameters <<
>
> Have you in fact verified that your spfile parameters are in fact valid?
> Startup nomount and full the spfile into a pfile then review it carefully.
>
>
> Mark Powell
> Database Administration
> (313) 592-5148
>
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>
> <oracle-l-bounce_at_freelists.org> on behalf of De DBA <dedba_at_tpg.com.au>
> <dedba_at_tpg.com.au>
> *Sent:* Thursday, August 24, 2017 10:51:24 AM
> *To:* oracle-l_at_freelists.org
> *Subject:* ORA-600 after July PSU apply -- production down.
>
> HI,
> I've tonight applied the July PSU to the last environment - production.
> All other environments, including DR, went swimmingly, but after applying
> the patches when I tried to startup upgrade to apply the in-database part,
> I was regaled with the following fine errors on both nodes:
> 00:28:52 [25-AUG-17][SYS_at_MyProd]$ startup upgrade
> ORA-01078 <01%20078>: failure in processing system parameters
> ORA-00600: internal error code, arguments: [kgfmGetCtx0], [kgfm.c],
> [2840], [ctx], [], [], [], [], [], [], [], []
> The parameter files of course do still exist. The MOS lookup tool has no
> information and my 24/7 db is down. Any clues?
>
> I've already attempted to roll-back the OCW part, but that had no effect.
> Although now opatch lsinventory no longer lists the original version of
> that patch (11.2.0.4.5) either.
>
> Environment:
> ODA X4-2
> RDBMS 11.2.0.4
> ASM 12.1.0.2
> Database PSU 11.2.0.4.170718
> OCW PSU - no longer shown
> OVJM PSU 11.2.0.4.170718
> Thanks,
> Tony
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 24 2017 - 20:18:16 CEST

Original text of this message