ORA-00600 found dead multi-threaded server

From: Arthur Levin <arthur_at_stario.com>
Date: 2000/04/05
Message-ID: <AcOG4.3$er3.6884@news.pacbell.net>#1/1

Hi ,

I only installed my Oracle 8.1.5 under NT and My database crashed recently with the following entries in the alert log:

ARC0: Beginning to archive log# 2 seq# 622
ARC0: Completed archiving log# 2 seq# 622
ARC0: re-scanning for new log files
ARC0: prodding the archiver
ARC0: received prod

Tue Apr 04 18:59:54 2000
Errors in file D:\Oracle\admin\prod1\udump\prod1S000.TRC: ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []

Tue Apr 04 19:00:14 2000
found dead multi-threaded server 'S000', pid = (9, 1)

!!!!!!!!!!!!!!!!!!!!!!!!!!

Tue Apr 04 19:00:40 2000
SNP0: terminating instance due to error 472 Instance terminated by SNP0, pid = 27

---

INIT.ora include:

mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
# Uncomment the following line when your listener is configured for SSL
# (listener.ora and sqlnet.ora)
# mts_dispatchers = "(PROTOCOL=TCPS)(PRE=oracle.aurora.server.SGiopServer)"

mts_dispatchers = "(protocol=TCP)(DISP=2)(mul=OFF)(pool=OFF)"
mts_max_dispatchers = 5
mts_servers = 1
mts_max_servers = 20
-----------------------------------------

LISTENER.ora:
# D:\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration
File:D:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle Net8 Assistant

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = dbserver1)(PORT = 1521))
      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME = prod1.stario.com)
      (ORACLE_HOME = D:\Oracle\Ora81)
      (SID_NAME = PROD1)

    )
  )
TNSNAMES.ORA
# D:\ORACLE\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration
File:D:\Oracle\Ora81\network\admin\tnsnames.ora
# Generated by Oracle Net8 Assistant

PROD1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dbserver1)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = prod1.stario.com)
    )
  )
There is no SQLNET.ora file

I understand I have not properly configured MTS, Is it necessary to use MTS if I'll have 20 parallel users connected to database and each user run 30 processes.

Thank you,

Arthur Received on Wed Apr 05 2000 - 00:00:00 CDT