My Oracle Support Banner

ORA-12154: TNS:Could Not Resolve the Connect Identifier Error Running T2T Load (Doc ID 1336771.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 and later
Oracle Financial Services Enterprise Financial Performance Analytics - Version 5.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)


In Oracle Financial Services Analytical Applications (OFSAA) Infrastructure, you are running a Table to Table (T2T) load for a database extract.  The load batch fails and the following error is in the t2t log file in $FIC_DB_HOME/log/t2t:

2011-05-25 | 14:23:11 | t2tserver | INFO | | | ClsUTableToTableLoad::directLoad, Success, connected to the Atomic Database
2011-05-25 | 14:23:11 | t2tserver | DEBUG | | | ClsUDBConnect::getConnectedDB, INFO, User ID = , DBName =
2011-05-25 | 14:23:11 | t2tserver | SEVERE | | | ClsUDBConnect::getConnectedDB, Error, could not connect to the database. ERROR Message : ORA-12154: TNS:could not resolve the connect identifier specified

2011-05-25 | 14:23:11 | t2tserver | SEVERE | | | ClsUTableToTableLoad::directLoad, unable to connect to source database
2011-05-25 | 14:23:11 | t2tserver | SEVERE | | | ClsUTableToTableLoad::ExtractLoad, Error, unable to perform direct table to table load

Additionally, the following errors are displayed for the failed task in Batch Monitor:

[10885] Error connecting source Database
[10865] Loading Failed.

The error prevents you from loading data into the target table.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.