3.7.0 HP StorageWorks MxDB-Oracle-HiAv installation and administration guide HP MxDB-Oracle-HiAv for Linux (AG513-96009, June 2009)

4 Implement Oracle Enterprise
Manager DB Console with the Virtual
Oracle Service
Implementing dbconsole Oracle Enterprise Manager (OEM) for 10g and 11g in
a clustered environment requires that dbconsole work properly with virtual oracle
hosts. The individual OEM services and processes on each node can then manage
the Oracle instance when the instance is running on that node. You must install
dbconsole for each database that you want to manage using dbconsole.
This chapter describes how to set the Oracle environmental parameter
ORACLE_HOSTNAME and how to create the sysman repository to make it possible
to transition a database between nodes and still use dbconsole. Since having
multiple databases running within the cluster is possible but requires using a unique
listener on a non-default port for each database, this aspect of the setup is also
addressed.
Implementation procedure
At a high level, the implementation steps are:
1. Create the Virtual Oracle Service, as described in Chapter 2.
2. Ensure that your database is up (using mxdb) and put the database into
Maintenance Mode.
3. On the server that is currently the active server for the database, open a shell
session as user oracle. Add to your environment ORACLE_HOSTNAME set to
the virtual oracle host address and make sure your ORACLE_SID and
ORACLE_HOME are pointing to the database you want to monitor with
dbconsole.
4. Using sqlplus, unlock the accounts needed for dbconsole (dbsnmp and
sysman).
MxDB-Oracle-HiAv installation and administration guide 61