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 AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.2 [Release 11.2]
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!


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