My Oracle Support Banner

Rarely Concurrent Programs Complete in Error "Concurrent Program Returned No Reason For Failure" (Doc ID 2449338.1)

Last updated on SEPTEMBER 26, 2018

Applies to:

Oracle Concurrent Processing - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Once or twice per month, some concurrent requests complete in an error "Concurrent Program Returned No Reason For Failure".
You can see the message in "COMPLETION_TEXT" in fnd_concurrent_requests.

We found a concurrent manager which processed the request died in the following error.

----------------
14-MAR-2018 15:32:04
Dropping current connection
ルーチン AFPCSQ にOracleエラーが発生しました。 ORA-12514: TNS: リスナーは接続記述子で要求されたサー。

エラー・メッセージを検証して、 エラーの原因を調べてください。 (=<POINTER>)

Shutting down Concurrent Manager : 14-MAR-2018 15:32:04
ORA-01012: ログオンされていません。
ORACLE error 3114 in AFPRSP

Cause: AFPRSP failed due to ORA-03114: Oracleに接続されていません。
.

The SQL statement being executed at the time of the error was: and was executed from the file .

List of errors encountered:
.............................................................................

_ 1 _
Routine AFPCMT encountered an ORACLE error. ORA-01012:
ログオンされていません。.

Review your error messages for the cause of the error. (=<POINTER>)

_ 2 _
Routine AFPPRD has encountered a fatal error. ORA-03114:
Oracleに接続されていません。

Contact your system administrator or support representative.

_ 3 _
Routine AFPCSQ encountered an ORACLE error. ORA-12514: TNS:
リスナーは接続記述子で要求されたサー.

Review your error messages for the cause of the error. (=<POINTER>)
.............................................................................

 

At the same time, we found the following error in DB Alert file.

***********************************************************************
Fatal NI connect error 12514, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xxx.xx.xx)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ABCDE)(CID=(PROGRAM=XXCONC_MGR)(HOST=qwerty)(USER=applmgr))))

VERSION INFORMATION:
TNS for Linux: Version 10.1.0.5.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 10.1.0.5.0 - Production
Time: 14-MAR-2018 15:32:04
Tracing not turned on.
Tns error struct:
ns main err code: 12564
TNS-12564: TNS:connection refused
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
***********************************************************************

 



Changes

 There is no change.

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!


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