1 2 Previous Next 15 Replies Latest reply: Jun 20, 2013 12:57 AM by qazianeel RSS

    Concurrent Manager Inactive - No Manager

    qazianeel

      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 ;)

          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

            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

              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

                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

                  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

                    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

                      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 ;)

                        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

                          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

                            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

                              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

                                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

                                  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
                                    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