"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 20, 2013

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

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