Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> HELP: ORA-00600: internal error code

HELP: ORA-00600: internal error code

From: Weiping He <weiping_at_vt.edu>
Date: Sun, 01 Sep 2002 11:37:02 -0400
Message-ID: <3D72341E.C479EF49@vt.edu>


Hi:

I have troubles to start oracle database instance. Is there any way to solve this ORA-00600 problem? Thanks.

Here is the error msg



bash-2.03$ svrmgrl

Oracle Server Manager Release 3.0.5.0.0 - Production

(c) Copyright 1997, Oracle Corporation. All Rights Reserved.

Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production

SVRMGR> connect internal
Connected.
SVRMGR> startup open course
ORACLE instance started.

Total System Global Area                          6012432 bytes
Fixed Size                                          48656 bytes
Variable Size                                     5677056 bytes
Database Buffers                                   204800 bytes
Redo Buffers                                        81920 bytes
ORA-00600: internal error code, arguments: [2806], [60], [], [], [], [], [], []

Here is the alert_course.log file



Sat Aug 31 10:44:56 2002
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0

Starting up ORACLE RDBMS Version: 8.0.5.0.0. System parameters with non-default values:
  processes                = 50
  shared_pool_size         = 5000000
  control_files            =

/pkg/Oracle/u01/app/oracle/product/8.0.5/dbs/course_control1, /p
kg/Oracle/u01/app/oracle/product/8.0.5/dbs/course_control2
  db_block_buffers         = 100
  log_buffer               = 8192
  log_checkpoint_interval  = 10000
  db_files                 = 80
  db_file_multiblock_read_count= 8
  transactions             = 40

  transactions_per_rollback_segment= 10
  sequence_cache_entries = 10
  sequence_cache_hash_buckets= 10
  global_names             = TRUE
  db_name                  = course
  parallel_max_servers     = 5
  max_dump_file_size       = 10240
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
Sat Aug 31 10:44:57 2002
alter database course mount
Sat Aug 31 10:45:57 2002
Errors in file
/pkg/Oracle/u01/app/oracle/product/8.0.5/rdbms/log/course_ora_766.trc:
ORA-00600: internal error code, arguments: [2806], [60], [], [], [], [], [], []
Sat Aug 31 10:46:07 2002
ORA-600 signalled during: alter database course mount...

here is the course_ora_766.trc file



Dump file
/pkg/Oracle/u01/app/oracle/product/8.0.5/rdbms/log/course_ora_766.trc
Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production
ORACLE_HOME = /pkg/Oracle/u01/app/oracle/product/8.0.5 System name: SunOS
Node name:      comet
Release:        5.7
Version:        Generic_106541-18
Machine:        sun4u

Instance name: course
Redo thread mounted by this instance: 0 <none> Oracle process number: 8
Unix process pid: 766, image: oracle

Thank you very much !

Weiping Received on Sun Sep 01 2002 - 10:37:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US