Agent configuration variables

/ORACLE_USERS..inst..UsersRegEx

This parameter describes the RegEx that should be used for the selection of users to be monitored.

/ORACLE_USERS.__ANYINST__.UsersRegEx

/ORACLE_JOBS.ORACLE_SID.FailedJobsExcludedList

/Oracle_JOBS.__ANYINST__.FailedJobsIDsExcludedList

enables or disables trigger for failed and long running jobs:

• 1 = Disables trigger
• 0 = enables trigger

• 1 = disables failed jobs reporting
• 0 = enables failed jobs reporting

/OracleConfig.<sid>.ExtentsLeftHint

This variable is used to determine if the queries for ExtentsLeft and ExtentsLeftPct parameters should be executed using the +RULE or NORULE hint.

This variable value is set to NORULE.

Set the value to +RULE and restart the agent to improve the performance and reduce high I/O for AVAILABILITY/ExtentsLeft and ExtentsLeftPct.

This variable is used to configure the minimum size remaining before the tablespace cannot extend due to a lack of operating system space or reaching the maximum space on the tablespace.

The default value is 1024*1024 bytes.

/AgentSetup/ORACLE_ASM_INSTANCE. ASMInstanceName.defaultAccount

For internal use only; do not modify or delete. stores sys database user name and password for an ASM instance

/AgentSetup/ORACLE_ASM_DGROUP.ASMInstanceName. defaultAccount

For internal use only; do not modify or delete.storessysdatabaseuser name and password for an ASM instance at disk group level

/AgentSetup/ORACLE_ASM_DISK.ASMInstanceName. defaultAccount

For internal use only; do not modify or delete.storessysdatabaseuser name and password for an ASM instance at the disk level

/AgentSetup/ORACLE_ CATEGORY. ORACLE_SID. defaultAccount

For internal use only; do not modify or delete. default username/password combination for the application class (ORACLE_ CATEGORY ) in its name.

/AgentSetup/ ORACLE_DATAGUARD_INSTANCE. hostName: standbyInstanceName.defaultAccount

For internal use only; do not modify or delete. stores the sys user password of the configured standby instance The hostName variable indicates the name of the host where the standby instance is running.

/AgentSetup/ ORACLE_DATAGUARD_DATABASE. primaryInstanceName.defaultAccount

For internal use only; do not modify or delete. stores the PATROL database user password of the configured primary instance in Oracle KM

/AgentSetup/ ORACLE_DATAGUARD_DATABASE. hostName: standbyInstanceName.defaultAccount

For internal use only; do not modify or delete. stores the sys user password of the configured standby instance The hostName variable indicates the name of the host where the standby instance is running.

/AgentSetup/ORACLE_SQLVIEWER.ORACLE_SID.archDest

location of data files to which SQL Viewer writes

• default on UNIX ^®: /tmp
• default on Windows: c:

/AgentSetup/ORACLE_SQLVIEWER.ORACLE_SID.collectorRunning

For internal use only; do not modify or delete. flag that indicates whether the collector for SQL Viewer is running

/AgentSetup/ORACLE_SQLVIEWER.ORACLE_SID. collStartTime

For internal use only; do not modify or delete. start time of the SQLViewer collector

/AgentSetup/ORACLE_SQLVIEWER.ORACLE_SID. collStopTime

For internal use only; do not modify or delete. stop time of the SQLViewer collector

/AgentSetup/ORACLE.temp.defaultAccount

For internal use only; do not modify or delete. temporary default account

/AgentSetup/ORACLE_RAC_DATABASE/ RACInstanceName.defaultAccount

For internal use only; do not modify or delete. default account of the Real Application Clusters (RAC) instance. This account information is used by RAC for opening a channel and connecting to the RAC instance to check its status.

/ASMConfig.ASMInstanceName.DGList

For internal use only; do not modify or delete. stores disk group names for the ASM instance being monitored

/ASMConfig.Instances

For internal use only; do not modify or delete. stores the ASM instance names being monitored

/ASMConfig.InstanceName.Exclusion

enables or disables monitoring Valid values are as follows:

• 1 = disable monitoring
• 0 or a blank value = enable monitoring

/DGConfig.InstanceName.Exclusion

enables or disables monitoring Valid values are as follows:

