ORA-07445 [qmkmfreeUga()] running catupgrd.sql (Doc ID 746794.1)

Last updated on MARCH 25, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.

Symptoms

When upgrading from 10.2.0.3 to 10.2.0.4 or 10.2.0.5, a user may see this error when running catupgrd.sql

SQL>
SQL>
SQL>
SQL> -- Fix for lrg 2834679:
SQL> -- The issue here was that during upgrade from XE to 10.2, upgrade of the
SQL> -- config.xml causes the config schema to be loaded and pined in the kgl.
SQL> -- The upgrade of the config.xml is followed by the upgrade of the config
SQL> -- schema. This changes the config schema on disk. The problem here is that the
SQL> -- config schema pinned in kgl is still the old schema while the config.xml
SQL> -- conforms to the new schema. 'alter system flush shared pool' does not work
SQL> -- here to flush the config schema as it is explicitly kept in kgl.
SQL>
SQL> -- The fix below involves three parts:
SQL>
SQL> -- 1) Forcibly Unpin the config schema.
SQL> -- 2) flush the system
SQL> -- 3) get the new schema from disk and pin it in kgl
SQL>
SQL> begin
2 dbms_xdbutil_int.UnpinConfigSch();
3 end;
4 /
begin
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

There may also be a trace file generated with this error

ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [qmkmfreeUga()+37] [SIGSEGV] [Address not mapped to object] [0x000000090] [] []
Current SQL statement for this session:
begin
dbms_xdbutil_int.UnpinConfigSch();
end;
----- PL/SQL Call Stack -----
object line object
handle number name
0x16ef5c7c0 469 package body XDB.DBMS_XDBUTIL_INT
0x18225dd50 2 anonymous block
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst ksedmp ssexhd __funlockfile
qmkmfreeUga qmkmUnpinConfig qmpxUnpinConfigSch spefcmpa spefmccallstd pextproc
peftrusted psdexsp rpiswu2

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms