0 Replies Latest reply: Nov 9, 2009 5:37 AM by 665995 RSS

    ORA-07445: exception encountered: core dump [] [] [] [] [] []

    665995
      Hi all,

      I have been running 10.2.0.2 DB

      Am getting errors; ORA-07445: exception encountered: core dump [] [] [] [] [] []

      Any idea about this?

      Alert log file content;
      $ tail -200 alert_WBORD.log
      Current log# 3 seq# 1818 mem# 1: /oradata/WBORD/redo/redog3m2.log
      kupprdp: master process DM00 started with pid=23, OS id=2580564
      to execute - SYS.KUPM$MCP.MAIN('SYS_EXPORT_FULL_01', 'OPS$ORACLE', 'KUPC$C_1_20091104191126', 'KUPC$S_1_20091104191126', 0);
      kupprdp: worker process DW01 started with worker id=1, pid=25, OS id=1794242
      to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_01', 'OPS$ORACLE');
      kupprdp: worker process DW02 started with worker id=2, pid=26, OS id=2703484
      to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_01', 'OPS$ORACLE');
      kupprdp: worker process DW03 started with worker id=3, pid=27, OS id=3108930
      to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_01', 'OPS$ORACLE');
      kupprdp: worker process DW04 started with worker id=4, pid=28, OS id=1007794
      to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_01', 'OPS$ORACLE');
      Thu Nov 5 19:11:22 2009
      The value (30) of MAXTRANS parameter ignored.
      kupprdp: master process DM00 started with pid=23, OS id=1364148
      to execute - SYS.KUPM$MCP.MAIN('SYS_EXPORT_FULL_01', 'OPS$ORACLE', 'KUPC$C_1_20091105191123', 'KUPC$S_1_20091105191123', 0);
      kupprdp: worker process DW01 started with worker id=1, pid=25, OS id=2920550
      to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_01', 'OPS$ORACLE');
      kupprdp: worker process DW02 started with worker id=2, pid=26, OS id=2703602
      to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_01', 'OPS$ORACLE');
      kupprdp: worker process DW03 started with worker id=3, pid=27, OS id=2961506
      to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_01', 'OPS$ORACLE');
      kupprdp: worker process DW04 started with worker id=4, pid=28, OS id=3223794
      to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_01', 'OPS$ORACLE');
      Thu Nov 5 19:39:05 2009
      Thread 1 advanced to log sequence 1819
      Current log# 1 seq# 1819 mem# 0: /oradata/WBORD/redo/redog1m1.log
      Current log# 1 seq# 1819 mem# 1: /oradata/WBORD/redo/redog1m2.log
      Fri Nov 6 19:32:56 2009
      The value (30) of MAXTRANS parameter ignored.
      kupprdp: master process DM00 started with pid=25, OS id=2854920
      to execute - SYS.KUPM$MCP.MAIN('SYS_EXPORT_FULL_01', 'OPS$ORACLE', 'KUPC$C_1_20091106194514', 'KUPC$S_1_20091106194514', 0);
      Fri Nov 6 22:42:10 2009
      Thread 1 advanced to log sequence 1820
      Current log# 2 seq# 1820 mem# 0: /oradata/WBORD/redo/redog2m1.log
      Current log# 2 seq# 1820 mem# 1: /oradata/WBORD/redo/redog2m2.log
      Sat Nov 7 02:34:17 2009
      Errors in file /shrd-dev/orasrc/admin/WBORD/udump/wbord_ora_3149992.trc:
      ORA-07445: exception encountered: core dump [] [] [] [] [] []
      Sat Nov 7 02:34:28 2009
      Errors in file /shrd-dev/orasrc/admin/WBORD/udump/wbord_ora_2339062.trc:
      ORA-07445: exception encountered: core dump [] [] [] [] [] []
      Sat Nov 7 02:34:32 2009
      Errors in file /shrd-dev/orasrc/admin/WBORD/udump/wbord_ora_2175034.trc:
      ORA-07445: exception encountered: core dump [] [] [] [] [] []
      Sat Nov 7 02:34:37 2009
      Errors in file /shrd-dev/orasrc/admin/WBORD/udump/wbord_ora_2883782.trc:
      ORA-07445: exception encountered: core dump [] [] [] [] [] []
      Sat Nov 7 02:37:35 2009
      Errors in file /shrd-dev/orasrc/admin/WBORD/udump/wbord_ora_2801696.trc:
      ORA-07445: exception encountered: core dump [] [] [] [] [] []
      Sat Nov 7 02:37:46 2009
      Errors in file /shrd-dev/orasrc/admin/WBORD/udump/wbord_ora_1269880.trc:
      ORA-07445: exception encountered: core dump [] [] [] [] [] []
      Sat Nov 7 02:48:04 2009
      Errors in file /shrd-dev/orasrc/admin/WBORD/bdump/wbord_j000_2039904.trc:
      ORA-07445: exception encountered: core dump [] [] [] [] [] []
      ORA-01403: no data found
      Sat Nov 7 02:58:15 2009
      Process 0x70000002ca72168 appears to be hung while dumping
      Current time = 1204017987, process death time = 1203957785 interval = 60000
      Attempting to kill process 0x70000002ca72168 with OS pid = 3088428
      OSD kill succeeded for process 70000002ca72168
      Restarting dead background process CJQ0
      Sat Nov 7 03:03:38 2009
      Starting background process CJQ0
      Sat Nov 7 03:08:19 2009
      Process 0x70000002ca72948 appears to be hung while dumping
      Current time = 1204078408, process death time = 1204018292 interval = 60000
      Attempting to kill process 0x70000002ca72948 with OS pid = 2805780
      OSD kill succeeded for process 70000002ca72948
      Restarting dead background process MMON
      Sat Nov 7 03:09:30 2009
      Starting background process CJQ0
      Sat Nov 7 03:13:48 2009
      Starting background process MMON
      MMON started with pid=11, OS id=2806004
      Sat Nov 7 03:13:48 2009
      Errors in file /shrd-dev/orasrc/admin/WBORD/bdump/wbord_mmon_2806004.trc:
      ORA-07445: exception encountered: core dump [] [] [] [] [] []
      Sat Nov 7 03:14:54 2009
      Starting background process CJQ0
      CJQ0 started with pid=11, OS id=2785328
      Sat Nov 7 03:14:57 2009
      Errors in file /shrd-dev/orasrc/admin/WBORD/bdump/wbord_cjq0_2785328.trc:
      ORA-07445: exception encountered: core dump [] [] [] [] [] []
      Sat Nov 7 03:18:23 2009
      Errors in file /shrd-dev/orasrc/admin/WBORD/bdump/wbord_smon_1839230.trc:
      ORA-07445: exception encountered: core dump [] [] [] [] [] []
      Sat Nov 7 03:18:33 2009
      Errors in file /shrd-dev/orasrc/admin/WBORD/bdump/wbord_pmon_2646236.trc:
      ORA-00474: SMON process terminated with error
      Sat Nov 7 03:18:33 2009
      PMON: terminating instance due to error 474
      Instance terminated by PMON, pid = 2646236
      Sat Nov 7 08:18:55 2009
      Starting ORACLE instance (normal)
      LICENSE_MAX_SESSION = 0
      LICENSE_SESSIONS_WARNING = 0
      Picked latch-free SCN scheme 3
      Using LOG_ARCHIVE_DEST_1 parameter default value as /shrd-dev/orasrc/product/db/10.2.0.2/dbs/arch
      Autotune of undo retention is turned on.
      IMODE=BR
      ILAT =19
      LICENSE_MAX_USERS = 0
      SYS auditing is disabled
      ksdpec: called for event 13740 prior to event group initialization
      Starting up ORACLE RDBMS Version: 10.2.0.2.0.
      System parameters with non-default values:
      processes = 160
      sessions = 181
      shared_pool_size = 201326592
      large_pool_size = 4194304
      java_pool_size = 50331648
      streams_pool_size = 20971520
      control_files = /oradata/WBORD/system/control01.ctl, /oradata/WBORD/system/control02.ctl, /oradata/WBORD/system/control03.ctl
      db_block_size = 8192
      db_cache_size = 197132288
      compatible = 10.2.0.2.0
      db_file_multiblock_read_count= 16
      undo_management = AUTO
      undo_tablespace = UNDOTBS1
      remote_login_passwordfile= EXCLUSIVE
      db_domain =
      dispatchers =
      job_queue_processes = 10
      background_dump_dest = /shrd-dev/orasrc/admin/WBORD/bdump
      user_dump_dest = /shrd-dev/orasrc/admin/WBORD/udump
      core_dump_dest = /shrd-dev/orasrc/admin/WBORD/cdump
      audit_file_dest = /shrd-dev/orasrc/admin/WBORD/adump
      db_name = WBORD
      open_cursors = 300
      pga_aggregate_target = 218103808
      PMON started with pid=2, OS id=2642002
      PSP0 started with pid=3, OS id=2506890
      MMAN started with pid=4, OS id=3285186
      DBW0 started with pid=5, OS id=2429094
      LGWR started with pid=6, OS id=2367700
      CKPT started with pid=7, OS id=2035858
      SMON started with pid=8, OS id=1798342
      RECO started with pid=9, OS id=1253482
      CJQ0 started with pid=10, OS id=3006512
      MMON started with pid=11, OS id=2617360
      MMNL started with pid=12, OS id=2576510
      Sat Nov 7 08:19:14 2009
      ALTER DATABASE MOUNT
      Sat Nov 7 08:19:19 2009
      Setting recovery target incarnation to 1
      Sat Nov 7 08:19:19 2009
      Successful mount of redo thread 1, with mount id 2552657923
      Sat Nov 7 08:19:19 2009
      Database mounted in Exclusive Mode
      Completed: ALTER DATABASE MOUNT
      Sat Nov 7 08:19:20 2009
      ALTER DATABASE OPEN
      Sat Nov 7 08:19:20 2009
      Beginning crash recovery of 1 threads
      parallel recovery started with 7 processes
      Sat Nov 7 08:19:24 2009
      Started redo scan
      Sat Nov 7 08:19:28 2009
      Completed redo scan
      0 redo blocks read, 0 data blocks need recovery
      Sat Nov 7 08:19:28 2009
      Started redo application at
      Thread 1: logseq 1820, block 24086, scn 7159064215634
      Sat Nov 7 08:19:28 2009
      Recovery of Online Redo Log: Thread 1 Group 2 Seq 1820 Reading mem 0
      Mem# 0 errs 0: /oradata/WBORD/redo/redog2m1.log
      Mem# 1 errs 0: /oradata/WBORD/redo/redog2m2.log
      Sat Nov 7 08:19:31 2009
      Completed redo application
      Sat Nov 7 08:19:32 2009
      Completed crash recovery at
      Thread 1: logseq 1820, block 24086, scn 7159064235635
      0 data blocks read, 0 data blocks written, 0 redo blocks read
      Sat Nov 7 08:19:32 2009
      Thread 1 advanced to log sequence 1821
      Thread 1 opened at log sequence 1821
      Current log# 3 seq# 1821 mem# 0: /oradata/WBORD/redo/redog3m1.log
      Current log# 3 seq# 1821 mem# 1: /oradata/WBORD/redo/redog3m2.log
      Successful open of redo thread 1
      Sat Nov 7 08:19:32 2009
      MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
      Sat Nov 7 08:19:33 2009
      SMON: enabling cache recovery
      Sat Nov 7 08:19:33 2009
      Successfully onlined Undo Tablespace 1.
      Sat Nov 7 08:19:33 2009
      SMON: enabling tx recovery
      Sat Nov 7 08:19:33 2009
      Database Characterset is US7ASCII
      replication_dependency_tracking turned off (no async multimaster replication found)
      Starting background process QMNC
      QMNC started with pid=21, OS id=2170936
      Sat Nov 7 08:19:43 2009
      Completed: ALTER DATABASE OPEN
      Sun Nov 8 20:23:37 2009
      ksvcreate: Process(q003) creation failed
      Sun Nov 8 20:32:52 2009
      ksvcreate: Process(q003) creation failed

      Thnks in advance

      Regards
      Bhagya

      Edited by: Bhagya on Nov 9, 2009 3:36 AM