• 1 = disable monitoring
• 0 or a blank value = enable monitoring

/DGConfig.standbyInstanceName.monDGInstType

For internal use only; do not modify or delete. stores the type of standby, it can be physical or logical

/DGConfig.standbyInstanceName.TNSService

For internal use only; do not modify or delete. indicates the TNS entry of a standby instance

/DGConfig.monDGDBList

For internal use only; do not modify or delete. stores the list of configured database names of the primary instances

/DGConfig.primaryDatabaseName.monDGInstList

For internal use only; do not modify or delete. stores the names of the standby instances configured for a primary database

/DGConfig.primaryInstanceName.DBHome

For internal use only; do not modify or delete. ORACLE HOME of the primary instance

/DGConfig.primaryInstanceName.DBName

For internal use only; do not modify or delete. stores the database name of the primary instance This pconfig gets created only when primary instance is configured with autodb configuration in ORACLE.kml.

If this pconfig is set to 0 the alerts collector will run the query to discover the location of Oracle alert log. The location will be forced discovered.

/ORACLE_AVAILABILITY.ORACLE_SID.ArchFreeSpace. active.

For internal use only; do not modify or delete. flag that indicates whether archive logging is active for the monitored instance

/ORACLE_AVAILABILITY.sid.tempTSparams. deactivatedByKM

For internal use only; do not modify or delete. flag that indicates whether the temp tablespaces were deactivated by the KM

/ORACLE_AVAILABILITY.ORACLE_SID.tempOSTableExists

For internal use only; do not modify or delete. flag that indicates that the p$temp_os_space table exists, the collector need not create this table, and the collector can count on the presence of this table

/ORACLE_AVAILABILITY.ORACLE_SID.temp.TableExists

For internal use only; do not modify or delete. flag that indicates that the p$temp_ts_space table exists, the collector need not create the table, and the collector can count on the presence of this table

/ORACLE_AVAILABILITY.ORACLE_SID.FreeSpace. kmactive

For internal use only; do not modify or delete. flag that indicates whether the FreeSpace parameter is active

/ORACLE_AVAILABILITY.ORACLE_SID.FreeSpaceDeficit. kmactive

For internal use only; do not modify or delete. flag that indicates whether the FreeSpaceDeficit parameter is active

/ORACLE_INSTANCE.ORACLE_SID.localInstance

For internal use only; do not modify or delete. flag that indicates whether an instance is monitored locally or remotely

/OracleConfig.FailoverMonitoring.Listener. ORACLE_LISTENER.Active

For internal use only; do not modify or delete. flag that indicates whether the named listener is a part of the Failover Configuration

/OracleConfig.ORACLE_SID.AlertFileInfo_eof_pos

For internal use only; do not modify or delete. end of the file for the alert log

/OracleConfig.ORACLE_SID.AlertFileInfo_modtime

For internal use only; do not modify or delete. last time the alert log was modified

/OracleConfig.ORACLE_SID.AlertFileInfo_size

For internal use only; do not modify or delete. size of the Alert Log

/OracleConfig.ORACLE_SID.AvExTablespaces

Stores the tablespace names in the ORACLE_AVAILABILITY application class that you want to exclude from monitoring

/OracleConfig.ORACLE_SID.ALTERNEXT.SCHEMA NAME. OBJECT NAME

For internal use only; do not modify or delete. flag that indicates whether the KM will alter the next extent of the object in the schema if there is a space problem.

/OracleConfig. ORACLE_SID.AlwaysOnLine

flag that indicates whether the InstanceStatus parameter goes into a warning or an alarm state when the instance is offline This variable uses the following values:

• 0 = AlwaysOnLine not selected during configuration of the instance; InstanceStatus parameter goes into a warning state if the instance goes down.
• 1 = AlwaysOnLine selected during configuration of the instance; InstanceStatus parameter goes into an alarm state if the instance goes down.

/OracleConfig. ORACLE_SID.ARCHIVELOG.DIRECTORY

For internal use only; do not modify or delete. archive log directory

/OracleConfig. ORACLE_SID.ACLFlag

