Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01092: ORACLE instance terminated. Disconnection forced

CrazyDeveloperJul 9 2006 — edited Jul 11 2006
Hi Guys
Firstly i m not a DBA, i just intsalled the Oracle Application 11.5.8, Initially everything was fine. But few days before i hibernate the system nd when i resumed my windows XP and tried to connect to SQLPlus, i m getting the error ora-01092. I haven't made any changes anywhere. Also i connected with SQLPlus with /nolog and when i tried to shutdown the Database i got the msessge ora-12560: TNS:Protocol Adapter error and i get the same messege if i use anyother command like "CONNECT apps/apps@prod
Moreover i writing the most recent entries of my <sid>alrt.log file

---------------------------------------------------------------
Dump file d:\oracle\proddb\8.1.7\admin\PROD\bdump\prodALRT.LOG
Sun Jul 09 10:08:22 2006
ORACLE V8.1.7.4.1 - Production vsnsta=0
vsnsql=f vsnxtr=3
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.7.4.1.
System parameters with non-default values:
_trace_files_public = TRUE
processes = 200
timed_statistics = TRUE
shared_pool_size = 300000000
shared_pool_reserved_size= 30000000
_shared_pool_reserved_min_alloc= 4100
java_pool_size = 50000000
enqueue_resources = 5000
nls_language = american
nls_territory = america
nls_sort = binary
nls_date_format = DD-MON-RR
nls_numeric_characters = .,
nls_comp = binary
control_files = d:\oracle\proddata\cntrl01.dbf, d:\oracle\proddata\cntrl02.dbf, d:\oracle\proddata\cntrl03.dbf
db_block_buffers = 10000
db_block_size = 8192
compatible = 8.1.7
log_buffer = 1048576
log_checkpoint_interval = 100000
log_checkpoint_timeout = 72000
db_files = 500
db_file_multiblock_read_count= 8
log_checkpoints_to_alert = TRUE
dml_locks = 500
row_locking = always
rollback_segments = rbs01, rbs02, rbs03, rbs04, rbs05, rbs06
max_enabled_roles = 40
remote_login_passwordfile= SHARED
optimizer_features_enable= 8.1.7
sort_area_size = 256000
db_name = PROD
open_cursors = 500
ifile = d:\oracle\proddb\8.1.7\dbs\ifilecbo.ora
_optimizer_undo_changes = FALSE
optimizer_mode = choose
_optimizer_mode_force = TRUE
_sort_elimination_cost_ratio= 5
always_anti_join = NESTED_LOOPS
_complex_view_merging = TRUE
_push_join_predicate = TRUE
_push_join_union_view = TRUE
_fast_full_scan_enabled = FALSE
always_semi_join = NESTED_LOOPS
_ordered_nested_loop = TRUE
optimizer_max_permutations= 2000
query_rewrite_enabled = TRUE
_sqlexec_progression_cost= 0
_use_column_stats_for_function= TRUE
_or_expand_nvl_predicate = TRUE
_like_with_bind_as_equality= TRUE
_table_scan_cost_plus_one= TRUE
_new_initial_join_orders = TRUE
session_cached_cursors = 100
utl_file_dir = c:\temp, d:\oracle\proddb\8.1.7\plsql\temp, d:\oracle\proddb\8.1.7/appsutil/outbound/PROD
job_queue_processes = 2
job_queue_interval = 90
optimizer_percent_parallel= 0
_system_trig_enabled = TRUE
parallel_min_servers = 0
parallel_max_servers = 8
background_dump_dest = d:\oracle\proddb\8.1.7\admin\PROD\bdump
user_dump_dest = d:\oracle\proddb\8.1.7\admin\PROD\udump
max_dump_file_size = 10240
core_dump_dest = d:\oracle\proddb\8.1.7\admin\PROD\cdump
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
SNP0 started with pid=8
SNP1 started with pid=9
QMN0 started with pid=10
Sun Jul 09 10:08:25 2006
alter database mount exclusive
Sun Jul 09 10:08:29 2006
Successful mount of redo thread 1, with mount id 7218973.
Sun Jul 09 10:08:29 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Sun Jul 09 10:08:29 2006
alter database open
Beginning crash recovery of 1 threads
Sun Jul 09 10:08:31 2006
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 2 Seq 1265 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODDATA\LOG01.DBF
Sun Jul 09 10:08:31 2006
Thread recovery: finish rolling forward thread 1
Thread recovery: 4 data blocks read, 4 data blocks written, 36 redo blocks read
Crash recovery completed successfully
Sun Jul 09 10:08:33 2006
Thread 1 advanced to log sequence 1266
Thread 1 opened at log sequence 1266
Current log# 1 seq# 1266 mem# 0: D:\ORACLE\PRODDATA\LOG02.DBF
Successful open of redo thread 1.
Sun Jul 09 10:08:34 2006
SMON: enabling cache recovery
SMON: enabling tx recovery
***
Corrupt block relative dba: 0x0701e604 (file 28, block 124420)
Bad header found during buffer read
Data in bad block -
type: 1 format: 7 rdba: 0x0000003d
last change scn: 0x0000.00000001 seq: 0x0 flg: 0x00
consistency value in tail: 0xe6050000
check value in block header: 0x0, block checksum disabled
spare1: 0x95, spare2: 0x65, spare3: 0x0
***
Reread of rdba: 0x0701e604 (file 28, block 124420) found same corrupted data
Sun Jul 09 10:08:35 2006
Errors in file d:\oracle\proddb\8.1.7\admin\PROD\bdump\prodSMON.TRC:
ORA-00600: internal error code, arguments: [kcbgcur_9], [20971568], [4], [4294966224], [16], [], [], []

