2
Oracle Parallel Server Management Operations

Oracle Enterprise Manager and Oracle Parallel Server Management provide an integrated solution for managing your heterogeneous environment, including management of Oracle Parallel Servers on your network.

This chapter discusses the following topics:

Topic	Refer to Page
Using the Enterprise Manager Console	2-2
Displaying Parallel Server Objects in the Navigator Window	2-2
Specifying User Preferences for Parallel Server Nodes and the Parallel Server Database	2-4
Starting Up Oracle Parallel Servers	2-9
Shutting Down Oracle Parallel Servers	2-12
Viewing the Parallel Server Operation Results	2-16
Viewing the Parallel Server Status	2-19
Creating a Job for a Parallel Server or Parallel Server Instance	2-24
Specifying Job Details	2-25
Registering Database Event Sets for Oracle Parallel Server Instances	2-36
Related Tools for Parallel Servers and Parallel Server Instances	2-37

 

Using the Enterprise Manager Console

The Oracle Enterprise Manager Console allows you to perform a variety of management tasks on your parallel servers, distributed systems, and databases. The Enterprise Manager Console provides a central point of control for the Oracle environment through an intuitive graphical user interface (GUI) that provides drag-and-drop system management.

The Enterprise Manager Console enables you to manage a heterogeneous environment as easily as a homogeneous one. You can schedule jobs on multiple nodes simultaneously or monitor groups of services together.

A database or system administrator can thus handle all nodes in a parallel server as a single entity. For example, you can configure Oracle Enterprise Manager to execute a job across all nodes of a parallel server.

Displaying Parallel Server Objects in the Navigator Window

From the Enterprise Manager Console Navigator, you can view and manage both single-instance and multiple instance Oracle Servers. The information available for parallel servers is the same as for single-instance databases.

The Navigator displays all the network objects and their relationships to other objects including a direct view of objects such as user-defined groups, nodes, listeners, servers, databases, and database objects. Refer to the Oracle Parallel Server Management Configuration Guide or your platform-specific installation and configuration guide for information on the requirements for performing automatic discovery of parallel server objects on the Navigator.

From the Navigator window, parallel servers are located in the Databases folder which contains entries for databases. Each entry can be either a single instance database or a parallel server which can be expanded by double-clicking the entry.

Each parallel server folder contains the objects for datafiles, in-doubt transactions, profiles, redo log groups, roles, rollback segments, schema objects, tablespaces, and users. Entries that represent parallel servers also contain a Parallel Server Instances folder which can be expanded to display the instances belonging to the parallel server.
 

Note:  Right-clicking on a Navigator object may display a menu allowing you to drill down to view other related options.

   

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

Figure 2-1 Oracle Parallel Server Icon

 

Figure 2-2 illustrates the tree structure of the Oracle Parallel Server named "opsmz" in the Navigator window.

Figure 2-2 Main Navigator Window

 

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

Specifying User Preferences for Parallel Server Nodes and the Parallel Server Database

 

Important:  There are three requirements that you must perform before you can use the Enterprise Manager Console to start up or shut down a parallel server. These requirements are listed below:

   

You must ensure that all nodes on which the parallel server(s) runs are automatically discovered and displayed in the Enterprise Manager's Navigator window. Refer to the Oracle Parallel Server Management Configuration Guide for UNIX or your platform-specific installation guide for information about performing auto-discovery.

You must first specify a valid operating system username and password credentials for at least one node belonging to each parallel server. Refer to "Setting Node Credentials" below.

You must select the parallel server database credentials and specify a valid database username and password. Refer to "Setting Database Credentials" below.

Setting Node Credentials

Follow these steps to specify a username and password for at least one node belonging to each Oracle Parallel Server on your network:

1. From the Enterprise Manager Console File menu, choose Preferences. The User Preferences dialog box appears which dynamically displays all objects in the network.
2. Scroll down to the line that displays the parallel server node (below Service Type column) you want to start up or shut down. In the following example, the Parallel Server is named "opsmz."

Figure 2-3 User Preferences Dialog Box for Node Credentials

1. Click this line and enter your Username and Password in the appropriate text boxes. Typically, you would enter the username and password of the oracle owner. The Role option appears dimmed and becomes unavailable for nodes.

 