Indicates during instance configuration whether the KM skips the permission check on the SQL*Plus binary for the PATROL OS user if the PATROL OS user belongs to the others group and the Oracle environment is set with the permissions on the SQL*Plus binary on the UNIX platform, as shown in the following example: -rwxr-x---+ 1 oracle dba 1059496 May5 2004sqlplus A value of 1 indicates that the KM will skip the permission check on the SQL*Plus binary and the instance configuration will be successful.

/OracleConfig. ORACLE_SID.AvExUsers

list of users who are excluded from monitoring by the following space parameters:

• CannotExtend
• ExtentsLeft
• ExtensLeftPct
• FreeSpace
• FreeSpaceDeficit
• RSExtentsLeft
• RSExtentsLeftPct
• RSSpaceLeftPct
• TempTSLeft
• TempTSLeftPct

/OracleConfig.ORACLE_SID.Categories

Categories(application classes) that are selected to monitor this instance.

Values for this variable are the following:

• AVAILABILITY
• COLLECTORS
• CAPACITY
• DBLINKS
• ENVIRONMENT
• JOBS
• LOG
• MTS
• NETWORK
• PERFORMANCE
• PQO
• REPLICATION
• SGA
• SQLVIEWER
• USERS

This is used to determine if we have exclusion active or not.

• 1 = exclusion is active
• 0 = no exclusion

/ORACLE_ETSM.__ANYINST__.TablespaceFilterInActiveList 

/ORACLE_ETSM.__ANYINST__.TablespaceFilterInActiveRegex 

/ORACLE_ETSM.__ANYINST__.TablespaceFilterTypes 

/ORACLE_ETSM.ORACLE_SID.VeryLargeTablespaceSize 

/ORACLE_ETSM.ORACLE_SID.LargeTablespaceSize 

/ORACLE_ETSM.ORACLE_SID. dataOSTableExists

indicates existence of the database table P$DATA_OS_SPACE If the value is 0, the P$DATA_OS_SPACE table is not created. If the value is 1, the P$DATA_OS_SPACE table is created.

/ORACLE_ETSM.ORACLE_SID.dataTableExists

indicates existence of the database table P$DATA_TS_SPACELEFT If the value is 0, the P$DATA_TS_SPACELEFT table is not created. If the value is 1, the P$DATA_TS_SPACELEFT table is created.

/ORACLE_ETSM.ORACLE_SID.StoreTbspHistory

For internal use only; do not modify or delete. a flag indicating whether the ETSM monitoring is exception-based or history-based Valid values are as follows:

• 0 indicates exception-based ETSM monitoring.
• 1 indicates history-based ETSM monitoring.

/ORACLE_ETSM.ORACLE.__ANYINST__.StoreTbspHistory

Note: The ANYINST designation allows you to apply these changes to any instance without adding specific instance name.

• 0 indicates exception-based ETSM monitoring.
• 1 indicates history-based ETSM monitoring.

/OracleConfig.ORACLE_SID.ConfigTime

For internal use only; do not modify or delete.

Time of the last configuration or reconfiguration activity for the ORACLE_SID instance

/OracleConfig.ORACLE_SID.DBAUsername

For internal use only; do not modify or delete.

Username of the dba account used to configure the KM for ORACLE_SID

/OracleConfig.ORACLE_SID.DBName

For internal use only; do not modify or delete.

Database name

/OracleConfig.ORACLE_SID.dbObjectsDeinstalled

For internal use only; do not modify or delete.

Flag that indicates whether the database objects have been uninstalled

/OracleConfig.ORACLE_SID.Exclusion

Flag that indicates whether the instance is excluded from monitoring by PATROL.

This variable uses the following values:

• 0 = instance is not excluded; the instance is monitored by PATROL
• 1 - instance is excluded; the instance is not monitored by PATROL

/OracleConfig.ORACLE_SID.ExcludeFreeSpaceDeficit

Flag that indicates whether the query for the FreeSpaceDeficit parameter will be skipped or not This variable uses the following values:

• 1 = The execution of the query will be skipped
• 0 = The execution of the query will not be skipped

/OracleConfig.ORACLE_SID.ExcludeExtentsLeft

Flag that indicates whether the query for the ExtentsLeft and ExtentsLeftPct parameters will be skipped or not This variable uses the following values:

• 1 = The execution of the query will be skipped
• 0 = The execution of the query will not be skipped

/OracleConfig.ORACLE_SID.ExtentsLeftHint

Determines if the queries for ExtentsLeft and ExtentsLeftPct must be executed by using the +RULE or NORULE hint.

/OracleConfig. ORACLE_SID.FailoverMonitoring.Active

Flag that indicates whether failover monitoring is active or inactive for the instance This variable uses the following values:

• 1 = Failover monitoring is active
• 0 = Failover monitoring is not active

/OracleConfig. ORACLE_SID.FailoverMonitoring. AlternateHost

Computer name for the backup instance; alternate host for failover monitoring Alternate Host name entered in the Configure ORACLE_SID for Failover Monitoring dialog box, accessed by using the Failover Monitoring > Configure menu command from the ORACLE_INSTANCE menu

/OracleConfig. ORACLE_SID.FailoverMonitoring. AlternateListenerName

For internal use only; do not modify or delete. Alternate listener for failover monitoring

/OracleConfig. ORACLE_SID.FailoverMonitoring. AlternateORASid

SID for the backup computer designated for failover monitoring Backup Oracle SID entered in the Configure ORACLE_SID for Failover Monitoring dialog box, accessed by using the Failover Monitoring > Configure menu command from the ORACLE_INSTANCE menu.

/OracleConfig. ORACLE_SID.FailoverMonitoring. AlternatePort

Port number for the PATROL Agent on the backup computer designated for failover monitoring Backup Agent Port entered the Configure ORACLE_SID for Failover Monitoring dialog box, accessed by using the Failover Monitoring > Configure menu command from the ORACLE_INSTANCE menu.

/OracleConfig. ORACLE_SID.FailoverMonitoring. LocalFailoverListenerName

For internal use only; do not modify or delete. Local listener name for failover monitoring

/OracleConfig.ORACLE_SID.FilterExcl

Strings in the Alert Logs that are excluded from monitoring Values for this variable are the strings entered in the Enter a New String to Exclude from Monitoring text box in the Error Log Filters dialog box. You can change this variable by using the Error Log Filters menu command from the AVAILABILITY menu.

/OracleConfig.ORACLE_SID.FilterIncl

Strings in the Alert Logs that are included for monitoring Values for this variable are the strings entered in the Enter a New String to Monitor for text box in the Error Log Filters dialog box. You can change this variable by using the Error Log Filters menu command from an AVAILABILITY menu.

/OracleConfig.ORACLE_SID.Home

ORACLE_HOME for database identified by ORACLE_SID The following are sample values by platform:

• UNIX: /u01/oracle/app/oracle/product/11.2.0/dbhome_1
• Windows: c:\oracle\product\12.1.0\dbhome_1

/OracleConfig.ORACLE_SID.InUsers

List of users (other than problem users) that are selected for monitoring The values for this variable are the users who are selected for monitoring. You can change this variable by using the User Monitoring > Users Monitoring menu command from the USERS instance menu.

/OracleConfig. ORACLE_SID.InProbUsers

List of users excluded from Problem User monitoring. The values for this variable are the users who are selected for exclusion from problem user monitoring. You can change this variable by using User Monitoring > Problem User Exclusion menu command from the USERS instance menu.

/OracleConfig.ORACLE_SID.InSessions

Sessions that are selected for Users monitoring This variable is created the first time you use the Sessions Monitoring menu command. A value of " " means that no sessions are selected. For each session selected, the value includes the name of the user and the session number, separated by a dash, as in the following example where ORA4, SYS, and ORA3 are user names:
ORA4-10 SYS-0 ORA3-5 You can change this variable by using User Monitoring > Sessions Monitoring menu command from the USERS instance menu.

/OracleConfig. ORACLE_SID.InTablespaces

List of the tablespaces selected for tablespace monitoring The value for this variable contains the names of the tablespaces that you selected for monitoring, along with a numeric identifier for each tablespace. The names and numeric identifier are separated by a comma, as in the following example where TEST1, SYSTEM, and EXAMPLE are tablespace names:
TEST1,31 SYSTEM,0 EXAMPLE,4 You can change this variable by using Tablespace Monitoring menu command from a TABLESPACE instance menu.

/OracleConfig.ORACLE_SID.Name

For internal use only; do not modify or delete. name of database; identical to SID

/OracleConfig.ORACLE_SID.NumPrivs

