Oracle Database Discussions

Hi People,

I guess this is not my week. After struggling and finally solving the other problem, someone shutdown the database ad now I cannot start it up again. Tried all the startup options but.... Below are extracts from the alert log. I am getting the error above. Any help will be greatly appreciated.



Fri Apr 27 08:14:04 2007
Errors in file e:\oracle\admin\csr\udump\csr_ora_736.trc:
ORA-12571: TNS : échec à l'écriture du paquet

Fri Apr 27 08:15:22 2007
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
Fri Apr 27 08:20:29 2007
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
Fri Apr 27 08:25:42 2007
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
Fri Apr 27 08:30:55 2007
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
Fri Apr 27 08:36:03 2007
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
Fri Apr 27 08:41:11 2007
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
Fri Apr 27 08:46:19 2007
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
Fri Apr 27 08:49:32 2007
Errors in file e:\oracle\admin\csr\udump\csr_ora_2736.trc:
ORA-12571: TNS : échec à l'écriture du paquet

Fri Apr 27 08:49:55 2007
Shutting down instance: further logons disabled
Fri Apr 27 08:50:06 2007
Shutting down instance (immediate)
License high water mark = 148
Fri Apr 27 08:50:06 2007
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
Fri Apr 27 08:55:14 2007
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
Fri Apr 27 08:55:15 2007
Active call for process 2724 user 'SYSTEM' program 'ORACLE.EXE'
Active call for process 2240 user 'SYSTEM' program 'ORACLE.EXE'
Active call for process 2388 user 'SYSTEM' program 'ORACLE.EXE'
SHUTDOWN: waiting for active calls to complete.
Fri Apr 27 09:00:22 2007
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
Fri Apr 27 09:05:30 2007
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
Fri Apr 27 09:08:44 2007
Errors in file e:\oracle\admin\csr\udump\csr_ora_2240.trc:
ORA-00600: code erreur interne, arguments : [12700], [31079], [79814359], [0], [79721051], [25], [], []

Fri Apr 27 09:08:46 2007
Errors in file e:\oracle\admin\csr\udump\csr_ora_2240.trc:
ORA-00600: code erreur interne, arguments : [12700], [31079], [79814359], [0], [79721051], [25], [], []

Fri Apr 27 09:10:37 2007
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
Fri Apr 27 09:11:04 2007
Errors in file e:\oracle\admin\csr\udump\csr_ora_2724.trc:
ORA-00600: code erreur interne, arguments : [12700], [31079], [92399011], [22], [83921286], [25], [], []

Fri Apr 27 09:11:04 2007
Errors in file e:\oracle\admin\csr\udump\csr_ora_2724.trc:
ORA-00600: code erreur interne, arguments : [12700], [31079], [92399011], [22], [83921286], [25], [], []

Fri Apr 27 09:11:47 2007
Errors in file e:\oracle\admin\csr\udump\csr_ora_2388.trc:
ORA-00600: code erreur interne, arguments : [12700], [31079], [92399011], [22], [83921286], [25], [], []

