HP Systems Insight Manager 5.3 with SP1 Installation and Configuration Guide for Microsoft Windows

Table Of Contents
installed. After SQL Server 2005 Express Edition is installed, the Select Installation Type
window appears.
Use SQL/SQL Express. This option is applicable if you have SQL Server 2008 or SQL Server
2005 Express Edition installed and you want to configure HP SIM to use it.
To use SQL or SQL Server 2005 Express Edition:
1. From the Database Configuration window, select Use SQL/SQL Express.
2. In the Username field, the installing user account appears and can be edited. The account
specified must be the user name for the database server.
3. In the Password field, enter the password for the database server.
HP SIM does not support the following in a user name and password:
A blank password
A space followed by a double-quote
A backslash (\)
If you use these characters in your user name or password, the HP SIM database
initialization fails.
4. In the Domain field, enter the domain name for the database server.
5. Click Next. The Select Installation Type window appears.
Use Oracle. This option is applicable if you have Oracle installed and you want to configure HP
SIM to use it.
To configure Oracle:
1. Install Oracle or verify Oracle is installed.
2. Create a Database Scheme using the Oracle Database Configuration Assistant. To use
the assistant, select Program FilesOracle-OraHome92Configuration and Migration
Tool.
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 MemoryCustom, 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 FilesOracle-OraHome92Configuration and Migration
ToolNetConfiguration 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.
85