HP-UX Workload Manager Toolkits User's Guide

HP-UX WLM Oracle Database Toolkit: Providing Database Metrics to WLM
Troubleshooting
Chapter 264
smooth: nonnumeric value ...
Run the tool with the option --debug to see what
values are being fed into it by the data collector (either
wlmoradc or a user-supplied collector). Then fix
wlmoradc or the user-supplied collector feeding the
invalid input to smooth.
wlmoradc: can’t connect to instance
Confirm the --home, --instance, and --username
values (or their $opt_name equivalents in the
wlmoradc configuration file) by setting the associated
environment variables and running SQL*Plus
manually, as in the following POSIX shell example:
Step 1. Set the ORACLE_HOME env variable to the --home value:
# export ORACLE_HOME=/oracle/app/oracle/product/8.1.5
Step 2. Set the ORACLE_SID env variable to the --instance value:
# export ORACLE_SID=myinstance
Step 3. Use the --username/--password values with SQL*Plus to confirm that
the instance can be connected to:
# $ORACLE_HOME/bin/sqlplus scott/tiger
SQL*Plus: Release 8.1.5.0.0 - Production on Thu Jan 18 19:48:40 2001
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
wlmoradc: bad perl code in configfile
Use perl -c to check the syntax of the configuration
file, then run wlmoradc by hand.