After the recovery of database:
Solution
SQL> alter database open resetlogs;
Database altered.
SQL>
SQL> shutdown immediate
ORA-03135: connection lost contact
SQL>
SQL>
bash-3.2$ less alert_tetris11.log
Dumping diagnostic data in directory=[cdmp_20130614165402],
requested by (instance=1, osid=1193 (MMON)), summary=[incident=2314801].
Errors in file /u02/app/oracle/diag/rdbms/tetris11/tetris11/trace/tetris11_mmon_1193.trc (incident=2314803):
ORA-00600: internal error code, arguments: [4194], [], [],
[], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [], [],
[], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [], [],
[], [], [], [], [], [], [], [], []
Incident details in:
/u02/app/oracle/diag/rdbms/tetris11/tetris11/incident/incdir_2314803/tetris11_mmon_1193_i2314803.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging
details.
Errors in file
/u02/app/oracle/diag/rdbms/tetris11/tetris11/trace/tetris11_mmon_1193.trc (incident=2314804):
ORA-00603: ORACLE server session terminated by fatal error
ORA-24557: error 600 encountered while handling error 600;
exiting server process
ORA-00600: internal error code, arguments: [4194], [], [],
[], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [], [],
[], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [], [],
[], [], [], [], [], [], [], [], []
Incident details in:
/u02/app/oracle/diag/rdbms/tetris11/tetris11/incident/incdir_2314804/tetris11_mmon_1193_i2314804.trc
Dumping diagnostic data in directory=[cdmp_20130614165404],
requested by (instance=1, osid=1193 (MMON)), summary=[incident=2314802].
opidrv aborting process MMON ospid (1193) as a result of
ORA-603
Dumping diagnostic data in directory=[cdmp_20130614165405],
requested by (instance=1, osid=1193 (MMON)), summary=[incident=2314804].
Fri Jun 14 16:54:07 2013
Errors in file
/u02/app/oracle/diag/rdbms/tetris11/tetris11/trace/tetris11_pmon_1165.trc (incident=2314697):
ORA-00600: internal error code, arguments: [4194], [], [],
[], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging
details.
Errors in file
/u02/app/oracle/diag/rdbms/tetris11/tetris11/trace/tetris11_pmon_1165.trc:
ORA-00600: internal error code, arguments: [4194], [], [],
[], [], [], [], [], [], [], [], []
PMON (ospid: 1165): terminating the instance due to error
472
System state dump requested by (instance=1, osid=1165
(PMON)), summary=[abnormal instance termination].
System State dumped to trace file
/u02/app/oracle/diag/rdbms/tetris11/tetris11/trace/tetris11_diag_1175.trc
Dumping diagnostic data in directory=[cdmp_20130614165408],
requested by (instance=1, osid=1165 (PMON)), summary=[abnormal instance termination].
Instance terminated by PMON, pid = 1165
Solution
Basic Steps to be Followed While Solving
ORA-00600 [4194]/[4193] Errors Without Using Unsupported parameter [ID 281429.1]
bash-3.2$ cd
/u02/app/oracle/fast_recovery_area/TETRIS11/backupset/
bash-3.2$ cp -R 2013_06_14 2013_06_14_old
bash-3.2$
bash-3.2$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Fri Jun 14
16:19:00 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
MOUNTED
SQL> show parameter undo;
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
SQL>
bash-3.2$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Fri Jun 14
16:31:11 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL>
SQL>
SQL> create pfile from spfile;
File created.
SQL> show parameter undo;
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace
string UNDOTBS1
SQL> desc dba_data_files;
ERROR:
ORA-04043: object dba_data_files does not exist
SQL> alter system set undo_management='MANUAL'
scope=spfile;
System altered.
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size
2232840 bytes
Variable Size
864030200 bytes
Database Buffers
197132288 bytes
Redo Buffers
5541888 bytes
Database mounted.
Database opened.
SQL> create undo tablespace UNDOTBS02 datafile
'/u02/app/oracle/oradata/tetris11/undotbs02.dbf' size 100m autoextend on
maxsize 1G;
Tablespace created.
SQL> alter system set undo_tablespace='UNDOTBS02'
scope=spfile;
System altered.
SQL> alter system set undo_management='AUTO'
scope=spfile;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size
2232840 bytes
Variable Size
864030200 bytes
Database Buffers
197132288 bytes
Redo Buffers
5541888 bytes
Database mounted.
Database opened.
SQL>
The old undo tablespace can be now dropped.
No comments:
Post a Comment