My Oracle Support Banner

OCIERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor Running DT Batch (Doc ID 2619266.1)

Last updated on DECEMBER 16, 2019

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)

Symptoms

When attempting to run a "TRANSFORM DATA" (DT) Batch / Task, the batch fails with the following ORA-12514 error in the "RunProc" / "RUNPROCEDURE" log:

Log Message here 1: Mon 25 Nov 2019 01:03:20 PM CST||INFO||Database Type : ORACLE
Log Message here 1: Mon 25 Nov 2019 01:03:20 PM CST||INFO||NLS Value : AMERICAN_AMERICA.UTF8
FAILED: log_on().
OCIERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Log Message here 1: Mon 25 Nov 2019 01:03:21 PM CST||SEVERE||Could not Connect to the Database from Login Information
Warning : Could not log off 0
Log Message here 1: Mon 25 Nov 2019 01:03:21 PM CST||INFO||After Calling execProc
Log Message here 1: Mon 25 Nov 2019 01:03:21 PM CST||SEVERE||Stored procedure execution failed

----------------------------------------------------------------------------------------------------
END OF RUNPROCEDURE OPERATIONS : Mon Nov 25 13:03:21 2019
----------------------------------------------------------------------------------------------------

As a result, the program included in the batch fails to execute.

Cause

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
Symptoms
Cause
Solution


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