Important:  The Preferred Credentials you set for the selected node are inherited by all other nodes belonging to the same parallel server. Therefore, you are not required to set the credentials for each node belonging to the same parallel server.

   
2. Repeat the above steps for at least one node belonging to each parallel server on your network.

Setting Database Credentials

Follow these steps to specify a username and password for your Oracle Parallel Server database:

1. From the Enterprise Manager Console File menu, choose Preferences. The User Preferences dialog box appears which dynamically displays all objects in the network.

Figure 2-4 User Preferences Dialog Box for Database Credentials

1. Scroll down to the line that displays the parallel server you want to start up or shut down.
2. Click this line and enter your database Username, Password, and Role in the appropriate text boxes.

 

Important:  The SYSDBA role is required for Oracle Parallel Server startup and shutdown.

   

You are now ready to start up your Enterprise Manager Console to manage your Oracle Parallel Server(s).

Node Credentials for Parallel Server Startup and Shutdown

The process of starting up a parallel server from the Startup page on the Quick Edit property sheet works by initiating a startup job on one of the nodes of the parallel server. Enterprise Manager many select any node to run the job. This process is similar for shutting down a parallel server.

When running the job, this process requires the operating system credentials (username and password) for the selected node which you should have already set in the Preferred Credentials dialog box by choosing the File>Preferences menu. Refer to "Setting Node Credentials" above for details.

Typically, all nodes share the same preferred credentials. However, in certain situations, Enterprise Manager may not be able to determine the credentials for a node. For example:

• If you did not specify the preferred credentials for at least one node on each parallel server.
• If you specified ambiguous credentials for different nodes on the same parallel server.

In these situations, the following Parallel Server Node Credentials dialog box is displayed:

Figure 2-5 Parallel Server Node Credentials Dialog Box

 

Enter the valid username and password for the selected node in the appropriate text boxes and click OK to accept these credentials and run the job.

Or, you can click Cancel to dismiss the dialog box and cancel the job.

Starting Up Oracle Parallel Servers

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

Starting up these services has traditionally been a time-consuming and tedious task. This task has now been vastly simplified by the OPSM utilities which allow the DBA to start up the parallel server from the Enterprise Manager Console.

From the Enterprise Manager Console, the DBA can start up all Oracle Parallel Server instances or only selected parallel server instances. The Operation Results Status Details window, which is described on 2-16, displays the progress of the instance start up or shut down operation. In addition, the status of the various instances of the Oracle Parallel Server can be monitored from the Enterprise Manager Console.

Startup Page

The Startup page on the Quick Edit Parallel Server property sheet allows you to start up all instances or only selected instances that are not already up and available. Starting up the instances also starts up all the necessary services such as the listener, group membership services, and so on.

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

1. In the Navigator window, click the appropriate Oracle Parallel Server icon which displays those instances you want to start up.

1. Right-click and select Startup. The Startup page from the Quick Edit property sheet appears as shown below:

Figure 2-6 Startup Page on the Quick Edit Parallel Server Property Sheet

1. Click the Startup Options you want for the selected parallel server. The Startup page on the Quick Edit property sheet contains these options:

Table 2-1 Options on the Startup Page

Option	Description
Force	Shuts down the currently running Oracle instances with the SHUTDOWN mode, ABORT, before restarting them. If the instances are running and FORCE is not specified, an error results.  Warning You should not use the FORCE mode under normal circumstances. Use the FORCE mode only while debugging and under abnormal circumstances.
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 startup.
Mount	Mounts a database but does not open it.
Mount and Open	(default) Mounts and opens the specified database.
Show Command	Select this check box to display the opsctl command line as the first line in the Results field from the Parallel Server Operation Results window.
Selected Instances Only	Select this check box if you want to start only selected instances. The Select Instances button becomes available.
Select Instances	Click the Select Instances button to choose only those instances you want to start.

   

1. If you want to start up all instances, click the Startup button. If you want to start up only selected instances, follow these steps:
1. Select the Selected Instances Only check box.
2. Click the Select Instances button to display the Select Instances To Startup window.
3. Click the << (Add) and >> (Remove) buttons to select the instances you want to start up.
4. Close the Select Instances To Startup window.
5. Click the Startup button from the Startup page.

