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

3.22 Installing the Database Server
3PAR System Reporter User’s Guide System Reporter 2.8
2 Click Next at the welcome screen.
3 Select the Create a Database radio button and click Next.
4 Select the radio button for the Data Warehouse template and click Next.
5 Enter a name for the database and Oracle System Identifier (SID) and click Next.
6 Keep defaults for Configure Enterprise Manager, and click Next.
7 Select passwords for various Oracle users and click Next.
8 Select the desired storage mechanism and click Next.
9 At this point you can click Finish or continue to set further options.
10 After clicking Finish, check the settings in the confirmation screen and click OK.
11 Click Exit after the database has been created.
3.8.3.2 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 3.11 About Apache HTTP Server Authorization and Access Control on page 3.34.
■ 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 7.2.2 Editing Sampling Policies on
page 7.4).
■ 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 3.9 Installing or Upgrading the System
Reporter Tools on page 3.24), the installer creates two Apache HTTP Server config.tcl files
to store the user names and passwords for the cliuser and the webuser. See 7.8 Modifying
the Apache HTTP Server Configuration Files on page 7.23 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 3.8.3.1 Creating an Oracle database on page 3.21, a
link to the Oracle Enterprise Manager URL for the database would typically have been
added to the Windows programs submenu for Oracle.