Starting ORACLE instance (normal)
Sat Jan 21 13:55:15 2006
WARNING: EINVAL creating segment of size 0x0000000007400000
fix shm parameters in /etc/system or equivalent
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
_latch_class_1 = 10000
_latch_classes = 98:1
processes = 150
timed_statistics = FALSE
event =
shared_pool_size = 20971520
large_pool_size = 16777216
java_pool_size = 0
_kghdsidx_count = 1
control_files = /opt/oracle/oradata/conner/control01.ctl,
/opt/oracle/oradata/conner/control02.ctl,
/opt/oracle/oradata/conner/control03.ctl
db_block_size = 8192
db_2k_cache_size = 20971520
db_cache_size = 41943040
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest = /opt/oracle/oradata/conner/archive
_disable_logging = TRUE
db_files = 8
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
_allow_resetlogs_corruption= TRUE
_corrupted_rollback_segments=
undo_management = AUTO
undo_tablespace = UNDOTBS2
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
global_names = TRUE
instance_name = conner
utl_file_dir = /tmp
job_queue_processes = 0
_system_trig_enabled = FALSE
hash_join_enabled = TRUE
background_dump_dest = /opt/oracle/admin/conner/bdump
user_dump_dest = /opt/oracle/admin/conner/udump
core_dump_dest = /opt/oracle/admin/conner/cdump
audit_trail = DB
sort_area_size = 524288
db_name = conner
open_cursors = 300
sql_trace = FALSE
optimizer_mode = CHOOSE
star_transformation_enabled= FALSE
optimizer_index_cost_adj = 10000
query_rewrite_enabled = FALSE
_left_nested_loops_random= FALSE
_use_nosegment_indexes = FALSE
pga_aggregate_target = 20480000
aq_tm_processes = 0
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
Sat Jan 21 13:55:16 2006
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=8
ARC0: Archival started
Sat Jan 21 13:55:16 2006
ARCH: STARTING ARCH PROCESSES COMPLETE
Sat Jan 21 13:55:16 2006
ARC0: Thread not mounted
ARC1 started with pid=9
ARC1: Archival started
ARC1: Thread not mounted
Sat Jan 21 13:55:16 2006
ALTER DATABASE MOUNT
Sat Jan 21 13:55:20 2006
Successful mount of redo thread 1, with mount id 3192212932.
Sat Jan 21 13:55:20 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Sat Jan 21 13:55:20 2006
ALTER DATABASE OPEN
Sat Jan 21 13:55:20 2006
Beginning crash recovery of 1 threads
Sat Jan 21 13:55:20 2006
Started first pass scan
Sat Jan 21 13:55:21 2006
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Sat Jan 21 13:55:21 2006
Started recovery at
Thread 1: logseq 42, block 3, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 1 Seq 42 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata/conner/redo01.log
Sat Jan 21 13:55:21 2006
Completed redo application
Sat Jan 21 13:55:21 2006
Ended recovery at
Thread 1: logseq 42, block 3, scn 2073.1734548
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Sat Jan 21 13:55:21 2006
Thread 1 advanced to log sequence 43
Thread 1 opened at log sequence 43
Current log# 3 seq# 43 mem# 0: /opt/oracle/oradata/conner/redo03.log
Successful open of redo thread 1.
Sat Jan 21 13:55:21 2006
ARC0: Media recovery disabled
Sat Jan 21 13:55:21 2006
SMON: enabling cache recovery
Sat Jan 21 13:55:21 2006
Undo Segment 11 Onlined
Undo Segment 12 Onlined
Undo Segment 13 Onlined
Successfully onlined Undo Tablespace 16.
Sat Jan 21 13:55:21 2006
SMON: enabling tx recovery
Sat Jan 21 13:55:21 2006
Database Characterset is ZHS16GBK
Sat Jan 21 13:55:21 2006
Errors in file /opt/oracle/admin/conner/bdump/conner_smon_17113.trc:
ORA-00600: internal error code, arguments: [4194], [43], [46], [], [], [], [], []
Sat Jan 21 13:55:21 2006
Errors in file /opt/oracle/admin/conner/udump/conner_ora_17121.trc:
ORA-00600: internal error code, arguments: [4194], [45], [44], [], [], [], [], []
Sat Jan 21 13:55:26 2006
Recovery of Online Redo Log: Thread 1 Group 3 Seq 43 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata/conner/redo03.log
Sat Jan 21 13:55:26 2006
Recovery of Online Redo Log: Thread 1 Group 3 Seq 43 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata/conner/redo03.log
Sat Jan 21 13:55:26 2006
Recovery of Online Redo Log: Thread 1 Group 3 Seq 43 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata/conner/redo03.log
Sat Jan 21 13:55:26 2006
Recovery of Online Redo Log: Thread 1 Group 3 Seq 43 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata/conner/redo03.log
Sat Jan 21 13:55:26 2006
Errors in file /opt/oracle/admin/conner/bdump/conner_smon_17113.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: [4194], [43], [46], [], [], [], [], []
Sat Jan 21 13:55:26 2006
Errors in file /opt/oracle/admin/conner/udump/conner_ora_17121.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [45], [44], [], [], [], [], []
Error 607 happened during db open, shutting down database
USER: terminating instance due to error 607
Instance terminated by USER, pid = 17121
ORA-1092 signalled during: ALTER DATABASE OPEN... Sat Jan 21 13:56:58 2006
Starting ORACLE instance (normal)
Sat Jan 21 13:56:58 2006
WARNING: EINVAL creating segment of size 0x0000000006400000
fix shm parameters in /etc/system or equivalent
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
_latch_class_1 = 10000
_latch_classes = 98:1
processes = 150
timed_statistics = FALSE
shared_pool_size = 20971520
large_pool_size = 0
java_pool_size = 0
_kghdsidx_count = 1
control_files = /opt/oracle/oradata/conner/control01.ctl,
/opt/oracle/oradata/conner/control02.ctl,
/opt/oracle/oradata/conner/control03.ctl
db_block_size = 8192
db_2k_cache_size = 20971520
db_cache_size = 41943040
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest = /opt/oracle/oradata/conner/archive
_disable_logging = TRUE
db_files = 8
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
_allow_resetlogs_corruption= TRUE
_corrupted_rollback_segments= _SYSSMU11$, _SYSSMU12$, _SYSSMU13$
undo_management = AUTO
undo_tablespace = UNDOTBS2
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
global_names = TRUE
instance_name = conner
utl_file_dir = /tmp
job_queue_processes = 0
_system_trig_enabled = FALSE
hash_join_enabled = TRUE
background_dump_dest = /opt/oracle/admin/conner/bdump
user_dump_dest = /opt/oracle/admin/conner/udump
core_dump_dest = /opt/oracle/admin/conner/cdump
audit_trail = DB
sort_area_size = 524288
db_name = conner
open_cursors = 300
sql_trace = FALSE
optimizer_mode = CHOOSE
star_transformation_enabled= FALSE
optimizer_index_cost_adj = 10000
query_rewrite_enabled = FALSE
_left_nested_loops_random= FALSE
_use_nosegment_indexes = FALSE
pga_aggregate_target = 20480000
aq_tm_processes = 0
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
Sat Jan 21 13:56:58 2006
ARCH: STARTING ARCH PROCESSES
RECO started with pid=7
ARC0 started with pid=8
ARC0: Archival started
ARC1 started with pid=9
Sat Jan 21 13:56:58 2006
ARCH: STARTING ARCH PROCESSES COMPLETE
Sat Jan 21 13:56:58 2006
ARC1: Archival started
ARC1: Thread not mounted
Sat Jan 21 13:56:58 2006
ARC0: Thread not mounted
Sat Jan 21 13:56:58 2006
ALTER DATABASE MOUNT
Sat Jan 21 13:57:03 2006
Successful mount of redo thread 1, with mount id 3192214826.
Sat Jan 21 13:57:03 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Sat Jan 21 13:57:03 2006
ALTER DATABASE OPEN
Sat Jan 21 13:57:03 2006
Beginning crash recovery of 1 threads
Sat Jan 21 13:57:03 2006
Started first pass scan
Sat Jan 21 13:57:03 2006
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Sat Jan 21 13:57:03 2006
Started recovery at
Thread 1: logseq 44, block 2, scn 2073.1754552
Recovery of Online Redo Log: Thread 1 Group 4 Seq 44 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata/conner/redo04.log
Sat Jan 21 13:57:03 2006
Completed redo application
Sat Jan 21 13:57:03 2006
Ended recovery at
Thread 1: logseq 44, block 2, scn 2073.1774553
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Sat Jan 21 13:57:03 2006
Thread 1 advanced to log sequence 45
Thread 1 opened at log sequence 45
Current log# 2 seq# 45 mem# 0: /opt/oracle/oradata/conner/redo02.log
Successful open of redo thread 1.
Sat Jan 21 13:57:03 2006
ARC0: Media recovery disabled
Sat Jan 21 13:57:03 2006
SMON: enabling cache recovery
Sat Jan 21 13:57:03 2006
Successfully onlined Undo Tablespace 16.
Sat Jan 21 13:57:03 2006
SMON: enabling tx recovery
SMON: about to recover undo segment 11
SMON: mark undo segment 11 as needs recovery
SMON: about to recover undo segment 12
SMON: mark undo segment 12 as needs recovery
SMON: about to recover undo segment 13
SMON: mark undo segment 13 as needs recovery
Sat Jan 21 13:57:03 2006
Database Characterset is ZHS16GBK
Sat Jan 21 13:57:03 2006
SMON: about to recover undo segment 11
SMON: mark undo segment 11 as needs recovery
SMON: about to recover undo segment 12
SMON: mark undo segment 12 as needs recovery
SMON: about to recover undo segment 13
SMON: mark undo segment 13 as needs recovery
Sat Jan 21 13:57:04 2006
Created Undo Segment _SYSSMU1$
Undo Segment 1 Onlined
Completed: ALTER DATABASE OPEN
aSat Jan 21 14:02:11 2006
SMON: about to recover undo segment 11
SMON: mark undo segment 11 as needs recovery
SMON: about to recover undo segment 12
SMON: mark undo segment 12 as needs recovery
SMON: about to recover undo segment 13
SMON: mark undo segment 13 as needs recovery
Sat Jan 21 14:03:29 2006
create undo tablespace undotbs1
datafile '/opt/oracle/oradata/conner/undotbs1.dbf' size 10M
Sat Jan 21 14:03:29 2006
Created Undo Segment _SYSSMU2$
Created Undo Segment _SYSSMU3$
Created Undo Segment _SYSSMU4$
Created Undo Segment _SYSSMU5$
Created Undo Segment _SYSSMU6$
Created Undo Segment _SYSSMU7$
Created Undo Segment _SYSSMU8$
Created Undo Segment _SYSSMU9$
Created Undo Segment _SYSSMU10$
Created Undo Segment _SYSSMU14$
Starting control autobackup
Control autobackup written to DISK device
handle '/opt/oracle/product/9.2.0/dbs/c-3152029224-20060121-00'
Completed: create undo tablespace undotbs1
datafile '/opt/ora
Sat Jan 21 14:03:43 2006
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Undo Segment 14 Onlined
Successfully onlined Undo Tablespace 1.
Undo Segment 1 Offlined
Undo Tablespace 16 successfully switched out.
Sat Jan 21 14:03:43 2006
ALTER SYSTEM SET undo_tablespace='UNDOTBS1' SCOPE=MEMORY;
Sat Jan 21 14:07:18 2006
SMON: about to recover undo segment 11
SMON: mark undo segment 11 as needs recovery
SMON: about to recover undo segment 12
SMON: mark undo segment 12 as needs recovery
SMON: about to recover undo segment 13
SMON: mark undo segment 13 as needs recovery
Sat Jan 21 14:08:06 2006
drop tablespace undotbs2
Sat Jan 21 14:08:07 2006
Starting control autobackup
Control autobackup written to DISK device
handle '/opt/oracle/product/9.2.0/dbs/c-3152029224-20060121-01'
Completed: drop tablespace undotbs2
Sat Jan 21 14:08:23 2006
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 1
Sat Jan 21 14:08:23 2006
ALTER DATABASE CLOSE NORMAL
Sat Jan 21 14:08:23 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Sat Jan 21 14:08:23 2006
Shutting down archive processes
Archiving is disabled
Sat Jan 21 14:08:23 2006
ARCH shutting down
ARC0: Archival stopped
Sat Jan 21 14:08:23 2006
ARCH shutting down
ARC1: Archival stopped
Sat Jan 21 14:08:23 2006
Thread 1 closed at log sequence 45
Successful close of redo thread 1.
Sat Jan 21 14:08:23 2006
Completed: ALTER DATABASE CLOSE NORMAL
Sat Jan 21 14:08:23 2006
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
Sat Jan 21 14:08:30 2006
Starting ORACLE instance (normal)
Sat Jan 21 14:08:31 2006
WARNING: EINVAL creating segment of size 0x0000000006400000
fix shm parameters in /etc/system or equivalent
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
_latch_class_1 = 10000
_latch_classes = 98:1
processes = 150
timed_statistics = FALSE
shared_pool_size = 20971520
large_pool_size = 0
java_pool_size = 0
_kghdsidx_count = 1
control_files = /opt/oracle/oradata/conner/control01.ctl,
/opt/oracle/oradata/conner/control02.ctl,
/opt/oracle/oradata/conner/control03.ctl
db_block_size = 8192
db_2k_cache_size = 20971520
db_cache_size = 41943040
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest = /opt/oracle/oradata/conner/archive
_disable_logging = TRUE
db_files = 8
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
_allow_resetlogs_corruption= TRUE
_corrupted_rollback_segments=
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
global_names = TRUE
instance_name = conner
utl_file_dir = /tmp
job_queue_processes = 0
_system_trig_enabled = FALSE
hash_join_enabled = TRUE
background_dump_dest = /opt/oracle/admin/conner/bdump
user_dump_dest = /opt/oracle/admin/conner/udump
core_dump_dest = /opt/oracle/admin/conner/cdump
audit_trail = DB
sort_area_size = 524288
db_name = conner
open_cursors = 300
sql_trace = FALSE
optimizer_mode = CHOOSE
star_transformation_enabled= FALSE
optimizer_index_cost_adj = 10000
query_rewrite_enabled = FALSE
_left_nested_loops_random= FALSE
_use_nosegment_indexes = FALSE
pga_aggregate_target = 20480000
aq_tm_processes = 0
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
Sat Jan 21 14:08:31 2006
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=8
ARC0: Archival started
Sat Jan 21 14:08:31 2006
ARCH: STARTING ARCH PROCESSES COMPLETE
Sat Jan 21 14:08:31 2006
ARC0: Thread not mounted
ARC1 started with pid=9
ARC1: Archival started
ARC1: Thread not mounted
Sat Jan 21 14:08:31 2006
ALTER DATABASE MOUNT
Sat Jan 21 14:08:36 2006
Successful mount of redo thread 1, with mount id 3192249311.
Sat Jan 21 14:08:36 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Sat Jan 21 14:08:36 2006
ALTER DATABASE OPEN
Sat Jan 21 14:08:36 2006
Thread 1 opened at log sequence 45
Current log# 2 seq# 45 mem# 0: /opt/oracle/oradata/conner/redo02.log
Successful open of redo thread 1.
Sat Jan 21 14:08:36 2006
ARC1: Media recovery disabled
Sat Jan 21 14:08:36 2006
SMON: enabling cache recovery
Sat Jan 21 14:08:36 2006
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Undo Segment 14 Onlined
Successfully onlined Undo Tablespace 1.
Sat Jan 21 14:08:36 2006
SMON: enabling tx recovery
Sat Jan 21 14:08:36 2006
Database Characterset is ZHS16GBK
Completed: ALTER DATABASE OPEN |
