These parameters are used in the snmp_rw.ora configuration file for the Intelligent Agent release.
agentctl.trace_level = off | user | admin | nn
Turns on tracing at the specified level for the AGENTCTL executable. Oracle recommends that you set the trace level to 13. Level 16 produces a deluge of information, which is only useful if a bug is being investigated. With a level of 16, you can see actual TCP/IP packet contents. With a level of 15, you can see that packets are being passed. This parameter is optional.
Note: Do not manually edit the services.ora file. The agent rewrites the file on startup.
User-configurable Parameters
agentctl.trace_directory = directory
Directory where trace file is written. The setting is only relevant in conjunction with DBSNMP.TRACE_LEVEL. If omitted, trace files are written to $ORACLE_
HOME\network\trace. This parameter is optional.
agentctl.trace_file = filename
Filename of the trace file. This parameter is optional.
agentctl.trace_timestamp = true/false
When set to TRUE, inserts a timestamp after each line of trace in the trace files.
snmp.index.service_name.world = index_number
The unique index number of the service that the agent is monitoring. The index number can be any number. The only limitation is that if you have more than one index line, the index numbers must be unique. For example:
snmp.index.<service_name1>=10 snmp.index.<service_name2>=20
snmp.connect.<service_name>.user = user_name
The username that the subagent uses to connect to the database. The default is
dbsnmp. This parameter is optional. The catsnmp.sql script should be edited and reexecuted if this parameter is not the default setting.
The "subagent" refers to the Intelligent Agent. Sometimes, the Intelligent Agent is called a subagent to the master SNMP agent when configuring SNMP on a server. However, SNMP does not have to be configured on the server before the Intelligent Agent will work (except for the Netware platform). For security reasons, the customers sometimes do not want to use the default Intelligent Agent database account/password of dbsnmp/dbsnmp. The example listed should only be used if they want to change the Intelligent Agent’s database logon account.
snmp.connect.<service_name>.password = password
The password for the username that is used by the subagent to connect to the database. The default is dbsnmp. This parameter is optional. The catsnmp.sql script should be edited and re-executed if this parameter is not the default setting.
The "subagent" refers to the Intelligent Agent. Sometimes, the Intelligent Agent is called a subagent to the master SNMP agent when configuring SNMP on a server. However, SNMP does not have to be configured on the server before the Intelligent Agent will work (except for the Netware platform). For security reasons, the customers sometimes do not want to use the default Intelligent Agent database account/password of dbsnmp/dbsnmp. The example listed should only be used if they want to change the Intelligent Agent’s database logon account.
User-configurable Parameters
When the dbsnmp password is changed it is automatically encrypted. The password parameter entry in the snmp_rw.ora file will appear in a non-readable format. For example:
snmp.connect.<service>.encryptedpassword="f1d03f5c7912faa3"
After the new password is accepted and encrypted, the Agent’s dbsnmp.log file will contain "NMS-00056: Agent’s db-account password for database ’<service>’ was encrypted"
snmp.contact.<service_name> ="contact_info"
A string containing contact information, such as name, phone number, and email, of the administrator responsible for the service. This parameter is optional.
dbsnmp.addnl_db_conns = nn
Increases the size of the Agent session pool. The default size of the Agent session pool is based on the number of ORACLE_DATABASE targets that the Agent manages. The connection limit is the default value plus the value specified for DBSNMP.ADDNL_DB_CONNS.
dbsnmp.no_job_skipped_notifications = <false/true>
When this parameter is true, skipped notifications are not sent. Skipped notifications are sent if this parameter is set to false (default value).
dbsnmp.notificationtimeout = <nn>
If the Agent fails to deliver a notification to the Oracle Management Server within this time, the Agent will be automatically re-started. The default value is 6 minutes. <nn> is number of milli-seconds.
dbsnmp.polltime = nn
The time interval (seconds) that the agent polls the database to check whether it is down. If the database has gone down or was never connected, this is the interval between retries. The default is 30 seconds.
Note: If the intelligent agent must monitor more than two instances, you should increase the value of DBSNMP.POLLTIME proportionally with the number of monitored instances.
For example:
The agent needs to monitor 10 instances. DBSNMP.POLLTIME should be set to 150. (10/2 * 30 = 150)
User-configurable Parameters
dbsnmp.noheuristic = {true/false}
The value of this parameter determines whether the Intelligent Agent will use a connection heuristic to ascertain the state of a monitored database (whether the database is up or down). By default, this value is set to FALSE (Agent uses the heuristic).
dbsnmp.notificationtimeout = <nn>
If the Agent fails to deliver a notification to the Oracle Management Server within the specified time (nn is number of milliseconds), the Agent is automatically re-started. The default value is 6 minutes.
dbsnmp.trace_level = off | user | admin | nn
Turns on tracing at the specified level for the Intelligent Agent process (dbsnmp). Oracle recommends that you set the trace level to 13. Level 16 produces a deluge of information, which is only useful if a bug is being investigated. With a level of 16, you can see actual TCP/IP packet contents. With a level of 15, you can only see that packets are being passed. This parameter is optional.
dbsnmp.trace_directory = directory
Directory where trace file is written. The setting is only relevant in conjunction with the DBSNMP.TRACE_LEVEL. If omitted, trace files are written to $ORACLE_ HOME\network\trace. This parameter is optional.
dbsnmp.trace_file = filename
Filename of the trace file. This parameter is optional.
dbsnmp.trace_filecnt = nn
Maximum number of trace files generated by the Agent. This optional parameter should be used when full tracing is desired, but disk space on the Agent machine is limited. This parameter is available beginning with version 8.1.7 of the Intelligent Agent.
dbsnmp.trace_filesize = nn
Maximum size of the individual trace file (in Kilobytes) generated by the Agent. For example, a value of 1024=1 megabyte trace file. This parameter is used in
conjunction with DBSNMP.TRACE_FILECNT when full tracing is desired, but disk
Note: If the monitored target is a Real Application Clusters database instance, DBSNMP.NOHEURISTIC must be set to TRUE since the heuristic does not work against Real Application Clusters database instances.
User-configurable Parameters
space on the Agent machine is limited. This parameter is available beginning with version 8.1.7 of the Intelligent Agent.
dbsnmp.trace_unique = true/false
When set to TRUE, generates unique log files for each log entry.
dbsnmp.log_directory = directory
Directory where log file is written. This parameter is optional.
dbsnmp.log_file = filename
Filename of the log file. This parameter is optional. On Windows NT, the filename defaults to dbsnmp.
dbsnmp.log_unique = true/false
When set to TRUE, generates unique log files for each log entry.
dbsnmp.trace_timestamp = true/false
When set to TRUE, inserts a timestamp after each line of trace in the trace files.
dbsnmp.hostname = <hostname or ip address>
Overrides the hostname the Agent is known by. This parameter allows the Agent to bind to a particular network interface card on its machine when an IP address is specified. This parameter also allows the Agent to bind to all network interface cards on its machine when hostname is specified.
The string that is returned is the name of the machine and is used in crypto exchanges. DBSNMP.HOSTNAME will also override the default host that is used for RPC listens (dbsnmp.address and dbsnmp.spawnaddress).
dbsnmp.threshold_job_status
This sets the number of job notifications that can be queued by the Agent for the Oracle Management Server.
dbsnmp.threshold_evocc
Sets the number of event notifications that can be queued for the OMS.
dbsnmp.avg_occ_per_event
Sets the number of notifications stored per event prior to flushing the queue when there are too many notifications.
dbsnmpj.trace_level = off | user | admin | nn
Turns on tracing at the specified level for the dbsnmpj process. dbsnmpj is spawned whenever a job is submitted to the Intelligent Agent. Oracle recommends that you
User-configurable Parameters
set the trace level to 13. Level 16 produces a deluge of information, which is only useful if a bug is being investigated. With a level of 16, you can see actual TCP/IP packet contents. With a level of 15, you can only see that packets are being passed. This parameter is optional.
dbsnmpj.trace_directory = directory
Directory where trace file is written. The setting is only relevant in conjunction with the DBSNMP.TRACE_LEVEL. If omitted, trace files are written to $ORACLE_ HOME\network\trace. This parameter is optional.
dbsnmpj.trace_file = filename
Filename of the trace file. This parameter is optional.
dbsnmpj.trace_filecnt = nn
Maximum number of trace files generated by the Agent. This optional parameter should be used when full tracing is desired, but disk space on the Agent machine is limited. This parameter is available beginning with version 8.1.7 of the Intelligent Agent.
dbsnmpj.trace_filesize = nn
Maximum size of the individual trace file (in Kilobytes) generated by the Agent. For example, a value of 1024=1 megabyte trace file. This parameter is used in
conjunction with DBSNMP.TRACE_FILECNT when full tracing is desired, but disk space on the Agent machine is limited. This parameter is available beginning with version 8.1.7 of the Intelligent Agent.
dbsnmpj.trace_unique = true/false
When set to TRUE, generates unique trace files for each line of trace.
dbsnmpj.log_directory = directory
Directory where log file is written. This parameter is optional.
dbsnmpj.log_file = filename
Filename of the log file. This parameter is optional. On Windows NT, the filename defaults to dbsnmpj.
dbsnmpj.log_unique = true/false
When set to TRUE, generates unique log files for each log entry.
dbsnmpj.trace_timestamp = true/false