HP Systems Insight Manager 7.0 Installation and Configuration Guide for Microsoft Windows

Use Oracle
Use Oracle.
This option is applicable if you have Oracle installed and you want to configure Systems Insight
Manager to use it.
Procedure 20 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 Files→Oracle-OraHome92→Configuration 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 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.
Use Oracle 65