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

mmaneyOct 21 2005 — edited Oct 21 2005
Hi

Suddenly my database throws an error " ORA-01092: ORACLE instance terminated. Disconnection forced" after restarting the service it works fine, but for sometime.

help

The content or alert file is
"

Fri Oct 21 01:00:01 2005
Errors in file D:\Oracle\admin\vista\udump\vistaS000.TRC:
ORA-00600: internal error code, arguments: [729], [152], [space leak], [], [], [], [], []

Fri Oct 21 01:01:51 2005
Errors in file D:\Oracle\admin\vista\udump\vistaS000.TRC:
ORA-00600: internal error code, arguments: [kghxhdr1], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [729], [152], [space leak], [], [], [], [], []

Fri Oct 21 01:03:47 2005
found dead multi-threaded server 'S000', pid = (8, 1)
Fri Oct 21 01:04:04 2005
LGWR: terminating instance due to error 472
Instance terminated by LGWR, pid = 4080
Dump file D:\Oracle\admin\vista\bdump\vistaALRT.LOG
Fri Oct 21 09:39:37 2005
ORACLE V8.1.5.0.0 - Production vsnsta=0
vsnsql=d vsnxtr=3
Windows NT V5.2, OS V14.206, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.5.0.0.
System parameters with non-default values:
processes = 65
shared_pool_size = 143098880
large_pool_size = 94371840
java_pool_size = 20971520
control_files = D:\Oracle\oradata\vista\control01.ctl, D:\Oracle\oradata\vista\control02.ctl
db_block_buffers = 52170
db_block_size = 8192
compatible = 8.1.0
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 10
service_names = vista
instance_name = vista
mts_dispatchers = (ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))(DIS=1)(SES=254)(CON=254)(TIC=15)(POO=NO)(MUL=NO)(LIS=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=PNPKEY))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(ADDRESS=(PROTOCOL=IPC)(KEY=vista))))(PRE=oracle.aurora.server.SGiopServer), (ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))(DIS=1)(SES=254)(CON=254)(TIC=15)(POO=NO)(MUL=NO)(LIS=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=PNPKEY))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(ADDRESS=(PROTOCOL=IPC)(KEY=vista))))
mts_servers = 1
mts_max_servers = 20
mts_max_dispatchers = 5
open_links = 4
sort_area_size = 66560
db_name = vista
os_authent_prefix =
job_queue_processes = 0
job_queue_interval = 60
parallel_max_servers = 5
background_dump_dest = D:\Oracle\admin\vista\bdump
user_dump_dest = D:\Oracle\admin\vista\udump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
Fri Oct 21 09:39:42 2005
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network protocol '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network protocol '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Oct 21 09:39:43 2005
alter database mount exclusive
Fri Oct 21 09:39:47 2005
Successful mount of redo thread 1, with mount id 2644266531.
Fri Oct 21 09:39:47 2005
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Fri Oct 21 09:39:47 2005
alter database open
Beginning crash recovery of 1 threads
Fri Oct 21 09:39:48 2005
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 1 Seq 6475 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\VISTA\REDO01.LOG
Fri Oct 21 09:39:48 2005
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 blocks read, 0 blocks written
Crash recovery completed successfully
Picked broadcast on commit scheme to generate SCNs
Fri Oct 21 09:39:48 2005
Thread 1 advanced to log sequence 6476
Thread 1 opened at log sequence 6476
Current log# 2 seq# 6476 mem# 0: D:\ORACLE\ORADATA\VISTA\REDO02.LOG
Successful open of redo thread 1.
Fri Oct 21 09:39:49 2005
SMON: enabling cache recovery
SMON: enabling tx recovery
Fri Oct 21 09:39:51 2005
Completed: alter database open

"
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 18 2005
Added on Oct 21 2005
1 comment
385 views