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 -> ORA-00600 in alert log

ORA-00600 in alert log

From: novastar <andreas.vandenberghe_at_gmail.com>
Date: 12 Sep 2005 04:51:57 -0700
Message-ID: <1126525917.772368.17590@o13g2000cwo.googlegroups.com> 





Hi,



We're having some problems. The db seems to have started up
but an attempt to connect gives a listener error ORA-12541
We have ORA-00600 errors in the alert log. Attached is the entry
in the alert_emprod.log. what can we do ?



Tia,


Andreas





Dump file c:\oracle\admin\emprod\bdump\alert_emprod.log
Mon Sep 12 13:01:14 2005


ORACLE V9.2.0.4.0 - Production vsnsta=0


vsnsql=12 vsnxtr=3


Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Mon Sep 12 13:01:14 2005


Starting ORACLE instance (normal)


LICENSE_MAX_SESSION = 0



LICENSE_SESSIONS_WARNING = 0



SCN scheme 2


Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0



SYS auditing is disabled


Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:

  processes                = 1500
  timed_statistics         = TRUE
  shared_pool_size         = 503316480
  large_pool_size          = 100663296
  java_pool_size           = 16777216
  resource_manager_plan    = EMPROD_DAY
  control_files            = D:\oracle\oradata\emprod\control01.ctl,


E:\oracle\oradata\emprod\control02.ctl,


F:\oracle\oradata\emprod\control03.ctl

  db_block_size            = 8192
  db_cache_size            = 2105540608
  compatible               = 9.2.0.0.0




  db_file_multiblock_read_count= 16

  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  instance_name            = emprod
  dispatchers              = (PROTOCOL=TCP)
  hash_join_enabled        = TRUE
  background_dump_dest     = C:\oracle\admin\emprod\bdump
  user_dump_dest           = C:\oracle\admin\emprod\udump
  core_dump_dest           = C:\oracle\admin\emprod\cdump
  sort_area_size           = 524288
  db_name                  = emprod
  open_cursors             = 300




  star_transformation_enabled= FALSE


  query_rewrite_enabled    = FALSE


  pga_aggregate_target     = 100000000

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




Mon Sep 12 13:01:17 2005


starting up 1 shared server(s) ...


starting up 1 dispatcher(s) for network address
'(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

Mon Sep 12 13:01:18 2005


alter database mount exclusive


Mon Sep 12 13:01:22 2005


Successful mount of redo thread 1, with mount id 77357854.
Mon Sep 12 13:01:22 2005


Database mounted in Exclusive Mode.


Completed: alter database mount exclusive
Mon Sep 12 13:01:22 2005


alter database open


Mon Sep 12 13:01:22 2005


Beginning crash recovery of 1 threads


Mon Sep 12 13:01:22 2005


Started first pass scan


Mon Sep 12 13:01:22 2005


Completed first pass scan


 257 redo blocks read, 65 data blocks need recovery
Mon Sep 12 13:01:22 2005


Started recovery at


 Thread 1: logseq 2509, block 3, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 1 Seq 2509 Reading mem 0
  Mem# 0 errs 0: F:\ORACLE\ORADATA\EMPROD\REDO01.LOG
Mon Sep 12 13:01:22 2005


Completed redo application


Mon Sep 12 13:01:22 2005


Ended recovery at


 Thread 1: logseq 2509, block 260, scn 0.84192994
 65 data blocks read, 65 data blocks written, 257 redo blocks read
Crash recovery completed successfully


Mon Sep 12 13:01:22 2005


Thread 1 advanced to log sequence 2510


Thread 1 opened at log sequence 2510


  Current log# 2 seq# 2510 mem# 0: F:\ORACLE\ORADATA\EMPROD\REDO02.LOG
Successful open of redo thread 1.


Mon Sep 12 13:01:23 2005


SMON: enabling cache recovery


Mon Sep 12 13:01:23 2005


Undo Segment 1 Onlined


Undo Segment 2 Onlined


Undo Segment 3 Onlined


Undo Segment 4 Onlined


Undo Segment 5 Onlined


Undo Segment 6 Onlined


Undo Segment 7 Onlined


Undo Segment 8 Onlined


Undo Segment 9 Onlined


Undo Segment 10 Onlined


Successfully onlined Undo Tablespace 1.


Mon Sep 12 13:01:23 2005


SMON: enabling tx recovery


Mon Sep 12 13:01:23 2005


Database Characterset is WE8MSWIN1252


replication_dependency_tracking turned off (no async multimaster
replication found)


Completed: alter database open


Mon Sep 12 13:01:24 2005


Errors in file c:\oracle\admin\emprod\udump\emprod_p002_2032.trc:
ORA-00600: internal error code, arguments: [ktbair1], [1], [2], [], [],


[], [], []




Mon Sep 12 13:01:26 2005


Errors in file c:\oracle\admin\emprod\udump\emprod_p002_2032.trc:
ORA-00600: internal error code, arguments: [17114], [0x5F59003C], [],


[], [], [], [], []



ORA-00600: internal error code, arguments: [ktbair1], [1], [2], [], [],


[], [], []






This is an exerpt of the trc :




Dump file c:\oracle\admin\emprod\udump\emprod_p002_2032.trc
Mon Sep 12 13:01:24 2005


ORACLE V9.2.0.4.0 - Production vsnsta=0


vsnsql=12 vsnxtr=3


Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production


Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: emprod



Redo thread mounted by this instance: 1



Oracle process number: 13



Windows thread id: 2032, image: ORACLE.EXE (P002)





Received on Mon Sep 12 2005 - 06:51:57 CDT












Original text of this message













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