The Parallel Server Operation Results window displays the progress of the startup operation. For more information, see "Viewing the Parallel Server Operation Results".

If the instances were started successfully, the Parallel Server Started message box appears as shown below.

Figure 2-7 Parallel Server Started Message Box

 

Click the View Details button to display more information in the Operation Results window on Figure 2-9 about the instances that were started.

If the startup fails, the Parallel Server Failed message box appears. Click the View Details button to display more information in the Operation Results window about why the startup failed.

Shutting Down Oracle 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 parallel server instances are shut down, the parallel server is considered to be shut down.
 

Note:  Occasionally, a parallel server database may be completely down, but some of its services such as the database listener or group membership services may remain running.

   

Shutdown Page

The Shutdown page on the Quick Edit Parallel Server property sheet allows you to shut down all instances or only selected instances that are currently up and available. Once all the parallel server instances are shut down, the parallel server is considered shut down.

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

1. In the Navigator window, click the appropriate Oracle Parallel Server icon which displays those instances you want to shut down.

1. Right-click and select Shutdown. The Shutdown page on the Quick Edit property sheet appears as shown below.

Figure 2-8 Shutdown Page on the Quick Edit Parallel Server Property Sheet

1. Click the Shutdown Options you want for the selected parallel server.

The Shutdown Page on the Quick Edit property sheet contains these options:
Table 2-2 Options on the Shutdown Page

Option	Description
Normal	Waits for the currently connected users to disconnect from the database, prohibits further connects, and closes and dismounts the database before shutting down the instance. Instance recovery is not required on next startup.
Immediate	(default) Does not wait for current calls to complete, prohibits further connects, and closes and dismounts the database.The instance is immediately shut down. Connected users are not required to disconnect and instance recovery is not required on next startup.
Abort	Proceeds with the fastest possible shut down. Connected users are not required to disconnect. The database is not closed or dismounted, but the instances are shut down. Instance recovery is required on next startup.  Warning You must use this option if a background process terminates abnormally.
Shutdown Database Only	(default) Shuts down the database only. The services required for an instance, such as the listener and group membership services remain up and available.
Show Command	Select this check box to display the opsctl command line as the first line in the Results field in the Parallel Server Operation Results window.
Selected Instances Only	Select this check box if you want to shut down only selected instances. The Select Instances button becomes available for selection.
Select Instances	Click the Select Instances button to choose only those instances you want to shut down.

   

1. If you want to shut down all instances, click the Shutdown button. If you want to shut down only selected instances, follow these steps:
1. Select the Selected Instances Only check box.
2. Click the Select Instances button to display the Select Instances To Shutdown window.
3. Click the << (Add) or >> (Remove) buttons to select the instances you want to shut down.
4. Close the Select Instances To Shutdown window.
5. Click the Shutdown button on the Shutdown page.

The Operation Results window displays the progress of the shutdown operation. For more information, see "Viewing the Parallel Server Operation Results"on page 2-16.

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

If the shutdown fails, the Parallel Server Shutdown Failed message box appears. Click the View Details button to view more information in the Operation Results window about why the shutdown failed.

Viewing the Parallel Server Operation Results

The Parallel Server Operation Results window displays information about the progress of the instance startup or shutdown operation you selected.

The operation results are presented in two views: Status Details and Output.

Status Details

The Status Details view presents the instance operation status graphically.
 

Caution:  The Status Details page is not supported on certain platforms or if you are running the Console with Oracle Server 8.0.3 or lower. In such cases, this page remains empty (gray background) with the "No status data available" message displayed.

   

Figure 2-9 Operation Results Status Details View

 
Table 2-3 Fields in the Operation Results Status Details View

Field Name	Description
Operation	Lists the date, time stamp, action, and the name of the parallel server on which the job is submitted.
Details	Displays the status of the operation. The status can be In progress, Succeeded, or Failed.
Status Details	Graphically displays the results of the operation. Information presented includes the following: Node, Name, GMS, Instance, Listener (status).

 

Current State of a Component

The following are the possible states that each component may experience:
Table 2-4 Current State of a Component from Status Details View

Icon	State	Description
	Up	The component is running.
	Down	The component is not running.
	Can't determine (gray background)	Enterprise Manager cannot determine the state of the component. This state occurs typically when there is an error contacting the Oracle Parallel Server Daemon (OPSD).
	Component doesn't exist on this node (blank background)	The component was not configured on the node.  Not all components (GMS, listener, instance) are required to exist on every node.

 

