My Oracle Support Banner

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

Last updated on JANUARY 17, 2020

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 21-Jan-2013***

Symptoms

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

Tue Mar 15 16:02:50 2011
SERVER COMPONENT id=CONTEXT: status=VALID, version=11.2.0.2.0, 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 ---
declare
aclxsd xmltype := xmltype(dbms_metadata_hack.get_bfile('acl.xsd.11.0'), 0);
begin
xdb$migratexmltable(xsd => aclxsd,
nmspc => 'http://xmlns.oracle.com/xdb/acl.xsd',
url => 'http://xmlns.oracle.com/xdb/acl.xsd',
tabname => 'XDB$ACL',
schemaowner => 'XDB', root => 'acl',
absdir => '/sys/schemas/PUBLIC/xmlns.oracle.com/xdb',
absfile => 'acl.xsd',
csx => true, transformfn => 'xdb.dbms_xdbutil_int.fixacl',
need_2nd_fn => 1);
end;

---- PL/SQL Call Stack ----
845 package body XDB.DBMS_XDBUTIL_INT
854 package body XDB.DBMS_XDBUTIL_INT
158 procedure SYS.XDB$MIGRATEXMLTABLE
4 anonymous block

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

Cause

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
Symptoms
Cause
Solution


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