Dm_oracle Backends Are Dying Intermittently (Doc ID 1278569.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.2.1.0.0 and later
Oracle Solaris on SPARC (32-bit)
Checked for relevance on 14-Feb-2013

Symptoms

dm_oracle back ends are dying intermittently where PIN_ERR_STREM_EOF errors are seen as some back end dm_oracle processes are dying with SIGV signal.

### Steps to Reproduce ###
Use dm_oracle10g.so with portal 7.2.1 and oracle10g database server,
Below are error messages from dm_oracle logs corresponding to the issue.

dm_oracle.log:
DM(master) respawned backend child for slot 7, pid 23938

dm_oracle_stdout.log:

Stack Trace (23938) :
/usr/local/untd/apps/portal-7.2.1/bin/dm:print_traceback+0x0(0x20, 0x7fff, 0x0, 0x0, 0x0, 0x0)
/usr/local/untd/apps/portal-7.2.1/bin/dm:sigsegv_handler+0x50(0xed91ce6c, 0x0, 0xecf7fba0, 0xffbe2680, 0xed5c4890, 0xe3220)
/usr/lib/libthread.so.1:_fork+0x874(0x0, 0x0, 0x231898, 0x22a040, 0xffbe29e7, 0x22a040)
/usr/local/portal/sys/dm_oracle/dm_oracle10g.so:ttcdrv+0x1bdc(0x4c000, 0xfddd0d10, 0xfddd1160, 0x0, 0x0, 0x0)
/usr/local/portal/sys/dm_oracle/dm_oracle10g.so:nioqwa+0x50(0xac84c29, 0x90, 0x11, 0xff250e18, 0x16, 0xfdd16e54)
/usr/local/portal/sys/dm_oracle/dm_oracle10g.so:upirtrc+0x684(0xed91ce6c, 0xffbe5578, 0xff480, 0x0, 0x1001d8, 0xecf7fba0)
/usr/local/portal/sys/dm_oracle/dm_oracle10g.so:kpurcsc+0x68(0x0, 0xdade0, 0x2, 0x1030, 0xec, 0xecacd798)
/usr/local/portal/sys/dm_oracle/dm_oracle10g.so:kpuexecv8+0x80c(0xed8af5ac, 0x0, 0x0, 0xe2ce4, 0xe2c80, 0x1)
/usr/local/portal/sys/dm_oracle/dm_oracle10g.so:kpuexec+0x1580(0x0, 0xff03fbbd, 0xffbe796c, 0xffbe7978, 0x0, 0x0)
/usr/local/portal/sys/dm_oracle/dm_oracle10g.so:OCIStmtExecute+0x2c(0x0, 0x0, 0x0, 0x0, 0x5, 0xffbe8c6c)
/usr/local/portal/sys/dm_oracle/dm_oracle10g.so:PINStmtExecute+0x88(0x7001e47, 0xf2568680, 0xa1623d5, 0x58e, 0x0, 0xecc94b89)
/usr/local/portal/sys/dm_oracle/dm_oracle10g.so:do_sql_select+0x6fc(0xfddd15f8, 0xecd3a668, 0xedda4290, 0xffbe7e50, 0xff04028c, 0x
2400)
/usr/local/portal/sys/dm_oracle/dm_oracle10g.so:op_rflds+0x5d8(0xff0a1230, 0xa7905d6, 0x100, 0x0, 0x1507c, 0x15000)
/usr/local/portal/sys/dm_oracle/dm_oracle10g.so:dm_if_process_op+0x7e4(0x2, 0x40e75, 0x7, 0x16aec, 0x4, 0x40db0)

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