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 name	Specify 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 Password	Re-type the privileged database password.
Database monitoring account credentials
User Name	Specify 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 Password	Re-type the database monitoring password.
Always on line	Select this check-box to show the instancStatus parameter goes into alarm when instance is offline.
Monitoring	Select this check-box to enable monitoring for the instance.
Default tablespace	Specify the default tablespace for database monitoring user.
Temporary tablespace	Specify the temporary tablespace for database monitoring user.
Profile	Specify the user create profile.
Categories	Specify the application classes.
Oracle home	Specify the oracle home for all instances.
Remote host name	Specify the host name for remote monitoring.
TNS service string	Specify 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 Name	Specify 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 Name	Specify the SSH connection user name.
Password	Specify the SSH connection password.
SSH Port	Specify the SSH port. By default the port number is 22.
Add to List	To add the configured remote host to the list of remote hosts, click the button.
Modify Selection	To modify a configured remote host, from the list of remote hosts, click the button.
Remove from List	To 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 jobs	Select this check box to exclude the disabled jobs from the list of failed jobs.
Exclude failed jobs	Specify 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 IDs	Specify 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 strings	Specify the list of strings that you want to exclude from monitoring. Use comma (,) only to separate the error log strings.
Include error log strings	Specify 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 expression	To 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 debug	Select this check-box to enable oracle global debug.

Note

Selecting these settings affects all the instances.

Oracle Global Configuration

Comments