Re: core dump in oracle

From: Swapnil <kadamswapnil_at_gmail.com>
Date: 12 Oct 2005 21:48:47 -0700
Message-ID: <1129178927.482001.121930@g14g2000cwa.googlegroups.com>

thanks sir ,
thanks a ton for such a prompt reply.

i am working on solaris

OS version:         5.8
Processor type:     sparc

and oracle version
Oracle9i Enterprise Edition Release 9.2.0.5.0

1. look at your alert.log for hints, and i have seen logs the only information i got is the abnormal termination of db connection
2. use your support contract to discuss this with Oracle Support We do have support contract what i wonder is that is it an oracle problem which needs to be patched or its just another set up issue. i have seen couple of post on net talking about insufficient swap space but that doesnt make a sense to me

here are the logs snippets of what i got from oracle side ub4 ksmugmg2 [2CC9830, 2CC9834) = 0000CDCD KSTDUMP: In-memory trace dump
TIME:SEQ# ORAPID SID EVENT OP DATA

---

13D72E05:00000000   299     0 10280   1 0x0000012B
13D80B1B:00000001     2     0 10280   1 0x00000002
13DAB9E5:00000002     3     0 10280   1 0x00000003

..
..
..

51579691:00002F75    13     0 10280   1 0x0000000D
570B81A6:00002F82    13     0 10280   1 0x0000000D
5D38C40C:00002F84    13     0 10280   1 0x0000000D
9CED46C3:000037C1    13     0 10280   1 0x0000000D

KSTDUMP: End of in-memory trace dump
ssexhd: crashing the process...
Shadow_Core_Dump = PARTIAL

regards
swapnil Received on Wed Oct 12 2005 - 23:48:47 CDT