Creating the oracle net service – HP 3PAR StoreServ 7000 Storage User Manual
Page 41
user names and passwords for the cliuser and the webuser. See
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