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

Resolution
Verify the stdout.log file located at %HPSS_HOME%/pa/tomcat/logs for the following error
messages:
• ERROR [com.hp.xpsl.datastore.DBConnect]: Check if the Database is run-
ning. Please contact administrator or HP Support, if the exception
continues. Listener refused the connection with the following error:
ORA-12505, TNS: listener does not currently know of SID given in connect
descriptor. The Connection descriptor used by the client was:
xxxx:1521:PADB.
ERROR [com.hp.xpsl.datastore.DBConnect] Check if the Database is run-
ning. Please contact administrator or HP Support, if the exception
continues. Listener refused the connection with the following error:
ORA-12528, TNS:listener: all appropriate instances are blocking new
connections. The Connection descriptor used by the client was:
xxxx:1521:PADB.
ERROR [com.hp.xpsl.datastore.DBConnect] Check if the Database is run-
ning. Please contact administrator or HP Support, if the exception
continues. ORA-01033: ORACLE initialization or shutdown in progress.
NOTE:
xxxx is the name of the management station on which HP StorageWorks P9000 Performance
Advisor Software is installed.
If the above error messages are present, perform one of the following actions:
• Manually restart the HP StorageWorks P9000 Performance Advisor Database
Listener service and HP StorageWorks P9000 Performance Advisor Database
service.
• Run the LSNRCTL STOP and LSNRCTL START commands.
• Run theSHUTDOWN command followed by the STARTUP database command.
• Ensure that the HP StorageWorks P9000 Performance Advisor Database and HP StorageWorks
P9000 Performance Advisor Database Listener services are running:
Click Start > Run and type services.msc in the command line.
The services should be in the Started mode.
• Verify the host name. Obtain the host name using the following command: nslookup
<IP_address>.
Example:
nslookup 01.01.01.01
Name: abc.ind.hp.com
<hostname>: abc
• Right click My Computer > Properties > Computer Name.
The <hostname> and the name of your system must match.
• Confirm the host name in the Oracle folder.
1. Go to <Installation_drive>\HPSS\padb\ora_db\NETWORK\ADMIN.
2. Verify the following file to confirm if HOST = <hostname>.
HP StorageWorks P9000 Performance Advisor Software Frequently Asked Questions 27