Oracle Enterprise Manager Administrator's Guide Release 2.2 Part Number A85248-01 |
Library | Service | Contents | Index

# 1
Console

This chapter introduces the Oracle Enterprise Manager Console and provides an overview of its components. The following topics are included in this chapter:

- Enterprise Manager Console

- Console Menus

- Managing Enterprise Manager Administrators

- Configuring and Starting the Paging Service

- Creating Enterprise Manager Reports

## Enterprise Manager Console

The Console is the primary interface used for all Oracle Enterprise Manager operations. It provides menus, toolbars, and the framework to access Oracle tools and utilities available through other vendors. The graphical configuration of the Console and the tools available are determined by the optional products installed and user preferences. See Figure 1-1, "Console Window" for an illustration of a Console screen.

### Components

The Console includes viewing panes for the Navigator, Group, Jobs, and Events systems.

#### Navigator

The Navigator displays a hierarchical list of all the services in a network, providing a direct view of services such as databases, groups, listeners, and nodes, plus the objects that they contain. The Navigator shows all the network services with their relationships to other objects.

Through the Navigator, you can also launch administration tools for managing objects such as database users and tablespaces. You can also perform many administration tasks in the Navigator, such as creating, editing, or dropping tablespaces. See Chapter 2, "Navigator" for information.

#### Group

The Group system allows you to organize managed services into logical groups that you can then manage collectively with a graphical display. With the Group system, you can create, save, modify, and view groups. To create a group of services, drag and drop objects from the Navigator into the Group view. See Chapter 3, "Groups" for information.

#### Jobs

Jobs are standard tasks, such as executing a SQL script or backing up a database, that can be automated through Oracle Enterprise Manager. The Job system allows you to manage and schedule jobs and remote operations for the services of your network. Jobs can be scheduled at various times, such as daily or weekly, and at single or multiple destinations. See Chapter 4, "Jobs" for more information.

#### Events

The Event system allows you to monitor and display the status of events--such as a loss of service--occurring on the managed services in your network system. See Chapter 5, "Events" for more information.

#### Figure 1-1 Console Window

Text description of the illustration console2.gif

## Console Menus

The Console menu bar provides access to the following menus:

#### Figure 1-2 Console Menu Bar

Text description of the illustration menu.gif

The File, View, System, Tools, and Help menus are described in this section.

- See "Navigator Menu" on page 2-5 for information about the Navigator menu.

- See "Group Menu" on page 3-3 for information about the Group menu.

- See "Job Menu" on page 4-10 for information about the Job menu.

- See "Event Menu" on page 5-24 for information about the Event menu.

When using the Console menus, note that:

- Some menus include other menus. For example, when you select the Database Applications from the Tools menu, a sub-menu containing several options displays.

- Menu options vary depending on the objects selected or the active window in the Console. The Tools menu items vary depending on the components that have been installed.

### Context-Sensitive Menus

You can click the right mouse button on objects in some windows of the Console to display a context-sensitive, or short-cut, menu. This menu usually contains a subset of the options that are available through a menu in the main menu bar. For example, if you click the right mouse button on a group in the Navigator pane, a menu appears with the menu options from the Group menu.

Note: See "Discovering Services" on page 2-7 for information on context-sensitive menu options in the Navigator.

### File Menu

The File menu items allow you to exit the system.

### View Menu

The View menu customizes the Console layout, allowing you to show or hide toolbars or windows. You can also use the window palette located in the upper-left corner of the Console to access the View menu options. At least one window must be visible in the Console.

Show/Hide Navigator Pane

Hides or shows the Navigator pane.

Show/Hide Job Pane

Hides or shows the Job Scheduling pane.

Show/Hide Event Pane

Hides or shows the Event Management pane.

Show/Hide Group Pane

Hides or shows the Group pane.

Show/Hide Toolbar

Hides or shows the Oracle Enterprise Manager toolbar.

### System Menu

The System menu provides options to set up administrator and system configurations.

Preferences...

Displays the Edit Administrator Preferences property sheet, which allows the current administrator to change preferences, including permissions and login credentials. See "Administrator Preferences" on page 1-11 for more information.

Manage Administrators

Displays the Administrator Manager Accounts property sheet for adding, modifying, and removing administrators. This option is only available to Super Administrators. See "Managing Enterprise Manager Administrators" on page 1-8 for more information.

Configure SMTP Gateway

The System menu contains the Configure SMTP Gateway option. Use the Configure SMTP Gateway option to specify the SMTP gateway that is used for the SMTP E-mail system. E-mail notification will not function correctly until the SMTP gateway is set properly. This menu option is only available to super administrators.

Add Services to tnsnames.ora

