This discussion is archived
0 Replies Latest reply: Nov 9, 2009 3:37 AM by 665995 RSS

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

665995 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points