Re: Urgent: ORA-00600 on Oracle9i r9.0.1 during Instance startup/database creation

Check your shared memory configuration on the os. Oracle cannot create the shared memory segment.

Stefan

Mladen Vidic wrote:

> I have Tru64 Cluster v5.1 with PatchKit4
> 2-node GS80 Compaq system. On Windows 2000/Solaris I didn't have this
> problem.
> Installed Oracle 9i software:
> Oracle9i EE 9.0.1 with RAC Option, Advanced security and others. NUMA is not
> installed.
> Latest patches from Compaq Support Site are downloaded and installed.
> Kernel parameters are configured as it is described in Installation guide
> and Release Notes.
>
> Onlu parameter gh_chunks is set to 0 because any other value >0 don't allow
> Nodes to startup correctly.
>
> During DBCA creation of database/manual startup noomount through sqlplus
> /nolog
> I have got Internal error message:
> ORA-00600
>
> alert_fis1.log:
>
> Tue Mar 12 21:11:07 2002
> Starting ORACLE instance (normal)
> Tue Mar 12 21:11:07 2002
> Global Enqueue Service Resources = 64
> Tue Mar 12 21:11:07 2002
> Global Enqueue Service Enqueues = 128
> Tue Mar 12 21:11:07 2002
> Errors in file /ora01/app/oracle/admin/digitfis/udump/ora_532019.trc:
> ORA-00600: internal error code, arguments: [SKGMFAIL], [2], [1], [1], [1],
> [], [], []
>
> and
> later again:
>
> Wed Mar 13 14:45:42 2002
> Starting ORACLE instance (normal)
> Wed Mar 13 14:45:42 2002
> Global Enqueue Service Resources = 64
> Wed Mar 13 14:45:42 2002
> Global Enqueue Service Enqueues = 128
> Wed Mar 13 14:45:43 2002
> Errors in file /ora01/app/oracle/admin/digitfis/udump/ora_531418.trc:
> ORA-00600: internal error code, arguments: [SKGMINVALID], [19], [3], [0],
> [0], [], [], []
>
> Trace file is in attachment.
>
> Init.ora is:
>
> initfis.ora:
>
> ############################################################################
> ##
> # Copyright (c) 1991, 2001 by Oracle Corporation
> ############################################################################
> ##
>
> ###########################################
> # Cache and I/O
> ###########################################
> db_block_size=8192
> db_cache_size=67108864
>
> ###########################################
> # Cluster Database
> ###########################################
> cluster_database_instances=2
> remote_listener=LISTENERS_DIGITFIS
>
> ###########################################
> # Cursors and Library Cache
> ###########################################
> open_cursors=300
>
> ###########################################
> # Diagnostics and Statistics
> ###########################################
> background_dump_dest=/ora01/app/oracle/admin/digitfis/bdump
> core_dump_dest=/ora01/app/oracle/admin/digitfis/cdump
> timed_statistics=TRUE
> user_dump_dest=/ora01/app/oracle/admin/digitfis/udump
>
> ###########################################
> # Distributed, Replication and Snapshot
> ###########################################
> db_domain=""
> remote_login_passwordfile=exclusive
>
> ###########################################
> # File Configuration
> ###########################################
> control_files=("/ora01/oradata/digitfis/control01.ctl",
> "/ora02/oradata/digitfis/control02.ctl",
> "/ora03/oradata/digitfis/control03.ctl")
>
> ###########################################
> # MTS
> ###########################################
> dispatchers="(PROTOCOL=TCP)(SER=MODOSE)",
> "(PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer)",
> "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
>
> ###########################################
> # Miscellaneous
> ###########################################
> compatible=9.0.0
> db_name=digitfis
>
> ###########################################
> # Pools
> ###########################################
> java_pool_size=83886080
> large_pool_size=1048576
> shared_pool_size=83886080
>
> ###########################################
> # Processes and Sessions
> ###########################################
> processes=150
>
> ###########################################
> # Redo Log and Recovery
> ###########################################
> fast_start_mttr_target=300
>
> ###########################################
> # Resource Manager
> ###########################################
> resource_manager_plan=SYSTEM_PLAN
>
> ###########################################
> # Sort, Hash Joins, Bitmap Indexes
> ###########################################
> hash_area_size=1048576
> sort_area_size=524288
>
> ###########################################
> # System Managed Undo and Rollback Segments
> ###########################################
> undo_management=AUTO
> undo_retention=10800
>
> fis2.instance_name=fis2
> fis1.instance_name=fis1
> fis2.instance_number=2
> fis1.instance_number=1
> fis1.thread=1
> fis2.thread=2
> fis2.undo_tablespace=UNDOTBS2
> fis1.undo_tablespace=UNDOTBS1
>
> # end of initfis.ora
>
> ----------------------------------------------
> Mladen Vidic, B.Sc. Oracle Technology Manager
> Oracle OCP DBA/Instructor
> Company: Digit IT Computer Engineering d.o.o
> Radomira Vujovica 3, 11000 Belgrade,YU
> Phone : +381 11 360 55 41, 360 55 40
> Fax : +381 11 360 55 99
> Mobile: +381 63 81 55 928,
> +387 66 671 026
> E-mail: Mladen.Vidic_at_Digit.co.yu
>
> Name: ora_532019.trc
> ora_532019.trc Type: application/x-unknown-content-type-trc_auto_file
> Encoding: x-uuencode