Enable Oracle Enterprise Manager 11g Database Control Release 11.2.0.3 in Oracle 11g RAC database in Linux 6 and access OEM from a Browser

Objective: Enable Oracle Enterprise Manager 11g Database Control Release 11.2.0.3 in Oracle 11g RAC database in Linux 6 and access OEM from a client browser.

Pre-requisites:

a) Oracle 11g database installed to use OEM Database Control for database management. (see steps, 17, 25 and 27 in this link)

b) Database(s) up and running.  

Enable Oracle Enterprise Manager 11g Database Control

1) Log into node1 as "oracle" user

[oracle@node1 ~]$ . oraenv
ORACLE_SID = [oracle] ? best
The Oracle base has been set to /u01/app/oracle

2) Check the dbconsole status

[oracle@node1 ~]$ export ORACLE_UNQNAME=best

[oracle@node1 ~]$ emctl status agent
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent is Not Running

3) Start the dbconsole process from the command line:-

[oracle@node1 ~]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://node1.babulab:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ............... started.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/node1_best/sysman/log
 

4) Check the dbconsole status again

 

[oracle@node1 ~]$ emctl status agent
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 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        : /u01/app/oracle/product/11.2.0/dbhome_1/node1_best
Agent binaries    : /u01/app/oracle/product/11.2.0/dbhome_1
Agent Process ID  : 6860
Parent Process ID : 6827
Agent URL         : https://node1.babulab:3938/emd/main
Repository URL    : https://node1.babulab:1158/em/upload/
Started at        : 2014-03-15 04:27:38
Started by user   : oracle
Last Reload       : 2014-03-15 04:28:16
Last successful upload                       : 2014-03-15 04:30:50
Total Megabytes of XML files uploaded so far :     2.22
Number of XML files pending upload           :        0
Size of XML files pending upload(MB)         :     0.00
Available disk space on upload filesystem    :    18.32%
Data channel upload directory                : /u01/app/oracle/product/11.2.0/dbhome_1/node1_best/sysman/recv
Last successful heartbeat to OMS             : 2014-03-15 04:30:46
---------------------------------------------------------------
Agent is Running and Ready

5) Now open a browser (either in one of the nodes or any client machine, I used Firefox in my laptop - a separate machine from the database server, most probably port 1158 should be accessible, if not open it) and provide the OEM URL (https://node1.domain:1158/em), username password as shown in the below screen and click login:-

6) Below is the screen I got once logged in:-

7) Here are few screens in the performance tab:-

8) Check the OEM / OMS (Oracle Management Server) sessions in the database using SQL*Plus:-

[oracle@node1 ~]$ export ORACLE_SID=best1
[oracle@node1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sat Mar 15 05:05:54 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> select username,program,machine from v$session where program='OMS';

USERNAME        PROGRAM         MACHINE
--------------- --------------- ---------------
DBSNMP          OMS             node1.babulab
SYSMAN          OMS             node1.babulab
SYSMAN          OMS             node1.babulab
SYSMAN          OMS             node1.babulab
SYSMAN          OMS             node1.babulab
SYSMAN          OMS             node1.babulab

6 rows selected.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options 

9) Stop the dbconsole process and disable OEM:-

[oracle@node1 ~]$ emctl stop dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://node1.babulab:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 11g Database Control ...
 ...  Stopped.