4 Replies Latest reply: Dec 10, 2012 6:42 AM by Fran RSS

    how to exectuemgmt_paf_utl.stop_daemon

    user3240461
      Hi all,
      how to exectue the below procedures in 11gR2 as it gives following error.
      10:54:54 SQL> conn sysman/oracle
      Connected.
      11:15:05 SQL> execute mgmt_paf_utl.stop_daemon;
      BEGIN mgmt_paf_utl.stop_daemon; END;

      *
      ERROR at line 1:
      ORA-20403: Job PROVISIONING DAEMON:PROVISIONING DAEMON does not exist
      ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 506
      ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 5724
      ORA-06512: at "SYSMAN.MGMT_JOBS", line 368
      ORA-06512: at "SYSMAN.MGMT_PAF_UTL", line 358
      ORA-06512: at line 1
        • 1. Re: how to exectuemgmt_paf_utl.stop_daemon
          Fran
          exactly database version (4 digits)?, os?

          you must have active emctl, set correct ORACLE_SID, ORACLE_BASE and ORACLE_UNQNAME.

          post value of:
          $emctl status dbconsole
          • 2. Re: how to exectuemgmt_paf_utl.stop_daemon
            Osama_Mustafa
            refer to MOS note :
            Steps to Configure Corrective Actions in EM 10.2 and Known Issues [ID 725835.1]

            This below Document for 10g
            How To Resolve Ora-20403:The Specified Job Does Not Exist When Applying Template [ID 812164.1]
            • 3. Re: how to exectuemgmt_paf_utl.stop_daemon
              user3240461
              Hi Fran,

              db version is 11.2.0.3.0 and os version is solaris 5.10 (Generic_147440-01).

              emctl status dbconsole:
              -bash-3.2$ emctl status agent
              Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
              Copyright (coffee) 1996, 2011 Oracle Corporation. All rights reserved.
              ---------------------------------------------------------------
              Agent Version : 10.2.0.4.4
              OMS Version : 10.2.0.4.4
              Protocol Version : 10.2.0.4.4
              Agent Home : /app/oracle/product/11.2.0.3/db_1/DB11G
              Agent binaries : /app/oracle/product/11.2.0.3/db_1
              Agent Process ID : 27961
              Parent Process ID : 27950
              Agent URL : https://erpsys:1831/emd/main
              Repository URL : https://erpsys:5500/em/upload/
              Started at : 2012-12-10 14:25:45
              Started by user : oracle
              Last Reload : 2012-12-10 14:25:45
              Last successful upload : 2012-12-10 14:28:50
              Total Megabytes of XML files uploaded so far : 0.06
              Number of XML files pending upload : 25
              Size of XML files pending upload(MB) : 0.87
              Available disk space on upload filesystem : 46.17%
              Data channel upload directory : /app/oracle/product/11.2.0.3/db_1/db11g/sysman/recv
              Last successful heartbeat to OMS : 2012-12-10 14:29:36
              ---------------------------------------------------------------
              Agent is Running and Ready
              -bash-3.2$ emctl status dbconsole
              Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
              Copyright (coffee) 1996, 2011 Oracle Corporation. All rights reserved.
              https://erpsys.com:5500/em/console/aboutApplication
              Oracle Enterprise Manager 11g is running.
              ------------------------------------------------------------------
              Logs are generated in directory /app/oracle/product/11.2.0.3/db_1/DB11G/sysman/log
              -bash-3.2$

              Edited by: user3240461 on Dec 10, 2012 3:50 AM
              • 4. Re: how to exectuemgmt_paf_utl.stop_daemon
                Fran
                I can't see any error in your steps, it should work.

                look for any error at "/app/oracle/product/11.2.0.3/db_1/DB11G/sysman/log"