HP 3PAR System Reporter Software - Manual (Page 42)

10. After clicking Finish, check the settings in the confirmation screen and click OK.
11. Click Exit after the database has been created.
Creating the Oracle Users for System Reporter
Use the instructions that follow to create two users: cliuser and webuser. These users have different
privilege levels that correspond with optional Apache HTTP Server privilege levels, as described
in
“About Apache HTTP Server Authorization and Access Control” (page 49) .
•
cliuser is the default user name for the sampler and policy change user. The System Reporter
tables are created in the cliuser schema. This user can create and edit database tables and
change database sampling policies (see
“Editing Sampling Policies” (page 114) ).
•
webuser is the default user name for the Web reports user. This user has select privileges only
for the tables in the cliuser schema.
As part of installing the System Reporter tools (see “Installing or Upgrading the System Reporter
Tools” (page 43) ), the installer creates two Apache HTTP Server config.tcl files to store the
user names and passwords for the cliuser and the webuser. See for instructions on editing these
config.tcl
files if you change the Oracle usernames and passwords at a later time.
To create the users, open the Oracle Enterprise Manager for the database in a web browser. When
you create the database in section
“Creating an Oracle database” (page 41) , a link to the Oracle
Enterprise Manager URL for the database would typically have been added to the Windows
programs submenu for Oracle.
1.
At the login screen for the Oracle Enterprise Manager login as SYSTEM with the password for
the SYSTEM user.
2. Click the link (or tab) for Server.
3. Under Security, click on the link for Users.
4. Click the Create button.
5. In the create user screen, enter the user name cliuser along with the password. Select a default
and temporary tablespace, select Unlocked for the status.
6. Click on the link (or tab) for Roles.
7. The cliuser needs to have the CONNECTION and RESOURCE roles. The CONNECTION role
should be there by default, otherwise add it along with the RESOURCE role by clicking the
Edit List button and adding RESOURCE and/or CONNECTION and clicking OK. The cliuser
should also have the CREATE TABLE role.
8. Click OK to create the cliuser user.
Repeat the steps above to create the webuser user as well. The webuser needs SELECT
privileges for all the tables in the cliuser schema. System Reporter will automatically grant
SELECT privileges to the webuser when it creates the tables.
NOTE: To improve performance, System Reporter runs the dbms_stats utility in Oracle.
Please grant execute permission for this utility in Oracle.
NOTE: System Reporter 2.9 logs more information for debugging purposes. It uses two
Oracle views v$instance and v$version. Please grant permissions to these views for the
user that sets the policy settings.
Creating the Oracle Net Service
You need to create an Oracle Net Service on the host on which the System Reporter will be installed.
This is used by the System Reporter sampler and the web CGI programs to connect to the Oracle
database.
1.
Install the Oracle Client (the Runtime version is sufficient) on the host. This should include the
Net Configuration Assistant under the Oracle client program menu.
42 Installation, Configuration, Update, and Removal