This discussion is archived
4 Replies Latest reply: Dec 10, 2012 4:42 AM by Fran RSS

how to exectuemgmt_paf_utl.stop_daemon

user3240461 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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"

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points