For internal use only; do not modify or delete. number of privileges granted to patrol user

/OracleConfig. ORACLE_SID.ProbUserMaxBlocked

Maximum threshold for determining a problem user The value of this variable is the number of minutes entered in the Problem User Settings Config dialog box as the maximum number of minutes that you can set for user idle. The number entered here changes the threshold in the Problem User Settings dialog box. You can change this variable by using the User Monitoring > Problem User Settings Config menu command from a USERS instance menu.

/OracleConfig. ORACLE_SID.ProbUserMaxIdle

Maximum threshold for determining a problem user The value for this variable is the number of minutes entered in the Problem User Settings Config dialog box as the maximum number of minutes that you can set for idle user. The number entered here changes the threshold in the Problem User Settings dialog box. You can change this variable by using the User Monitoring > Problem User Settings Config menu command from a USERS instance menu.

/OracleConfig. ORACLE_SID.ProbUserMaxRunaway

Maximum threshold for determining a problem user The value for this variable is the number of minutes entered in the Problem User Settings Config dialog box as the maximum number of minutes that you can select for runaway user. The number entered here changes the threshold in the Problem User Settings dialog box. You can change this variable by using the User Monitoring > Problem User Settings Config menu command from a USERS instance menu.

/OracleConfig. ORACLE_SID.ProbUserMinBlocked

Minimum threshold for determining a problem user The value for this variable is the number of minutes entered in the Problem User Settings Config dialog box as the minimum number of minutes that you can select for the user blocked threshold. The number entered here changes the threshold in the Problem User Settings dialog box. This number must exceed the polling cycle of the CollUsers collector, which is 30 minutes by default. You can change this variable by using the User Monitoring > Problem User Settings Config menu command from a USERS instance menu.

/OracleConfig. ORACLE_SID.ProbUserMinIdle

Minimum threshold for determining a problem user The value for this variable is the number of minutes entered in the Problem User Settings Config dialog box as the minimum number of minutes that you can use for the user idle threshold. The number entered here changes the threshold in the Problem User Settings dialog box. This number must exceed the polling cycle of the CollUsers Collector, which is 30 minutes by default. You can change this variable by using the User Monitoring Config > Problem User Settings menu command from a USERS instance menu.

/OracleConfig. ORACLE_SID.ProbUserMinRunaway

Minimum threshold for determining a problem user The value of this variable is the number of minutes entered in the Problem User Settings Config dialog box as the minimum number of minutes that you can use for the user runaway threshold. The number entered here changes the threshold in the Problem User Settings dialog box. This value must exceed the polling cycle for CollUsers collector, which is 30 minutes by default. You can change this variable by using the User Monitoring > Problem User Settings Config menu command from a USERS instance menu.

/OracleConfig. ORACLE_SID.RdbmsVersion

Oracle version If the instance is properly configured, this variable contains the version number for the Oracle instance. The value of this variable takes the form of a dot-separated version number, as in the following example: 9.0.1.0.0

/OracleConfig. ORACLE_SID.TablespaceExclusionFlag

Indicates whether the /OracleConfig. ORACLE_SID.AvExTablespaces pconfig variable has been updated A value of 1 indicates that the pconfig variable has been updated.

/OracleConfig. ORACLE_SID.RECOVERY

For internal use only; do not modify or delete. flag that indicates whether recovery is set

/OracleConfig. ORACLE_SID.RECOVERY.ARCHIVELOG

For internal use only; do not modify or delete. action that PATROL for Oracle performs when the archive log destination gets full. A value of compress indicates that the log files would be compressed and MOVE indicates where the log files would be moved to.

/OracleConfig.ORACLE_SID.Service

Oracle Net service name specified at instance configuration

/OracleConfig. ORACLE_SID.UserBlocked

Number of seconds a user can remain blocked before it is detected as a problem user The output for this variable is in seconds; it equals the number of minutes you selected for User Blocked in the Problem User Settings dialog box multiplied by 60. You can change this variable by using the User Monitoring > Problem User Settings menu command from a USERS instance menu.

/OracleConfig.ORACLE_SID.UserCpu

Percentage of CPU a user can use before it is detected as a problem user The output for this variable is a percentage. You can change this variable by using the User Monitoring > Problem User Settings menu command from a USERS instance menu.

