Difference between revisions of "Oracle Monitoring Subagent"

Oracle Monitoring Subagent (view source)

Revision as of 21:23, 1 April 2012

997 bytes removed , 21:23, 1 April 2012

no edit summary

Victor

AutoPatrol, Bureaucrats, Administrators

683

edits

@@ Line 1: / Line 1: @@
-= Introduction =
+= Summary =
 NetXMS subagent for Oracle DBMS monitoring (hereinafter referred to as Oracle subagent) monitors one or more instances of Oracle databases and reports various crucial database-related parameters.
@@ Line 6: / Line 6: @@
 = Configuration =
+Subagent can be configured using XML configuration file (usually created as separate file in configuration include directory), or in simplified INI format, usually in main agent configuration file.
+== XML configuration ==
 There is a sample Oracle subagent configuration file in XML format:
@@ Line 11: / Line 16: @@
 <config>
 	<agent>
-		<subagent>c:\netxms\bin\oracle.nsm</subagent>
+		<subagent>oracle.nsm</subagent>
 	</agent>
 	<oracle>
@@ Line 34: / Line 39: @@
 You can specify multiple databases in the '''oracle''' section. Each database description must be surrounded by '''database''' tags with the '''id''' attribute. '''id''' can be any unique integer, it instructs the Oracle subagent about the order in which '''database''' sections will be processed.
-Each database description supports the following parameters:
+Each database definition supports the following parameters:
-{| style="border-spacing:0;"
-| style="background-color:#b3b3b3;border-top:0.002cm solid #000000;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:none;padding:0.097cm;"| '''Name'''
-| style="background-color:#b3b3b3;border:0.002cm solid #000000;padding:0.097cm;"| '''Description'''
+{| class="wikitable"
+|-
+! Parameter !! Description !! Default value
+|-
+| Id || Database identifier. It will be used to address this database in parameters. || ''empty''
+|-
+| TnsName || Database TNS name. This is a name for Oracle connect string as described in tnsnames.ora. It can also be instant client connection string. || ''empty''
 |-
-| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:none;padding:0.097cm;"| Id
+| UserName || User name for connecting to database. || ''empty''
-| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:0.002cm solid #000000;padding:0.097cm;"| Database id. It will be used to address this database in DCI parameters
 |-
-| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:none;padding:0.097cm;"| TnsName
+| Password || Database user password. || ''empty''
-| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:0.002cm solid #000000;padding:0.097cm;"| Database TNS name. This is a name for Oracle connect string as described in tnsnames.ora
+|}
-|-
-| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:none;padding:0.097cm;"| Username
-| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:0.002cm solid #000000;padding:0.097cm;"| Database user name.
-|-
+== INI configuration ==
-| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:none;padding:0.097cm;"| Password
-| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:0.002cm solid #000000;padding:0.097cm;"| Database user password.
-|}
 = Provided Parameters =
 The Oracle subagent declares and supports a number of Oracle.* DCI parameters. Almost all of them accept a database id (the one specified in “Id” tag in the subagent configuration file) as the only input parameter (with the exception of Oracle.TableSpaces.* which also take a tablespace name). The all supported DCIs are described below.