OEM Agent is Down

Oracle Enterprise Manager Agent is down

2 of Single Instance database OEM agent was down.

STEPS

2 OEM agents are down for 2 databases: one prod & one dev

— login to the box

need to know the owner, who installed this oem agent, mostly it’s oracle, but in RAC, it’s owned by grid.

how to find oem agent installed location/directory:

find / -name emctl -print 2>/dev/null

cd  <directory>

ls -lrt     – this’ll tell you the owner

$ find / -name emctl -print 2>/dev/null

/u01/app/agent/core/12.1.0.5.0/bin/emctl               – this is the one that we’ll be using to start/stop or even check agent status

/u01/app/agent/agent_inst/bin/emctl

cd /u01/app/agent/core/12.1.0.5.0/bin

ls -lrt emctl*

— when we did this … got an error:

$ emctl status agent

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

[oracle@/u01/app/agent/core/12.1.0.5.0/bin]

— Reason is  …

$ echo $ORACLE_HOME

/u01/app/oracle/product/11.2.0/dbhome_1

— The OEM agent is installed as 12c, whereas we are connected to 11g Oracle Home, need to change Oracle Home to 12c home or either can force to run the agent from that home itself, by using this:

$ ./emctl status agent

Oracle Enterprise Manager Cloud Control 12c Release 5

Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.

—————————————————————

Agent is Not Running

— now starting agent

$ ./emctl start agent

Oracle Enterprise Manager Cloud Control 12c Release 5

Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.

Starting agent ………………………………….. started.

— it was easy, let’s start for the 2nd one, this is a DEV box:

TIP: it’s good to have a doc, where all the oem locations are listed if having multiple DBS/agent:

$ /u01/app/agent/core/12.1.0.5.0/bin/emctl status agent

Oracle Enterprise Manager Cloud Control 12c Release 5

Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.

—————————————————————

Agent is Not Running

$ /u01/app/agent/core/12.1.0.5.0/bin/emctl start agent

Oracle Enterprise Manager Cloud Control 12c Release 5

Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.

Starting agent ……………………………………………………………………. started.

— agent started here too, now there are couple of steps that you can take:

— check status again:

$ /u01/app/agent/core/12.1.0.5.0/bin/emctl status agent

Oracle Enterprise Manager Cloud Control 12c Release 5

Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.

—————————————————————

Agent Version          : 12.1.0.5.0

OMS Version            : 12.1.0.5.0

Protocol Version       : 12.1.0.1.0

Agent Home             : /u01/app/agent/agent_inst

Agent Log Directory    : /u01/app/agent/agent_inst/sysman/log

Agent Binaries         : /u01/app/agent/core/12.1.0.5.0

Agent Process ID       : 25530

Parent Process ID      : 25221

Agent URL              : https://orcldev.orcldb.int:1158/emd/main/

Local Agent URL in NAT : https://orcldev.orcldb.int:1158/emd/main/

Repository URL         :

Started at             : 2018-01-02 09:33:51

Started by user        : oracle

Operating System       : Linux version 2.6.32-696.13.2.el6.x86_64 (amd64)

Last Reload            : (none)

Last successful upload                       : 2018-01-02 09:35:30

Last attempted upload                        : 2018-01-02 09:35:30

Total Megabytes of XML files uploaded so far : 0.11

Number of XML files pending upload           : 0

Size of XML files pending upload(MB)         : 0

Available disk space on upload filesystem    : 9.54%

Collection Status                            : Collections enabled

Heartbeat Status                             : Ok

Last attempted heartbeat to OMS              : 2018-01-02 09:35:21

Last successful heartbeat to OMS             : 2018-01-02 09:35:21

Next scheduled heartbeat to OMS              : 2018-01-02 09:36:21

—————————————————————

Agent is Running and Ready

— also can upload status too:

$ /u01/app/agent/core/12.1.0.5.0/bin/emctl upload agent

Oracle Enterprise Manager Cloud Control 12c Release 5

Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.

—————————————————————

EMD upload completed successfully

$ /u01/app/agent/core/12.1.0.5.0/bin/emctl status agent

Oracle Enterprise Manager Cloud Control 12c Release 5

Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.

—————————————————————

Agent Version          : 12.1.0.5.0

OMS Version            : 12.1.0.5.0

Protocol Version       : 12.1.0.1.0

Agent Home             : /u01/app/agent/agent_inst

Agent Log Directory    : /u01/app/agent/agent_inst/sysman/log

Agent Binaries         : /u01/app/agent/core/12.1.0.5.0

Agent Process ID       : 25530

Parent Process ID      : 25221

Agent URL              : https://orcldev.orcldb.int:1158/emd/main/

Local Agent URL in NAT : https://orcldev.orcldb.int:1158/emd/main/

Repository URL         :

Started at             : 2018-01-02 09:33:51

Started by user        : oracle

Operating System       : Linux version 2.6.32-696.13.2.el6.x86_64 (amd64)

Last Reload            : (none)

Last successful upload                       : 2018-01-02 09:37:15

Last attempted upload                        : 2018-01-02 09:37:15

Total Megabytes of XML files uploaded so far : 0.15

Number of XML files pending upload           : 0

Size of XML files pending upload(MB)         : 0

Available disk space on upload filesystem    : 9.54%

Collection Status                            : Collections enabled

Heartbeat Status                             : Ok

Last attempted heartbeat to OMS              : 2018-01-02 09:37:21

Last successful heartbeat to OMS             : 2018-01-02 09:37:21

Next scheduled heartbeat to OMS              : 2018-01-02 09:38:21

—————————————————————

Agent is Running and Ready