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
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.
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