6
Installing and Configuring Oracle Parallel Server Manager

This chapter describes how to install and set up Oracle Parallel Server Manager (OPSM). Specific topics discussed are:

• Overview of OPSM

• OPSM Requirements

• Understanding Oracle Enterprise Manager Console Setup

• Step 1: Install Oracle Enterprise Manager

• Step 2: Configure Oracle Enterprise Manager

• Step 3: Configure Oracle Performance Manager

Overview of OPSM

You can control the activity of parallel servers and parallel server instances using the OPSM. OPSM is a comprehensive and integrated system management solution for the Oracle Parallel Server. OPSM allows you to manage multi-instance databases running in heterogeneous environments through an open client-server architecture.

In addition to managing parallel databases, OPSM allows you to schedule jobs, perform event management, monitor performance, and obtain statistics to tune parallel databases.

Oracle Enterprise Manager provides database administrators (DBAs) with a powerful set of tools to manage, monitor, and administer even the most complex network of databases from a single workstation, called the Enterprise Manager Console.

This console requires the following components:

Component	Description
Oracle Enterprise Manager Console	Oracle Enterprise Manager Console works with the Oracle Intelligent Agent (installed on the nodes) to perform database administration from a single console. Oracle Enterprise Manager is installed on a Windows NT, Windows 95 or Windows 98 client.
(Optional) Oracle Performance Manager	The Oracle Enterprise Manager's Oracle Performance Manager allows you to choose from a variety of tabular and graphic performance statistics for parallel servers.
Repository Database	Oracle Enterprise Manager Console uses a repository database to store its information. This repository database is an Oracle8 database installed on the Oracle Enterprise Manager Console if it is a Windows NT machine, or on another Windows NT machine where a Windows NT, Windows 95 or Windows 98 Oracle Enterprise Manager Console can connect. The repository database must be on a separate machine from the nodes.
Oracle Intelligent Agent	The Oracle Intelligent Agent is installed on the nodes with the Oracle Enterprise Edition database. The Oracle Intelligent Agent is responsible for managing and completing tasks requested from Oracle Enterprise Manager Console. Once installed, the Oracle Intelligent Agent: Listens for and responds to job requests initiated by the Oracle Enterprise Manager Console. Schedules job requests (requests can include detecting and correcting abnormal conditions, performing standard database administration procedures, and monitoring events) executes the job request. Note: If you need to re-install the Oracle Intelligent Agent, make sure that the ORACLE_HOME\NET80\AGENT\CONFIG\ NMICONF.LST file that is over-written contains an entry for CONFOPS.TCL. After auto-discovery is performed, the Oracle Intelligent Agent runs the scripts in the NMICONF.LST file. CONFOPS.TCL is required for OPSM.

OPSM uses the OPSCTL utility (installed on each node) to manage instances. This utility is run directly from the command line on a node, or called by the Oracle Enterprise Manager Console. OPSCTL gathers information about all the instances in a cluster from the TNSNAMES.ORA files. When OPSCTL is called by the Oracle Enterprise Manager Console, only one node's Intelligent Agent is used to communicate to OPSCTL. OPSCTL on that node then communicates to the other nodes through Net8.

Figure 6-1, "OPSCTL Architecture" shows how OPSCTL operates between the agent and the nodes.

Figure 6-1 OPSCTL Architecture

OPSM Requirements

The following requirements must be met in order to use OPSM from the Oracle Enterprise Manager Console:

The requirements for each node are:

Node Requirements	For additional information, see:
Ensure Oracle8 Enterprise Edition, Oracle Parallel Server Option, Oracle Parallel Server Manager Server, and Oracle Intelligent Agent are installed on each node in the cluster.	"Step 1: Install Oracle8 Enterprise Edition and Oracle Parallel Server on Nodes" in Chapter 4, "Installing Oracle Parallel Server"
The INIT_COM.ORA and INITSID.ORA initialization files must located in ORACLE_HOME\DATABASE.	"Step 1: Copy Initialization Files" in Chapter 5, "Configuring Oracle Parallel Server"
Use OPSCONF to create a TNSNAMES.ORA file for each node. Each instance must have a service name specified for it, which is used in defining the database links for the instances.	"Step 6: Configure the Network" in Chapter 5, "Configuring Oracle Parallel Server"
The SIDs of the instances in the parallel server must be different.	Chapter 5, "Configuring Oracle Parallel Server"
In order to use the optional Oracle Performance Manager component, run OPS_8MON.SQL script.	"Step 3: Configure Oracle Performance Manager"

The requirements for the Oracle Enterprise Manager Console are:

