HP Storage Essentials V5.1 User Guide First Edition (T4283-96026, August 2006)

Database Maintenance and Management242
You should change the default password after the initial installation to prevent a security breach.
See ”Changing the Password of System Accounts” on page 233.
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 233 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 134.
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 134.
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:
%ORA_HOME%\network\admin\listener.ora
• 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 233.
APPIQ_SYSTEM (management server admin user) password
Table 31 Default Passwords for Database Accounts
Account Name Default Password