OraFAQ Forum: Server Administration » ORA-01092: Oracle Instance Terminated. Disconnection Forced

Home » RDBMS Server » Server Administration » ORA-01092: Oracle Instance Terminated. Disconnection Forced

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01092: Oracle Instance Terminated. Disconnection Forced [message #181360]

Sun, 09 July 2006 03:32

CrazyDeveloper
Messages: 3
Registered: July 2006

Junior Member

Hi Guys
Firstly i m not a DBA, i just intsalled the

Oracle Application 11.5.8, Initially everything was

for 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

Attachment: prodALRT.LOG
(Size: 902.83KB, Downloaded 1067 times)

Report message to a moderator

Re: ORA-01092: Oracle Instance Terminated. Disconnection Forced [message #181370 is a reply to message #181360]

Sun, 09 July 2006 06:34

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

First, Ora-600 errors are supposed to be handled by Oracle support.
Second, Oracle-suppor may not even handle this because you are using a very old version of oracle.
Again all block level corruptions are supposed to be dealt with oracle support.
>> But few days before i hibernate the system and when i resumed my windows XP
Why would you do that?
Hibernation is something to save resources in a PC. If you are running a database of somewhat worth, always properly shutdown and startup.

I suggest you open a TAR with Oracle support.

Report message to a moderator

Re: ORA-01092: Oracle Instance Terminated. Disconnection Forced [message #181371 is a reply to message #181360]

Sun, 09 July 2006 06:57

CrazyDeveloper
Messages: 3
Registered: July 2006

Junior Member

Hi Mahesh
Well man have u figured out this is a block corruption issue? since i m getting TNS error as well. Moreover i just want to have some work solution instead of reinstalling the apps again

Regards
Hasan

Report message to a moderator

Previous Topic:	files
Next Topic:	error: ora 01034: Oracle not availabe

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:46:41 CDT 2024