Updates the local network configuration file (tnsnames.ora) with discovered services information. You should run this after a Discovery operation so that any Value-Added Applications, such as Oracle Parallel Server Manager or Replication Manager, can access the discovered services.

Font Settings

Changes the font settings for the Console and DBA Studio.

Font settings in pop-up menus will not change even if you have specified to change the font settings.

Generate Enterprise Report

Allows you to create an HTML-based Enterprise Report containing information such as event alerts, scheduled jobs, groups, and discovered services for all managed nodes in your enterprise. For more information, see "Creating Enterprise Manager Reports" on page 1-35.

### Tools Menu

The Tools menu allows you to execute database applications and other utilities that have been installed on your system. The menu options in the Tools menu depend on your installed Oracle Enterprise Manager configuration.

#### Database Applications

This menu option lists the database administration functions that you can execute from the Console. Examples include schema, instance, and security management.

#### Service Management

This menu option lists integrated applications such as the Oracle Application Server Manager.

Other optional applications may also be available from this menu.

### Help Menu

From the Help menu, you can access the Enterprise Manager online help system. You can also access Enterprise Manager's Quick Tours. Enterprise Manager comes with a variety of Quick Tours, each providing a comprehensive overview for Enterprise Manager and specific integrated applications. Enterprise Manager version information is also available.

## Managing Enterprise Manager Administrators

Enterprise Manager, Release 2.2 is a multi-administrator system: every person who is administering systems using Enterprise Manager has his or her own administrator account which he or she uses to log into the Console or stand-alone application.

The installation of Enterprise Manager creates a single super administrator named sysman. The super administrator `sysman` creates administrators using the Manage Administrators item in the System menu. In addition to an administrator name and password, each account can be tagged as a "Super Administrator" account or an account to which the administrator has access to only jobs and/or events. Differences between the two types of accounts are as follows:

- Super Administrators automatically have full privileges for all objects in the system. Most Super Administrators also have a separate account for daily operations but use their Super Administrator account for special operations only available to Super Administrators, such as starting and stopping the Management Server, creating new Enterprise Manager Administrators, configuring paging servers, or checking other administrator's schedules. Using the `sysman` account for daily administration work is not recommended. The Super Administrator account is similar to root on UNIX or Administrator on Windows NT and is a user which cannot be deleted or renamed. It is a user that can perform any task and therefore should be used only for setting up the environment. After the necessary DBA accounts are created, the Super Administrator account ' SYSMAN' should not be used anymore.

- Regular Administrators can have full access to all other Console operations but they will only see or be able to modify those jobs, events, or groups to which they have access.

Typically, all administrators share a single Enterprise Manager, Release 2.2 repository, which allows administrators to share information. Although you can set up multiple repositories, administrators using different repositories will not have access to each other's information; there is no sharing of data between repositories. Administrative data stored in the repository is filtered based on administrator permissions.

Preferred Credentials must be set up for each administrator account. When an administrator connects through the Navigator or stand-alone application, the preferred credentials used are those defined explicitly for that administrator.

### Managing Administrator Accounts

Enterprise Manager administrators are created, edited, and deleted with the Manage Administrators option of the Console System menu. The Manage Administrators option displays the Manage Administrator Accounts dialog (Figure 1-3, "Manage Administrator Accounts"). The Manage Administrators option is only available to Super Administrators. Super Administrators have full privileges for all objects and can create, edit, and delete other administrators. The Super Administrator sets up the administrator name and initial password and determines whether an administrator is a Super Administrator or regular administrator. The Super Administrator also determines whether the administrator has access to the job and event systems.

In this dialog, you can:

- Click the Add button in the Manage Administrator Accounts dialog to display the Create Administrator Account dialog. The Administrator Account dialog allows you to add a new administrator. See "Creating or Editing an Administrator Account" below for more information.

- Select the Delete button to delete an administrator. If the administrator is the owner of any objects, you need to reassign object ownership otherwise the objects are deleted with the administrator. See "Reassigning Object Ownership" on page 1-11 for more information.

#### Figure 1-3 Manage Administrator Accounts

Text description of the illustration addadmin.gif

### Creating or Editing an Administrator Account

In the Manage Administrators dialog, enter a unique administrator name and password for the Enterprise Manager administrator. Note that the administrator name is not the same as a database username.

#### Figure 1-4 Create Administrator Account

Text description of the illustration ctreadmn.gif

Check the access available to the administrator:

Super Administrator

Allows the administrator to add other administrators, as well as access to all created objects, e.g., jobs, events, and groups.

Access to Job System

Allows the administrator access to the Job system, but does not automatically give access privileges for specific jobs.

Access to Event System

Allows the administrator access to the Event system.