/OracleConfig. ORACLE_SID.UserCriteria

flags that indicate which criteria are active for monitoring problem users Four values in some combination of 1s and 0s.

• The first value indicates whether Idle is active (1) or inactive (0).
• The second value indicates whether Blocked is active (1) or inactive (0).
• The third value indicates whether Runaway is active (1) or inactive (0).
• The fourth value indicates whether Cpu Hog is active (1) or inactive (0).

/OracleConfig. ORACLE_SID.UserIdle

number of seconds a user can remain idle before it is detected as a problem user The output for this variable is in seconds; it equals the number of minutes you selected for User Idle in the Problem User Settings dialog box multiplied by 60. You can change this variable by using the User Monitoring > Problem User Settings menu command from a USERS instance menu.

/OracleConfig. ORACLE_SID.UserRunaway

number of seconds a user can perform a process without returning any data before it is detected as a problem user The output for this variable is in seconds; it equals the number of minutes you select for User Runaway in the Problem User Settings dialog box multiplied by 60. You can change this variable by using the User Monitoring > Problem User Settings menu command from a USERS instance menu.

/OracleConfig.blackout

list of scheduled blackouts Each scheduled blackout is expressed as follows:

• server_name
• day-of-the-week
• starting time in seconds after midnight
• duration expressed in minutes

/OracleConfig.Debug

flag that indicates whether debug is active for discovery This variable uses the following values:

• 0 = inactive
• 1 = active (displays all debug messages generated during discovery in a task output window)

/OracleConfig.DebugConf

flag that indicates whether debug is active for instance configuration This variable uses the following values:

• 0 = inactive
• 1 = active (displays all debug messages generated during instance configuration in a task output window)

/OracleConfig.FailoverMonitoring.Listener. ORACLE_LISTENER.Active

flag that indicates whether the named listener is a part of the Failover Configuration

/OracleConfig.Instances

list of Oracle instances that are configured If the value for this variable is null or contains " ", then no instances are configured. If instances are configured, the value should contain the names of the configured instances, as in the following example:
rhe901d1 rhe901d2

/OracleConfig.ObjectsList

For internal use only; do not modify or delete. list of database objects (tables, views, synonyms) created by instance configuration

/OracleConfig.PackageBodyList

For internal use only; do not modify or delete. list of package bodies created by instance configuration

/OracleConfig.PackageList

For internal use only; do not modify or delete. list of packages created by instance configuration

/OracleConfig.SessTimeStamp

For internal use only; do not modify or delete. time of completion of last activity for session settings

/OracleConfig.TimeStamp

For internal use only; do not modify or delete. time of completion of last instance configuration or reconfiguration activity

/OracleConfig.UsrTimeStamp

For internal use only; do not modify or delete. time of completion of last activity for User settings

OracleConfig. ORACLE_SID.LockConflictsHint

contains the Oracle hint that is used by the LockConflicts parameter query Valid values are the following types of Oracle hints:

• NORULE
• + RULE

/OraNetConfig.javaHome

stores list of management listeners of the specified host

/OraNetConfig.listener_name.ConfigHome

stores Oracle Home to check the status of the listener if /OraNetConfig.listener_name.LsnrConfigHomeFlag is set to 1.

/OraNetConfig.listener_name.log_path

stores the location of the listener log file

/OraNetConfig.listener_name.LsnrConfigHomeFlag

Holds a value of 1 if the user modifies the Listener Home for the listener from the Configuration menu command of the ORANET application class.

/OraNetConfig.listener_name.FilterExcl

strings in the Listener Logs that are excluded from monitoring Values for this variable are the strings entered in the Enter a New String to Exclude from Monitoring text box in the Listener Log Filters dialog box. You can change this variable by using the Listener Log Filters menu command from the ORANET menu. NOTE: This pconfig variable supports PSL regular expressions only. Each string must be separated by a new line.

/OraNetConfig.listener_name.FilterIncl

strings in the Listener Logs that are included for monitoring Values for this variable are the strings entered in the Enter a New String to Monitor for: text box in the Listener Log Filters dialog box. You can change this variable by using the Listener Log Filters menu command from the ORANET menu. NOTE: This pconfig variable supports PSL regular expressions only. Each string must be separated by a new line.

/OraNetConfig.listener_name.home

Oracle Home directory holding the Oracle Net installation under which this listener runs

/OraNetConfig.listener_name.monitorflag

flag that indicates whether monitoring of the listener specified by LISTENER NAME is enabled

/OraNetConfig.clusterConfigChanged

flag that indicates whether a value was entered through the Cluster Configuration command from the ORANET menu If values are entered through the Cluster Configuration menu command, the value of this variable is set to 1, which forces ORANET to go through a FULL discovery (reading the listener.ora files). When discovery completes, the value of this variable is reset to 0.

/OraNetConfig.Instances

list of Oracle Net listeners being monitored by ORANET

/OraNetConfig.logicalHosts

list of logical hosts for ORANET

/OraNetConfig.virtualServers

list of virtual servers for ORANET

/RACConfig. InstanceName.Exclusion

enables or disables monitoring Valid values are as follows:

• 1 = disable monitoring
• 0 or a blank value = enable monitoring

/RACConfig.Databases

lists the configured and monitored RAC databases. This pconfig variable is created for each monitored RAC database.

/RACConfig.RACDatabaseName.DBHome

stores the RAC database home path. This pconfig variable is created for each monitored RAC database.

/RACConfig.RACDatabaseName.DownInstList

lists the RAC instances that are down. This pconfig variable is created for each monitored RAC database.

/RACConfig.RACDatabaseName.MountInstList

lists instances that are in the mount state

/RACConfig.RACDatabaseName.Monitoring

indicates the success of monitoring the RAC database If the value is 1, the RAC database is monitored successfully. When the RAC database has been removed from monitoring, this pconfig variable is also removed from the pconfig database This pconfig variable is created for each monitored RAC database.

/RACConfig.RACDatabaseName.RACInsList

lists the RAC instances that are monitored under the RAC database. This pconfig variable is created for each monitored RAC database.

/RACConfig.RACInstanceName.rdbmsVersion

stores the RDBMS version of the RAC instance. This pconfig variable is created for each RAC instance that is monitored under the RAC database.

/RACConfig.RACInstanceName.TNSService

stores the TNS service name of the monitored RAC instance. This pconfig variable is created for each RAC instance that is monitored under the RAC database.

/OracleConfig.ORACLE_SID.perflockHint

sets the Oracle hint for the query that sets the value of CurrentTrans and DMLLocks parameters (ORACLE_PERFORMANCE application class). The valid values for this pconfig are NORULE and + RULE. Note: By default, the queries for ORACLE_PERFORMANCE application class are executed without any Oracle hint.

/OracleConfig.ORACLE_SID.RuleHint

sets the Oracle hints while executing PATROL queries for ORACLE_AVAILABILITY and ORACLE_USERS application classes. The valid values for this pconfig are NORULE and + RULE. For Oracle version, 10.2 or later, the default value is NORULE.

/OracleConfig.ORACLE_SID.RACInstance

For internal use only; do not modify or delete. a flag indicating whether the instance is a RAC instance Valid values are as follows:

• 0 indicates a non-RAC instance.
• 1 indicates a RAC instance

/OracleConfig.UserCanRunSRVCTL

discovers and monitors the SCAN listener based on PATROL for Oracle user's privileges to run the Oracle SRVCTL utility. The user must be a member of the primary DBA group to run this utility. This variable must be added manually in the PATROL configuration file (pconfig). Valid values are as follows:

• 1 to confirm that the user has sufficient privileges to run the Oracle SRVCTL utility. If the value is set to 1, only the SCAN listener that is running is displayed and monitored. The listener is displayed under the node in which it is currently running.
• Any value other than 1 indicates that sufficient privileges were not granted to the user, for executing the Oracle SRVCTL utility. If set to any value other than 1, all defined SCAN listeners are displayed under each Oracle RAC node. The SCAN listener that currently runs on a node is monitored. All the other listeners will be in the Alert status.

/ORACLE_ETSM.ORACLE_SID.DisableRollBack

does not execute the rollback related query in the P$POPULATE_CONTAINERS procedure, which populates all ETSM containers. Default value is 0 to execute the rollback related query. Execution of this query is skipped when you specify a value 1.

checks whether to execute or block the PATROL queries for ORACLE_ETSM.

