HP Storage Essentials NAS Manager Software - Manual (Page 246)

Database Maintenance and Management 216
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 122.
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 207.
Checking Database Status:
These steps restart the database. If you receive an error message, contact technical support.
• From the command line:
Sqlplus /nolog
Sql>connect sys/change_on_install@appiq as sysdba
Sql> startup force;
• From the Database Admin Utility. See ” Checking the Database and Listener Status ” on
page 207.
These steps restart the database. If you receive an error message, contact technical support.