After an administrator has been created, the administrator can log in to the Enterprise Manager Console and set up administrator preferences.

If you select the Edit button, you will get the Preferences window, as described in "Administrator Preferences" on page 1-11. You can then edit the preferences for the selected administrator.

### Reassigning Object Ownership

If you delete an administrator who owns any object, the Object Ownership Management dialog appears. See Figure 1-5, "Object Ownership Management". The dialog allows you to reassign the objects to another Enterprise Manager administrator. If you do not reassign the objects, the objects are deleted.

#### Figure 1-5 Object Ownership Management

Text description of the illustration objowner.gif

### Administrator Preferences

The Edit Administrator Preferences property sheet is displayed with the Preferences option of the System menu. This property sheet allows you to configure the preferences for an Enterprise Manager administrator. The pages in the property sheet are:

- General

- Notification

- Schedule

- Permissions

- Preferred Credentials

### General

The General Preferences page allows a Super Administrator to change an administrator's password and access privileges.

#### Figure 1-6 Administrator General Preferences

Text description of the illustration genprefs.gif

### Notification

The Notification page allows you to set up paging and email notification methods for the administrator. This page consists of a hierarchical tree list and a right-side modal area that changes according to the object selected in the navigator. The tree list consists of four top-level objects:

- Filters (Selected by default)

- Email

- Paging

- Paging Servers

Note: If you plan to use the Enterprise Manager Paging Server for notification, you need to configure the paging and modem settings for your system before you set up administrators. To configure the modem for the system, access the Modems option in the Control Panel. Before using mail, specify the SMTP Gateway for Email with the Configure SMTP Gateway option of the Console System menu.

#### Figure 1-7 Administrator Notification Preferences

Text description of the illustration notipref.gif

#### Filters

Notification filters allow each administrator to specify when to send an email notification as opposed to a page notification as a result of a job or event status change.

- Event Notification Filter: The Event Notification Filter allows you to filter email/pages sent to an administrator according to the event's level of severity. Filtering is set at the user level by checking or unchecking the Email/Page options on this property sheet page. You can select any combination of the following levels of event severity. For example, you can set filtering so that an administrator is notified via email if there is a warning and notified via the paging system if there is an alert. Selecting all levels of severity provides no filtering.

  - Alert

  - Warning

  - Clear

  - Node Down

  - Reassign

##### Job Notification Filter

The Job Notification Filter allows you to filter email/pages sent to an administrator according to job status. As with the Event Notification Filter, filtering is set at the user level by checking or unchecking the desired option. Selecting all job statuses provides no filtering.

- Start

- Complete

- Fail

- Delete (Job removed)

#### Email

This page allows you to specify notification parameters for email.

#### Figure 1-8 Administrator Notification Preferences: Email

Text description of the illustration notemail.gif

- Receiver's Email: Enter the email address of the administrator to whom the mail is being sent.

- Subject Prefix: Enter an optional prefix that is appended to the E-mail subject. That allows administrators to quickly identify messages from Enterprise Manager in their mail.

- Limit message length: Allows you to specify the maximum message body length of an E-mail notification. By default, this length is unlimited.

- Current Definition: Displays the current settings for format and content of E-mail notifications. To set or change the default parameters, expand the Email object in the tree list. You can select format and content options for the Subject line and Message Body. You can further expand the Message Body object to specify options at the Per Event Test level.

- Test: Click the Test button to check the validity of E-mail configuration. A message displays to inform you of the status of the test email.

##### Email Subject

This page allows you to select the content and format of the email subject line. By default, Type, Name, and Status are selected. You use the left/right arrows to move items back and forth between the Available and Selected lists.

Once an item has been selected, you can control the order in which the item appears by selecting it in the list and using the up/down arrows (located to the immediate right of the Selected list) to reposition the item within the list.

Note: The following information also applies to inserting content into the Email/Paging message body.

- Available: Lists available content.

- Selected: Lists currently selected content and the order in which the content should be displayed.

- Use Abbreviated Format: For Type (Job or Event), Status, and Target Type, you can select the Use Abbreviated Format option. When selected abbreviations are used in the Subject line. The following abbreviations are used by the system:

Service Type

- DB for Database

- LSR for Listener

- N for Node

Status

- ST for Started

- CO for Completed

- F for Failed

- D for Deleted

- W for Warning

- A for Alert

- C for Cleared

- NU for Node Unreachable

- R for Reassign

Timestamp Format

This option is available if Timestamp is chosen from the Selected list. You use the pull-down menu to select one of the pre-defined formats.

Do not include titles

When selected, classification titles such as Status, Service Name, and Timestamp are omitted from the message.

#### Paging

This page allows you to specify notification parameters for paging.

