If an instance fails, then Oracle Database 10 g uses the redo log files to recover the modified data in memory. Oracle Database uses redo log files in a cyclical fashion. For example, if three files constitute the online redo log, Oracle Database fills the first file, then the second file, and then the third file. (In older versions of Oracle, and 9i, and 10g, the alert.log file is a simple ascii. Oracle 9i does offer the ability to create a new Undo tablespace and to alter the. Chose to re-install the XDB subsystem, if so connect as sys and run catqm.sql.
![]()
Last updated on JANUARY 20, 2020
Applies to:Oracle Database - Standard Edition - Version 11.1.0.7 to 11.2.0.2 [Release 11.1 to 11.2]![]() Oracle Database Backup Service - Version N/A and later Oracle Database Cloud Service - Version N/A and later ![]() Oracle Cloud Infrastructure - Database Service - Version N/A and later Information in this document applies to any platform. Symptoms
There are several sessions stuck with wait event 'XDB SGA initialization'.
In the alert log, the following errors were reported during XDB initialization: Wed Dec 28 16:10:53 2011 XDB installed. Errors in file /u01/app/oracle/diag/rdbms/bw/BW/trace/BW_ora_17755.trc (incident=115838): ORA-00603: ORACLE server session terminated by fatal error ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML Incident details in: /u01/app/oracle/diag/rdbms/bw/BW/incident/incdir_115838/BW_ora_17755_i115838.trc Wed Dec 28 16:11:11 2011 opiodr aborting process unknown ospid (17755) as a result of ORA-603 If XDB was initialized correctly , i.e. with no issues, you would see the following in the alert log: Wed Dec 21 06:23:34 2011 XDB installed. XDB initialized. <---- The trace file has the following functions in the call stack: ----- Call Stack Trace ----- . . . . ktcPopAutonomousFrame qmrcGetCmtRC qmrcCacheReadKsys qmrcCacheRead kqrReadFromDB kqrpre1 kqrpre qmrcGetResCfgRowCache . . . . Cause
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. ![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |