HP XP P9000 Performance Advisor v5.5 Software Troubleshooting and FAQs Guide (T1789-96344, February 2013)

• ERROR [com.hp.xpsl.datastore.DBConnect]: Check if the Database is running. 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 running. 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 running. 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 XP P9000 Performance
Advisor Software is installed.
If the above error messages are present, perform one of the following actions:
◦ Manually restart the HP XP P9000 Performance Advisor Database Listener
service and HP XP 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 XP P9000 Performance Advisor Database and HP XP 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>.
– listener.ora [INSTALL
DIR>\HPSS\padb\ora_db\NETWORK\ADMIN\listener.ora]
– tnsnames.ora [INSTALL
DIR>\HPSS\padb\ora_db\NETWORK\ADMIN\tnsnames.ora]
If HOST = <hostname>, follow these steps to modify the host name manually:
1. Click Start+Run and type services.msc in the command line.
2. Stop the HP XP P9000 Performance Advisor Database Listener service.
3. Change the host name.
Troubleshooting configuration issues 25