#### Figure 1-9 Administrator Notification Preferences: Paging

Text description of the illustration notpage.gif

- Carrier: After a paging server is specified by a super administrator and the name of the paging carrier service and the corresponding paging carriers have been configured, select the name of the paging carrier service from the pull-down list.

- PIN: Enter the PIN for your paging carrier. This entry is only required for alphanumeric pagers.

- Limit message length: Allows you to specify the maximum message length of paging notifications. By default, this length is set to 256 characters.

- Current Definition: Displays the current settings for format and content of paging notifications. To set or change these parameters, expand the Paging object in the tree list. You can select format and content options for the Message Body. You can further expand the Message Body object to specify options at the Per Event Test level.

- Test: Click the Test button to check the validity of the paging configuration. For alphanumeric pagers, enter the PIN number. For numeric pagers 700, is sent.

  Click on the Send button to send a test page to the specified pager. A message informs you of the status of the test page.

  If the test fails, check the log file. If tracing is enabled for paging, you can also view the paging trace log file in the ORACLE_HOME\sysman\log directory on the machine which has the paging server.

#### Paging Status Codes for Numeric Pages

Numeric pages need to be interpreted as follows:

For job notifications, you will receive a 3 digit number which indicates the job status.

For event notifications you will receive the status code.

The event status and job status codes are listed as follows:

100 = Job Started

200 = Job Completed

300 = Job Failed

400 = Job Deleted

500 = Event Cleared

600 = Event Warning

700 = Event Alert

800 = Event Node Down

900 = Event Unknown

1000 = Event Assignee Changed

#### Email/Paging Message Body Definition

This page allows you to select the content and format for the body of the email or page message. By default, Name, and Status are selected. You use the left/right arrows to move items back and forth between the Available and Selected lists.

#### Figure 1-10 Administrator Notification Preferences: Email/Paging Body

Text description of the illustration empgbody.gif

Expanding the Message Body object in the navigator and selecting per Test allows you to use a subset of the following option settings on a per test basis. See "Email Subject" on page 1-16 for more information on manipulating message content.

- Available: Lists available content.

- Selected: Lists currently selected content.

- Use Abbreviated Format: For Type (Job or Event), Status, and Service Type, you can select the Use Abbreviated Format option. When selected abbreviations are used in the Subject line. The following abbreviations are used by the system:

Service Type

- DB for Database

- LSR for Listener

- N for Node

Status

- ST for Started

- CO for Completed

- F for Failed

- D for Deleted

- W for Warning

- A for Alert

- C for Cleared

- NU for Node Unreachable

- R for Reassign

Timestamp Format

This option is available if Timestamp is chosen from the Selected list. You use the pull-down menu to select one of the pre-defined formats.

Do not include titles

When selected, classification titles such as Status, Service Name, and Timestamp are omitted from the message.

Append job output

When selected job output is appended to the end of the notification. For instances where job output is large, you may want to specify a limit to the message length. If the job output pushes the notification length past the specified limit, then the job output will be truncated, not the message itself.

#### Paging Server

This page lists all available paging servers currently recognized by Enterprise Manager.

#### Figure 1-11 Administrator Notification Preferences: Paging Server

Text description of the illustration pageserv.gif

The multi-column list consists of two columns: The name of the paging server and whether the paging server is currently being used. Below the list are three icons that allow you to perform the following operations:

- Ping a paging server to see if it can be contacted.

- Add a new paging server to the list.

- Remove a server from the list.

Except for the Add Paging Server icon, the icons are grayed out unless a specific paging server is selected from the list. For information on how to add a paging server, see "Setting Up Paging" on page 1-29 and "Adding a Paging Server" on page 1-30.

### Schedule

Use this property sheet page to indicate when you want to be paged and/or e-mailed. Determine the day, hour, and the method of notification. You will receive notifications only on the objects you have permission to access.

#### Figure 1-12 Administrator Notification Schedule

Text description of the illustration schdpref.gif

An administrator can be notified by email, paging, or both email and paging. Paging is recommended for urgent jobs, events, or critical systems.

To determine notifications:

1. Select None, Pager, Email, or Email and Pager at the bottom of the dialog.

2. Click in the appropriate day/hour to set the notification method for that time period.

3. Repeat steps 1 and 2 for each notification method.

If you want to set the same notification an entire day or an hour of the day, click on the heading for that row or column. For example, if you want to set up paging notification for Saturday, click on the Sat heading after you have selected Pager at the bottom of the screen. You can also drag the cursor to "paint" across multiple cells.

### Permissions

Use this property sheet page to determine the default permissions you want to assign to other administrators for the objects you create. This allows other Enterprise Manager administrators to share objects, such as events and jobs, that you have created. If you work on a team, this page lets you assign access privileges to all the members of the team at one time. When an object is created by an administrator, that administrator is the owner and automatically has full permissions. The owner's permissions cannot be modified.

