Concurrent Managers Fail to Start, No Service Manager Process Spawned OR Fails with: ORA-01427, ORA-06512
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:
The issue was caused by incorrect node names in the FND_NODES table, the table had not been updated to remove non existent nodes.
Solution:
1.Stop the services or atleast concurrent manager
2.Execute FND_CONC_CLONE.SETUP_CLEAN
3.Run AutoConfig on the database tier.
4.Run AutoConfig on the apps tier.
5.Check if AutoConfig completed successfully.
6.Start the services/concurrent managers and re-test.
Reference metalink Doc ID 470100.1
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:
The issue was caused by incorrect node names in the FND_NODES table, the table had not been updated to remove non existent nodes.
Solution:
1.Stop the services or atleast concurrent manager
2.Execute FND_CONC_CLONE.SETUP_CLEAN
3.Run AutoConfig on the database tier.
4.Run AutoConfig on the apps tier.
5.Check if AutoConfig completed successfully.
6.Start the services/concurrent managers and re-test.
Reference metalink Doc ID 470100.1
No comments:
Post a Comment