internal error code: core dump

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tris0516
    New Member
    • Oct 2006
    • 2

    internal error code: core dump

    Hi, would like to ask for help regarding the error we encountered on our database. We are currently using Oracle 8.0.5. Below is the error message got from the alert.log. Please advise. Thank you.

    Thu Oct 5 21:02:17 2006
    Errors in file /mbs3/app/oracle/product/8.0.5/rdbms/log/arch_2807.trc:
    ORA-07445: exception encountered: core dump [11] [2063851536] [0] [1812] [] []
    Thu Oct 5 21:02:19 2006
    PMON: terminating instance due to error 473
    Instance terminated by PMON, pid = 2787
    Thu Oct 5 22:41:43 2006
    Starting ORACLE instance (normal)
    Thu Oct 5 22:41:43 2006
    Cannot start multiple dbwrs when using I/O slaves.
    LICENSE_MAX_SES SION = 0
    LICENSE_SESSION S_WARNING = 0
    Cannot start multiple dbwrs when using I/O slaves.
    Thu Oct 5 22:41:43 2006
    Errors in file /mbs3/app/oracle/product/8.0.5/rdbms/log/ora_21684.trc:
    ORA-00600: internal error code, arguments: [SKGMBUSY], [1], [0], [0], [0], [], [], []
    LICENSE_MAX_USE RS = 0
    Starting up ORACLE RDBMS Version: 8.0.5.2.2.
    System parameters with non-default values:
    processes = 200
    timed_statistic s = TRUE
    shared_pool_siz e = 250000000
    large_pool_size = 100000000
    pre_page_sga = TRUE
    nls_date_format = YYYYMMDD-HH24.MI.SS
    dbwr_io_slaves = 4
    lgwr_io_slaves = 4
    arch_io_slaves = 4
    control_files = /mbs1/oradata/mbas5/mbas5.ctrl1.dbf , /mbs4/oradata/mbas5/mbas5.ctrl2.dbf
    db_block_buffer s = 50000
    db_block_size = 8192
    db_block_lru_la tches = 4
    compatible = 8.0.5
    log_archive_sta rt = TRUE
    log_archive_des t = /mbs1/oradata/mbas5/arch
    log_archive_for mat = mbas%s.arc
    log_buffer = 512000
    log_checkpoint_ interval = 100000000
    log_simultaneou s_copies = 8
    db_files = 30
    db_file_multibl ock_read_count= 8
    dml_locks = 500
    row_locking = ALWAYS
    transactions = 600
    transactions_pe r_rollback_segm ent= 8
    rollback_segmen ts = r01, r02, r03, r04, r05, r06, r07
    sequence_cache_ entries = 30
    sequence_cache_ hash_buckets= 10
    max_enabled_rol es = 50
    remote_os_authe nt = TRUE
    distributed_loc k_timeout = 180
    distributed_tra nsactions = 600
    distributed_rec overy_connectio n_hold_time= 600
    audit_trail = TRUE
    sort_area_size = 1024000
    sort_area_retai ned_size = 512000
    db_name = mbas5
    open_cursors = 2000
    sql_trace = FALSE
    optimizer_mode = RULE
    partition_view_ enabled = TRUE
    cursor_space_fo r_time = TRUE
    utl_file_dir = /home/avner/PD/Interfaces
    job_queue_proce sses = 1
    job_queue_inter val = 10
    max_dump_file_s ize = 10240
  • arg
    New Member
    • Oct 2006
    • 11

    #2
    Ah this is a ORA-600 error. and I dont have metalink access at the moment. If you have a metalink account, and you should! look for the ORA 600 error message lookup tool.

    Comment

    • arg
      New Member
      • Oct 2006
      • 11

      #3
      Solaris? fix:
      Increase the unix kernel parameter SEMMNS to a higher value. This will allow
      the database to started with a higher processes parameter.

      New database?
      Perhaps lingering oracle instance with same SID out there?

      Comment

      Working...