ORA-12203 Errors During Login to 16-bit OFSA 4.5 Applications and SQL*Plus 3.3 (Doc ID 302036.1)

Last updated on JULY 31, 2017

Applies to:

Oracle Risk Manager - Version 4.5 to 4.5.41
Oracle Financial Data Manager - Version 4.5 to 4.5.41
Oracle Transfer Pricing - Version 4.5 to 4.5.41
Oracle Profitability Manager - Version 4.5 to 4.5.41
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) - Version 4.5
Oracle Performance Analyzer (PA) - Version 4.5
Oracle Balance and Control - Version 4.5
Note: All OFSA 4.5 products have reached sustaining support.

Symptoms

In OFSA 4.5, when attempting to login to any of the 16-bit OFSA client applications -- BC, PA, Risk Manager (RM), or Transfer Pricing (TP), the following error occurs:

ERROR
ORA-12203 TNS Unable to Connect to Destination

Login to 32-bit Financial Data Manager (FDM) is successful.  Login to Oracle for Windows -> SQL*Plus 3.3 results in the same ORA-12203 error.

The correct entries for the tnsnames.ora and sqlnet.ora files have been confirmed in the orawin\network\admin directory.

Changes

New OFSA 4.5 client installation.

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