"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 MARCH 01, 2024
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle 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.
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 |