HP 3PAR StoreServ 7400 2-node HP 3PAR System Reporter 3.1.0 Software User& - Page 41
Creating the Oracle Net Service, Modifying the Apache HTTP, Server Configuration Files
View all HP 3PAR StoreServ 7400 2-node manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 41 highlights
user names and passwords for the cliuser and the webuser. See "Modifying the Apache HTTP Server Configuration Files" (page 125) 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 40), 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 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 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 3.1 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. 2. Start the Net Configuration Assistant. 3. Select the Local Net Service Name Configuration radio button and click Next. 4. Select the Add radio button and click Next. 5. Enter the service name for the database according to the directions and click Next. 6. Select TCP protocol and click Next. 7. Enter the host name for the database server along with the appropriate port number and click Next. 8. Select Yes, perform a test and click Next. The test may fail if the default user and password are not set. Click the Change Login button and enter cliuser and password and click OK. The test should succeed. Click Next. 9. Enter a net service name. This is the name you will need to enter when installing the System Reporter tools. Click Next. 10. Follow instructions to complete the net service configuration and exit the program. Installing the Database Server 41