Oracle Parallel Server Support for the Oracle Enterprise Manager Console Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index



Go to previous file in sequence Go to next file in sequence

Oracle Parallel Server Support


Oracle Enterprise Manager can display information about the parallel servers on your network. Using the Enterprise Manager console, you can start up, shut down, and monitor the activity of parallel servers. This lets you handle all of the nodes in a parallel server as a single entity. For example, you can use Oracle Enterprise Manager to execute a job across all nodes of a parallel server.

The topics in this chapter are:

For more information on Enterprise Manager, see the Oracle Enterprise Manager Administrator's Guide.

Parallel Server Container in the Navigator Window


Oracle Parallel Servers appear as a separate category in the Navigator window. The parallel server container displays information about the parallel server, such as instances, datafiles, in-doubt transactions, profiles, redo log groups, roles, rollback segments, schema objects, tablespaces, and users. A unique feature of parallel servers is that a parallel server's instances can also contain this same information.

The icon which represents Oracle Parallel Servers in the Oracle Enterprise Manager is shown in Figure 2-1.

Oracle Parallel Server Icon
Figure 2-2 illustrates the tree structure of the Oracle Parallel Server "fin" in the Navigator window and its icon in the Map window.

Oracle Parallel Server in the Oracle Enterprise Manager
The parallel servers and their instances are arranged in a tree structure. When navigating the tree you can:

For more information on the Navigator window and manipulating objects in the window, see Navigator in the Oracle Enterprise Manager Administrator's Guide.

Starting Up Parallel Servers


You can start all instances or only selected instances belonging to a parallel server that are not already up and available. Starting the instances also starts all of the required services such as the listener, the lock manager, and so on.

Follow these steps to start all instances or only selected instances:

  1. In the Navigator window, click the icon of the parallel server whose instances you want to start.

  2. Right mouse click and select Startup. The Startup Page of the Quick Edit property sheet opens.

  3. Click the startup options you want to select.

  4. If you want to start all of the instances, click the Startup button. If you want to start only selected instances, follow these steps:

    1. Mark the Selected Instances Only checkbox.
    2. Click the Selected Instances button to open the Selected Instances dialog box.
    3. Use the <<(Add) and >>(Remove) buttons to select the instances you want to start.
    4. Close the Selected Instances dialog box.
    5. Click the Startup button in the Startup page.
The Results dialog box displays the progress of the startup operation. For more information, see Viewing the Results Dialog Box.

If the instances start successfully, the Parallel Server Startup Successful dialog box opens.

Parallel Server Startup Successful Dialog Box
Click the View Details button to see more information in the Results dialog box about the instances that were started.

If the startup fails, the Parallel Server Startup Failed dialog box opens. Click the OK button to see more information in the Results dialog box about why the start up failed.

Shutting Down Parallel Servers


You can shut down all instances or only selected instances belonging to a parallel server which are currently up and available. Once all of the parallel server's instances are shut down, the parallel server is considered to be shut down. When you shut down a parallel server, Oracle Trace (oratrcd), also shuts down.

Note: Occasionally, a parallel server database will be completely down, but some of its services (such as the database listener or lock manager) will remain running. If you follow the steps below, the services will also be shut down.

Follow these steps to shut down all instances or only selected instances:

  1. In the Navigator window, click the parallel server icon whose instances you want to shut down.

  2. Right mouse click and select Shutdown. The Shutdown Page of the Quick Edit property sheet.

  3. Click the shut down options you want to select.

  4. If you want to shut down all of the instances, click the Shutdown button. If you want to shut down only selected instances, follow these steps:

    1. Mark the Selected Instances Only checkbox.
    2. Click the Select Instances button to open the Select Instances dialog box.
    3. Use the <<(Add) and >>(Remove) buttons to select the instances you want to shut down.
    4. Close the Select Instances dialog box.
    5. Click the Shutdown button on the Shutdown page.
The Results dialog box displays the progress of the shut down operation. For more information, see Viewing the Results Dialog Box.

If the instances shut down successfully, the Parallel Server Shutdown Successful dialog box opens. Click the View Details button to see more information in the Results dialog box about the instances that were shut down.

If the shut down fails, the Parallel Server Shutdown Failed dialog box opens. Click the OK button to see more information in the Results dialog box about why the shut down failed.

Viewing the Results Dialog Box


The Results dialog box displays information about the progress of the instance start up or shut down operation you selected.

Results Dialog Box
The Results dialog box contains these fields:
Field Name
Description
Operation

The Operation combo box lists the time stamp and the name of the parallel server the job is submitted on.

Details

The Details status box displays the status of the operation. The status can be "In progress", "Success", or "Failed".

Results

The Results edit box lists the progress of the of the start up or shut down operation. If you marked the Show Command checkbox on the Startup or Shutdown page, the first line of the Results box displays the command line issued to the opsctl utility.

In addition to displaying results, you can save or print the results of the operation.

Parallel Server Quick Edit Property Sheet


Use the Quick Edit property sheet to view the status of the parallel servers, or to start up or shut down the instances belonging to a specified parallel server. The Quick Edit property sheet contains these pages:


