ORACLE Enterprise Manager Control

Enterprise Manager Control (EMCTL)

OEM:Daily / Weekly Backups not happening

Issue : 
Daily incremental/ weekly full backups scheduled through OEM is not happening as scheduled.

Troubleshooting:

1) First check whether emagent is running or not on that database node?
    a) ps -efa|grep agent

        - confirms the agent is running.

    b) cd /home/oracle/OEM_GRID/agent10g/bin/
       ./emctl status agent

       - The output says agent is up and running fine properly.

2) Checked whether agent upload is happening or not?
    ./emctl upload agent

    - ERROR.
    May be the same thing is not allowing the backups to happen as scheduled.

Fix :
    cd /home/oracle/OEM_GRID/agent10g/bin/
    ./emctl stop agent
    ./emctl clearstate agent
    ./emctl start agent
    ./emctl upload agent

After this, scheduled OEM jobs will run as expected.

oracle_unqname tips

Question:  I need to understand how the oracle_unqname environmental variable works in 11g.

Answer:  The oracle_unqname an OS environmental variable that defines the database unique name.  The oracle_unqname is used in 11g and beyond to enable OEM.  You can see this value with this query:

select
   name,
   db_unique_name
from
   v$database;

If you have not defined oracle_unqname you will see this error when starting OEM:

C:\> emctl status dbconsole

Environment variable ORACLE_UNQNAME not defined.
Please set ORACLE_UNQNAME to database unique name


Here is hot to set oracle_unqname in Windows.  You use a similar "export command" in UNIX/Linux:

C:\>set ORACLE_HOSTNAME=localhost

C:\>set ORACLE_UNQNAME=orcl

C:\>set ORACLE_SID=orcl

C:\>emctl status dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.1