T2T Data Mapping Batch Fails with OCIERROR: ORA-12545 (Doc ID 2248839.1)

Last updated on APRIL 04, 2017

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.1 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In a newly installed and migrated environment with Oracle Financial Services Analytical Applications (OFSAA) 8.0.1 or higher, you get the following errors running a Table to Table (T2T) load in the log from $FIC_DB_HOME/log/t2t:

ClsUSmsConnect::retrieveInformation, Executed Query = SELECT a.V_SRV_IP_ADDR, a.V_SRV_PORT, a.V_USER_ID, a.V_PASSWORD, a.V_FTP_SHARE, a.V_FTP_DRIVE, a.V_FILE_CATEGORY, a.V_SOURCE_TYPE, a.V_DB_NAME, a.V_DATE_FORMAT, a.V_DB_TYPE, a.V_TABLE_OWNER FROM AAI_ETL_SOURCE a WHERE a.V_SOURCE_NAME = 'OFSPFTSRC'
ClsUSmsConnect::retrieveETLInformation, Error, parameters not available in the specified schema
ClsUSmsConnect::ClsUSmsConnect, Error, failed to retrieve ETL information


and

Log Message here 1: Mon 27 Mar 2017 07:22:03 PM WAT||INFO||ClsUTableToTableLoad::directLoad, Success, connected to the Atomic Database
Log Message here 1: Mon 27 Mar 2017 07:22:03 PM WAT||DEBUG||ClsUDBConnect::getConnectedDB, INFO, User ID = , DBName =
FAILED: log_on().
OCIERROR: ORA-12545: Connect failed because target host or object does not exist


Log Message here 1: Mon 27 Mar 2017 07:22:03 PM WAT||SEVERE||ClsUDBConnect::getConnectedDB, Error, could not connect to the database. ERROR Message : ORA-12545: Connect failed because target host or object does not exist

Log Message here 1: Mon 27 Mar 2017 07:22:03 PM WAT||SEVERE||ClsUTableToTableLoad::directLoad, unable to connect to source database
Warning : Could not log off 0
Log Message here 1: Mon 27 Mar 2017 07:22:03 PM WAT||SEVERE||ClsUTableToTableLoad::ExtractLoad, Error, unable to perform table to table load
Log Message here 1: Mon 27 Mar 2017 07:22:03 PM WAT||INFO||Status from extract load ... 1


As a result of these errors, the T2T load fails.

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