My Oracle Support Banner

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

Last updated on APRIL 01, 2020

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.


When upgrading from to or, a user may see this error when running catupgrd.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> -- The fix below involves three parts:
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> begin
2 dbms_xdbutil_int.UnpinConfigSch();
3 end;
4 /
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:
----- 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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.