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@xxxxxxxxxxxxxxxxx>:
I was curious and ran
oracle@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@xxxxxxxxxx> 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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx>
<oracle-l-bounce@xxxxxxxxxxxxx> on behalf of De DBA <dedba@xxxxxxxxxx>
<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 <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
