Getting ORA-12154 Only Logging into FDM Administration When Oracle 10g Client Installed (Doc ID 743642.1)

Last updated on MAY 02, 2014

Applies to:

Oracle Financial Data Manager - Version 4.5.39 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5.39
Checked for relevance 02-May-2014.

Symptoms

After installing the Oracle 10g client onto a PC, you cannot log into OFSA's Financial Data Manager (FDM) Administration application.  The following error occurs:

ORA-12154: TNS:could not resolve service name

You can log into the other OFSA applications (ex. PA, BC, TP, etc.).

Oracle 10g was installed into a separate Oracle directory.  For example, the OFSA 32-bit software is installed into C:\orant while the Oracle 10g software is installed into C:\Oracle102.  An Oracle Names Server is used to connect from the PC to the database.

The OFSA directory is listed first in the PATH environment variable.

Additionally, the TNSPING program does not work from Orant but does work in the C:\Oracle102\bin directory.

Changes

Installed the Oracle 10g client.

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