Attribute definitions


Attribute definitions
Prev	Oracle agent	Next

The following table describes the definitions of required attribute of Oracle agent.

Table: Oracle agent - required attributes

Required Attribute	Type and Dimension	Definition
ServiceName	string-scalar	The name of the Oracle service set during the installation of Oracle. The service name is specified in the format OracleServiceSID, where SID represents the database instance.
Domain	string-scalar	The name of the domain to which the user belongs in whose context Oracle was installed.
SID	string-scalar	A system identifier that uniquely identifies the Oracle database instance to be monitored in detail.
UserName	string-scalar	The name of the domain user in whose context Oracle was installed.
EncryptedPasswd	string-scalar	The encrypted password for the user identified by UserName. The password must be encrypted with the VCS Encrypt utility.

The following table describes the definitions of optional attributes of Oracle agent.

Table: Oracle agent - optional attributes

Optional Attributes

Type and Dimension

Definition

DelayAfterOffline

integer-scalar

Number of seconds the agent waits to start the monitoring routine after Oracle is taken offline.

Default = 20

DelayAfterOnline

integer-scalar

Number of seconds the agent waits to start the monitoring routine after Oracle is brought online.

Default = 20

DetailMonitor

boolean-scalar

A flag that defines whether the agent monitors Oracle in detail by trying to verify access to the database by running a SQL script. The value 1 indicates that the agent will monitor Oracle in detail. The value 0 indicates that the agent will not.

Default = 0

If the DetailMonitor flag is set to 1, the following attributes must be defined:

SID
SQLFile

IndepthMonitorCount

integer-scalar

An integer that defines the monitor interval between two consecutive detail monitoring cycles. If this attribute is set to 5, the agent monitors the application in detail after every five monitor intervals.

Default = 5

Note:

Do not set the value of this attribute to 0.

SQLTimeOut

integer-scalar

The number of seconds the agent waits for the SQL script to return a value during detail monitoring. If this limit exceeds, the resource is declared faulted.

Default = 20

SQLFile

string-scalar

The name of SQL script to be used for detail monitoring, along with its complete path. The agent verifies the existence of this file.

A sample file, check.sql, is located at %VCS_HOME%\bin\Oracle\. The sample file contents are:

select * from v$database;

Do not include any spool commands within the SQL script.

If an Oracle error occurs during execution, the error is logged to the agent log. If debug logging is also enabled for the resource, the output of the SQL script is also logged to the agent log.

Prev	Up	Next
Resource type definition	Home	Netlsnr agent