HP Storage Essentials V5.1 User Guide Second Edition (Linux Release) (T4283-96056, November 2006)

Storage Essentials 5.1 User Guide 253
IMPORTANT: Do not change any Database Password manually or from the command line. If a
password is changed manually, DB-Admin tool will not work and export, import, rman backup will
start failing. See ”Changing the Password of System Accounts” on page 244 for information about
changing database passwords.
How to change the Database Password for APPIQ_USER account on Managed Database
Application:
To discover and manage the database application from management server, APPIQ_USER
(GLOBAL) account is used. On all the managed applications the APPIQ_USER account with the
default password of “password” was created when you configured the management server before
you discovered the database application.
You can change the password for the APPIQ_USER account but this should done for all database
applications. See ”Changing the Password for the Managed Database Account” on page 143.
For example: If the management server is managing two Oracle and two Sybase database
applications, ask the database administrator to change the password for APPIQ_USER on all the
Oracle and Sybase managed databases to a single password. Then, change the password for
APPIQ_USER on the management server as described in ”Changing the Password for the Managed
Database Account” on page 143.
Troubleshooting Listener and Database Connection Problems
If there is any connection problem from management server or you see a JBoss connection problem
in appiq.log, first verify that the listener and database are running:
Checking Listener Status:
If you are not able to start the listener contact technical support with the error message and network
files (tnsnames.ora,listener.ora) from the following directory:
Microsoft Windows:
%ORA_HOME%\network\admin\listener.ora
UNIX systems:
$ORACLE_HOME/network/admin/listener.ora
• On Windows:
• From the command line:
lsnrctl status
This will show you the status of listener. If the listener is not up try to start as:
lsnrctl start
• From the Database Admin Utility. See ”Checking the Database and Listener Status” on
page 243.
• UNIX systems: From command line su – oracle and as a Oracle user
• From the command line:
lsnrctl status