#### Figure 1-13 Administrator Default Permissions

Text description of the illustration defperms.gif

Access-control permissions apply to event, group, and job objects. When these objects are created, the default permissions are assigned to other Enterprise Manager administrators according to the selections in this page. These initial permissions can be overridden with the Permissions page of the object's property sheet.

For more information, see the following sections:

- "Group Permissions Page" on page 3-6

- "Job Permissions Page" on page 4-18

- "Event Permissions Page" on page 5-35

Note: Changing your default permissions does not retroactively change permissions on existing objects.

The levels of permission that you can assign to an Enterprise Manager administrator are:

None

This permission does not allow the administrator to view this object anywhere.

View

This permission allows the administrator to view the object, inspect object properties, view job/event status and outputs, and receive notifications if the object is an event.

Modify

This permission allows the administrator to edit the object's properties except those reserved for Full permission.

Full

This permission allows the administrator to delete the object, modify permissions for other administrators, and change the ownership of the object.

Notify

This permission allows the administrator to receive enhanced notifications on the objects. Notify permission cannot be assigned if the administrator's permission level is set to None.

### Preferred Credentials

The Administrator Preferred Credentials property sheet page displays a list of services in the network, along with the service type and the administrator name for accessing the service. The property sheet page is accessed with the Administrator Preferences option of the System menu. Each row in the list of the property sheet includes:

- Service Name

- Service Type (such as database, listener, or node)

