Table of Contents
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)