T2T Data Mapping Batch Fails with OCIERROR: ORA-12545
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)
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
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 =
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms