Dm_oracle Seems To Re-Connect After 15 Min. Of No Activity - Fails Using Ldap Failover. (Doc ID 1321506.1)

Last updated on MARCH 28, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.4.0.1.0 [Release 7.4.0]
Information in this document applies to any platform.
***Checked for relevance on 24-Jun-2013***
***Checked for relevance on 27-Mar-2017***

Symptoms

dm_oracle seems to re-connect after 15 min. of no activity - it fails using LDAP failover.

What happens is:
On first try to connect:
• The failover seems to be working fine
• Tries to use the 1st OID: msphupvoid5:3016 => failed
• Then tries to use the 2nd OID: msplgpdb1oid4:3016 => succeed.

Later on (see in Bold below or at the end of the enclosed file):
• After 15 min. without activities, it seems that sqlnet tries to (re)connect again
• This time, sqlnet tries 3 times with the 1st OID !
• This is actually the issue - on reconnect, there's no failover - at least it should try to reconnect to the 2nd OID which worked initially
.

Snippet of the DB trace:

[01-OCT-2010 13:57:06:278] nnflpsl: No connect method found.
[01-OCT-2010 13:57:06:278] nnflgcp: entry
[01-OCT-2010 13:57:06:278] nnflgcp: exit
[01-OCT-2010 13:57:06:279] nnflpsl: host = 'msphupvoid5'
[01-OCT-2010 13:57:06:279] nnflpsl: port = 3016
[01-OCT-2010 13:57:06:279] nnflpsl: exit
[01-OCT-2010 13:57:06:279] nnflilc: entry
[01-OCT-2010 13:57:06:279] nnflilc: Opening sync conn to msphupvoid5:3016
[01-OCT-2010 13:57:06:389] nnflilc: ldap_open failed ld:0
[01-OCT-2010 13:57:06:389] nnflilc: exit
[01-OCT-2010 13:57:06:389] nnflpsl: entry
[01-OCT-2010 13:57:06:389] nnflgcp: entry
[01-OCT-2010 13:57:06:389] nnflgcp: can't get config parameter DIRECTORY_CONNECT_METHOD
[01-OCT-2010 13:57:06:389] nnflgcp: exit
[01-OCT-2010 13:57:06:389] nnflgcp: entry
[01-OCT-2010 13:57:06:389] nnflgcp: exit
[01-OCT-2010 13:57:06:389] nnflpsl: host = 'msplgpdb1oid4'
[01-OCT-2010 13:57:06:389] nnflpsl: port = 3016
[01-OCT-2010 13:57:06:390] nnflpsl: exit
[01-OCT-2010 13:57:06:390] nnflilc: entry
[01-OCT-2010 13:57:06:390] nnflilc: Opening sync conn to msplgpdb1oid4:3016
[01-OCT-2010 13:57:06:421] nnflalc: entry
[01-OCT-2010 13:57:06:556] nnflalc: bind call returns 0
[01-OCT-2010 13:57:06:556] nnflalc: exit
[01-OCT-2010 13:57:06:556] nnflilc: exit


[01-OCT-2010 13:57:06:923] nsprecv: normal exit
[01-OCT-2010 13:57:06:923] nsrdr: got NSPTDA packet
[01-OCT-2010 13:57:06:923] nsrdr: NSPTDA flags: 0x0
[01-OCT-2010 13:57:06:923] nsrdr: normal exit
[01-OCT-2010 13:57:06:923] nsdo: *what=1, *bl=2001
[01-OCT-2010 13:57:06:923] nsdo: nsctxrnk=0
[01-OCT-2010 13:57:06:923] nsdo: normal exit
[01-OCT-2010 13:57:06:923] nioqrc: exit
[01-OCT-2010 13:57:06:923] nszssk: entry
[01-OCT-2010 13:57:06:923] nassky: entry
[01-OCT-2010 13:57:06:923] nassky: exit
[01-OCT-2010 13:57:06:923] nszssk: exit
[01-OCT-2010 14:12:06:565] nnflilc: entry
[01-OCT-2010 14:12:06:565] nnflilc: Opening sync conn to msphupvoid5:3016
[01-OCT-2010 14:12:06:575] nnflilc: ldap_open failed ld:0
[01-OCT-2010 14:12:06:575] nnflilc: exit
[01-OCT-2010 14:27:06:600] nnflilc: entry
[01-OCT-2010 14:27:06:600] nnflilc: Opening sync conn to msphupvoid5:3016
[01-OCT-2010 14:27:06:610] nnflilc: ldap_open failed ld:0
[01-OCT-2010 14:27:06:610] nnflilc: exit
[01-OCT-2010 14:42:06:635] nnflilc: entry
[01-OCT-2010 14:42:06:635] nnflilc: Opening sync conn to msphupvoid5:3016
[01-OCT-2010 14:42:06:645] nnflilc: ldap_open failed ld:0
[01-OCT-2010 14:42:06:645] nnflilc: exit



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