Results of an Operation

Results are presented in the Parallel Server Operation Results window shown on page 2-16. The requested operation on the Oracle Parallel Server can have any of the following results:
Table 2-5 Status Icons on the Operation Results Page, Status Details View

Icon	Result	Description
	Operation failed	The requested operation failed.
	Operation succeeded	The requested operation was performed successfully.
	Operation is in progress	The requested operation is currently in progress.
	Don't know	Enterprise Manager was unable to determine the results of the operation.

 

Output View

The Output view displays the commands executed by the parallel server node and any associated error messages in textual format.

Figure 2-10 Operation Results Output View

 
Table 2-6 Fields in the Operation Results Output View

Field Name	Description
Operation	Lists the date, time stamp, action, and the name of the parallel server on which the job is submitted.
Details	Displays the status of the operation. The status can be In progress, Succeeded, or Failed.
Output	Displays the results of the operation in textual format.

 

In addition to displaying the results in both the Status Details and Output views, you can save or print the results of the operation from the Parallel Server Operation Results window as directed below:

• Click Close to cancel the settings and close the Results window.
• Click Save to save the settings in the Operation Results window. A Save As dialog box appears where you can choose the filename and path for the results.
• Click Print to print the settings in the Operation Results window.

Viewing the Parallel Server Status

The following pages from the Quick Edit Parallel Server property sheet allow you to view various status information about your parallel server(s):

• Status Page Displays banner information about the Oracle Server release. This page also contains connection information.
• Instances Available Page Displays the names of the instances which are currently up and available.
• Status Details Page Displays an overall view of the state of the parallel server and related components.

 

Note:  To display all tabs, click the forward and backward arrow buttons displayed at the top-right corner of the tab area.

   

Status Page

The Status page on the Quick Edit Parallel Server property sheet displays banner information about the Oracle Parallel Server release. This page also contains connection information.

Figure 2-11 Status Page on the Quick Edit Parallel Server Property Sheet

 

Instances Available Page

The Instances Available page on the Quick Edit Parallel Server property sheet displays the instances belonging to the parallel server which are currently up and available.

Figure 2-12 Instances Available Page on the Quick Edit Parallel Server Property Sheet

 

The following parallel server and instance information is presented:
Table 2-7 Information on the Instances Available Page

Column Name	Description
Instance Number	The number assigned to the instance.
Instance Name	The name specified for the instance and the node it is running on. This name has the following format: node:instance_name.

 

Status Details Page

The Status Details page on the Quick Edit Parallel Server property sheet allows you to obtain an overall view of the state of the parallel server at any given time. This page displays the status of the various components such as GMS, listeners, and instances for all parallel server nodes.
 

Caution:  The Status Details page is not supported on certain platforms or if you are running the Console with Oracle Server 8.0.3 or lower. In such cases, this page remains empty (gray background) with the "No status data available" message displayed.

   

Figure 2-13 Status Details Page on the Quick Edit Parallel Property Sheet

 

Current State of a Component

The following are the possible states that each component may experience:
Table 2-8 Current State of a Component from the Status Details Page

Icon	State	Description
	Up	The component is running.
	Down	The component is not running.
	Can't determine  (gray background)	Enterprise Manager cannot determine the state of the component. This state occurs typically when there is an error contacting the Oracle Parallel Server Daemon (OPSD).
	Component doesn't exist on this node (blank background)	The component was not configured on the node.  Not all components (GMS, listener, instance) are required to exist on every node.

 

Refresh Button

By clicking the Refresh button, the status view is updated with its current display. All components are dimmed until their status is determined.

Creating a Job for a Parallel Server or Parallel Server Instance

The job scheduling system provides a highly reliable and flexible mechanism for DBAs to schedule and automate repetitive jobs on both the parallel server database and parallel server instances.

The Enterprise Manager Console contains a full-featured scheduling tool which allows DBAs to come up with a customized schedule. This provides DBAs with true "lights out" management capability so that they can focus on other tasks. A rich selection of jobs is provided for parallel servers.

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. On the Job menu, choose Create Job to display the Create Job property sheet.

