R12 E-Business Suite Concurrent Managers Fail To Start Via Script adcmctl.sh After A DB Refresh Due To Errors 'FDPRRC failed due to ORA-00904: "NLS_SORT": invalid identifier' And ' insert_fcp failed due to ORA-00054: resource busy and acquire with NOWAIT' (Doc ID 2284216.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

E-Business Suite R12 Concurrent Processing, Concurrent Manager related issues

 


Starting the concurrent managers with script adcmctl.sh fails with the following error:


 You are running adcmctl.sh version 120.17.12010000.5

adcmctl.sh: Shutting down concurrent managers for EBS_BALANCE ...
ORACLE Password:
ORACLE error 904 in FDPRRC

Cause: FDPRRC failed due to ORA-00904: "NLS_SORT": invalid identifier

The Internal Concurrent Manager (ICM) log is showing the following errors:

ORACLE error 54 in insert_fcp

Cause: insert_fcp failed due to ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
ORA-06512: at "APPS.FND_CP_FNDSM", line 134
ORA-06512: at line 1.

The SQL statement being executed at the time of the error was: begin fnd_cp_fndsm.register_fndsm_fcp(:c,:n,:o,:l,:m,:t); end; and was executed from the file &ERRFILE.
Could not initialize the Service Manager FNDSM_S1_EBS. Verify that S1 has been registered for concurrent processing.
An error ocurred in client-side routine afpsmcsm for Service Manager FNDSM_S1_EBS. The routine returned code 126.

Changes

 The DB was refreshed.

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