HP Systems Insight Manager 7.1 Installation and Configuration Guide for MS Windows

Procedure 20 Use Oracle
1. From the Database Configuration window, select Use Oracle. Before using the database you
must ensure the database:
• Uses Unicode character set of AL32UTF8 and national character set of AL16UTF16.
• The NLS Length is set to BYTE.
• Has an Oracle user with Database Administrator (DBA) privileges created for the exclusive
use by Systems Insight Manager.
• The Oracle database schema is empty. Systems Insight Manager must be installed in an
empty Oracle database schema.
• The thin client .jar (ojdbc14.jar) is copied to the system at C:\oracle\ora92\jdbc\lib,
and the location specified during installation.
2. In the Username field, enter the Oracle user name assigned the DBA role.
NOTE: An Oracle user name cannot contain a backslash (\) or a forward slash (/).
3. In the Password field, enter the password for the user name specified.
4. In the Host field, enter the name of the remote or local server where Oracle is installed. An IP
address may also be used.
5. Under Instance name in the Database field, enter the name of the database created on Oracle
for the use of Systems Insight Manager.
6. In the Port field, the default 1521 appears but can be edited.
7. In the JarFile field, enter the full path to theojdbc14.jarfile or click Browse and navigate
to the correct location, typically C:\oracle\ora92\jdbc\lib. This path must be accessible
through the file system on the CMS. The installation copies the file to the correct location.
8. In the Host field, the local host name appears and can only be edited if you are performing
a fresh install.
9. Click Next. The Select Installation Type window appears.
NOTE: If an HP Insight Vulnerability and Patch Manager software MSDE database exists
(within the Systems Insight Manager database instance or located on a database instance
created by Vulnerability and Patch Manager), it is upgraded to SQL Express. If the Vulnerability
and Patch Manager database upgrade fails, a message displays indicating Failed to
Upgrade Vulnerability and Patch Manager Database to SQL Express, but
the Systems Insight Manager installation continues.
68 Database installation