• 0 executes the query.
• 1 blocks the query.

Note: No value for this variable executes the query.

threshold value for long running queries. If a query's execution duration is equal to, or greater than, the threshold, the long running query is blocked.

When a specific query exceeds the execution threshold, the blockETSMQuery is set to 1. This setting blocks the running query and prevents the specific query from running again.

If this threshold is not set, the default value for long running queries is 30 minutes.

/AgentSetup/ORACLE_LISTENER. listenerName. LsnrPassword

For internal use only; do not modify or delete. stores the password for a listener that is specified in the listener.ora file.

/OraNetConfig.DynListenerList

lists dynamic listeners that ORANET monitors.

/OraNetConfig.DiscoveryConstant

For internal use only; do not modify or delete. indicates that the database query to discover a dynamic listener by ORANET will be executed at every third polling cycle. The default value of this pconfig variable is 3.

/OracleConfig.LargeTablespaceSize

stores the tablespace size in bytes for ETSM_LARGE containers.

/OraNetConfig.ScanListenerList

/OracleConfig.VeryLargeTablespaceSize

stores the tablespace size in bytes for ETSM_VERY_LARGE containers.

/AgentSetup/ORACLE_INSTANCE. ORACLE_SID. defaultAccount

For internal use only; do not modify or delete. stores PATROL database user password for an instance.

/OracleConfig.ORACLE_SID.osusername

stores the OS authenticated user name.

/OracleConfig.ORACLE_SID.UpdateLinksSchedule

indicates the polling interval after which the p$autoextendedlinks table will get updated. The default value for this pconfig variable is 10. Therefore, by default, the p$autoextendedlinks table will get updated again at the 11th polling cycle.

/OracleConfig.ORACLE_SID.LockTime

stores the lock contention duration. The default value is 120 seconds.

/OracleConfig.ASMInstanceName.ASMFlag

For internal use only; do not modify or delete. stores value 1 to indicate that an instance is using ASM storage.

/OracleConfig.ASMInstanceName.ASMInstance

stores the ASM instance name.

/OracleConfig.ASMInstanceName.ASMHome

stores ASM instance home.

/AgentSetup/ORACLE_INSTANCE.ASMInstanceName.defaultAccount

For internal use only; do not modify or delete. stores SYS database user password for an ASM instance.

/AgentSetup/ORACLE_AVAILABILITY. ASMInstanceName.defaultAccount

For internal use only; do not modify or delete. stores SYS database user password for an ASM instance.

/OracleConfig.InstanceName.UseDeletNotTruncate

value 1 indicates that for every collector polling cycle, all p$< tableName> tables should be deleted. Value 0 indicates that for every collector polling cycle, all p$< tableName > tables should be truncated.

/OracleConfig.InstanceName.OracleBase

enter the actual value of the $ORACLE_BASE environment variable. For example, /OracleConfig. InstanceName. OracleBase = { REPLACE = "/usr/oracle" }

/OracleConfig.InstanceName.exclude_dba_undo_extents

flag that indicates whether the dba_undo_extents view in the query will be skipped or not. This variable uses the following values:

• 1 = The dba_undo_extents view will be skipped.
• 0 = The dba_undo_extents view will not be skipped.

/OracleConfig.__ANYINST__.exclude_dba_undo_extents

• 1 = The dba_undo_extents view will be skipped.
• 0 = The dba_undo_extents view will not be skipped.

/OracleConfig.InstanceName.ExcludeDBARoleCheck

flag that indicates whether the query that checks DBA role will be skipped or not. This variable uses the following values:

• 1 = The DBA role check will be skipped
• 0 = The DBA role check will not be skipped

/OracleConfig.InstanceName.Overduetime

flag that indicates whether overdue time of Job parameter can be increased.
Unit: minutes
Default value: 2 minutes

/OracleConfig.SRVCTLHome

indicates the location of the SRVCTL utility. The KM adds /bin to this path.

/OracleConfig.CandidateServers

contains the list of servers and ports on which all the PATROL Agents at the RAC One Node are running.

/OranetConfig.ListenerPort

indicates the port onwhich to listen for incoming connections. Example: %PSL pconfig("REPLACE", "/OraNetConfig.ListenerPort"| [1521,1525]) Default value: 1521