Oracle Enterprise Manager Console Requirements	For additional information, see:
Install your Enterprise Manager version 1.6 software (with or without Oracle Diagnostics Pack option) on a Windows NT, Windows 95 or Windows 98 computer. Oracle Diagnostics Pack, which contains the Oracle Performance Manager application, is sold separately.	"Step 1: Install Oracle Enterprise Manager".
If the Oracle Enterprise Manager Console is on separate machine than the repository database, ensure that the Net8 Client is installed and properly configured on the Console.	"Step 1: Install Oracle Enterprise Manager". and "Step 2d: Create Configuration Files".
Configure and connect to the repository database, including performing auto-discovery of your nodes.	"Step 2: Configure Oracle Enterprise Manager".
To use the optional Oracle Performance Manager component, specify the user preferences for your Oracle Parallel Server nodes and your Oracle Parallel Server databases.	Chapter 2, "Oracle Parallel Server Management Operations," of the Oracle Parallel Server Management User's Guide.

Understanding Oracle Enterprise Manager Console Setup

Set up your Oracle Enterprise Manager Console environment in either of two ways.

Environment 1: Console and Repository on same machine
	The Console remotely manages the databases for both nodes. The Console is running on a Windows NT machine with an Oracle8 database installed that is only being used as a repository. The Oracle Intelligent Agent does not need to be running. The nodes share an Oracle8 database. The repository is not created in this database, and the Oracle Intelligent Agent is running on both nodes.
Environment 2: Console and repository on separate machines
	The Repository is on a separate Windows NT machine with an Oracle8 database installed that is only being used as a repository. The Oracle Intelligent Agent does not need to be running. The Console remotely manages the databases. The Console is running on a Windows NT, Windows 95 or Windows 98 machine. The nodes run an Oracle8 database. The repository is not created in this database, and the Oracle Intelligent Agent is running on both nodes.

Step 1: Install Oracle Enterprise Manager

You can install Oracle Enterprise Manager on a Windows NT, Windows 95 or Windows 98 machine.

Installing Oracle Enterprise Manager includes:

• Step 1a: Install Repository Database on Windows NT

• Step 1b: Install Oracle Enterprise Manager on Console Workstation.

Step 1a: Install Repository Database on Windows NT

The repository database is an Oracle8 Enterprise Edition database installed on the console if it is a Windows NT machine, or on another Windows NT machine where the Windows NT, Windows 95 or Windows 98 console can connect.

To install the repository database:

Install Oracle8 Enterprise Edition on a Windows NT Server by following the instructions in Oracle8 Enterprise Edition for Windows NT Installation CD-ROM Insert CD-ROM insert.

Step 1b: Install Oracle Enterprise Manager on Console Workstation

Oracle Enterprise Manager version 1.5 is installed on a console workstation, a Windows NT, Windows 95 or Windows 98 client which connects to the Oracle8 repository database. To install the Oracle Enterprise Manager:

1. Install Net8 Client (if you want Oracle Enterprise Manager Console to be on separate machine from the repository database) from the Software Asset Manager window after choosing the Custom Installation option.

   Additional Information: See the Oracle8 Enterprise Edition for Windows NT Installation CD-ROM Insert CD-ROM insert for complete installation instructions.

2. Install Oracle Enterprise Manager.

   Additional Information: See the Oracle8 Enterprise Edition for Windows NT Installation CD-ROM Insert CD-ROM insert for complete installation instructions.

3. Install the Oracle Diagnostics Pack to use the Oracle Performance Manager. Oracle Diagnostics Pack is on another CD from Oracle Enterprise Manager, requiring a separate license.

   Additional Information: See the Oracle Diagnostics Installation CD-ROM insert for complete installation instructions.

Step 2: Configure Oracle Enterprise Manager

This table describes the tasks that must be performed to configure the two Oracle Enterprise Manager Console environments illustrated above. Each task is then described fully below:

Perform This Task...	On All Nodes?	On machine where Oracle Enterprise Manager Console and Repository machine both are?	On Oracle Enterprise Manager Console machine or Repository machine?
Step 2a: Start Oracle Services	Yes	No	No
Step 2b: Create a Repository User Account	No	Yes	Yes, perform this task on the Repository machine.
Step 2c: Create a Windows NT User Account	Yes	No	No
Step 2d: Create Configuration Files	No	No	Yes, perform this task on the Oracle Enterprise Manager Console machine to connect to the Repository machine.
Step 2e: Create the Repository and DiscoverServices	No	Yes	Yes, perform this task on the Repository machine.

Note: These instructions assume Oracle Enterprise Manager is already installed on a console workstation. See the installation CD-ROM insert to install Oracle Enterprise Manager and see "Step 1b: Install Oracle Enterprise Manager on Console Workstation" to install OPSM Client.

Step 2a: Start Oracle Services

Start OracleServiceSID, OracleHOME_NAMETNSListener80, OracleAgent and OraclePGMSService services are running on each node:

To start the Oracle services:

1. From the Control Panel window, double-click Services.

   The Services window appears.

