My Oracle Support Banner

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

Last updated on MAY 07, 2018

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.


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.


Installed the Oracle 10g client.


To view full details, 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 a vibrant support community of peers and Oracle experts.