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

  • From: De DBA <dedba@xxxxxxxxxx>
  • To: mark.powell2@xxxxxxx, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 25 Aug 2017 01:32:35 +1000

 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: 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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf of De 
DBA <dedba@xxxxxxxxxx>
*Sent:* Thursday, August 24, 2017 10:51:24 AM
*To:* oracle-l@xxxxxxxxxxxxx
*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@MyProd]$ startup upgrade
ORA-01078: 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


Other related posts: