Oracle Parallel Server Getting Started
Release 8.0.4 for Windows NT

A55925-01

Library

Product

Contents

Index

Prev Next

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

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 or Windows 95 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 95 or Windows NT 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. 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.
 

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 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 or Oracle Net8 Easy Config to create a TNSNAMES.ORA file for each node. Each instance must have a service name defined for it, which is used in defining the database links for the instances. Also, edit the LISTENER.ORA file accordingly if you use the Net8 Easy Config.  

"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:  

 

  • OPS_DBL.SQL script must exist in order to recognize the parallel server instances. This script can be generated with OPSCONF or created manually.
 

"Using OPSCONF" in Chapter 5, "Configuring Oracle Parallel Server", and "Step 3: Configure Oracle Performance Manager" in this chapter  

  • Run the OPS_MON.SQL script.
 

"Step 3: Configure Oracle Performance Manager" in this chapter  

The requirements for the Oracle Enterprise Manager Console are:

Oracle Enterprise Manager Console Requirements   For additional information, see:  

Install your Enterprise Manager 1.5 software (with or without Oracle Enterprise Manager Performance Pack 1.5 option) on a Windows NT or Windows 95 computer. The Enterprise Manager Console is part of this installation.

Oracle Enterprise Manager Performance Pack, which contains the Oracle Performance Manager application, is sold separately.  

"Step 1: Install Oracle Enterprise Manager" in this chapter.  

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" in this chapter. and "Step 2d: Create Configuration Files" in this chapter  

Configure and connect to the repository database, including performing auto-discovery of your nodes.  

"Step 2: Configure Oracle Enterprise Manager" in this chapter.  

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. Both environments are illustrated below:

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 or Windows 95 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 or Windows 95 machine.

Installing Oracle Enterprise Manager includes:

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 95 or Windows NT 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 Installation for Windows NT 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 or Windows 95 client which connects to the Oracle8 repository database.

To install the Oracle Enterprise Manager:

  1. Install Oracle Enterprise Manager and 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 Installation for Windows NT CD-ROM insert for complete installation instructions.

     

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

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 Discover Services  

No  

Yes  

Yes, perform this task on the machine on the Repository machine.  


Note:

These instructions assume Oracle Enterprise Manager is already installed on a Windows NT or Windows 95 console workstation. See the Oracle8 Enterprise Edition Installation for Windows NT CD-ROM insert to install Oracle Enterprise Manager.

 

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.

  1. 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.

  2. 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" in Chapter 6, "Installing and Configuring Oracle Parallel Server Manager", 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 are automatically generated when the Intelligent Agent is started. These files contains the listening address of the agent, the names of Net8 listener and Oracle database services it knows about, plus tracing 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. Because of this, Oracle Corporation recommends that you create a new user account so that the repository can be created in its own tablespace. It is also recommended that you create a new tablespace and the newly-created user be customized to use this 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
    

  1. 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 place.

  2. 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;
    

  3. Grant SYSTEM privileges to this user account:

    SVRMGR> GRANT DBA TO USERNAME IDENTIFIED BY PASSWORD;
    

  4. When done, enter:

    SVRMGR> EXIT
    

    Exiting Server Manager closes the database connection.

  5. 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 Oracle8 Enterprise Edition server.

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:

  1. Choose New User from the User menu.

    The New User dialog box appears:

  2. 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 and choose <- 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.

  3. Click OK in the New User dialog box.

    The user is added and the User Manager window re-appears.

  4. Select the newly-created user and choose User Rights from the Policies menu.

    The User Rights Policy dialog box appears:

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

  6. 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 and click Add.

    4. Click OK.

      Users appears in the Grant To list box.

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

    The User Manager window re-appears.

  8. Choose Exit from the User menu.

  9. 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 95 or Windows NT 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 Net8 Assistant to configure your network.

Step 2e: Create the Repository and Discover Services

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 Login Information dialog box appears:

  1. Enter the following appropriate information and choose 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:

  2. Click OK.

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

  3. Click Continue to dismiss this dialog box.

    The Discover New Services Wizard appears:

  4. Use the wizard to discover services.

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

  5. 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.

 

Configuring the Oracle Performance Manager involves running the OPS_MON.SQL script located in ORACLE_HOME\OPS to run the following SQL scripts:

Script   Description  

OPS_PACK.SQL  

Contains a set of PL/SQL procedures that are executed by Oracle Performance Manager to aggregate results from all instances of the parallel server.  

OPS_CTAB.SQL  

Contains a set of tables used to store the aggregated results.  

OPS_DBL.SQL1  

Contains database links for each instance of the parallel server.  

1 OPS_DBL.SQL is not generated until the OPSCONF utility is run.

To configure Oracle Performance Manager:

  1. Check to see if ORACLE_HOME\OPS\OPS_DBL.SQL exists on the node where OPSCONF was run (if at all).

    If it does not exist, go to Step 2. If it does exist, go to Step 3.

  1. Create the OPS_DBL.SQL script by following the format below:

    The format of ORACLE_HOME\OPS\OPS_DBL.SQL script file is as follows for each instance's entry:

    • drop public database link;
    • create public database link DB_NAME@NODE_NAME_SID using 'SERVICE_NAME', where:

      DB_NAME  

      database name from V$DATABASE  

      NODE_NAME  

      host name of the node on which the instance runs  

      SID  

      instance name  

      SERVICE_NAME  

      Net8 service name for the instance  

    Below is an example OPS_DBL.SQL script for a database named "OPS" with four instances:

    • ops1 running on node opshost13
    • ops2 running on node opshost14
    • ops3 running on node opshost15
    • ops4 running on node opshost16
        drop public database link ops@opshost13_ops1
        /
        create public database link ops@opshost13_ops1 using 'ops1'
        /
        drop public database link ops@opshost14_ops2
        /
        create public database link ops@opshost14_ops2 using 'ops2'
        /
        drop public database link ops@opshost15_ops3
        /
        create public database link ops@opshost15_ops3 using 'ops3'
        /
        drop public database link ops@opshost16_ops4
        /
        create public database link ops@opshost16_ops4 using 'ops4'
        /
      

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

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

    OPS_MON.SQL executes the following scripts:

    • OPS_PACK.SQL
    • OPS_CTAB.SQL
    • OPS_DBL.SQL

  3. Ensure the database links have been created using the proper database names:

    SELECT NAME FROM V$DATABASE;
    

    If you configured the Oracle Parallel Server with the default scripts, OPS (the default name of the database) is returned to the screen.

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

    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.

     

    Once the scripts have been executed, 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


Note:

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

 

To start Oracle Performance Manager:

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

    The Login Information dialog box appears:

  1. Enter the following information and choose 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

  2. Select a database instance in the Oracle Enterprise Manager Console Navigator tree with which a connection will be established.

  3. Start the Oracle Performance Manager by:

    • Clicking on the Oracle Performance Manager application icon from the Performance Pack launch palette.
    • Selecting Performance Pack, and then Oracle Performance Manager from the Tools menu.

    The Oracle Performance Manager window appears:

  4. From the Display menu, choose Parallel Server > option to access the charts.


    ATTENTION:

    If only one instance of the Oracle Parallel Server is running, parallel server options will not be available. At lease two instances of the Oracle Parallel Server must be running in order to use the Oracle Performance Manager's options.

     




Prev

Next
Oracle
Copyright © 1997 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index