1. Complete the pages of the Create Job property sheet.
2. When you are satisfied with your job settings, click the Submit button to submit the job to the Intelligent Agent. The job appears in the Active Jobs window.
3. 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 Intelligent Agent.

   

To modify or view details about a job, refer to the Oracle Enterprise Manager Administrator's Guide.

Specifying Job Details

From the Create Job property sheet, you can specify the details of a new job. The Create Job property sheet contains these pages:

• General Page Specify the job name, description, type, and destination.
• Tasks Page Choose the task(s) that you want the job to perform.
• Parameters Page Set the run-time parameters for the tasks. The parameters that appear on this page depend on which task(s) you chose on the Task list box.
• Schedule Page Schedule the time and frequency you want Oracle Enterprise Manager to run the job.

General Page

From the General page, specify the Job Name, Description, Destination Type, and Destinations as show in the following window.

Figure 2-14 General Page on the Create Job Property Sheet

 

The General page contains these options:
Table 2-9 Options on the Create Job General Page

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 box. You can choose from the following options: parallel server, parallel server instance, database, listener, node, or name server.
Available Destinations	The destinations are determined by your selection of the Destination Type. The destinations include parallel servers, parallel server instances, databases, listeners, nodes, name servers, and groups of these objects.  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 Destinations list, then click the >> (Remove) button.  For a parallel server task, a list of parallel servers and parallel server groups appears.  For a parallel server instance, a list of parallel server instances appears.  For a database task, a list of databases and database groups appears.  For an operating system task, a list of nodes and node groups appears.  For a listener task, a list of listener and listener groups appears.
Fixit Job	Select this check box if you want to use this job as the fixit job for an event occurrence. The job cannot be scheduled.

 

Tasks Page

From the Tasks page, choose the task(s) that you want the job to perform. The list of tasks that appear is different depending on whether you select a parallel server or a parallel server instance as your Destination Type from the General page.

Figure 2-15 Tasks Page on the Create Job Property Sheet

 

Move the tasks between the Available Tasks and Selected Tasks lists with the << (Add) and >> (Remove) buttons.
Table 2-10 Options on the Create Job Tasks Page

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 list.
Selected Tasks	The tasks you move into this list are executed. To remove tasks from this list, select 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:
Table 2-11 Tasks for Parallel Server Destination

Task	Description
Backup Tablespace	Backup Tablespace Task
Run DBA Script	Run DBA Script Task
Run SQL *Plus	Run SQL*Plus Task
Shutdown Parallel Server	Shutdown Parallel Server Task
Startup Parallel Server	Startup Parallel Server Task

 

For a description of these tasks and the parameters you need to set, see "Parameters for the Parallel Server Startup Task" and "Parameters for the Parallel Server Shutdown Task".

Tasks for Parallel Server Instance Destinations

If your Destination Type is a parallel server instance, you can choose from these tasks:
Table 2-12 Tasks for Parallel Server Instance Destinations

Task	Description
Backup Tablespace	Backup Tablespace Task
Export	Export Data Task
Import	Import Data Task
Load	Load Data Task
Run DBA Script	Run DBA Script Task
Run SQL *Plus	Run SQL*Plus Task
Shutdown Database	Shutdown Database Task
Startup Database	Startup Database Task
Broadcast Message	Broadcast Message Task
Run OS Command	Run OS Command Task
Run TCL	Run TCL Command Task
Deinstall Products	Remove one or more products
Delete Package	Remove a software package from a host
Distribute Package	Copy a software package from a host to another host
Install Package	Install a software package.
Refresh Hosts	Refresh information about the selected host(s)

 

For a description of these tasks and the parameters you need to set, refer to the Oracle Enterprise Manager Administrator's Guide.

Parameters Page

From the Parameters page, you can specify parameter settings for the job tasks you selected on the Tasks page. The parameters which display 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 set for parallel server instance tasks, refer to the Oracle Enterprise Manager Administrator's Guide.

Parameters for the Parallel Server Startup Task

When you select the Startup Parallel Server task on the Tasks page, the following Parameters page displays.

Figure 2-16 Parameters Page for Startup Parallel Server

 

Complete the parameters on the page and click the Submit button to run the parallel server startup task.

