This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Jun 19, 2013 10:57 PM by qazianeel RSS

Concurrent Manager Inactive - No Manager

qazianeel Newbie
Currently Being Moderated

Hello friends,

 

After applying a standalone patch my concurrent managers stopped working it shows Inactive - No Manager status while running requests.

I executed ./adopmnctl.sh status and it shows Internal Manager is working.

 

I executed cmclean.sql script but it also shows error after execution:

....

Updates complete.

Type commit now to commit these updates, or rollback to cancel.

-----------------------------------------------------------------------

 

SP2-0042: unknown command "Disclaimer" - rest of line ignored.

SP2-0734: unknown command beginning "EXCEPT WHE..." - rest of line ignored.

SP2-0734: unknown command beginning "PROVIDED O..." - rest of line ignored.

SP2-0734: unknown command beginning "ALL WARRAN..." - rest of line ignored.

SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SP2-0734: unknown command beginning "LIMITED TO..." - rest of line ignored.

......

 

Snapshot of managers' status: http://www.fileconvoy.com/dfl.php?id=g83b735a7cc047d5599930687418db0ce76690f55a


Configuration EBS R12.1, Linux 5.3 64 bit.

 

Please let me know if you need further information.

 

Regards

 

Aneel Ahmed

  • 1. Re: Concurrent Manager Inactive - No Manager
    ;) ApPsMasTi ;) Journeyer
    Currently Being Moderated

    please run autoconfig and make sure it completes without error

    do you see any error in db log file?

    what do you see any errors  in mangers logfile?

    only ICM is working what about standard managers?

    please post how you executed cmclean.sql

     

    please check and update ..

     

    AppsMasti
    sharing is Caring

  • 2. Re: Concurrent Manager Inactive - No Manager
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

    Type commit now to commit these updates, or rollback to cancel.

    -----------------------------------------------------------------------

     

    SP2-0042: unknown command "Disclaimer" - rest of line ignored.

    SP2-0734: unknown command beginning "EXCEPT WHE..." - rest of line ignored.

    SP2-0734: unknown command beginning "PROVIDED O..." - rest of line ignored.

    SP2-0734: unknown command beginning "ALL WARRAN..." - rest of line ignored.

    SP2-0044: For a list of known commands enter HELP

    and to leave enter EXIT.

    SP2-0734: unknown command beginning "LIMITED TO..." - rest of line ignored.

     

    Please make sure not to copy/include the lines after "REM <= Last REM statment -----------------------------------------------------" from cmclean.sql script which is on MOS website. Once you remove those entries from the script, run it again and check the CM.

     

    Thanks,

    Hussein

  • 3. Re: Concurrent Manager Inactive - No Manager
    qazianeel Newbie
    Currently Being Moderated

    Hello

     

    Ok akhi Hussein I deleted the lines and re-executed the script and it was executed without errors but concurrent manager was still not working. I even executed autoconfig it was succeeded too but issue was still remain.

     

    I took help from another friend he found that the nodes were not mentioned on concurrent managers and tried some methods, at last he stopped and re-executed adcmctl.sh through root and concurrent managers start working.

     

    What would be the main issue?

     

    Thanks

     

    Aneel Ahmed

  • 4. Re: Concurrent Manager Inactive - No Manager
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

    Thanks akhi Aneel

     

    You shouldn't bring the CM up as root user and this script must be executed as the user who owns the application tier nodes files (typically applmgr user).

     

    What's the error you get when you start adcmctl.sh as applmgr user? Any errors in the CM log file?

     

    Thanks,

    Hussein

  • 5. Re: Concurrent Manager Inactive - No Manager
    qazianeel Newbie
    Currently Being Moderated

    Akhi

     

    We tried to bring up the CM through applmgr user and it was showing internal CM status up too but Concurrent -> Administer application node name was not showing. Then we tried to assign node names through Concurrent -> Define but nothing was working. In last we brought it down through applmgr and brought up again through root and everything started working fine even after machine restart. We are not using that trick anymore as now it's working fine through applmgr. My friend told me that some services were stucked up, that's why managers were not working.

     

    Here is old log file, while we were facing the issue:

    http://www.filedropper.com/logfilevis0613mgr

     

    Thanks

     

    Aneel Ahmed

  • 6. Re: Concurrent Manager Inactive - No Manager
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

    I see this error in the log --> can not chdir(/var/spool/clientmqueue/): Permission denied


    Please make sure your applmgr user has permission to this directory and on all application tier node files.

     

    Thanks,

    Hussein

  • 7. Re: Concurrent Manager Inactive - No Manager
    qazianeel Newbie
    Currently Being Moderated

    Hello

     

    There is some problem with this directory (/var/spool/clientmqueue/) permissions.

    drwxrwx--- 2 smmsp  smmsp  4096 Jun 17 12:15 clientmqueue

     

    Do I've to grant rights to applmgr on this directory?


    Regards

     

    Aneel Ahmed

  • 8. Re: Concurrent Manager Inactive - No Manager
    ;) ApPsMasTi ;) Journeyer
    Currently Being Moderated

    Hi aneel
    yes

    please grant read write execute permission  to applmgr to the directory

     

    AppsMasti
    sharing is Caring

  • 9. Re: Concurrent Manager Inactive - No Manager
    qazianeel Newbie
    Currently Being Moderated

    Thanks Masti

     

    Here you go :

    drwxrwxrwx 2 root   root   4096 Jun 17 12:15 clientmqueue

     

    Regards

     

    Aneel Ahmed

  • 10. Re: Concurrent Manager Inactive - No Manager
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

    Aneel,

     

    As root user, please issue "chmod -R 777 /var/spool/clientmqueue" and see if you can reproduce the issue then.

     

    Thanks,

    Hussein

  • 11. Re: Concurrent Manager Inactive - No Manager
    qazianeel Newbie
    Currently Being Moderated

    Sir,

     

    I've granted the permissions on the same directory and I can't see errors anymore in logs, the managers are working fine.

     

    Please help me to delete the log files includes .req, .mgr, .txt formats. I've logs starting from July 2012.

     

    $LOG_HOME/appl/conc/log

    [oracle@OAConsultants log]$ ls | wc -l

    7730

     

    $LOG_HOME/appl/conc/out

    [oracle@OAConsultants out]$ ls | wc -l

    1428

     

    Thanks and regards

     

    Aneel Ahmed

  • 12. Re: Concurrent Manager Inactive - No Manager
    Asif Muhammad Guru
    Currently Being Moderated

    Hi Ahmed,

     

    The files you are refering are the concurrent request log and output files, and the effective way is to delete them is from the front end by running the following request ( from Sysadmin responsibility):

    Purge Concurrent Request and/or Manager Data 

     

    As you wish to delete both log and output files, have the following paramete:

    Entity=All

    Mode=Count ( how many days of log and output files you wish to have)

            =Age    ( how many number of files you wish to have)

    Mode Vaue = your input value for the selected mode

     

    Please also refer note:

    Concurrent Processing - Purge Concurrent Request and/or Manager Data Program (FNDCPPUR) [ID 104282.1]

     

    Hope this helps!

    Regards,   

  • 13. Re: Concurrent Manager Inactive - No Manager
    qazianeel Newbie
    Currently Being Moderated

    Thanks Asif Bhai

     

    I ran the request for purging logs older than 14 days, the output is :

     

    Purged 1870 entrie(s) from FND_CONCURRENT_REQUESTS :-19-JUN-2013 12:42:35

    Purged 0 entrie(s) from FND_FILE_TEMP :-19-JUN-2013 12:42:35

    Purged 4182 entrie(s) from FND_CRM_HISTORY :-19-JUN-2013 12:42:35

    Purged 0 entrie(s) from FND_TM_EVENTS :-19-JUN-2013 12:42:36

    Purged 0 entrie(s) from FND_TEMP_FILES :-19-JUN-2013 12:42:36

    Purged 0 entrie(s) from FND_ENV_CONTEXT :-19-JUN-2013 12:43:28

    Purged 0 entrie(s) from FND_DUAL :-19-JUN-2013 12:43:28

    Purged 1 entrie(s) from FND_CONFLICTS_DOMAIN :-19-JUN-2013 12:43:28

     

    But I still have so many .mgr,  .log, .txt files and date still goes upto July 2012.

     

    $ ls *.mgr | less | wc -l

    4418

     

    $ ls *.log | less | wc -l

    422

     

    $ ls *.txt | less | wc -l

    500

     

    Thanks and regards

     

    Aneel Ahmed

  • 14. Re: Concurrent Manager Inactive - No Manager
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    But I still have so many .mgr,  .log, .txt files and date still goes upto July 2012.


    You can safely delete those files manually.


    Thanks,

    Hussein

1 2 Previous Next