Systems Insight Manager 6.2 Installation and Configuration Guide for MS Windows

3. Select Create a Database, and then select Next.
4. Select General Purpose, and then select Next.
5. Enter a name in Global Database Name, for example HPSIM, and then select Next.
6. Select Dedicated Server Mode, and then select Next.
7. Select Memory→Custom, and then select Next.
8. Select Character Sets.
9. Select Use Unicode (AL32UTF8), and then select Next.
10. Select Next.
11. Select Finish, review the options, and then select Okay. The schema will take approximately 10 -15
minutes to create.
12. When Oracle finishes creating the database, enter the password for SYS and SYSTEM.
13. Create a user and grant access for the schema:
a. Open a Command Prompt.
b. At the prompt, enter sqlplus.
c. At >login:, enter sys as sysdba.
d. At >Password:, enter the password.
e. At SQL>, enter create user sim_manager identified by quake.
f. At SQL>, enter grant connect, resource, dba to sim_manager.
g. Exit the Command Prompt utility, using the exit command.
14. Create the listener for the database schema.
a. Select Program Files→Oracle-OraHome92→Configuration and Migration
Tool→NetConfiguration Assistant.
b. Select Listener Configuration.
c. Select Add.
d. Use the default name of LISTENER, and then select Next.
e. Select TCP, and then select Next.
f. Enter the port number, use standard port 1521.
g. Select No when the "Would you like to configure another listener?" dialog appears.
h. In Services, set OracleOraHome92TNSListener to Automatic, and then start the service.
Procedure 9-4 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
HP Systems Insight Manager.
• The Oracle database schema is empty. HP 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 HP Systems Insight Manager.
6. In the Port field, the default 1521 appears but can be edited.
52 Database installation