Oracle Global Configuration

This topic provides information about configuring the Oracle Database Instance by using Central Monitoring Administration.

On the Add Monitor Types dialog, with the Monitoring Profile set to Oracle Database, and the Monitor Type set to Oracle Global Configuration, provide the following details:

Field
Description
 Instance Monitoring Batch Configuration
Oracle Instance Batch Configuration
Instance Monitoring Batch Configuration
Oracle Instance Batch Information
Instance config unique group nameSpecify the Instance config unique group name.
Instances list

Specify the instances to be configured for monitoring. Instances can be separated by commas only. Input value must not contain any character from the set ':;'

Privileged database account credentials
User Name

Specify the privileged database user name. 

Note

A user with SYSDBA privilege (SYS) is used by the KM to create the monitoring DB user. In case if the user is empty, then the KM will not create the DB user and uses the name that already exists.

Password

Specify the privileged database password.

Note

In PATROL for Oracle 9.7.11.02, if the user password contains special characters, specify the password within the double quotes. Example: “%BMC$”

Confirm PasswordRe-type the privileged database password.
Database monitoring account credentials
User NameSpecify the database monitoring user name.
Password

Specify the database monitoring password.

Note

In PATROL for Oracle 9.7.11.02, if the user password contains special characters, specify the password within the double quotes. Example: “%BMC$”

Confirm PasswordRe-type the database monitoring password.
Always on lineSelect this check-box to show the instancStatus parameter goes into alarm when instance is offline.
MonitoringSelect this check-box to enable monitoring for the instance.
Default tablespaceSpecify the default tablespace for database monitoring user.
Temporary tablespaceSpecify the temporary tablespace for database monitoring user.
ProfileSpecify the user create profile.
CategoriesSpecify the application classes.
Oracle homeSpecify the oracle home for all instances.
Remote host nameSpecify the host name for remote monitoring.
TNS service stringSpecify the TNS service string for remote monitoring.

Note

Remote host name and TNS service string are used only when an instance is running on a remote host (different host) other than the PATROL Agent.

In case of remote monitoring, user have to enter configuration for remote host. See more about Remote Host Configuration

 Remote Host Registration
Remote Host Configuration
Remote Host Registration
Remote Host NameSpecify the remote host name. The host name where instance is running (not agent host) have to be the same as in instance configuration.
Remote Package Location

Specify the directory where the remote package is located. The base location for the user installed the Oracle Remote image, as shown in example: /opt/bmc/Patrol3.

Remote User Profile Path

Specify the profile path of the user. This is an optional location for user profile where environment variables are defined, as shown in example: /home/user/.profile.

Host Credentials
User NameSpecify the SSH connection user name.
PasswordSpecify the SSH connection password.
SSH PortSpecify the SSH port. By default the port number is 22.
Add to ListTo add the configured remote host to the list of remote hosts, click the button.
Modify SelectionTo modify a configured remote host, from the list of remote hosts, click the button.
Remove from ListTo remove a configured remote host, from the list of remote hosts, click the button.
 Global Settings
Oracle Global Failed Jobs Options
Generate detailed events (requires MRL)

Select this check box to generate a detailed event per job.

Note

To support the detailed events report, you must configure an MRL script that only displays events which are still open. For more details, see Configuring an MRL script for a detailed event per job.
Exclude disabled jobsSelect this check box to exclude the disabled jobs from the list of failed jobs.
Exclude failed jobsSpecify the list of job names from DBMS_SCHEDULER that you want to exclude from the list of failed jobs. Use comma (,) only to separate the names of the job.
Exclude failed job IDsSpecify the list of job IDs from DBA_JOBS that you want to exclude from the list of failed jobs. Use comma (,) only to separate the IDs of the job.
Oracle Global Alert Log Filters
Exclude error log stringsSpecify the list of strings that you want to exclude from monitoring. Use comma (,) only to separate the error log strings.
Include error log stringsSpecify the list of strings that you want to include in monitoring. Use comma (,) only to separate the error log strings.
Oracle Global users Options
User monitoring regular expressionTo add users for monitoring, the KM uses this regex. Any existing and future users which answer this regex is monitored.
KM Administration
Oracle debug
Oracle debugSelect this check-box to enable oracle global debug.

Note

Selecting these settings affects all the instances. 

Was this page helpful? Yes No Submitting... Thank you

Comments