Database Crash With ora-4030 Using ORADISM and With 'oradism creation failed' message. (Doc ID 1323264.1)

Last updated on APRIL 14, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Oracle Solaris on SPARC (64-bit)
Oracle Solaris on x86-64 (64-bit)
***Checked for relevance on 06-Jun-2013***

Symptoms

Solaris OS is being used.

The oradism creation failed for unknown reasons and "0 8 101" errors have been arising for some time. Eventually the database crashed with the errors shown below.

Tue May 17 15:47:33 2011
WARNING: Detected too many memory locking problems.
WARNING: Performance degradation may occur.

Dynamic ISM can not be locked.                                        <=======
oradism creation failed for unknown reasons 0 8 101         <=======
Tue May 17 12:39:01 2011
WARNING: Detected too many memory locking problems.
WARNING: Performance degradation may occur.
Tue May 17 14:26:44 2011
. .  .
ORA-04030: out of process memory when trying to allocate 123416 bytes (QERGH hash-agg,kllcqas:kllsltba)
. . . .
Tue May 17 14:26:54 2011
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xFFFFFFFF7FFE51AC] [PC:0x10096CBF4, ksmpgd_scan_pga_heaps()+84] [flags: 0x0, count: 1]
Errors in file . . . .
ORA-07445: exception encountered: core dump [ksmpgd_scan_pga_heaps()+84] [SIGSEGV] [ADDR:0xFFFFFFFF7FFE51AC] [PC:0x10096CBF4] [Address not mapped to object] []
Incident details in: . . . . .
Tue May 17 14:26:59 2011
Errors in file . . . . . .
ORA-04030: out of process memory when trying to allocate 169040 bytes (pga heap,kgh stack)
ORA-04030: out of process memory when trying to allocate 123416 bytes (QERGH hash-agg,kllcqas:kllsltba)
Incident details in: . . . . . .
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xFFFFFFFF7FFBCB38] [PC:0x106BEEF00, kgdsdst()+32] [flags: 0x0, count: 1]
Tue May 17 14:27:08 2011
Trace dumping is performing id=[cdmp_20110517142708]
. . .  .
Tue May 17 14:27:25 2011
PMON (ospid: 8596): terminating the instance due to error 470
Instance terminated by PMON, pid = 8596

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms