3 replies to this topic

[sleezy]

All,

If you can help...I dont believe its the Unix semaphore's though they were increased recently...

I am having an issue with a 'virtual' workfile (Oracle). eg.The table is not a physical table that can be accessed via sql/toad.
Within the code it runs an SQL statement which it buffers into a 'virtual' workfile of oracle flavour.

This has historically worked fine, and although the database has grown it is now falling over.
When the statement runs I get a '363 - SQL ERROR: Database Connection Dropped'

with the following at the beginning of the Oracle trace file
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [00000001029BDBB8] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []

***insert lots of noise***

with the following at the end of the Oracle trace file
KSTDUMP: End of in-memory trace dump
ssexhd: crashing the process...
Shadow_Core_Dump = PARTIAL

[sleezy]

We are useing:
VIP 55r500 (Happens in Native v55r323 too)
Unix Solaris
Oracle 9i

[Chris Mackenzie]

We are useing:
VIP 55r500 (Happens in Native v55r323 too)
Unix Solaris
Oracle 9i

To help I reckon someone would need to see your
SQL statements and definitions. You mention
your database is growing so the first thing
might be to check if your SGA has enough space
for your virtual table.

[sleezy]

Thanks Chris.

Looks like it an Oracle error. so I'm going to raise a call with Metalink.

I'll post the solution once I know.