2. Check the status of the services. A blank in Status column indicates that a service is not running.

   If all the services are already running, close the window and go to "Step 2b: Create a Repository User Account". If a service is not running, to Step 3 in this procedure.

3. Start the service(s):

   Note: Prior to starting a OracleServiceSID service, the OraclePGMSService service must be running. If you used the CRTSRV script in "Step 4: Create Services", OraclePGMSService automatically starts when the OracleServiceSID service is started. If you chose to create your services with another method, you can still have OraclePGMSService start up automatically with a OracleServiceSID service by entering the following at the command for each node: C:\> OPSREG80 ADD SID

   • From the MS-DOS command line, enter:

     C:\> NET START SERVICE
     

   • From the Control Panel's Services window, select a service, then choose Start.

   The SNMP_RW.ORA and SNMP_RO.ORA files located in ORANT\NET80\ADMIN are automatically generated when the Intelligent Agent is started. These files contain the listening address of the agent, the names of Net8 listener and Oracle database services it knows about, plus tracing parameters. Do not update these read-only files

   .

   Additonal Information: See Appendix A, "Configuration Files," of the Oracle Enterprise Manager Configuration Guide, for a description of SNMP_RO.ORA and SNMP_RW.ORA parameters.

Step 2b: Create a Repository User Account

You need to have a user account with DBA (database administrator) privileges set up on the Oracle8 repository database. Oracle Enterprise Manager places its repository in the default tablespace of the user account to which you are connected when creating the repository. Oracle Corporation recommends creating a new user account, creating a new tablespace, and the customizing the newly-created user to use the new tablespace as its default tablespace.

To create a repository user account on the Oracle8 repository database:

1. Start Server Manager and connect to the Oracle8 repository database:

   C:\> SVRMGR30
   SVRMGR> CONNECT SYSTEM/MANAGER
   

2. Create a special tablespace for the Oracle Enterprise Manager repository:

   SVRMGR> CREATE TABLESPACE REPOSIT_TABLESPACE DATAFILE 'PATH\DATAFILE' SIZE 
   XM;
   

   where X is the tablespace size in megabytes; 20 MB is a good starting point.

3. Create a user account where the user's default tablespace is the newly-created tablespace:

   SVRMGR> CREATE USER USERNAME IDENTIFIED BY PASSWORD
   2> DEFAULT TABLESPACE REPOSIT_TABLESPACE;
   

4. Grant DBA privileges to this user account:

   SVRMGR> GRANT DBA TO USERNAME IDENTIFIED BY PASSWORD;
   

5. When done, enter:

   SVRMGR> EXIT
   

   Exiting Server Manager closes the database connection.

6. Follow Steps 1-5 for additional repository user accounts.

Step 2c: Create a Windows NT User Account

After a repository user account is created, an NT user account with the same user name as the repository user account must be created on the the individual Oracle Parallel Server nodes. To create a user account on each node of the cluster:

1. Choose Start > Programs > Administrative Tools (Common) > User Manager: The User Manager window appears:

   
   

2. Choose New User from the User menu. The New User dialog box appears:

   
   

3. Enter the appropriate information in the dialog box:
   1. Enter a user name that is the same as the one you entered in section "Step 2b: Create a Repository User Account" in the Username field.

   2. Enter the same password you entered in section Step 2b: Create a Repository User Account in both the Password and Confirm Password fields.

   3. Make sure the User Must Change Password at Next Logon check box is not checked and Password Never Expires check box is checked.

   4. Make the user a member of the Administrator's group by choosing Groups. The Group Memberships dialog box appears:

      
      

   5. Select Administrators from the Not member of list box, then click <- Add. Administrators is added to the Member of list box.

   6. Click OK to close the Group Memberships dialog box and return to the New User dialog box.

4. Click OK in the New User dialog box. The user is added and the User Manager window re-appears.

5. Select the newly-created user, then choose User Rights from the Policies menu. The User Rights Policy dialog box appears:

   
   

6. Click the Show Advanced User Rights check box and select Log on as a batch job from the Right drop-down list box.

7. Select Users from the Grant To list box. If Users does not exist, create it:
   1. Click Add. The Add Users and Groups dialog box appears:

      
      

   2. Select the names of the local host machine from the List Names From drop-down list box.

   3. Select Users from the Names list box, then click Add.

   4. Click OK.

      Users appears in the Grant To list box.

8. Click OK in the User Rights Policy dialog box.

   The User Manager window re-appears.

9. Choose Exit from the User menu.

10. Repeat Steps 1-9 for any other repository user accounts you created.

Step 2d: Create Configuration Files

If Oracle Enterprise Manager is installed on a Windows NT, Windows 95 or Windows 98 client console separate from the machine on which the repository database is installed, you must configure the client machine so it can connect to the Oracle8 repository database. Use the Oracle Net8 Easy Config to configure your network.