The Parameters page for Startup contains these options:
Table 2-13 Options on the Startup Parameters Page

Parameters	Description
Startup	Select the startup modes for the job from the drop-down list box.
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 select this check box to override the credentials, you must enter a Username and Password.  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	Your Oracle username for the database to which you are connecting.
Password	Your Oracle password for the database to which you are connecting.
Connect As	Pop-up menu containing NORMAL, SYSOPER, and SYSDBA for Oracle8. Only Normal is allowed for Oracle7. For Oracle8, SYSOPER and SYSDBA roles allow you the maximum database administration privileges. You require SYSDBA or SYSOPER privileges to run job tasks such as shutdown or startup on the database. For more information on SYSOPER and SYSDBA roles, refer to the Oracle8 Server Administrator's Guide.  If you try to connect as SYSDBA and do not have SYSDBA privileges, an error message states that an invalid username or password was entered. The error message should state that invalid Login credentials were entered.

 

Parameters for the Parallel Server Shutdown Task

When you select the Shutdown Parallel Server task on the Tasks page, the following Parameters page displays.

Figure 2-17 Parameters Page for Shutdown Task

 

Complete the parameters on the page and click the Submit button to run the parallel server startup task.

The Parameters page for Shutdown contains these options:
Table 2-14 Options on the Shutdown Parameters Page

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 select this check box to override the credentials, you must enter a Username and Password.  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	(default is on) Shuts down the database only. The services required for an instance, such as the listener, group membership services, and so on, remain up and available.

 

Schedule Page

From the Schedule page, schedule the time, date, and frequency at which you want to execute your job.

Figure 2-18 Schedule Page on the Create Job Property Sheet

 

The Schedule page contains these options:
Table 2-15 Options on the Schedule Page

Parameter	Description
Execute	Click the frequency at which you want the job executed. The choices are:  Immediately: Schedules the job as soon as you click the Submit button. The job executes only one time.  Once: Schedules the job only one time at the date and time you specify.  Interval: Schedules a specific number of days between job executions. The interval can be a combination of hours and minutes, or number of days. Click the value you want to change, then click the scroll buttons. You can also enter the new value.  On Day of Week: Schedules the job on one or multiple days (Sunday, Monday, etc.) of the week. Click the days of the week to select the days you want the job scheduled.  On Date of Month: Schedules the job on one or more days (1 - 31) of the month. Click the dates of the month to select the dates you want the job scheduled.
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.  Click the month, day, and year in the Date field, then click the scroll buttons to change the value. You can also enter the new values.  Click the hour, minute, and AM/PM in the Time field, then click the scroll buttons to change the value. You can also enter the new values.
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.  Click the month, day, and year in the Date field, then click the scroll buttons to change the value. You can also type in new values.  Click the hour, minute, and AM/PM in the Time field, then click the scroll buttons to change the value. You can also type in new values.
Time Zone	Select the time zone from the drop-down list box. The choices are:  Agent: The agent schedules the job execution at each destination based on the system time of each agent. Jobs are not necessarily run simultaneously.  Console: The agent schedules the job execution simultaneously on all destinations based on the system time of the console.  GMT: The agent schedules the job execution simultaneously on all destinations based on Greenwich Mean Time.

 

Registering Database Event Sets for Oracle Parallel Server Instances

The Oracle Enterprise Manager's Event Management System allows you to register Database event sets for Oracle Parallel Server instances.

To register Database event sets for OPS instances, complete the following steps:

1. From the Event menu, select Register Event Set. The Register Event Set property sheet appears:

Figure 2-19 Register Event Set Property Sheet

1. On the General page, select Parallel Server Instance from the Service Type list.
2. Select an appropriate event Set Name from the list. This list displays all Database event sets including those pre-defined or created by the user.
3. From the Available Destinations scroll list, select the appropriate Oracle Parallel Server instance and click the << (Add) button. The OPS instance is added to the Selected Destinations list.
4. Configure the Notification page as required.
5. Repeat the above steps for each Parallel Server Instance for which you want to create and register an event set.

For more information about the Event Management System, refer to the Oracle Enterprise Manager Administrator's Guide.

Related Tools for Parallel Servers and Parallel Server Instances

From the Enterprise Manager 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-click. Select the Related Tools command. A menu displays with the following options:

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

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

   

---