Fri Apr 27 09:11:50 2007
All dispatchers and shared servers shutdown
Fri Apr 27 09:11:51 2007
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
Fri Apr 27 09:11:58 2007
ALTER DATABASE CLOSE NORMAL
SMON: disabling tx recovery
Fri Apr 27 09:12:15 2007
SMON: disabling cache recovery
Fri Apr 27 09:12:17 2007
Shutting down archive processes
Archiving is disabled
Fri Apr 27 09:12:17 2007
ARCH shutting down
Fri Apr 27 09:12:17 2007
ARC0: Archival stopped
Fri Apr 27 09:12:17 2007
Thread 1 closed at log sequence 1243
Successful close of redo thread 1.
Fri Apr 27 09:12:18 2007
ARCH shutting down
Fri Apr 27 09:12:20 2007
ARC1: Archival stopped
Fri Apr 27 09:12:37 2007
Completed: ALTER DATABASE CLOSE NORMAL
Fri Apr 27 09:12:38 2007
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Dump file e:\oracle\admin\csr\bdump\alert_csr.log
Fri Apr 27 09:17:53 2007
ORACLE V9.2.0.4.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Fri Apr 27 09:17:53 2007
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.4.0.
System parameters with non-default values:
processes = 400
timed_statistics = TRUE
shared_pool_size = 327155712
sga_max_size = 848372908
large_pool_size = 33554432
java_pool_size = 176160768
control_files = E:\oracle\oradata\CSR\CONTROL01.CTL, E:\oracle\oradata\CSR\CONTROL02.CTL, E:\oracle\oradata\CSR\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 75497472
compatible = 9.2.0.0.0
log_archive_start = TRUE
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
max_rollback_segments = 1600
rollback_segments = 1600
undo_management = AUTO
undo_tablespace = UNDOTBS3
undo_retention = 36000
max_enabled_roles = 120
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = CSR
dispatchers = (PROTOCOL=TCP) (SERVICE=CSRXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = E:\oracle\admin\CSR\bdump
user_dump_dest = E:\oracle\admin\CSR\udump
core_dump_dest = E:\oracle\admin\CSR\cdump
sort_area_size = 524288
db_name = CSR
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 69206016
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=8
CJQ0 started with pid=9
QMN0 started with pid=10
Fri Apr 27 09:18:01 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=13
ARC0: Archival started
Fri Apr 27 09:18:02 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Fri Apr 27 09:18:02 2007
ARC0: Thread not mounted
Fri Apr 27 09:18:03 2007
alter database mount exclusive
ARC1 started with pid=14
Fri Apr 27 09:18:03 2007
ARC1: Archival started
ARC1: Thread not mounted
Fri Apr 27 09:18:08 2007
Successful mount of redo thread 1, with mount id 3767612491.
Fri Apr 27 09:18:08 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Fri Apr 27 09:18:08 2007
alter database open
Fri Apr 27 09:18:14 2007
Thread 1 opened at log sequence 1243
Current log# 3 seq# 1243 mem# 0: E:\ORACLE\ORADATA\CSR\REDO03.LOG
Successful open of redo thread 1.
Fri Apr 27 09:18:14 2007
SMON: enabling cache recovery
Fri Apr 27 09:18:15 2007
ARC1: Media recovery disabled
Fri Apr 27 09:18:17 2007
Errors in file e:\oracle\admin\csr\udump\csr_ora_1184.trc:
ORA-00600: code erreur interne, arguments : [25012], [1], [2], [], [], [], [], []

Fri Apr 27 09:18:20 2007
Errors in file e:\oracle\admin\csr\udump\csr_ora_1184.trc:
ORA-00600: code erreur interne, arguments : [25012], [1], [2], [], [], [], [], []

Fri Apr 27 09:18:20 2007
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Fri Apr 27 09:18:30 2007
Errors in file e:\oracle\admin\csr\bdump\csr_pmon_2280.trc:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

Fri Apr 27 09:18:33 2007
Instance terminated by USER, pid = 1184
ORA-1092 signalled during: alter database open...
Fri Apr 27 09:19:11 2007
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.4.0.
System parameters with non-default values:
processes = 400
timed_statistics = TRUE
shared_pool_size = 327155712
sga_max_size = 848372908
large_pool_size = 33554432
java_pool_size = 176160768
control_files = E:\oracle\oradata\CSR\CONTROL01.CTL, E:\oracle\oradata\CSR\CONTROL02.CTL, E:\oracle\oradata\CSR\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 75497472
compatible = 9.2.0.0.0
log_archive_start = TRUE
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
max_rollback_segments = 1600
rollback_segments = 1600
undo_management = AUTO
undo_tablespace = UNDOTBS3
undo_retention = 36000
max_enabled_roles = 120
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = CSR
dispatchers = (PROTOCOL=TCP) (SERVICE=CSRXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = E:\oracle\admin\CSR\bdump
user_dump_dest = E:\oracle\admin\CSR\udump
core_dump_dest = E:\oracle\admin\CSR\cdump
sort_area_size = 524288
db_name = CSR
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 69206016
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
Fri Apr 27 09:19:15 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=12
ARC0: Archival started
Fri Apr 27 09:19:16 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Fri Apr 27 09:19:16 2007
ARC0: Thread not mounted
Fri Apr 27 09:19:17 2007
/* OracleOEM */ ALTER DATABASE MOUNT
ARC1 started with pid=13
Fri Apr 27 09:19:17 2007
ARC1: Archival started
ARC1: Thread not mounted
Fri Apr 27 09:19:22 2007
Successful mount of redo thread 1, with mount id 3767605141.
Fri Apr 27 09:19:22 2007
Database mounted in Exclusive Mode.
Completed: /* OracleOEM */ ALTER DATABASE MOUNT
Fri Apr 27 09:19:22 2007
/* OracleOEM */ ALTER DATABASE OPEN
Fri Apr 27 09:19:23 2007
Beginning crash recovery of 1 threads
Fri Apr 27 09:19:23 2007
Started first pass scan
Fri Apr 27 09:19:24 2007
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Fri Apr 27 09:19:24 2007
Started recovery at
Thread 1: logseq 1243, block 192990, scn 0.121580859
Recovery of Online Redo Log: Thread 1 Group 3 Seq 1243 Reading mem 0
Mem# 0 errs 0: E:\ORACLE\ORADATA\CSR\REDO03.LOG
Fri Apr 27 09:19:24 2007
Completed redo application
Fri Apr 27 09:19:24 2007
Ended recovery at
Thread 1: logseq 1243, block 192990, scn 0.121600860
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Fri Apr 27 09:19:24 2007
Thread 1 advanced to log sequence 1244
Thread 1 opened at log sequence 1244
Current log# 1 seq# 1244 mem# 0: E:\ORACLE\ORADATA\CSR\REDO01.LOG
Successful open of redo thread 1.
Fri Apr 27 09:19:25 2007
SMON: enabling cache recovery
Fri Apr 27 09:19:26 2007
Errors in file e:\oracle\admin\csr\udump\csr_ora_2320.trc:
ORA-00600: code erreur interne, arguments : [25012], [1], [2], [], [], [], [], []

Fri Apr 27 09:19:26 2007
ARC0: Media recovery disabled
Fri Apr 27 09:19:27 2007
Errors in file e:\oracle\admin\csr\udump\csr_ora_2320.trc:
ORA-00600: code erreur interne, arguments : [25012], [1], [2], [], [], [], [], []

Fri Apr 27 09:19:27 2007
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Fri Apr 27 09:19:36 2007
Errors in file e:\oracle\admin\csr\bdump\csr_pmon_2232.trc:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

Instance terminated by USER, pid = 2320
ORA-1092 signalled during: /* OracleOEM */ ALTER DATABASE OPEN ...
Dump file e:\oracle\admin\csr\bdump\alert_csr.log
Fri Apr 27 09:34:00 2007
ORACLE V9.2.0.4.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Fri Apr 27 09:34:00 2007
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.4.0.
System parameters with non-default values:
processes = 400
timed_statistics = TRUE
shared_pool_size = 327155712
sga_max_size = 848372908
large_pool_size = 33554432
java_pool_size = 176160768
control_files = E:\oracle\oradata\CSR\CONTROL01.CTL, E:\oracle\oradata\CSR\CONTROL02.CTL, E:\oracle\oradata\CSR\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 75497472
compatible = 9.2.0.0.0
log_archive_start = TRUE
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
max_rollback_segments = 1600
rollback_segments = 1600
undo_management = AUTO
undo_tablespace = UNDOTBS3
undo_retention = 36000
max_enabled_roles = 120
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = CSR
dispatchers = (PROTOCOL=TCP) (SERVICE=CSRXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = E:\oracle\admin\CSR\bdump
user_dump_dest = E:\oracle\admin\CSR\udump
core_dump_dest = E:\oracle\admin\CSR\cdump
sort_area_size = 524288
db_name = CSR
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 69206016
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
Fri Apr 27 09:34:07 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=12
ARC0: Archival started
Fri Apr 27 09:34:09 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Fri Apr 27 09:34:09 2007
ARC0: Thread not mounted
Fri Apr 27 09:34:09 2007
alter database mount exclusive
ARC1 started with pid=13
Fri Apr 27 09:34:09 2007
ARC1: Archival started
ARC1: Thread not mounted
Fri Apr 27 09:34:14 2007
Successful mount of redo thread 1, with mount id 3767569681.
Fri Apr 27 09:34:14 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Fri Apr 27 09:34:14 2007
alter database open
Fri Apr 27 09:34:20 2007
Beginning crash recovery of 1 threads
Fri Apr 27 09:34:20 2007
Started first pass scan
Fri Apr 27 09:34:21 2007
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Fri Apr 27 09:34:21 2007
Started recovery at
Thread 1: logseq 1244, block 3, scn 0.121600863
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1244 Reading mem 0
Mem# 0 errs 0: E:\ORACLE\ORADATA\CSR\REDO01.LOG
Fri Apr 27 09:34:21 2007
Completed redo application
Fri Apr 27 09:34:21 2007
Ended recovery at
Thread 1: logseq 1244, block 3, scn 0.121620864
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Fri Apr 27 09:34:23 2007
Thread 1 advanced to log sequence 1245
Thread 1 opened at log sequence 1245
Current log# 2 seq# 1245 mem# 0: E:\ORACLE\ORADATA\CSR\REDO02.LOG
Successful open of redo thread 1.
Fri Apr 27 09:34:26 2007
SMON: enabling cache recovery
Fri Apr 27 09:34:26 2007
ARC0: Media recovery disabled
Fri Apr 27 09:34:28 2007
Errors in file e:\oracle\admin\csr\udump\csr_ora_1268.trc:
ORA-00600: code erreur interne, arguments : [25012], [1], [2], [], [], [], [], []

Fri Apr 27 09:34:30 2007
Errors in file e:\oracle\admin\csr\udump\csr_ora_1268.trc:
ORA-00600: code erreur interne, arguments : [25012], [1], [2], [], [], [], [], []

Fri Apr 27 09:34:30 2007
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Fri Apr 27 09:34:42 2007
Errors in file e:\oracle\admin\csr\bdump\csr_pmon_2268.trc:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

Fri Apr 27 09:34:42 2007
Instance terminated by USER, pid = 1268
ORA-1092 signalled during: alter database open...
Fri Apr 27 09:36:56 2007
Starting ORACLE instance (force)
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.4.0.
System parameters with non-default values:
processes = 400
timed_statistics = TRUE
shared_pool_size = 327155712
sga_max_size = 848372908
large_pool_size = 33554432
java_pool_size = 176160768
control_files = E:\oracle\oradata\CSR\CONTROL01.CTL, E:\oracle\oradata\CSR\CONTROL02.CTL, E:\oracle\oradata\CSR\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 75497472
compatible = 9.2.0.0.0
log_archive_start = TRUE
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
max_rollback_segments = 1600
rollback_segments = 1600
undo_management = AUTO
undo_tablespace = UNDOTBS3
undo_retention = 36000
max_enabled_roles = 120
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = CSR
dispatchers = (PROTOCOL=TCP) (SERVICE=CSRXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = E:\oracle\admin\CSR\bdump
user_dump_dest = E:\oracle\admin\CSR\udump
core_dump_dest = E:\oracle\admin\CSR\cdump
sort_area_size = 524288
db_name = CSR
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 69206016
aq_tm_processes = 1
PMON started with pid=3
DBW0 started with pid=4
LGWR started with pid=5
CKPT started with pid=6
SMON started with pid=7
RECO started with pid=8
CJQ0 started with pid=9
QMN0 started with pid=10
Fri Apr 27 09:36:59 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=14
ARC0: Archival started
Fri Apr 27 09:37:01 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Fri Apr 27 09:37:01 2007
ARC0: Thread not mounted
Fri Apr 27 09:37:01 2007
ALTER DATABASE MOUNT
ARC1 started with pid=15
Fri Apr 27 09:37:01 2007
ARC1: Archival started
ARC1: Thread not mounted
Fri Apr 27 09:37:05 2007
Successful mount of redo thread 1, with mount id 3767566013.
Fri Apr 27 09:37:05 2007
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Fri Apr 27 09:37:05 2007
ALTER DATABASE OPEN
Fri Apr 27 09:37:05 2007
Beginning crash recovery of 1 threads
Fri Apr 27 09:37:06 2007
Started first pass scan
Fri Apr 27 09:37:06 2007
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Fri Apr 27 09:37:06 2007
Started recovery at
Thread 1: logseq 1245, block 3, scn 0.121620867
Recovery of Online Redo Log: Thread 1 Group 2 Seq 1245 Reading mem 0
Mem# 0 errs 0: E:\ORACLE\ORADATA\CSR\REDO02.LOG
Fri Apr 27 09:37:06 2007
Completed redo application
Fri Apr 27 09:37:06 2007
Ended recovery at
Thread 1: logseq 1245, block 3, scn 0.121640868
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Fri Apr 27 09:37:07 2007
Thread 1 advanced to log sequence 1246
Thread 1 opened at log sequence 1246
Current log# 3 seq# 1246 mem# 0: E:\ORACLE\ORADATA\CSR\REDO03.LOG
Successful open of redo thread 1.
Fri Apr 27 09:37:07 2007
SMON: enabling cache recovery
Fri Apr 27 09:37:08 2007
Errors in file e:\oracle\admin\csr\udump\csr_ora_1060.trc:
ORA-00600: code erreur interne, arguments : [25012], [1], [2], [], [], [], [], []

Fri Apr 27 09:37:08 2007
ARC0: Media recovery disabled
Fri Apr 27 09:37:09 2007
Errors in file e:\oracle\admin\csr\udump\csr_ora_1060.trc:
ORA-00600: code erreur interne, arguments : [25012], [1], [2], [], [], [], [], []

Fri Apr 27 09:37:09 2007
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Fri Apr 27 09:37:18 2007
Errors in file e:\oracle\admin\csr\bdump\csr_pmon_1692.trc:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

Instance terminated by USER, pid = 1060
ORA-1092 signalled during: ALTER DATABASE OPEN...
Dump file e:\oracle\admin\csr\bdump\alert_csr.log
Fri Apr 27 09:45:50 2007
ORACLE V9.2.0.4.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Fri Apr 27 09:45:50 2007
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.4.0.
System parameters with non-default values:
processes = 400
timed_statistics = TRUE
shared_pool_size = 327155712
sga_max_size = 848372908
large_pool_size = 33554432
java_pool_size = 176160768
control_files = E:\oracle\oradata\CSR\CONTROL01.CTL, E:\oracle\oradata\CSR\CONTROL02.CTL, E:\oracle\oradata\CSR\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 75497472
compatible = 9.2.0.0.0
log_archive_start = TRUE
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
max_rollback_segments = 1600
rollback_segments = 1600
undo_management = AUTO
undo_tablespace = UNDOTBS3
undo_retention = 36000
max_enabled_roles = 120
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = CSR
dispatchers = (PROTOCOL=TCP) (SERVICE=CSRXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = E:\oracle\admin\CSR\bdump
user_dump_dest = E:\oracle\admin\CSR\udump
core_dump_dest = E:\oracle\admin\CSR\cdump
sort_area_size = 524288
db_name = CSR
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 69206016
aq_tm_processes = 1
PMON started with pid=2
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
DBW0 started with pid=3
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Fri Apr 27 09:45:58 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=12
ARC0: Archival started
Fri Apr 27 09:45:59 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Fri Apr 27 09:45:59 2007
ARC0: Thread not mounted
Fri Apr 27 09:45:59 2007
alter database mount exclusive
ARC1 started with pid=13
Fri Apr 27 09:46:00 2007
ARC1: Archival started
ARC1: Thread not mounted
Fri Apr 27 09:46:04 2007
Successful mount of redo thread 1, with mount id 3767577303.
Fri Apr 27 09:46:04 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Fri Apr 27 09:46:04 2007
alter database open
Fri Apr 27 09:46:12 2007
Beginning crash recovery of 1 threads
Fri Apr 27 09:46:12 2007
Started first pass scan
Fri Apr 27 09:46:13 2007
Completed first pass scan
1 redo blocks read, 0 data blocks need recovery
Fri Apr 27 09:46:13 2007
Started recovery at
Thread 1: logseq 1246, block 2, scn 0.121640870
Recovery of Online Redo Log: Thread 1 Group 3 Seq 1246 Reading mem 0
Mem# 0 errs 0: E:\ORACLE\ORADATA\CSR\REDO03.LOG
Fri Apr 27 09:46:13 2007
Completed redo application
Fri Apr 27 09:46:13 2007
Ended recovery at
Thread 1: logseq 1246, block 3, scn 0.121660871
0 data blocks read, 0 data blocks written, 1 redo blocks read
Crash recovery completed successfully
Fri Apr 27 09:46:14 2007
Thread 1 advanced to log sequence 1247
Thread 1 opened at log sequence 1247
Current log# 1 seq# 1247 mem# 0: E:\ORACLE\ORADATA\CSR\REDO01.LOG
Successful open of redo thread 1.
Fri Apr 27 09:46:16 2007
SMON: enabling cache recovery
Fri Apr 27 09:46:16 2007
ARC0: Media recovery disabled
Fri Apr 27 09:46:18 2007
Errors in file e:\oracle\admin\csr\udump\csr_ora_1268.trc:
ORA-00600: code erreur interne, arguments : [25012], [1], [2], [], [], [], [], []

Fri Apr 27 09:46:19 2007
Errors in file e:\oracle\admin\csr\udump\csr_ora_1268.trc:
ORA-00600: code erreur interne, arguments : [25012], [1], [2], [], [], [], [], []

Fri Apr 27 09:46:19 2007
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Fri Apr 27 09:46:27 2007
Errors in file e:\oracle\admin\csr\bdump\csr_pmon_2048.trc:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

Fri Apr 27 09:46:30 2007
Instance terminated by USER, pid = 1268
ORA-1092 signalled during: alter database open...
Fri Apr 27 09:47:06 2007
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.4.0.
System parameters with non-default values:
processes = 400
timed_statistics = TRUE
shared_pool_size = 327155712
sga_max_size = 848372908
large_pool_size = 33554432
java_pool_size = 176160768
control_files = E:\oracle\oradata\CSR\CONTROL01.CTL, E:\oracle\oradata\CSR\CONTROL02.CTL, E:\oracle\oradata\CSR\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 75497472
compatible = 9.2.0.0.0
log_archive_start = TRUE
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
max_rollback_segments = 1600
rollback_segments = 1600
undo_management = AUTO
undo_tablespace = UNDOTBS3
undo_retention = 36000
max_enabled_roles = 120
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = CSR
dispatchers = (PROTOCOL=TCP) (SERVICE=CSRXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = E:\oracle\admin\CSR\bdump
user_dump_dest = E:\oracle\admin\CSR\udump
core_dump_dest = E:\oracle\admin\CSR\cdump
sort_area_size = 524288
db_name = CSR
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 69206016
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
Fri Apr 27 09:47:10 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=12
ARC0: Archival started
Fri Apr 27 09:47:11 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Fri Apr 27 09:47:11 2007
ARC0: Thread not mounted
Fri Apr 27 09:47:11 2007
ALTER DATABASE MOUNT
ARC1 started with pid=13
Fri Apr 27 09:47:11 2007
ARC1: Archival started
ARC1: Thread not mounted
Fri Apr 27 09:47:15 2007
Successful mount of redo thread 1, with mount id 3767577631.
Fri Apr 27 09:47:15 2007
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Fri Apr 27 09:47:32 2007
ALTER DATABASE RECOVER database
Fri Apr 27 09:47:32 2007
Media Recovery Start
Starting datafile 1 recovery in thread 1 sequence 1247
Datafile 1: 'E:\ORACLE\ORADATA\CSR\SYSTEM01.DBF'
Starting datafile 2 recovery in thread 1 sequence 1247
Datafile 2: 'F:\ORACLE\ORADATA\CSR\UNDOTBS306.ORA'
Starting datafile 3 recovery in thread 1 sequence 1247
Datafile 3: 'E:\ORACLE\ORADATA\CSR\CWMLITE01.DBF'
Starting datafile 4 recovery in thread 1 sequence 1247
Datafile 4: 'E:\ORACLE\ORADATA\CSR\DRSYS01.DBF'
Starting datafile 5 recovery in thread 1 sequence 1247
Datafile 5: 'E:\ORACLE\ORADATA\CSR\EXAMPLE01.DBF'
Starting datafile 6 recovery in thread 1 sequence 1247
Datafile 6: 'E:\ORACLE\ORADATA\CSR\INDX01.DBF'
Starting datafile 7 recovery in thread 1 sequence 1247
Datafile 7: 'E:\ORACLE\ORADATA\CSR\ODM01.DBF'
Starting datafile 8 recovery in thread 1 sequence 1247
Datafile 8: 'E:\ORACLE\ORADATA\CSR\TOOLS01.DBF'
Starting datafile 9 recovery in thread 1 sequence 1247
Datafile 9: 'E:\ORACLE\ORADATA\CSR\USERS01.DBF'
Starting datafile 10 recovery in thread 1 sequence 1247
Datafile 10: 'E:\ORACLE\ORADATA\CSR\XDB01.DBF'
Starting datafile 11 recovery in thread 1 sequence 1247
Datafile 11: 'E:\ORACLE\ORADATA\CSR\CSR01.ORA'
Starting datafile 12 recovery in thread 1 sequence 1247
Datafile 12: 'E:\ORACLE\ORADATA\CSR\CSR02.ORA'
Starting datafile 13 recovery in thread 1 sequence 1247
Datafile 13: 'E:\ORACLE\ORADATA\CSR\CSR03.ORA'
Starting datafile 14 recovery in thread 1 sequence 1247
Datafile 14: 'E:\ORACLE\ORADATA\CSR\CSR04.ORA'
Starting datafile 15 recovery in thread 1 sequence 1247
Datafile 15: 'E:\ORACLE\ORADATA\CSR\CSR05.ORA'
Starting datafile 16 recovery in thread 1 sequence 1247
Datafile 16: 'E:\ORACLE\ORADATA\CSR\CSR06.ORA'
Starting datafile 17 recovery in thread 1 sequence 1247
Datafile 17: 'E:\ORACLE\ORADATA\CSR\CSR07.ORA'
Starting datafile 18 recovery in thread 1 sequence 1247
Datafile 18: 'E:\ORACLE\ORADATA\CSR\CSR08.ORA'
Starting datafile 19 recovery in thread 1 sequence 1247
Datafile 19: 'E:\ORACLE\ORADATA\CSR\CSR09.ORA'
Starting datafile 20 recovery in thread 1 sequence 1247
Datafile 20: 'E:\ORACLE\ORADATA\CSR\CSR10.ORA'
Starting datafile 21 recovery in thread 1 sequence 1247
Datafile 21: 'E:\ORACLE\ORADATA\CSR\CSR11.ORA'
Starting datafile 22 recovery in thread 1 sequence 1247
Datafile 22: 'E:\ORACLE\ORADATA\CSR\CSR12.ORA'
Starting datafile 23 recovery in thread 1 sequence 1247
Datafile 23: 'E:\ORACLE\ORADATA\CSR\CSR13.ORA'
Starting datafile 24 recovery in thread 1 sequence 1247
Datafile 24: 'E:\ORACLE\ORADATA\CSR\CSR14.ORA'
Starting datafile 25 recovery in thread 1 sequence 1247
Datafile 25: 'E:\ORACLE\ORADATA\CSR\CSR15.ORA'
Starting datafile 26 recovery in thread 1 sequence 1247
Datafile 26: 'E:\ORACLE\ORADATA\CSR\CSR16.ORA'
Starting datafile 27 recovery in thread 1 sequence 1247
Datafile 27: 'E:\ORACLE\ORADATA\CSR\IMAGE01.ORA'
Starting datafile 28 recovery in thread 1 sequence 1247
Datafile 28: 'E:\ORACLE\ORADATA\CSR\IMAGE02.ORA'
Starting datafile 29 recovery in thread 1 sequence 1247
Datafile 29: 'F:\ORACLE\ORADATA\CSR\UNDOTBS307.ORA'
Starting datafile 30 recovery in thread 1 sequence 1247
Datafile 30: 'F:\ORACLE\ORADATA\CSR\UNDOTBS308.ORA'
Starting datafile 31 recovery in thread 1 sequence 1247
Datafile 31: 'F:\ORACLE\ORADATA\CSR\UNDOTBS309.ORA'
Starting datafile 32 recovery in thread 1 sequence 1247
Datafile 32: 'F:\ORACLE\ORADATA\CSR\UNDOTBS3010.ORA'
Starting datafile 36 recovery in thread 1 sequence 1247
Datafile 36: 'E:\ORACLE\ORADATA\CSR\DIS_REPOSITORY.DBF'
Starting datafile 37 recovery in thread 1 sequence 1247
Datafile 37: 'E:\ORACLE\ORADATA\CSR\INST_TBS_DES2.DBF'
Starting datafile 38 recovery in thread 1 sequence 1247
Datafile 38: 'E:\ORACLE\ORADATA\CSR\OEMREP01.DBF'
Starting datafile 39 recovery in thread 1 sequence 1247
Datafile 39: 'E:\ORACLE\ORADATA\CSR\DISCOVERER.DBF'
Starting datafile 40 recovery in thread 1 sequence 1247
Datafile 40: 'E:\ORACLE\ORADATA\CSR\IMAGE03.ORA'
Starting datafile 41 recovery in thread 1 sequence 1247
Datafile 41: 'E:\ORACLE\ORADATA\CSR\IMAGE04.ORA'
Starting datafile 42 recovery in thread 1 sequence 1247
Datafile 42: 'E:\ORACLE\ORADATA\CSR\CSR17.ORA'
Starting datafile 44 recovery in thread 1 sequence 1247
Datafile 44: 'F:\ORACLE\ORADATA\CSR\UNDOTBS301.ORA'
Starting datafile 45 recovery in thread 1 sequence 1247
Datafile 45: 'F:\ORACLE\ORADATA\CSR\UNDOTBS302.ORA'
Starting datafile 46 recovery in thread 1 sequence 1247
Datafile 46: 'F:\ORACLE\ORADATA\CSR\UNDOTBS303.ORA'
Starting datafile 47 recovery in thread 1 sequence 1247
Datafile 47: 'F:\ORACLE\ORADATA\CSR\UNDOTBS304.ORA'
Starting datafile 48 recovery in thread 1 sequence 1247
Datafile 48: 'F:\ORACLE\ORADATA\CSR\UNDOTBS305.ORA'
Media Recovery Log
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1247 Reading mem 0
Mem# 0 errs 0: E:\ORACLE\ORADATA\CSR\REDO01.LOG
Media Recovery Complete
Completed: ALTER DATABASE RECOVER database
Fri Apr 27 09:48:02 2007
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 4
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Fri Apr 27 09:48:04 2007
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Fri Apr 27 09:48:04 2007
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Fri Apr 27 09:48:07 2007
ARCH shutting down
Fri Apr 27 09:48:07 2007
ARC0: Archival stopped
Fri Apr 27 09:48:08 2007
ARCH shutting down
Fri Apr 27 09:48:08 2007
ARC1: Archival stopped
Fri Apr 27 09:48:09 2007
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Apr 27 09:48:29 2007
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.4.0.
System parameters with non-default values:
processes = 400
timed_statistics = TRUE
shared_pool_size = 327155712
sga_max_size = 848372908
large_pool_size = 33554432
java_pool_size = 176160768
control_files = E:\oracle\oradata\CSR\CONTROL01.CTL, E:\oracle\oradata\CSR\CONTROL02.CTL, E:\oracle\oradata\CSR\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 75497472
compatible = 9.2.0.0.0
log_archive_start = TRUE
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
max_rollback_segments = 1600
rollback_segments = 1600
undo_management = AUTO
undo_tablespace = UNDOTBS3
undo_retention = 36000
max_enabled_roles = 120
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = CSR
dispatchers = (PROTOCOL=TCP) (SERVICE=CSRXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = E:\oracle\admin\CSR\bdump
user_dump_dest = E:\oracle\admin\CSR\udump
core_dump_dest = E:\oracle\admin\CSR\cdump
sort_area_size = 524288
db_name = CSR
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 69206016
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
Fri Apr 27 09:48:32 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=12
ARC0: Archival started
Fri Apr 27 09:48:34 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Fri Apr 27 09:48:34 2007
ARC0: Thread not mounted
Fri Apr 27 09:48:34 2007
ALTER DATABASE MOUNT
ARC1 started with pid=13
Fri Apr 27 09:48:34 2007
ARC1: Archival started
ARC1: Thread not mounted
Fri Apr 27 09:48:38 2007
Successful mount of redo thread 1, with mount id 3767602802.
Fri Apr 27 09:48:38 2007
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Fri Apr 27 09:48:38 2007
ALTER DATABASE OPEN
Fri Apr 27 09:48:38 2007
Beginning crash recovery of 1 threads
Fri Apr 27 09:48:39 2007
Started first pass scan
Fri Apr 27 09:48:39 2007
Completed first pass scan
1 redo blocks read, 0 data blocks need recovery
Fri Apr 27 09:48:39 2007
Started recovery at
Thread 1: logseq 1247, block 2, scn 0.121660873
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1247 Reading mem 0
Mem# 0 errs 0: E:\ORACLE\ORADATA\CSR\REDO01.LOG
Fri Apr 27 09:48:39 2007
Completed redo application
Fri Apr 27 09:48:39 2007
Ended recovery at
Thread 1: logseq 1247, block 3, scn 0.121680874
0 data blocks read, 0 data blocks written, 1 redo blocks read
Crash recovery completed successfully
Fri Apr 27 09:48:39 2007
Thread 1 advanced to log sequence 1248
Thread 1 opened at log sequence 1248
Current log# 2 seq# 1248 mem# 0: E:\ORACLE\ORADATA\CSR\REDO02.LOG
Successful open of redo thread 1.
Fri Apr 27 09:48:40 2007
SMON: enabling cache recovery
Fri Apr 27 09:48:40 2007
Errors in file e:\oracle\admin\csr\udump\csr_ora_2168.trc:
ORA-00600: code erreur interne, arguments : [25012], [1], [2], [], [], [], [], []

Fri Apr 27 09:48:40 2007
ARC0: Media recovery disabled
Fri Apr 27 09:48:42 2007
Errors in file e:\oracle\admin\csr\udump\csr_ora_2168.trc:
ORA-00600: code erreur interne, arguments : [25012], [1], [2], [], [], [], [], []

Fri Apr 27 09:48:42 2007
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Fri Apr 27 09:48:51 2007
Errors in file e:\oracle\admin\csr\bdump\csr_pmon_2504.trc:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

Instance terminated by USER, pid = 2168
ORA-1092 signalled during: ALTER DATABASE OPEN...
Dump file e:\oracle\admin\csr\bdump\alert_csr.log
Fri Apr 27 10:17:23 2007
ORACLE V9.2.0.4.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Fri Apr 27 10:17:23 2007
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.4.0.
System parameters with non-default values:
processes = 400
timed_statistics = TRUE
shared_pool_size = 327155712
sga_max_size = 848372908
large_pool_size = 33554432
java_pool_size = 176160768
control_files = E:\oracle\oradata\CSR\CONTROL01.CTL, E:\oracle\oradata\CSR\CONTROL02.CTL, E:\oracle\oradata\CSR\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 75497472
compatible = 9.2.0.0.0
log_archive_start = TRUE
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
max_rollback_segments = 1600
rollback_segments = 1600
undo_management = AUTO
undo_tablespace = UNDOTBS3
undo_retention = 36000
max_enabled_roles = 120
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = CSR
dispatchers = (PROTOCOL=TCP) (SERVICE=CSRXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = E:\oracle\admin\CSR\bdump
user_dump_dest = E:\oracle\admin\CSR\udump
core_dump_dest = E:\oracle\admin\CSR\cdump
sort_area_size = 524288
db_name = CSR
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 69206016
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=9
QMN0 started with pid=10
Fri Apr 27 10:17:28 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=13
ARC0: Archival started
Fri Apr 27 10:17:29 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Fri Apr 27 10:17:29 2007
ARC0: Thread not mounted
Fri Apr 27 10:17:29 2007
alter database mount exclusive
ARC1 started with pid=14
Fri Apr 27 10:17:30 2007
ARC1: Archival started
ARC1: Thread not mounted
Fri Apr 27 10:17:34 2007
Successful mount of redo thread 1, with mount id 3767557433.
Fri Apr 27 10:17:34 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Fri Apr 27 10:17:34 2007
alter database open
Fri Apr 27 10:17:37 2007
Beginning crash recovery of 1 threads
Fri Apr 27 10:17:37 2007
Started first pass scan
Fri Apr 27 10:17:38 2007
Completed first pass scan
1 redo blocks read, 0 data blocks need recovery
Fri Apr 27 10:17:38 2007
Started recovery at
Thread 1: logseq 1248, block 2, scn 0.121680876
Recovery of Online Redo Log: Thread 1 Group 2 Seq 1248 Reading mem 0
Mem# 0 errs 0: E:\ORACLE\ORADATA\CSR\REDO02.LOG
Fri Apr 27 10:17:38 2007
Completed redo application
Fri Apr 27 10:17:38 2007
Ended recovery at
Thread 1: logseq 1248, block 3, scn 0.121700877
0 data blocks read, 0 data blocks written, 1 redo blocks read
Crash recovery completed successfully
Fri Apr 27 10:17:39 2007
Thread 1 advanced to log sequence 1249
Thread 1 opened at log sequence 1249
Current log# 3 seq# 1249 mem# 0: E:\ORACLE\ORADATA\CSR\REDO03.LOG
Successful open of redo thread 1.
Fri Apr 27 10:17:40 2007
SMON: enabling cache recovery
Fri Apr 27 10:17:40 2007
ARC0: Media recovery disabled
Fri Apr 27 10:17:41 2007
Errors in file e:\oracle\admin\csr\udump\csr_ora_2088.trc:
ORA-00600: code erreur interne, arguments : [25012], [1], [2], [], [], [], [], []

Fri Apr 27 10:17:43 2007
Errors in file e:\oracle\admin\csr\udump\csr_ora_2088.trc:
ORA-00600: code erreur interne, arguments : [25012], [1], [2], [], [], [], [], []

Fri Apr 27 10:17:43 2007
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Fri Apr 27 10:17:49 2007
Errors in file e:\oracle\admin\csr\bdump\csr_pmon_1760.trc:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

Instance terminated by USER, pid = 2088
ORA-1092 signalled during: alter database open...