Sunday 23 September 2018

Concurrent Managers are down error insert_fcp failed due to ORA-01403 no data found, ORA-06512

Hey DBA-Mates, Recently we faced this below error: ORA-01403: no data found
Scenario:
We are doing cloning and after all we started Application but we found that all Concurrent Manager is down except ICM.
We checked the Manager log under $ cd $APPLCSF/log then we found the error as shown below:

Error in CM :
The SQL statement being executed at the time of the error was:  and was executed from the file &ERRFILE.
Could not initialize the Service Manager FNDSM_host_SID. Verify that host has been registered for concurrent processing.

An error occured in client-side routine afpsmcsm for Service Manager FNDSM_host_SID.  The routine returned code 126.

Check for preceding errors and as well as the service manager log file for further details."
Routine AFPEIM encountered an error while starting concurrent manager POMGR with library /apps/sku/apps/apps_st/appl/fnd/12.0.0/bin/FNDLIBR.
Check that your system has enough resources to start a concurrent manager process. Contact your system admin : 17-AUG-2018 04:43:39
Starting OAMCOLMGR Concurrent Manager              : 17-AUG-2018 04:43:39

ORACLE error 1403 in insert_fcp
Cause: insert_fcp failed due to ORA-01403: no data found
ORA-06512: at "APPS.FND_CP_FNDSM", line 177
ORA-06512: at line 1.

The SQL statement being executed at the time of the error was:  and was executed from the file &ERRFILE.
Could not initialize the Service Manager FNDSM_ora-data_sku. Verify that ora-data has been registered for concurrent processing.

An error occured in client-side routine afpsmcsm for Service Manager FNDSM_ora-data_sku.  The routine returned code 126.

Check for preceding errors and as well as the service manager log file for further details."
Routine AFPEIM encountered an error while starting concurrent manager OAMCOLMGR with library /apps/sku/apps/apps_st/appl/fnd/12.0.0/bin/FNDLIBR.

Work-around/Solution:

1. We logged in to front end and we noticed that Host name for ICM is in "Caps letters" like HOSTNAME and for others CM hostname was like hostname.

2. Executed
SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;

SQL>update fnd_concurrent_queues set NODE_NAME='HOSTNAME' where ENABLED_FLAG='Y';

SQL>update fnd_concurrent_queues set TARGET_NAME='HOSTNAME' where ENABLED_FLAG='Y';
SQL> commit;
Commit complete.
SQL> exit

3. Run autoconfig on DB tier.
# pwd
$ORACLE_HOME/appsutil/scripts/SID_hostname
# ls -ltr adautocfg.sh
-rwx------   1 oracle   dba         1570 Aug 12  2017 adautocfg.sh
#

4. Run autoconfig on APPS tier.
$cd $APPL_TOP
$ . ./APPSSID_hostname.env
$ cd $ADMIN_SCRIPTS_HOME
$ ls -ltr adautocfg.sh
-rwx------   1 applmgr  oinstall    1564 Sep 17 08:03 adautocfg.sh
$

5. Start the application.
$cd $ADMIN_SCRIPTS_HOME
$ ls -ltr adstrtal.sh
-rwx------   1 applmgr  oinstall    8393 Sep 17 08:03 adstrtal.sh
$

Some more useful links:
Regards,
Ora-data Team

6 comments:

  1. Hi to all, it's really a good for me to pay a visit this website, it consists of valuable Information.

    ReplyDelete
    Replies
    1. Dear user,
      Thank you for your valuable feedback and interest.

      Regards,
      ora-data Team

      Delete
  2. oracle has developed its own Linux variant based on RedHad Enterprise Linux; all Oracle products that run on Linux run on RHEL by binary compatibility.

    Functional Support

    ReplyDelete
  3. I used to be able to find good advice from your articles.

    ReplyDelete
    Replies
    1. Dear User,
      Thank you for your feedback. Nice to hear that...

      Regards,
      ora-data Team

      Delete
  4. Heya i am for the first time here. I found this boazrd and
    I find It truly useful & it helped me out a lot.
    I hope to give something back andd aid others like you aioded
    me.

    ReplyDelete

Thank you for your comments and suggestions. It's good to talk you.