EM and RAC – first steps

Start EM and check EM Agent and DBConsole status

Start EM dbconsole 
[oracle@grac41 ~]$ setenv  ORACLE_UNQNAME grac4
[oracle@grac41 ~]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0 
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
https://grac41.example.com:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is not running. 
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11204/racdb/grac41_grac4/sysman/log 

Start dbconsole 
[oracle@grac41 ~]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0 
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
https://grac41.example.com:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ................... started. 
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11204/racdb/grac41_grac4/sysman/log 
Start EM on grac2 and grac43 too !

Check agent status on all nodes
[oracle@grac43 ~]$ emctl status agent
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0 
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version     : 10.2.0.4.5
OMS Version       : 10.2.0.4.5
Protocol Version  : 10.2.0.4.5
Agent Home        : /u01/app/oracle/product/11204/racdb/grac43_grac4
Agent binaries    : /u01/app/oracle/product/11204/racdb
Agent Process ID  : 18187
Parent Process ID : 18166
Agent URL         : https://grac43.example.com:3938/emd/main
Repository URL    : https://grac41.example.com:1158/em/upload/
Started at        : 2014-07-28 17:44:39
Started by user   : oracle
Last Reload       : 2014-07-28 17:47:24
Last successful upload                       : 2014-07-28 17:47:58
Total Megabytes of XML files uploaded so far :     2.94
Number of XML files pending upload           :        2
Size of XML files pending upload(MB)         :     2.21
Available disk space on upload filesystem    :    26.48%
Last successful heartbeat to OMS             : 2014-07-28 17:47:45
---------------------------------------------------------------
Agent is Running and Ready

Display and configure EM Preferred Credentials
Display EM output 
[oracle@grac41 ~]$ firefox https://grac41.example.com:1158/em/console/aboutApplication

Configure ASM connectivity
EM HOME -> prerferences -> Prefered Credentials -> ASM -> Set Credentials -> Change SYSASM/SYSDBA username/password -> Press test !
--> Test connectivity for all cluster nodes !

Enterprise Manager : Access to ASM Home Page 
Database Home -> Instances -> ASM Instance -> Press on any instance like:  +ASM1_grac41.example.com 

Solve error  ORA-12543 in EM HTML output      

Error: 
java.lang.Exception: ORA-12543: TNS:destination host unreachable - wait_bottlenecks

Check EM traces: 
[oracle@grac41 log]$ more  /u01/app/oracle/product/11204/racdb/grac41_grac4/sysman/log/emagent.trc
.. 
LOGIN =/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.160)(PORT=1521))(CONNECT_DATA=(SID=grac41)))
--> HOST=192.168.1.160 was wrong 

Checking dbsnmp account login 
SQL> connect DBSNMP/sys
ERROR:
ORA-28002: the password will expire within 7 days
Connected. 
--> Fix this error and test login 
SQL> alter user DBSNMP identified by sys;
User altered.
SQL>  connect DBSNMP/sys
Connected.

[oracle@grac41 ~]$ emctl stop dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0 
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
https://grac41.example.com:1158/em/console/aboutApplication

Fix problems with targets.xml
Go to $ORACLE_HOME/host_sid/sysman/emd/targets.xml and  change Property NAME="MachineName" to the correct TCP IP address
        <Target TYPE="oracle_database" NAME="grac4_grac41">
                <Property NAME="MachineName" VALUE="192.168.1.160"/>
        <Target TYPE="oracle_listener" NAME="LISTENER_grac41.example.com">
                <Property NAME="Machine" VALUE="192.168.1.160"/>
        <Target TYPE="oracle_listener" NAME="LISTENER_grac41.example.com">
              <Property NAME="Machine" VALUE="192.168.1.160"/>
  to
        <Property NAME="Machine" VALUE="192.168.1.101"/>

Start db console again 
[oracle@grac41 ~]$ emctl start dbconsole
--> correct targets.xml on the remaining node if you want to run the dbconsole from these nodes too

Reference

  • How to Change DBSNMP Password in Database 10g and 11g Monitored by DB Control (Doc ID 259387.1)

Leave a Reply

Your email address will not be published. Required fields are marked *