HP 3PAR StoreServ 7200 2-node HP 3PAR System Reporter 3.1.0 Software User& - Page 40
Setting Up the Oracle Database (Optional), Creating an Oracle database
View all HP 3PAR StoreServ 7200 2-node manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 40 highlights
4. Grant the two users the privilege levels described above by running the commands below: use inservstats grant all on * to cliuser; grant select on * to webuser; exit; 5. Exit the mysql command line by running the following command: exit; Setting Up the Oracle Database (Optional) System Reporter supports the use of MySQL® Database Server or Oracle 11g Database Server. To use Oracle, you must set up Oracle, following the instructions provided in this section. To use and install MySQL go to "Installing and Setting Up the Microsoft SQL Server Database (Optional)" (page 32). Oracle is optional third-party software and is not provided by HP. Installing the Oracle database server is beyond the scope of this guide. We assume that you already have an Oracle database server. In this section we describe how to create a database and users on that server for the System Reporter and how to set up a connection to the database from the System Reporter. NOTE: To ensure that all environment variables are properly updated, install Oracle prior to installing the Apache Web Server. If Apache is already installed, be sure to restart it after the Oracle client is installed. Creating an Oracle database On the Oracle database server: 1. Start the Oracle Database Configuration Assistant. 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. 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 48). • 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 115)). • 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 42)), the installer creates two Apache HTTP Server config.tcl files to store the 40 Installation, Configuration, Update, and Removal