OFSA 4.5 After Upgrading Database to 10g, 'Can't Open Shared Library' Errors Attempting to Run the OFSPA Executable Directly on the Server (Doc ID 758561.1)

Last updated on MAY 02, 2014

Applies to:

Oracle Financial Data Manager - Version 4.5.39 and later
Oracle Profitability Manager - Version 4.5.39 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) - Version: 4.5
Oracle Performance Analyzer (PA) - Version: 4.5

Checked for relevance on 02-May-2014.
Note: All OFSA 4.5 products have reached sustaining support.
Checked for relevance on 12-Apr-2012.


Symptoms

On OFSA 4.5.39 after database upgrade from 9.2.0.6 to 10.2.0.3, when attempting to run the ofspa executable: /db/d01/app/ofsa/ofsa4.05092-hp/bin/ofspa the following error is produced:

ERROR

/usr/lib/dld.sl: Can't open shared library:
../../../ofsa3plib/RogueWave/RWTools/workspaces/HPUX10/HPACC/0d/lib/libtls0d.sl
/usr/lib/dld.sl: No such file or directory
Abort(coredump)"

The same errors are not produced when running on the server through the Performance Analyzer GUI.
No errors occur while starting Request Queue (RQ) as the following note was used: <Note:357464.1>.

Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Set the $ORA_NLS33 to the correct path as per <Note: 357464.1>:
/db/d01/app/oracle/product/10.2.0/nls/data/9.2.0

2. Attempt to run ofspa:
oracle@ofsa:/db/d01/app/ofsa/ofsa4.05092-hp/bin=> ./ofspa < /db/d00/prod/gl/jobs/195445

Changes

Upgrade database to 10g.

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