Hi, would like to ask for help regarding the error we encountered on our database. We are currently using Oracle 8.0.5. Below is the error message got from the alert.log. Please advise. Thank you.
Thu Oct 5 21:02:17 2006
Errors in file /mbs3/app/oracle/product/8.0.5/rdbms/log/arch_2807.trc:
ORA-07445: exception encountered: core dump [11] [2063851536] [0] [1812] [] []
Thu Oct 5 21:02:19 2006
PMON: terminating instance due to error 473
Instance terminated by PMON, pid = 2787
Thu Oct 5 22:41:43 2006
Starting ORACLE instance (normal)
Thu Oct 5 22:41:43 2006
Cannot start multiple dbwrs when using I/O slaves.
LICENSE_MAX_SES SION = 0
LICENSE_SESSION S_WARNING = 0
Cannot start multiple dbwrs when using I/O slaves.
Thu Oct 5 22:41:43 2006
Errors in file /mbs3/app/oracle/product/8.0.5/rdbms/log/ora_21684.trc:
ORA-00600: internal error code, arguments: [SKGMBUSY], [1], [0], [0], [0], [], [], []
LICENSE_MAX_USE RS = 0
Starting up ORACLE RDBMS Version: 8.0.5.2.2.
System parameters with non-default values:
processes = 200
timed_statistic s = TRUE
shared_pool_siz e = 250000000
large_pool_size = 100000000
pre_page_sga = TRUE
nls_date_format = YYYYMMDD-HH24.MI.SS
dbwr_io_slaves = 4
lgwr_io_slaves = 4
arch_io_slaves = 4
control_files = /mbs1/oradata/mbas5/mbas5.ctrl1.dbf , /mbs4/oradata/mbas5/mbas5.ctrl2.dbf
db_block_buffer s = 50000
db_block_size = 8192
db_block_lru_la tches = 4
compatible = 8.0.5
log_archive_sta rt = TRUE
log_archive_des t = /mbs1/oradata/mbas5/arch
log_archive_for mat = mbas%s.arc
log_buffer = 512000
log_checkpoint_ interval = 100000000
log_simultaneou s_copies = 8
db_files = 30
db_file_multibl ock_read_count= 8
dml_locks = 500
row_locking = ALWAYS
transactions = 600
transactions_pe r_rollback_segm ent= 8
rollback_segmen ts = r01, r02, r03, r04, r05, r06, r07
sequence_cache_ entries = 30
sequence_cache_ hash_buckets= 10
max_enabled_rol es = 50
remote_os_authe nt = TRUE
distributed_loc k_timeout = 180
distributed_tra nsactions = 600
distributed_rec overy_connectio n_hold_time= 600
audit_trail = TRUE
sort_area_size = 1024000
sort_area_retai ned_size = 512000
db_name = mbas5
open_cursors = 2000
sql_trace = FALSE
optimizer_mode = RULE
partition_view_ enabled = TRUE
cursor_space_fo r_time = TRUE
utl_file_dir = /home/avner/PD/Interfaces
job_queue_proce sses = 1
job_queue_inter val = 10
max_dump_file_s ize = 10240
Thu Oct 5 21:02:17 2006
Errors in file /mbs3/app/oracle/product/8.0.5/rdbms/log/arch_2807.trc:
ORA-07445: exception encountered: core dump [11] [2063851536] [0] [1812] [] []
Thu Oct 5 21:02:19 2006
PMON: terminating instance due to error 473
Instance terminated by PMON, pid = 2787
Thu Oct 5 22:41:43 2006
Starting ORACLE instance (normal)
Thu Oct 5 22:41:43 2006
Cannot start multiple dbwrs when using I/O slaves.
LICENSE_MAX_SES SION = 0
LICENSE_SESSION S_WARNING = 0
Cannot start multiple dbwrs when using I/O slaves.
Thu Oct 5 22:41:43 2006
Errors in file /mbs3/app/oracle/product/8.0.5/rdbms/log/ora_21684.trc:
ORA-00600: internal error code, arguments: [SKGMBUSY], [1], [0], [0], [0], [], [], []
LICENSE_MAX_USE RS = 0
Starting up ORACLE RDBMS Version: 8.0.5.2.2.
System parameters with non-default values:
processes = 200
timed_statistic s = TRUE
shared_pool_siz e = 250000000
large_pool_size = 100000000
pre_page_sga = TRUE
nls_date_format = YYYYMMDD-HH24.MI.SS
dbwr_io_slaves = 4
lgwr_io_slaves = 4
arch_io_slaves = 4
control_files = /mbs1/oradata/mbas5/mbas5.ctrl1.dbf , /mbs4/oradata/mbas5/mbas5.ctrl2.dbf
db_block_buffer s = 50000
db_block_size = 8192
db_block_lru_la tches = 4
compatible = 8.0.5
log_archive_sta rt = TRUE
log_archive_des t = /mbs1/oradata/mbas5/arch
log_archive_for mat = mbas%s.arc
log_buffer = 512000
log_checkpoint_ interval = 100000000
log_simultaneou s_copies = 8
db_files = 30
db_file_multibl ock_read_count= 8
dml_locks = 500
row_locking = ALWAYS
transactions = 600
transactions_pe r_rollback_segm ent= 8
rollback_segmen ts = r01, r02, r03, r04, r05, r06, r07
sequence_cache_ entries = 30
sequence_cache_ hash_buckets= 10
max_enabled_rol es = 50
remote_os_authe nt = TRUE
distributed_loc k_timeout = 180
distributed_tra nsactions = 600
distributed_rec overy_connectio n_hold_time= 600
audit_trail = TRUE
sort_area_size = 1024000
sort_area_retai ned_size = 512000
db_name = mbas5
open_cursors = 2000
sql_trace = FALSE
optimizer_mode = RULE
partition_view_ enabled = TRUE
cursor_space_fo r_time = TRUE
utl_file_dir = /home/avner/PD/Interfaces
job_queue_proce sses = 1
job_queue_inter val = 10
max_dump_file_s ize = 10240
Comment