HP-UX Workload Manager Toolkits User's Guide

HP-UX WLM Oracle Database Toolkit: Providing Database Metrics to WLM
Where do I get ODBTK?
Chapter 230
* For descriptions of the example configuration files, see Table 2-2 on
page 35 and Table 2-3 on page 37.
How do I install ODBTK?
Use the SD-UX swinstall command to install ODBTK, which is part of
the WLM Toolkits product (product number WLMToolkits).
The toolkit is installed at:
/opt/wlm/toolkits/oracle/
The manpages are installed at:
/opt/wlm/share/man/
For more information about installation procedures and related issues,
see the following documentation:
• Managing HP-UX Software with SD-UX
• swinstall (1M)
Giving ODBTK access to the database instances
Before you use the ODBTK utility wlmoradc, you must provide it with
access to the database instances. You do this in one of two ways:
• Using an existing username/password combination
• Using the default wlmoradc username/password combination
hp_wlmuser/hp_wlmuser
ODBTK comes with a script that creates a user and role for hp_wlmuser,
as explained in the next section.
After granting ODBTK access to your instances, see the section “How do
I use the metrics?” on page 34 for information on using wlmoradc with
WLM.
Creating a user and role for hp_wlmuser
The wlmoradc utility, by default, attempts to connect to database
instances with the username/password combination
hp_wlmuser/hp_wlmuser. For convenience, the DBA may wish to create
a user and role for hp_wlmuser. Creating this user allows wlmoradc to
connect and query the V$ tables for SLOs based on SQL values; however,