Step 2e: Create the Repository and DiscoverServices

Before you can use Oracle Enterprise Manager Console, you need a repository on the console workstation where Oracle Enterprise Manager Console will run. The repository is a set of base tables in a database that contains status and environment information for your managed databases. A separate repository must be created for each user wanting to use Oracle Enterprise Manager Console.

The Oracle Enterprise Manager Console machine must also discover network services, such as databases, listeners, and nodes, to populate the Navigator tree. In addition to discovery, the Oracle Enterprise Manager Console must also be able to manage these services for the Job Scheduling and Event Management systems. This can be achieved with the Discovery Wizard.

When the agent starts up and is explicitly requested by the Oracle Enterprise Manager Console with the Navigator Discovery feature, the agent passes information from the Oracle Enterprise Manager Console to populate the Navigator tree.

To create a repository on the Oracle Enterprise Manager Console machine:

1. Choose Start > Programs > Oracle Enterprise Manager. The Repository Login Information dialog box appears:

   
   

2. Enter the following appropriate information, then click OK:
   1. Repository user name and password you created in "Step 2b: Create a Repository User Account" in Username

   2. Net8 service name (or database alias) of the repository database; only necessary to enter service name if you are connecting from a client console machine connecting to the Oracle8 repository database

   The Oracle Repository Manager window appears, prompting you to build the repository:

   
   
3. Click OK. The repository is built. A dialog box asking if you want a quick tour of Oracle Enterprise Manger appears.

4. Click Continue to dismiss this dialog box. The Discover New Services Wizard appears:

   
   

5. Use the wizard to discover services.

   Services are discovered when you see the dialog box below with a status of Discovered:

   
   
6. Click Close. The Oracle Enterprise Manager Console appears with access to the Oracle Parallel Servers in the Navigator tree:

   
   

   Additional Information: See the Oracle Parallel Server Management User's Guide for further information about managing Oracle Parallel Servers and parallel server instances from Oracle Enterprise Manager Console.

Step 3: Configure Oracle Performance Manager

The Oracle Enterprise Manager's Oracle Performance Manager allows you to choose from a variety of tabular and graphic performance statistics for parallel servers. The statistics represent the aggregate performance for all instances running on a parallel server. The statistics are displayed in individual charts and include information on data block pings, lock activity, file I/O, and session and user information.

Note: The Enterprise Manager Intelligent Agent is not required by the Oracle Performance Manager, as its functions are performed using a database connection to the parallel server.

To configure Oracle Performance Manager:

1. Enter the following at the MS-DOS command line from any node:

   C:\> CD ORACLE_HOME\OPS
   C:\ORACLE_HOME\OPS> SVRMGR30
   SVRMGR> @OPS_8MON.SQL
   

2. Increase the OPEN_LINKS and DISTRIBUTED_TRANSACTAIONS parameters in the INIT_COM.ORA file by the number of instances in the parallel server:

   Parameter	Description
   OPEN_LINKS	Specifies the maximum number of concurrent open connections to remote databases in one session. The default is set to 4.
   DISTRIBUTED_TRANSACTIONS	Specifies the maximum number of distributed transactions in which this database can concurrently participate. The default is set to 16.

   Note: By default these parameters are not stored in the INIT_COM.ORA file. To increase the value of these parameters, you must add them to the INIT_COM.ORA file.

   Oracle Enterprise Manager Oracle Performance Manager can be invoked against any instance of the parallel server. Oracle Performance Manager will execute a PL/SQL procedure on this instance to query for performance data from all instances of the parallel server via database links, aggregating the results into a set of database tables, which are then displayed in graphical form by Oracle Performance Manager.

Accessing Oracle Performance Manager

To start Oracle Performance Manager:

Note: Oracle Performance Manager requires at least two instances in the Oracle Parallel Server be up and running.

1. Choose Start > Programs > Oracle Enterprise Manager > Enterprise Manager.

   The Repository Login Information dialog box appears:

   
   
2. Enter the following information, then click OK:
   • Repository user name

   • Password for the user name

   • Net8 service name of the repository database; only necessary to enter service name if you are connecting from a client console machine connecting to the Oracle8 repository database

3. Start the Oracle Performance Manager by:
   • Clicking on the Oracle Performance Manager application icon from the Diagnostics Pack launch palette.

   • Selecting Diagnostics Pack, and then Oracle Performance Manager from the Tools menu.

   The Oracle Performance Manager application appears.

4. Click on the Databases folder.

5. Double-click on a database instance.

6. Enter a database user name and password when prompted.

   The list of available charts appears.

7. Double-click Parallel Server.

8. Click any of the charts.

   The charts display in the right-hand window.

   Additional Information: See the Oracle Parallel Server Management User's Guide for further information about managing Oracle Parallel Servers and parallel server instances from Oracle Enterprise Manager Console.