ORA-01092: ORACLE instance terminated. Disconnection forced
HI,
All when iam trying to open the database its giving me the error
i chkd the alert logfile it gives me the message Errr : in recursive sql 1
please help!!!!
Alter log
========
Sun Mar 04 11:30:05 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\oracle\oradata\orcl\CONTROL01.CTL, D:\oracle\oradata\orcl\CONTROL02.CTL, D:\oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 4096
db_cache_size = 33554432
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 8
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 900
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = FALSE
background_dump_dest = D:\oracle\admin\orcl\bdump
user_dump_dest = D:\oracle\admin\orcl\udump
core_dump_dest = D:\oracle\admin\orcl\cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 16777216
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Sun Mar 04 11:30:07 2012
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sun Mar 04 11:30:08 2012
ALTER DATABASE MOUNT
Sun Mar 04 11:30:12 2012
Successful mount of redo thread 1, with mount id 1304790976.
Sun Mar 04 11:30:12 2012
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Sun Mar 04 11:30:12 2012
ALTER DATABASE OPEN
Sun Mar 04 11:30:13 2012
Beginning crash recovery of 1 threads
Sun Mar 04 11:30:13 2012
Started first pass scan
Sun Mar 04 11:30:13 2012
Completed first pass scan
2 redo blocks read, 0 data blocks need recovery
Sun Mar 04 11:30:13 2012
Started recovery at
Thread 1: logseq 82, block 3, scn 0.117622663
Recovery of Online Redo Log: Thread 1 Group 3 Seq 82 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Sun Mar 04 11:30:13 2012
Ended recovery at
Thread 1: logseq 82, block 5, scn 0.117642665
0 data blocks read, 0 data blocks written, 2 redo blocks read
Crash recovery completed successfully
Sun Mar 04 11:30:13 2012
Thread 1 advanced to log sequence 83
Thread 1 opened at log sequence 83
Current log# 1 seq# 83 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Successful open of redo thread 1.
Sun Mar 04 11:30:14 2012
SMON: enabling cache recovery
Sun Mar 04 11:30:15 2012
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_2412.trc:
ORA-00600: internal error code, arguments: [4193], [62], [68], [], [], [], [], []
Sun Mar 04 11:30:15 2012
Recovery of Online Redo Log: Thread 1 Group 1 Seq 83 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Recovery of Online Redo Log: Thread 1 Group 1 Seq 83 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Sun Mar 04 11:30:16 2012
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_2412.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [62], [68], [], [], [], [], []
Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Sun Mar 04 11:30:17 2012
Errors in file d:\oracle\admin\orcl\bdump\orcl_pmon_1904.trc:
ORA-00604: error occurred at recursive SQL level
Instance terminated by USER, pid = 2412
ORA-1092 signalled during: ALTER DATABASE OPEN...
Sun Mar 04 11:38:08 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 54525952
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\oracle\oradata\orcl\CONTROL01.CTL, D:\oracle\oradata\orcl\CONTROL02.CTL, D:\oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 4096
db_cache_size = 33554432
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 8
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 900
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = FALSE
background_dump_dest = D:\oracle\admin\orcl\bdump
user_dump_dest = D:\oracle\admin\orcl\udump
core_dump_dest = D:\oracle\admin\orcl\cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 16777216
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Sun Mar 04 11:38:11 2012
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sun Mar 04 11:38:11 2012
ALTER DATABASE MOUNT
Sun Mar 04 11:38:15 2012
Successful mount of redo thread 1, with mount id 1304828579.
Sun Mar 04 11:38:15 2012
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Sun Mar 04 11:38:15 2012
ALTER DATABASE OPEN
Sun Mar 04 11:38:16 2012
Beginning crash recovery of 1 threads
Sun Mar 04 11:38:16 2012
Started first pass scan
Sun Mar 04 11:38:16 2012
Completed first pass scan
2 redo blocks read, 0 data blocks need recovery
Sun Mar 04 11:38:16 2012
Started recovery at
Thread 1: logseq 83, block 3, scn 0.117642668
Recovery of Online Redo Log: Thread 1 Group 1 Seq 83 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Sun Mar 04 11:38:16 2012
Ended recovery at
Thread 1: logseq 83, block 5, scn 0.117662670
0 data blocks read, 0 data blocks written, 2 redo blocks read
Crash recovery completed successfully
Sun Mar 04 11:38:16 2012
Thread 1 advanced to log sequence 84
Thread 1 opened at log sequence 84
Current log# 2 seq# 84 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Successful open of redo thread 1.
Sun Mar 04 11:38:17 2012
SMON: enabling cache recovery
Sun Mar 04 11:38:18 2012
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_2896.trc:
ORA-00600: internal error code, arguments: [4193], [62], [68], [], [], [], [], []
Sun Mar 04 11:38:19 2012
Recovery of Online Redo Log: Thread 1 Group 2 Seq 84 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Recovery of Online Redo Log: Thread 1 Group 2 Seq 84 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Sun Mar 04 11:38:19 2012
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_2896.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [62], [68], [], [], [], [], []
Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Sun Mar 04 11:38:21 2012
Errors in file d:\oracle\admin\orcl\bdump\orcl_pmon_3392.trc:
ORA-00604: error occurred at recursive SQL level
Instance terminated by USER, pid = 2896
ORA-1092 signalled during: ALTER DATABASE OPEN...