Oracle SNMP Support Reference Guide Release 8.1.5 A67822-01 |
|
This appendix provides information to help you interpret the variables of the private Oracle Names MIB which are implemented in this release. Specifically, it includes sections covering SNMP variables in the following tables:
For more information about the Oracle Names product, refer to the Oracle Names Administrator's Guide. For a listing of all variables in the Oracle Names MIB, including those not implemented in this release, see the MIB itself.
The oraTNSTable contains variables which could be common to all applications running on SQL*Net. SQL*Net is Oracle's remote data access software that enables both client/server and server/server communications across any network. Monitoring these variables is useful in order to obtain basic (mostly static) information about the Oracle Names application.
Each entry in the oraNamesTNSTable represents a given active SQL*Net application located on the managed node. (In this case, that application is Oracle Names.) Each entry is indexed by applIndex. (For details about applIndex, see Appendix E, "Interpreting Implemented Variables of the Network Services MIB.") The current value of each oraNamesTNSTable variable is retrieved from an internal table or from a corresponding field in the NAMES.ORA configuration file on the managed node.
Appendix C-1 lists each of these variables and its corresponding object ID.
A description of each of these variables follows.
Integer32
read-write
Indicates the amount and granularity (if any) of trace messages the server writes to its trace file. The higher the number, the more verbose the tracing information. Enumerated levels include 4 (user) and 6 (admin) or 17 (off). The value of this variable is retrieved from the NAMES.TRACE_LEVEL field of the NAMES.ORA file.
enumerated 1 - 17
less important
oraNamesTNSParameterFile, oraNamesTNSTraceFile
simple string
DisplayString
read-write
Indicates the name of the startup file containing all site-specific configuration/ tuning settings for this server.
any legal filename
less important
oraNamesTNSListenAddresses, oraNamesTNSLogFile, oraNamesTNSTraceFile, onsrTNSTraceLevel
simple string
DisplayString
read-write
Indicates the name of the file to which this server writes log information concerning normal events, errors, and possibly periodic statistical dumps.
any legal filename
less important
oraNamesTNSParameterFile
simple string
DisplayString
read-write
Indicates the name of the file to which this server writes trace information when tracing is enabled. Such trace information includes internal details about this server's operation, for use in solving operational problems.
any legal filename
less important
oraNamesTNSParameterFile, oraNamesTNSTraceLevel
simple string
DisplayString
read-only
Indicates the person to contact regarding the operation or administration of this server, together with information on how to contact this person.
0 - 255 characters
less important
oraNamesTNSState
simple string
TimeTicks
read-write
Indicates the amount of time (in centiseconds) until this server reloads. This variable can be used to automatically reload this server or show when reload will occur. Reloading enables the server to reread parameter files, network definitions, and reset statistics, for example. When set to 0, the server reloads immediately.
0 - 4294967296 centiseconds
less important
oraNamesConfigTable, oraNamesTNSRunningTime, oraNamesTNSState
stopwatch
Integer32
read-only
Indicates the amount of time (in seconds) that the server has been running. This variable can be used as a statistical baseline for evaluating counters and running averages.
0 - 2147483647
very important
oraNamesServerTable variables
stopwatch
The oraNamesConfigTable contains information on those Oracle Names server configuration parameters that are not included in the oraNamesTNSTable. Monitoring this information is important in order to characterize the operation of the Oracle Names server.
Each entry in the oraNamesConfigTable represents a given active SQL*Net application on the node. Each entry is indexed by applIndex. (For details about applIndex, see Appendix E, "Interpreting Implemented Variables of the Network Services MIB.") The current value of each oraNamesConfigTable variable is retrieved directly from a corresponding field in the NAMES.ORA configuration file on the managed node.
Table C-2 lists each of the variables implemented in this release, together with its corresponding object ID.
* Variables marked with an asterisk are not supported.
Attempts to access these variables may result in errors.
A description of each of these variables follows.
DisplayString
read-write
Indicates the name of the Administrative Region which this server serves. Identifies which area of the namespace is the responsibility of this server and the location of the network definition for the region.
any valid region name
important
none
simple string
TruthValue
read-write
TRUE indicates that this server requires an authoritative answer to system query requests that it generates. FALSE results in faster, but less reliable answers to the server's inquiries. Requests with Authority Required cannot be answered by a non-authoritative server out of its cache.
true/false
less important
oraNamesConfigDomainHints, oraNamesConfigDomains
simple string
TimeTicks
read-write
A running Oracle Names server periodically checks its network definition to see if it has been updated. If a check fails, the Oracle Names server retries for the period of time set in AutoRefreshExpire. In this case, the server continues operation using its current network definition, until it finds it needs to update. The default is 72 hours.
1 minute - ~ 3 months
less important
oraNamesConfigAutoRefreshRetry, oraNamesConfigAdminRegion, oraNamesTNSParameterFile
date/time countdown with knob adjuster, or hourglass with slide adjuster
TimeTicks
read-write
A running Oracle Names server periodically checks its network definition to see if it has been updated. If a check fails, the Oracle Names server retries with the frequency set in AutoRefreshRetry. In this case, the server continues operation using its current network definition, until it finds it needs to update. The default is three minutes.
1 minute - 10 hours
less important
oraNamesConfigAutoRefreshExpire, oraNamesConfigAdminRegion, oraNamesTNSParameterFile
knob or slide (a reostat, for example)
DisplayString
read-write
The Oracle Names server periodically writes its cache to disk and then reads the cache on startup. The value of oraNamesConfigCacheCheckpointFile is the filename of the file to which this cache is written. Any data in this file which is still valid (positive time to live) is retained when the new server is started up.
any legal filename
less important
none
simple string
TimeTicks
read-write
Indicates the amount of time between cache checkpoints. If the value of oraNamesConfigCacheCheckpointInterval is greater than 0, the server writes its cache at the specified frequency. When the server is started again, any foreign data in the cache which is still valid (positive time to live) will be retained. If set to 0 (the default), then checkpointing is disabled, and any foreign data is lost when the server is stopped.
0 - 3 days
less important
oraNamesConfigCacheCheckpointFile, oraNamesTNSParameterFile
simple string
TruthValue
read-write
TRUE indicates that this server is to operate in DEFAULT-FORWARDERS-ONLY mode. A server in this mode must have at least one default forwarder. The server then operates in slave mode, forwarding all foreign requests to at least one default forwarder, whether or not it has server information that might be more accurate. This feature provides for administrative optimization, by presuming that a high percentage of foreign requests are for names in the vicinity of the DefaultForwarders.
FALSE indicates that the server operates normally, that is, foreign requests are passed to subdomain servers if the name should reside there, or to the root.
true/false
less important
oraNamesConfigDefaultForwarders, oraNamesTNSParameterFile
simple string
TruthValue
read-write
Servers that do not forward will not handle the request for clients, but may refer them to other regions. Referral is only possible when the requestor is another names server; regular clients cannot handle referrals. Servers that do not forward cut their work in half (at the exepense of the requestor) by "staying out of the middle." FALSE is the default, and is only intended for regions which have no domain data, typically the root domain. TRUE indicates that this server is willing to forward requests for data for which it is not authoritative.
true/false
important
oraNamesTNSParameterFile
simple string
TruthValue
read-write
TRUE indicates that this server desires other servers to forward requests which this server generates on its own. Requests which this server forwards have Forwarding Desired set by the original requestor. This server can reduce its load by a factor of the number of hops to an authoritative server if the intermediate servers are willing to forward the request, rather than refer the requestor to the next-nearest server.
true/false
less important
oraNamesTNSParameterFile
simple string
TimeTicks
read-write
Indicates the interval (in centiseconds) at which server statistic counters (a subset of Oracle Names MIB variables) are written to the log file. The default is 0, indicating that no variables are logged.
0 - 1 day
less important
oraNamesTNSLogFile, oraNamesTNSParameterFile
simple string
Integer32
read-write
The server keeps a count of the number of times a given forwarded query returns with a referral to a closer name server. When the number of referrals exceeds oraNamesConfigMaxReforwards, the query is cancelled and an error is returned to the requestor. Higher settings make the server more persistent in resolving failed queries; lower settings will save the server time and reduce traffic (probably trivial).
1 - 15
less important
oraNamesTNSParameterFile
simple string
TruthValue
read-write
When this value is set "ON", the server refuses any requests to modify its region data.
true or false
Less important. Not relevant to version 2.2 of Oracle Names. When insert, update, and delete support are added in subsequent versions, this variable will enable and disable the modification of region data.
oraTNSParameterFile
simple string
TimeTicks
read-write
Indicates the interval (in centiseconds) at which all server statistic counters are reset back to zero. This parameter enables administrators to automatically reset all MIB statistics at a specified frequency without disrupting the operation of the server. If set to 0, statistics are never reset.
0 or 10 - 4294967295 centiseconds
less important
oraNamesConfigLogStatsInterval, oraNamesTNSParameterFile
simple string
DisplayString
read-only
Indicates this server's name, as defined in the Network definition. Every service has a unique domain-qualified name.
any valid service name
important
oraNamesTNSParameterFile
simple string
The oraNamesServerTable contains variables which describe the current operational status of the Oracle Names server. Monitoring these measures is important to ensure that the server is up and fully functional.
Each entry in the oraNamesServerTable represents a given active Oracle Name Resolution Server on the node. Each entry is indexed by applIndex. (For details about applIndex, see Appendix E, "Interpreting Implemented Variables of the Network Services MIB.") The current value of each oraNamesServerTable variable is retrieved from internal tables of this Oracle Names server.
Table C-3 lists each of the variables implemented in this release, together with its corresponding object ID.
* Variables marked with an asterisk are not supported.
Attempts to access these variables may result in errors.
A description of each of these variables follows.
Counter32
read-only
Indicates the number of query requests received by this server. Serves as an indicator of the overall load on this server.
0 - 4294967295
very important
oraNamesServerLastNnamesNotFound,
oraNamesServerQueriesTotalTime
rolling counter
TimeTicks
read-only
Indicates the total time spent processing query requests (in centiseconds), including the time it takes to forward the request and get an answer. In the current version (2.2), this represents all of the server's primary activity. When delete/rename/update are supported, this variable describes the query processing load relative to the load from requests of the other three types.
0 - 4294967295 centiseconds
important
oraNamesServerQueriesReceived
simple string
Counter32
read-only
Indicates the number of corrupted messages this server has received. A corrupt message indicates either that a bug exists in the client or network transport, or that the caller does not intend to be calling an Oracle Names server (wrong number). The second cause is more likely, and indicates configuration inconsistencies.
0 - 4294967295
important
very important
rolling counter
Counter32
read-only
Indicates the number of responses of all sorts this server has sent. This variable is a good general indicator of the cumulative load. The number of responses should equal the sum of the requests received.
0 - 4294967295
very important
oraNamesServerDeletesReceived, oraNamesServerQueriesReceived, oraNamesServerRenamesReceived
rolling counter
Counter32
read-only
Indicates the number of alias loops this server has detected. Alias loops are the result of improperly defined sets of domain data in two or more regions. Any alias loops should be corrected immediately.
0 - 10
important
none
warning light for any non-zero value.
Counter32
read-only
Indicates the query load (number of name lookup operations) this server has performed.
0 - 4294967295
very important
oraNamesServerCreatedOnLookup, oraNamesSeerverExactMatches oraNamesServerLookupFailures
rolling counter
Counter32
read-only
Indicates the number of names created on lookup because they were not found. Cache entries are created whenever the server receives a query for a certain name for the first time. This value represents the degree of diversity of queries to foreign regions. Higher values might indicate the need for tuning.
0 - 4294967295
important
oraNamesServerLookupsAttempted
rolling counter
Counter32
read-only
Indicates the number of name lookups for a name not known to this server. Frequent lookup failures might indicate configuration inconsistencies, in that clients are looking for names in undefined domains.
0 - 4294967295
important
oraNamesServerLookupsAttempted
rolling counter
Counter32
read-only
Indicates the "hit rate," that is the number of name lookups resulting in an exact match with information known to this server. This value includes both queries for local region data and queries for foreign names which have already been cached.
0 - 4294967295
important
oraNamesServerLookupsAttempted, oraNamesServerLookupFailures
rolling counter
Counter32
read-only
Indicates the number of forwarded requests which failed because no servers responded to the request. A high value indicates either that the names servers for some other regions are down, or that this server's topology data is incorrect.
0 - 4294967295
important
oraNamesServerRequestsForwarded
rolling counter with siren
Counter32
read-only
Indicates the number of requests this server has forwarded which timed out waiting for a response. The cause might either be a high processing load at the foreign server, or some network-related delay.
0 - 4294967295
important
oraNamesServerRequestsForwarded
rolling counter with siren
Counter32
read-only
Indicates the number of responses this server has received. This value should match the number of requests forwarded, minus oraNamesServerForwardFailures and oraNamesServerForwardTimeouts.
0 - 4294967295
important
oraNamesServerRequestsForwarded
rolling counter
Counter32
read-only
Indicates the number of requests that this server has forwarded because it is not authoritative for the requested name.
0 - 4294967295
important
oraNamesServerForwardFailure, oraNamesServerForwardTimeout, oraNamesServerErrorResponsesReceived
rolling counter
Counter32
read-only
Indicates the number of times this server has failed in a check to see whether the region data changed and needs reloading. Indicates that the source for this server's network definition is unavailable. These failures are likely to be innocuous, but could be the result of inaccurate configuration information for this Oracle Names server.
0 - 4294967295
important
oraNamesConfigAdminRegion, oraNamesServerAdminRegionDescription
rolling counter with siren
DisplayString
read-only
Indicates this server's name, as printed in its start-up banner.
any valid server name
important
none
simple string
DisplayString
read-only
This is a description that defines the server's region. It includes the region name and the location of its network definition.
any valid region name
important
oraNamesConfigAdminRegion
simple string