Concurrent Managers Fails To Start, No Service Manager Process Spawned OR Fails with: ORA-01427, ORA-06512 (Doc ID 470100.1)

Last updated on MARCH 27, 2017

Applies to:

Oracle Concurrent Processing - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Oracle Application Object Library - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
IBM AIX on POWER Systems (64-bit)
IBM AIX Based Systems (64-bit)


Symptoms

After migration or changes to the Applications tier, the concurrent managers do not start. Only a single FNDLIBR process is seen and the following errors appear in the log file:

Process monitor session started : 04-DEC-2007 12:01:49
Could not contact Service Manager FNDSM_DHSRVMDS518_SDBA. The TNS alias could not be located, the listener process on DHSRVMDS518 could not be contacted, or the listener failed to spawn the Service Manager process.

Check that your system has enough resources to start a concurrent manager process. Contact your system administrator : 04-DEC-2007 12:06:02
Starting STANDARD Concurrent Manager : 04-DEC-2007 12:06:02
Could not initialize the Service Manager FNDSM_DHSRVMDS519_SDBA. Verify that DHSRVMDS519 has been registered for concurrent processing.
Routine AFPEIM encountered an error while starting concurrent manager STANDARD with library /u02/app/oracle/sdbaappl/fnd/11.5.0/bin/FNDLIBR.

OR

Cause: cleanup_node failed due to ORA-01427: single-row subquery returns more than one row
ORA-06512: at "APPS.FND_CP_FNDSM", line 29
ORA-06512: at line 1.

The SQL statement being executed at the time o
Routine AFPEIM encountered an error while starting concurrent manager STANDARD with library /mnt/oraarch1/arch1appl/fnd/11.5.0/bin/FNDLIBR.

Check that your system has enough resources to start a concurrent manager process. Contact your system administrator : 28-MAR-2011 05:36:25
Starting STANDARD Concurrent Manager : 28-MAR-2011 05:36:25
ORACLE error 1422 in get_sm_info

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