Sun Jul 09 10:08:36 2006
Errors in file d:\oracle\proddb\8.1.7\admin\PROD\bdump\prodSMON.TRC:
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcbgcur_9], [20971568], [4], [4294966224], [16], [], [], []

Sun Jul 09 10:08:36 2006
Errors in file d:\oracle\proddb\8.1.7\admin\PROD\bdump\prodSMON.TRC:
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcbgcur_9], [20971568], [4], [4294966224], [16], [], [], []

Sun Jul 09 10:08:37 2006
Errors in file d:\oracle\proddb\8.1.7\admin\PROD\bdump\prodSMON.TRC:
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcbgcur_9], [20971568], [4], [4294966224], [16], [], [], []

Sun Jul 09 10:08:37 2006
Errors in file d:\oracle\proddb\8.1.7\admin\PROD\bdump\prodSMON.TRC:
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcbgcur_9], [20971568], [4], [4294966224], [16], [], [], []

Sun Jul 09 10:08:37 2006
Errors in file d:\oracle\proddb\8.1.7\admin\PROD\bdump\prodSMON.TRC:
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcbgcur_9], [20971568], [4], [4294966224], [16], [], [], []

Sun Jul 09 10:08:37 2006
Errors in file d:\oracle\proddb\8.1.7\admin\PROD\bdump\prodSMON.TRC:
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcbgcur_9], [20971568], [4], [4294966224], [16], [], [], []

Sun Jul 09 10:08:38 2006
Errors in file d:\oracle\proddb\8.1.7\admin\PROD\bdump\prodSMON.TRC:
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcbgcur_9], [20971568], [4], [4294966224], [16], [], [], []

Sun Jul 09 10:08:38 2006
Errors in file d:\oracle\proddb\8.1.7\admin\PROD\bdump\prodSMON.TRC:
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [5020], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcbgcur_9], [20971568], [4], [4294966224], [16], [], [], []

SMON: terminating instance due to error 600
Sun Jul 09 10:08:39 2006
Errors in file d:\oracle\proddb\8.1.7\admin\PROD\bdump\prodLGWR.TRC:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

Sun Jul 09 10:08:39 2006
Errors in file d:\oracle\proddb\8.1.7\admin\PROD\bdump\prodPMON.TRC:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

Instance terminated by SMON, pid = 2696

------------------------------------------

Please guys help me around.
Thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 8 2006
Added on Jul 9 2006
15 comments
875 views