My Oracle Support Banner

"XDB SGA reset to NULL" Messages Reported in the Alert Log During Upgrade of Database to (Doc ID 1306432.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 21-Jan-2013***


The following messages are reported in the alert log during upgrade of the database to

Tue Mar 15 16:02:50 2011
SERVER COMPONENT id=CONTEXT: status=VALID, version=, timestamp=2011-03-15 16:02:50
Tue Mar 15 16:02:53 2011
Archived Log entry 45308 added for thread 1 sequence 93 ID 0xda05abe dest 10:
Tue Mar 15 16:04:11 2011
XDB installed.
XDB initialized.
Errors in file /u01/app/oracle/diag/rdbms/dg1/PTVDB/trace/PTVDB_ora_3037.trc:
XDB SGA reset to NULL.
XDB installed.
XDB initialized.
Errors in file /u01/app/oracle/diag/rdbms/dg1/PTVDB/trace/PTVDB_ora_3037.trc:
Tue Mar 15 16:04:21 2011
XDB SGA reset to NULL.
XDB installed.
XDB initialized.

The trace file contains the following information:

---- Current SQL Statement ---
aclxsd xmltype := xmltype(dbms_metadata_hack.get_bfile('acl.xsd.11.0'), 0);
xdb$migratexmltable(xsd => aclxsd,
nmspc => '',
url => '',
tabname => 'XDB$ACL',
schemaowner => 'XDB', root => 'acl',
absdir => '/sys/schemas/PUBLIC/',
absfile => 'acl.xsd',
csx => true, transformfn => 'xdb.dbms_xdbutil_int.fixacl',
need_2nd_fn => 1);

---- PL/SQL Call Stack ----
845 package body XDB.DBMS_XDBUTIL_INT
854 package body XDB.DBMS_XDBUTIL_INT
4 anonymous block

----- Call Stack Trace -----
ksedst1  ksedst  dbkedDefDump  qm_set_uga_null  qm_set_uga_sga_null  spefcmpa .....


To view full details, 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 a vibrant support community of peers and Oracle experts.