HP XP P9000 Performance Advisor Software v5.5 Install Guide (T1789-96339, February 2013)

4. Ensure that the following services are stopped:
• Distributed Transaction Coordinator
• HP XP P9000 Performance Advisor Database
• HP XP P9000 Performance Advisor Database Job Scheduler
By default, this service is disabled.
• HP XP P9000 Performance Advisor Database Listener
• HP XP P9000 Performance Advisor Database VSS Writer
• HP XP P9000 Performance Advisor Monitor
• HP XP P9000 Performance Advisor Security
• HP XP P9000 Performance Advisor Tomcat
To stop the above mentioned services, do the following:
a. Select Start > Run, type services.msc, and press the Enter key.
The Services window appears.
b. Right-click the respective services and select Stop from the list that appears.
c. Close the Services dialog box.
Procedure
IMPORTANT: When you double-click the Oracle patch installer, it takes some time to initialize.
Wait for the installer screens to appear.
To install the latest Oracle patches and security updates:
1. Execute the Oracle patch installer from the OraclePatchInstaller folder on Disk2 of the
DVD.
2. After the installation, complete the following additional steps to verify invalid objects:
a. In the command prompt window, type sqlplus /nolog and press Enter.
b. Execute the following query to connect to the database as SYSDBA using SQL*Plus:
CONNECT / AS SYSDBA SQL
c. After you are connected, execute the following query:
SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS = 'INVALID';
The following message is displayed:
no rows selected.
If any invalid objects are listed, contact your HP Support representative for further
assistance to resolve the issue.
116 Installing Oracle patches and security updates