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.

216 Database Maintenance and Management