3.5.1 MxDB-Oracle-HiAv Installation and Administration Guide

Chapter 2: Operations 43

Multiple Oracle Homes

The GUI and CLI can perform operations on any Oracle Home for either

Oracle9i or Oracle10g. The oracle user can login, execute the GUI, and

select an Oracle9i or Oracle10g home to perform operations on without

care for environment variables. Likewise, with the mxdb command, the

-d and -h options can be used to operate upon any database in the system

as long as the user executing the command is in the dba group.

Additional Monitoring Capabilities

The PolyServe Management Console can also be used by Database

Administrators to view the Virtual Oracle Service status. The System

Administrator will need to use the mxpasswd command to add the DBA

to the system. The following example grants access for monitoring to the

user oracle with a password of oracle:

# /opt/polyserve/bin/mxpasswd

mxpasswd> {oracle} {oracle}

Password added for user oracle.

When the account is set up, the DBA can access the Management Console.

Issue the mxconsole command to start the Console, specify the server on

the Matrix Server Connect window, and click on Connect. When you are

asked for authentication information, enter the user name and password.

When the Management Console appears, you can view the following:

• Select the Virtual Hosts tab to see the cluster-wide Virtual Oracle

Servers. Click on the Services icon under the Virtual Oracle Server to

see the node states.

• Select the Applications tab to see each Virtual Oracle Service and the

host on which it is active.