Unable to connect to the Oracle MDB database after installing Unicenter Asset Portfolio Manager 11.3.4. ConnectTest.exe errors: ADO Connection to the database could not be established: ORA-12154: TNS: Could not resolve service name

Document ID : KB000026031
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue:

Unable to connect to the Oracle mdb database after installing Unicenter Asset Portfolio Management 11.3.4. The ConnectTest.exe program returns the error:
ADO Connection to the database could not be established.  ORA-12154: TNS: Could not resolve service name.

Environment: 

Unicenter Asset Portfolio Management 11.3, 11.3.4, any patch level. 


Resolution: 

The Oracle Client Tools, with "All Options" selected, must be installed on the Unicenter Asset Portfolio Management application server. 


Additional information: 

Additional information on this or other Oracle specific error messages can be obtained from the Oracle 10g online documentation: http://www.oracle.com/pls/db102/homepage .