Status Page

The status page displays banner information about the server release. This page also contains connection information.

Status Page on the Quick Edit Property Sheet

Instances Available Page

The Instances Available page displays information about the parallel server that you highlight in the Navigator window. It displays the names of the instances belonging to the parallel server which are currently up and available.

Instances Available Page on the Quick Edit Property Sheet
The list box displays the following parallel server and instance information:
Column Name
Description
Instance Number

The number of the instance.

Instance Name

The name of the instance and the node it is running on. This name has the format node:instance_name.


Startup Page

Use the Startup page to start all instances or only selected instances that are not already up and available. Starting the instances also starts all of the necessary services such as the listener, the lock manager, and so on.

Startup Page on the Quick Edit Property Sheet
You can choose any of the following start up options:
Option
Description
Force

Shuts down the currently running Oracle instances with SHUTDOWN mode ABORT, before restarting them. If the instances are running and FORCE is not specified, an error results. Use FORCE mode while debugging and under abnormal circumstances. It should not normally be used.

Restrict

Makes the started instances accessible only to users with the RESTRICTED SESSION system privilege. Users already connected are not affected.

No Mount

Does not mount the database upon instance start up.

Mount

Mounts a database but does not open it.

Mount and Open

Mounts and opens the specified database (default).

Configuration File

Enter the fully qualified path to the parallel server configuration file that resides in the managed system. By default, this is the file $ORACLE_HOME/ops/ops_name.conf where ops_name is the name of the parallel server.

Show Command

Mark this checkbox to display the opsctl command line as the first line in the Results field in the Results dialog box.

Selected Instances Only

Mark this checkbox if you want to start only selected instances. The Select Instances button becomes active.

Select Instances

Click the Select Instances button to choose only those instances you want to start.


Shutdown Page

Use the Shutdown page to shut down all instances or only selected instances that are currently up and available. Shutting down the instances also shuts down Oracle Trace (oratrcd).

Shutdown Page on the Quick Edit Property Sheet
You can choose any of the following shut down options:
Option
Description
Normal

Waits for currently connected users to disconnect from the database, prohibits further connects, and closes and dismounts the database. Finally, shuts down the instance. Does not require instance recovery on next start up.

Immediate

Does not wait for current calls to complete, prohibits further connects, and closes and dismounts the database. Finally, shuts down the instance. Does not wait for connected users to disconnect. Does not require instance recovery on next start up. IMMEDIATE is the default option.

Abort

Proceeds with the fastest possible shut down. Does not wait for calls to complete or users to disconnect. Does not close or dismount the database, but does shut down the instance. Requires instance recovery on next start up. You must use this option if a background process terminates abnormally.

Shutdown Database Only

Shuts down the database only. The services required for an instance, such as the listener, the lock manager, and so on, remain up and available. This option defaults to "on".

Show Command

Mark this checkbox to display the opsctl command line as the first line in the Results field in the Results dialog box.

Selected Instances Only

Mark this checkbox if you want to shut down only selected instances. The Select Instances button becomes active.

Select Instances

Click the Select Instances button to choose only those instances you want to shut down.

Creating a Job for a Parallel Server or Parallel Server Instance


You can create a job with a parallel server or a parallel server instance as the destination. To create a new job follow these steps:

  1. Select Create Job from the Job menu to display the Create Job property sheet.

  2. Complete the pages of the Create Job property sheet. For more information, see Parallel Server Create Job Property Sheet.

  3. Determine whether the job is ready to submit.

  4. Click the Submit button to submit the job to the agents at the selected destinations. The job appears in the Active Jobs window.

  5. Click the Save button to save the job. The job appears in the Job Library window. You can modify or submit a saved job at a later time.

Note: There is usually a slight delay between submitting the job and notification by the agent.

To modify or view details about a job, see Creating, Modifying, or Viewing a Job in the Oracle Enterprise Manager Administrator's Guide.


Parallel Server Create Job Property Sheet

Use the Create Job property sheet to specify the details of a new job. The Create Job property sheet contains these pages:


General Page

Use the General page to specify the job name, description, type, and destination.

General Page on the Create Job Property Sheet
The General page contains these parameters:
Parameter
Description
Job Name

Enter the name of the new job.

Description

Enter a description of the job.

Destination Type

Select a destination type from the drop-down list. You can choose parallel server, parallel server instance, database, listener, node, or name server.

Destinations

Click the destinations of the job in the Available Destinations list, then click the << (Add) button to move the destination to the Selected Destinations list. To remove a destination from a job, click the destination in the Selected Destination list, then click the >> (Remove) button.

The destinations are determined by your selection of Destination Type. The destinations include parallel servers, parallel server instances, databases, listeners, nodes, name servers, and groups of these objects.

Fixit Job

Check this box if you want to use this job as the fixit job for an event occurrence. The job cannot be scheduled.


Task Page

Use the Task page to choose the tasks that you want the job to perform. The list of tasks that appear are different depending on whether you select a parallel server or a parallel server instance as your Destination Type in the General page.

