HP StorageWorks P9000 Performance Advisor Software v5.4 Troubleshooting and FAQs Guide (T1789-96336, April 2012)

P9000 Performance Advisor Oracle database connection failure
Cause
P9000 Performance Advisor is unable to connect to the Oracle database and following error is logged
in the pa.log file (HPSS_HOME\pa\tomcat\log).
Resolution
1. Ensure that the user account used to install P9000 Performance Advisor had administrator priv-
ileges.
2. Check whether the P9000 Performance Advisor Oracle Database services are active.
Go to Start > Run and type services.msc. In the Services dialog box, verify that the HP Stor-
ageWorks P9000 Performance Advisor Database and HP StorageWorks P9000 Performance
Advisor Database Listener services have started.
3. If the above steps are successful, check for duplicate server entries in the hosts file
(DRIVE_LETTER:\WINNT\system32\drivers\etc\hosts). In the following example, the
IP address 127.0.0.1 has duplicate server name entries:
127.0.0.1 localhost
127.0.0.1 tstrgwb1
4. Remove the duplicate entry for the IP address.
5. Execute the following commands in a command prompt window on your management station to
stop and start the HP StorageWorks P9000 Performance Advisor Database Listener service:
a. lsnrctl stop
b. lsnrctl start
6. Restart P9000 Performance Advisor.
Click Start > All Programs > HP Storage Works > Restart services.
7. Launch P9000 Performance Advisor and verify if the connection is established with the Oracle
database.
HP StorageWorks P9000 Performance Advisor Database service initialization
failure
The database service initialization fails with the following error message:
Database service may not be responding. Database Service initialization
failed.
Cause
• The database service might have encountered a problem during start up of the database
• The database service initialization fails after the operating system is restarted
Troubleshooting P9000 Performance Advisor issues26