Application pin_sub_balance_cleanup ERROR: "cannot open database 'pindb'; user 'pin'; password 'pin'; accesslib 'libor95212d.so'" (Doc ID 465185.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.0.0.0.0 to 7.3.0.0.0 [Release 7.0.0 to 7.3.0]
Oracle Solaris on SPARC (64-bit)
Solaris Operating System (SPARC 64-bit)
***Checked for relevance on 11-Jan-2010***
Checked for relevance on 20-Oct-2011
***Checked for relevance on 14-OCt-2014***


Symptoms

When the following command

pin_sub_balance_cleanup -n 60

was run from $PIN_HOME/apps/pin_subscription, there is an error in pin_subscription.pinlog as following

D Thu Oct 18 22:39:26 2007 myhost pin_sub_balance_cleanup:9205 pin_sub_balance_cleanup.cpp:337 1:myhost:pin_sub_balance_cleanup:9205:1:0:1192761565:0
       arg_flistp
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /search 0 0
0 PIN_FLD_END_T TSTAMP [0] (1106361566) Fri Jan 21 21:39:26 2005 
E Thu Oct 18 22:39:27 2007 myhost pin_sub_balance_cleanup:9205 pin_sub_balance_cleanup.cpp:194 1:myhost:pin_sub_balance_cleanup:9205:1:0:1192761565:0
       ERROR: cannot open database 'pindb'; user 'pin'; password 'pin'; accesslib 'libor95212d.so'
E Thu Oct 18 22:39:27 2007 myhost pin_sub_balance_cleanup:9205 pin_sub_balance_cleanup.cpp:196 1:myhost:pin_sub_balance_cleanup:9205:1:0:1192761565:0 
       [DBNOTFOUND] No Access Module for 'libor95212d.so'
E Thu Oct 18 22:39:27 2007 myhost pin_sub_balance_cleanup:9205 pin_sub_balance_cleanup.cpp:201 1:myhost:pin_sub_balance_cleanup:9205:1:0:1192761565:0
      Failed to open database
      <location=PIN_ERRLOC_APP:8 class=PIN_ERRCLASS_SYSTEM_DETERMINATE:1 errno=PIN_ERR_INVALID_CONF:30>
      <field num=0:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0> 
      <facility=0 msg_id=0 version=0>
E Thu Oct 18 22:39:27 2007 myhost pin_sub_balance_cleanup:9205 pin_mta.c:3401 1:myhost:pin_sub_balance_cleanup:9205:1:0:1192761565:0 
      Obsolete callback function: pin_mta_init_job error
      <location=PIN_ERRLOC_APP:8 class=PIN_ERRCLASS_SYSTEM_DETERMINATE:1 errno=PIN_ERR_INVALID_CONF:30>
     <field num=0:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
     <facility=0 msg_id=0 version=0>
...

The following configuration has been added to $PIN_HOME/apps/pin_subscription/pin.conf:

#======================================================================
# Some parameters for pin_sub_balance_cleanup application to manipulate
# the database directly.
#======================================================================
- pin_sub_balance_cleanup db_user pin
- pin_sub_balance_cleanup db_password pin
- pin_sub_balance_cleanup db_name pindb
- pin_sub_balance_cleanup db_accesslib or952

Also the user is able to login to the DB with "sqlplus pin/pin@pindb".

"ls -ltr libor*" shows :

-rwxr-xr-x 1 pin101 pin 576972 Sep 20 2005 libor95212d.so

What could be wrong?

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