Task Page on the Create Job Property Sheet
Move the tasks between the Available and Selected Tasks lists with the <<(Add) and >>(Remove) buttons.
Task List
Description
Available Tasks

Click a task, then click the << (Add) button to include the task in the job. You can add multiple tasks to the job from the Available Tasks scrolling list.

Selected Tasks

The tasks you move into this list will be executed. To remove tasks from this list: click the task, then click the >>(Remove) button.

Tasks for Parallel Server Destinations

If your Destination Type is a parallel server, you can choose from these tasks:
Parallel Server Startup

Parallel Server Shutdown

For a description of these tasks and the parameters you need to supply, see the sections Parameters for the Parallel Server Startup Task and Parameters for the Parallel Server Shutdown Task under Parameters Page.

Tasks for Parallel Server Instance Destinations

If your Destination Type is a parallel server instance, you can choose from these tasks:
Backup Tablespace

Broadcast Message

Export

Import

Loader

Run DBA Script

Run OS Command

Run SQL *Plus

Run TCL

Shutdown Database

Startup Database

For a description of these tasks and the parameters you will need to supply, see Predefined Job Tasks in the Oracle Enterprise Manager Administrator's Guide.


Parameters Page

Use the Parameters page to specify parameter settings for the job tasks you selected on the Tasks page. The parameters which display will vary according to the job task. Parameters for parallel server startup and shutdown tasks are described below. To find out what parameters you need to supply for parallel server instance tasks, see Predefined Job Tasks in the Oracle Enterprise Manager Administrator's Guide.

Parameters for the Parallel Server Startup Task

When you select the Startup Parallel Server task on the Task page, the following Parameters page opens.

Parameters Page for the Startup Parallel Server Task
Enter the following parameters.
Parameters
Description
Startup

Select the start up modes for the job from the drop-down list.

Configuration File

Enter the fully qualified path to the parallel server configuration file that resides in the managed system. By default, this will be the file $ORACLE_HOME/ops/ops_name.conf where ops_name is the name of the parallel server.

Override Preferred Credentials

You can use the preferred credentials that have been set up for the database, or you can enter a Username and Password. If you check the box to override the credentials, you must enter a Username and Password.

Note: the names of parallel servers appear in the Preferred Credentials window but the instances belonging to parallel servers do not. When you set Preferred Credentials for a parallel server, its instances inherit those settings.

Username

Enter the username for accessing the database.

Password

Enter the password corresponding to the specified username. The password can be a null string.

Connect As

Open the drop-down list and click SYSDBA (default) or SYSOPER.

Restrict Connections

Starts a parallel server in restricted mode. Connections are limited to those users who have been granted the RESTRICTED SESSION system privilege.

Force Startup

Forces the parallel server to start regardless of the operating circumstances.

Parameters for the Parallel Server Shutdown Task

When you select the Shutdown Parallel Server task on the Task page, the following Parameters page opens.

Parameters Page for the Shutdown Parallel Server Task
Enter the following parameters.
Parameter
Description
Mode

Click the Immediate button (default) or the Abort button.

Connect As

Click the SYSDBA button (default) or the SYSOPER button.

Override Preferred Credentials

You can use the preferred credentials that have been set up for the database, or you can enter a Username and Password. If you check the box to override the credentials, you must enter a Username and Password.

Note: the names of parallel servers appear in the Preferred Credentials window but the instances belonging to parallel servers do not. When you set Preferred Credentials for a parallel server, its instances inherit those settings.

Username

Enter the username for accessing the database.

Password

Enter the password corresponding to the specified username. The password can be a null string.

Shutdown Database Only

Shuts down the database only. The services required for an instance, such as the listener, the lock manager, and so on, remain up and available. The option default is "on".


Schedule Page

Use the Schedule page to schedule the time, date, and frequency that you want to execute your job.

Schedule Page on the Create Job Property Sheet
The Schedule page contains these parameters:
Parameter
Description
Execute

Click the frequency that you want the job executed. The choices are:

Start Execution

Choose the first date and time that you want the job executed. This is the starting time for any job scheduled on an interval.

End Execution

Choose the last date and time that you want the job executed. This option does not apply if you chose the Immediately or Once execution options.

Time Zone

Select the time zone from the pull-down list. The choices are:

Related Tools for Parallel Servers and Parallel Server Instances


From the console, you can execute a number of database administration tools and utilities on parallel servers and parallel server instances. Click a parallel server or parallel server instance in the Navigator window, then right mouse click. Select the Related Tools command. A menu opens with the following choices.
Backup Manager

Lock Manager

Performance Manager

Schema Manager

Security Manager

SQL Worksheet

Storage Manager

Tablespace Manager

Instance Manager
(not available for
parallel servers
)

TopSessions
(not available for
parallel servers
)

Select the tool or utility you want to run for the parallel server or parallel server instance.

For more information on database tools and utilities, see the Oracle Enterprise Manager Administrator's Guide and the Oracle Enterprise Manager Performance Monitoring User's Guide.



Go to previous file in sequence Go to  file in sequence
Prev Next
Oracle
Copyright © 1996 Oracle Corporation.
All Rights Reserved.
Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index