- Credentials (Check mark indicating you have already specified connection information. The check mark is either grey (credential set in a previous session) or green (credential set in the current session).

You can click on a column heading to sort on that column. See Figure 1-14, "Administrator Preferred Credentials"for an illustration of the property sheet.

Note: Individual instances of an Oracle Parallel Server are listed. Oracle recommends that all instances of a Parallel server use the same preferred credentials as the Oracle Parallel Server.

Also, the Intelligent Agent authenticates the user name and password for all jobs and many events that it runs. These credentials are used when you access a network service in the Navigator or Group, and when running jobs and registering events. If you do not set the preferred credentials correctly, jobs and events may fail. See "Job Credentials" on page 4-4 and "Registering Events" on page 5-6 for more information.

Important: Changes to the Preferred Credentials will not be automatically propagated to previously registered jobs and events. In order to update these jobs and events with the new preferred credentials, you must de-register and subsequently re-register the jobs and events.

Oracle recommends that if some services of a particular type require the same credentials, use the <DEFAULT> credentials selection for that service type to have those credentials used by all services of that type.

For example, if Administrator_1 has a username and password of foo/bar on all the databases that he manages, the administrator needs to enter foo/bar as his credentials in the <DEFAULT> database entry. All database administration tasks will use these <DEFAULT> credentials.

Furthermore, if the administrator has just one database which requires different credentials from foo/bar, he can enter different credentials for that database by selecting that specific database.

For NT users, you must set the preferred credentials for the node (where the NT Intelligent Agent resides) to be the same as the user that is set up to "Logon as a batch job."

#### Figure 1-14 Administrator Preferred Credentials

Text description of the illustration prefcred.gif

#### Setting Administrator Credentials

Select any row to update the credential fields for the object identified in the row.

Username

Enter the username. This field is required if a password needs to be entered.

Password

Enter the password associated with the username.

Confirm Password

Confirm the password.

Role (Database only)

Select the role from the pull-down list. You need to login with the SYSDBA or SYSOPER role to start up or shut down a database.

Changes to the credentials are recorded when you move to another line. When you are finished, save all your updates by clicking the OK button at the bottom of the property sheet.

### Saving Logon Information as a Preferred Credential

Another convenient way to specify Preferred Credentials for discovered services is to select the Save as Preferred Credential option when manually connecting to a service from the Console or integrated application. For example, you attempt to access a newly discovered database from the Console Navigator. Enterprise Manager displays the Connect Information dialog so that you can log in to the database. You type in the requisite information and check the Save as Preferred Credential option. Click OK to log on to the database and save the logon information as a Preferred Credential for this service.

### Saving the Contents of a List

Save list allows you to extract information from a multi-column list (such as the Job or Event History panes) and save it in a variety of formats (text, HTML, or Comma-Separated-Values). For example, you can select one or more entries in the Event History pane. By selecting the Report Event History from the Events Menu, you can save the list information (Event, Target, Target Type, Severity, Date/Time, Assigned To, Owner) to an HTML file. The dialog consists of the following elements:

File Name

The name and directory to which you want to save the file information.

Browse

Displays the File Save to dialog. Choose the desire location and file name.

Format

Select HTML (table), Text row, or comma-separated-values (used by spreadsheets or other applications).

View

Active only when HTML is selected as the file format, allows you to view the generated HTML table through the default browser for your system.

Rows

- All (total number) rows - Export all rows in the multi-column list.

- Selected (number of rows selected) rows - Export only selected rows in the multi-column list.

## Configuring and Starting the Paging Service

If you want to be notified via paging in Oracle Enterprise Manager, you must explicitly install the Oracle Enterprise Manager Paging Server. This paging service is not installed as part of the base Oracle Enterprise Manager installation; it is installed through a Custom installation type. Refer to the installation guide provided with the database release for more details.

Note: The Paging Server is only available on Windows NT or Windows 2000, but the ability to configure it is available on both Unix and Windows platforms.

Only one paging service installation is required if you wish to utilize paging for notification purposes within Oracle Enterprise Manager.

The paging service supports either numeric or alphanumeric pagers and utilizes the following paging service protocols (for alphanumeric pagers only).

- TAP (Telocator Alphanumeric Protocol)

- GSM (Global System for Mobile Communications)

- FLEXTD

To use alphanumeric paging, you need a phone number to call for the modem at the paging service provider and the pin number for your pager. Contact your paging service provider for the phone number to call. It is the number for the modem for sending pages.

Your paging provider may also have a feature for sending email to your pager. If you have that feature, you can configure an administrator's preferences for notification to use email, and specify your pager as the email receiver. This method will also work with many providers for sending notification to a cell phone.

Configuration of the paging service is not automatic. Follow the steps below to configure paging.

### Setting Up Paging

On the machine from which you want to run the paging service, follow these instructions:

1. Install a modem.

Note: You must have a modem installed on the Windows NT or Windows 2000 machine that you are running the paging service.

1. Specify modem settings.

   1. Go to Start > Settings > Control Panel > Modems.

   2. Specify how your calls are dialed by clicking Dialing Properties from the Modems Properties page and then setting the following parameters:

      - From what area code you are dialing

      - From what country you are dialing

      - How you access an outside line. If you are not required to dial a number to access an outside line, leave this field blank.

   3. Set the Maximum Speed parameter by clicking Properties from the Modems Properties page. Oracle recommends setting this parameter to 9600K Baud; however, you should find the baud rate setting optimal for your system.

   Note: A baud rate higher than 9600 may result in the loss of data with the paging service carrier. The baud rate of 9600 for your modem is only a recommendation. You must find the baud rate setting which is optimal for your system.

   1. Install the Oracle Enterprise Manager Paging Server. Refer to the installation guide provided with the database release for information.

   2. Start the Paging Service.

      1. Go to Start > Settings > Control Panel > Services.

      2. Select the Oracle<ORACLE_HOME_NAME>PagingService and click Start.

      You can also start the paging service by typing the following at a command prompt

          oemctrl start paging

   ### Adding a Paging Server

   Note: Only Super Administrators can add a paging server; this functionality is not available to regular administrators.

   1. From the Enterprise Manager Console, select Preferences from the System menu. The Edit Administrator preferences property sheet appears. Click the Notification tab to access the Notification page.

   2. From the Notification page, highlight Paging Servers from the tree list.

   3. Right-click Paging Servers to obtain the pop-up menu and choose the Add item or click the Add Server icon on the detail view to the right.

   4. When the Add Paging Server dialog appears, enter the name of the machine on which the paging server runs. For example, pjlee-pc.

   5. Press the OK button.

   If the Console is unable to find the paging server with the given hostname, an error appears, saying "VD-4362: Could not add paging server, as paging server <hostname> could not be reached."

   If the paging server is found, a new paging server object is added under the "Paging Server" object in the tree list. The new paging server will have no paging carrier. You must add at least one paging carrier in order for paging to function.

   ### Adding Paging Carrier

   Note: Only Super Administrators can add a new paging carrier; the functionality is not available to regular administrators.

   1. From the Notification page, highlight Paging Carriers from the tree list.

   2. Right-click Paging Carriers to obtain the pop-up menu and choose the Add Carrier item or click the Add Carrier icon on the detail view to the right.

   3. When the Add New Paging Carrier dialog appears, fill in the fields. Once defined, you can view the paging carriers by expanding the appropriate paging server and carrier objects in the tree list.

      - Name

        Paging carrier name. Field accepts alphanumeric characters and underscores.

      - Type

        Type of paging carrier. Enterprise Manager supports alphanumeric or numeric.

      - Protocol

        TAP, FLEXTD, or GSM. Protocol selection is only available if the carrier type is Alphanumeric.

      - Connection Properties

        - Country Code: The country code used to dial the pager if the call is international.

        - Area Code: Area code used the by country in which the pager is located.

        - Number: Local dialing number of the pager.

        - Suffix: Permits identification of voice messages from a paging carrier and allows the person being paged to choose from several options when using a touch tone phone. For example, commas can be used as pauses. The Suffix field accepts the following characters: integers, commas, pound sign, and the star (asterisk).

   Note: This option is only available if the paging carrier type is set to Numeric.

   - Dialing Properties

     - Timeout (in seconds): Maximum dialing time allowed for a successful page.

     - Delay (in seconds): Time delay before dialing.

   - Press the OK button.

   ### Specifying Paging Notification Preferences

   While the Super Administrator configured the paging server and its carrier(s), all administrators who want page notifications must specify their own notification preferences by following the steps below:

   1. Log on to the Console.

      1. Go to System > Preferences > Notification. Then highlight Paging on the tree list to view Paging Preferences on the detail view to the right.

      2. Select a paging service carrier from the drop down list.

      3. Enter the Pin number for your alphanumeric pager. If you have a numeric pager, leave this field blank.

      4. Test the paging notification by clicking the Test button.

   2. Set your notification schedule. If you neglect to do so, you will not receive page notifications.

      1. Within the Console go to System > Preferences > Schedule

      2. Choose when you want to be notified by paging. If you do not select any days/hours to be notified by paging, you will never receive a page.

      Refer to the Oracle Enterprise Manager Administrator's Guide for instructions on how to set up the notification schedule.

   ### Other Paging Server Operations

   #### Removing a Paging Server

   Note: Only Super Administrators can remove a paging server; the functionality is not available to regular administrators.

   1. From the Notification page, highlight the paging server object you want to remove from the tree list.

   2. Right-click the paging server object to obtain the pop-up menu and choose the Remove item or click the Remove Server icon on the detail view to the right.

      A warning dialog appears, saying "Remove Paging Server <servername>?"

   3. Click "yes". The Console will check if anyone is currently using any carrier from the paging server. If not, all paging carriers will be removed, and the paging server will be removed as well. Otherwise an error dialog appears, saying "The paging server cannot be removed because at least one carrier is being used.

   #### Viewing Information on Paging Server

   Note: Only Super Administrators can view information on a paging server; the functionality is not available to regular administrators.

   From the Notification page, left-click the paging server object.

   The detail view to the right will show information about that paging server such as the paging carrier names, the pager types, the protocol, and whether or not they are in use.

   #### Pinging a Paging Server

   Note: Only Super Administrators can ping a paging server; the functionality is not available to regular administrators.

   To check the status of the paging server, follow the steps below:

   1. From the Notification page, highlight the paging server you want to ping.

   2. Right-click the paging server object to obtain the pop-up menu and choose the Ping item or click the Ping Server icon on the detail view to the right.

   #### Querying Status of the Paging Service

   To check the paging status, right-mouse click the carrier name to access the Ping Paging Service item in the context-sensitive menu.

   #### Stopping the Paging Service

   Stop the paging service from the Windows NT or Windows 2000 Services Control Panel.

   You can also stop paging service by typing

       oemctrl stop paging

   #### Removing a Paging Carrier

   Note: Only Super Administrators can remove a paging carrier; the functionality is not available to regular administrators.

   1. From the Notification page, highlight the paging carrier object you want to remove from the tree list.

   2. Right-click the paging carrier object to obtain the pop-up menu and choose the Remove item or click the Remove Carrier icon on the detail view to the right.

      A message appears, saying "Remove Paging carrier <carrier name>?"

   3. Click "yes." The Console checks if anyone is current using the carrier. If not, it will be removed and the notification tree updated.

   #### Editing a Paging Carrier

   Note: Only Super Administrators can edit a paging carrier; the functionality is not available to regular administrators.

   1. From the Notification page, select the paging carrier object. The paging carrier information appears in the detail view to the right.

   2. Make the changes.

   3. Click the OK button.

      The Console will validate all the carrier information, update the notification tree. All administrators who have selected to use this carrier will automatically inherit the new changes.

      If the validation fails, an error dialog appears stating which entry failed to validate and what type of input is expected. When you click the "OK" button in the error dialog, all the paging carrier's entries are set back to their original values.

   #### Viewing Information about a Paging Carrier

   From the Notification page, select the paging carrier object. The paging carrier information appears in the detail view to the right.

   #### Testing a Paging Carrier

   1. Right-click the paging carrier object and choose the "Test" menu item. A dialog appears, asking for the PIN.

   2. Enter the PIN if your pager is an alphanumeric pager and click "OK" to continue. If it is a numeric pager, leave this field blank.

   ## Creating Enterprise Manager Reports

   The Report Wizard allows you to generate pre-defined reports for all managed targets. The Enterprise Manager Job system is used to schedule and execute the task of generating the actual report. For this reason, the prerequisites for successful Job system operation apply to correct functioning of the Report Wizard: node preferred credentials must be set, network communication between the Management Server and the agent/managed target, the Management Server must be operational.

   IMPORTANT: You must be running an Intelligent Agent version 8.1.7 in order to generate a report. If you are running an earlier version of the Intelligent Agent, you need to apply an Agent update patch. The patch consists of a TAR file containing the necessary images and the HTML templates needed to generate the reports. See the README.agent.reports file located in your ORACLE_HOME/sysman/admin directory for installation instruction. The patch file (agent_reports.tar) is also located in this directory.

   ### Enterprise Report versus Database Configuration/Status Reports

   Oracle Enterprise Manager allows you to generate two types of reports: Enterprise Reports and Database Configuration/Status Reports.

   #### Enterprise Report (General Systems)

   The Enterprise Report provides an overview of the information contained within the Enterprise Manager repository.

   This report covers the includes the following information:

   - The setup and configuration of the environment

     Including the administrators, the discovered agent, the job and event library, and the available Data Gatherer collections.

   - The current state of environment

     This topology overview provides details on the state of all services known in the repository such as outstanding alerts, job information and basic configuration of the service.

     An Enterprise Report cannot be customized.

   #### Database Configuration/Status Report

   A Database Configuration/Status Report may contain schema, instance, storage, and security information, depending on what options you select in the Generate Report dialog. This report can either be generated immediately, locally on the client machine, or it can be scheduled as a job.

   If you schedule a Database Configuration/Status Report, information from the Enterprise Report is included in a single report. If an Enterprise Report has been previously generated, and you then create a Database Configuration Report, database configuration information is added to the existing Enterprise Report.

   ### Requirements

   The following general requirement must be met to generate a report:

   - Enterprise Manager Repository views: All the HTML reports are based on these repository views, which are created on top of the repository, are generated by default by the Enterprise Manager Configuration Assistant starting from Oracle Enterprise Manager Release 2.2.

   - Enterprise Manager Release 2.2 or higher since it will have the ability to schedule the reports as a job

   - Intelligent Agent version 8.1.7 or higher

   ### Launching the Report Wizard

   The Report Wizard can be launched in two ways, each generating a different type of report.

   - By choosing Enterprise Report from the System main menu to create an Enterprise Report (user must have `super administrator' privileges).

   - By choosing Reports from the Navigator main menu and clicking Schedule from the Generate Report dialog to create a Database Configuration or Database Status Report. (available to all administrators).

   Note: Although the Report Wizard is available to all administrators, the Report Wizard's Schedule button is enabled for super administrators only

   #### Creating Enterprise Reports

   To create an Enterprise Report, perform the following steps:

   1. Choose "Report" from the Console Navigator menu to display the Reports Wizard. The wizard allows you to schedule the job for execution. Depending on the size of the Enterprise Manager repository and the need for up-to-date information, you can change the scheduling interval of the reports.

      During the creation of the job, the wizard will ask for two parameters:

      - The node which will generate the reports.

        To minimize network traffic and make the setup easy and convenient, use the Intelligent Agent on the machine with the web server to generate the report. The generated HTML files will therefore be usable by the web server immediately.

      - The output directory where to place the reports.

        The reports are first generated in the $TEMP directory. To avoid partial updates and partially refreshed information, either copy the entire set of HTML files from the TEMP directory to their final destination after successful completion or remove all files if the job cannot complete successfully.

   2. After the job has completed once, add the output directory where the HTML resides to your web server configuration so that it can be recognized as a virtual directory.

   #### Creating DBA Studio Reports

   From DBA studio reports, specific database reports can be scheduled as a job. This job follows the same conventions and has the same requirements as the system reports.

   If there is no job currently scheduled for the system reports, the DBA Studio reports will generate this job and schedule it, together with the job to generate the database report.

   If DBA Studio finds the job for the system reports, it will use the settings of this job (the Intelligent Agent to be used to generate the report, and the output directory) for its job definition.

   The database reports can be scheduled in two ways.

   From the Console
   1. Select a database in the Navigator tree.

   2. Connect to that database.

   3. From the Navigator menu, select "Report."

      From DBA studio (using the Management Server)

   4. Select a database in the Navigator tree.

   5. Connect to that database.

   6. From the Object menu, select "Report" or right-click and select the "Report" item from the context-sensitive menu.

| Copyright © 1996-2000, Oracle Corporation. All Rights Reserved. |
Library | Service | Contents | Index