User's Manual

Database Maintenance and Management216
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.