EM dbconsole for 11gR2 Clustered environment

Hi There,
     Here we have steps for configuring 11gR2 dbconsole for a clustered environment.
Before configuring EM dbconsole, we need to follow pre-configuration steps.

Preconfiguration Steps:
1. set ORACLE_UNQNAME for your cluster environment
  Ex: export ORACLE_UNQNAME=TESTDB

Check for DBUNIQUE name
=======
SELECT name, db_unique_name FROM v$database;

db user passwd unlock
=====================
alter user SYSMAN identified by SYSMAN account unlock;
alter user DBSNMP identified by DBSNMP account unlock;


alter user sys identified by system;



export GRID HOME AND SID FOR ASM
==========
sqlplus sys/system as sysasm
create user asmsnmp identified by asmsnmp;
grant sysdba to asmsnmp;
grant sysasm to asmsnmp;
grant sysoper to asmsnmp;


SQL>select * from gv$pwfile_users;


INST_ID USERNAME          SYSDB SYSOP SYSAS
---------- ------------------------------ ----- ----- -----
         2 SYS                            TRUE  TRUE  TRUE
         2 ASMSNMP                TRUE  TRUE  TRUE
         1 SYS                            TRUE  TRUE  TRUE
         1 ASMSNMP                TRUE  TRUE  TRUE

passwd file for oracle_home/dbs for sysuser
=================
orapwd file=orapwEHISKOL1 password=SYSTEM entries=5 force=y ignorecase=y
orapwd file=orapwEHISKOL2 password=SYSTEM entries=5 force=y ignorecase=y

inside grid_home/dbs
orapwd file=orapw+ASM password=SYSTEM entries=5 force=y ignorecase=y

Check dbconsole status
===================
emctl status dbconsole

if you will find dbconsole running on single node deconfig it or drop the dbconsole
$emca -deconfig dbcontrol db -repos drop

Now time to configure EM dbconsole for clustered environment
$ emca -config dbcontrol db -repos create -cluster

If EM is already available then recreate it by this command

$emca -config dbcontrol db -repos recreate -cluster (This will drop and create the repository again)

It will ask

Db Unique Name:
Service to connect DB:
GRid Listener Home : /u01/app/grid 
SYS Passwd:
DBSNMP passwd:
SYSMAN Passwd :
ASMSNMP Passwd :

We have to provide correct info inorder to get it done.

If it will be successful, it will provide you a link to connect to dbconsole.

We need to add RAC node names in our window hostfiles to access dbconsole on browser.


If any doubts please feel free to ask.

No comments:

Post a Comment