Oracle® Enterprise Manager Configuration Change Console User's Guide 10g Version 10.2.0.4 for Windows or UNIX Part Number E12913-01 |
|
|
PDF · Mobi · ePub |
The following section lists the connection parameters used on the Update Internal Configuration screen for specific rule sets. These rule sets require specific connection parameters for agents to perform monitoring.
The following sections describe the various snapshot modules available in Configuration Change Console.
For the Active Directory (Snapshot) rule set the following connection parameters are displayed:
ldap.url -- URL used to connect to the Active Directory server, where ip is the ip address of the Active Directory server, and port is the port number used for access, in the format:
ldap://<ip>:<port>
If the agent is running on the Active Directory server use the default value of ldap://127.0.0.1:389
(localhost)
ldap.user -- Username used to connect to the Active Directory server. Username should be in the format username@domain
ldap.password -- Password used to connect to the Active Directory server
ldap.password (Verify) -- Used to re-type the password entered in the Password field for verification purposes
template.base -- The root location of the query used to retrieve information by the application template. You can use the tempate.base to narrow what information is monitored
The template.base value should be in entered in the format of DC=<node element> for all node values. If the node name features a period (. ) you will need to add an additional DC=<node element> marker, separated by a comma ( , ) for each string following a period. Note that the period itself is not included. For example, if you wish to specify domain/base node activereasoning.com as the template.base value you would enter the following in the template.base field:
DC=activereasoning,DC=com
For the Oracle 8i (Snapshot) and Oracle 9i (Snapshot) rule sets, the following connection parameters are displayed:
Connection URL -- URL used to connect to the database in the following format where host/ip is the hostname or ip address used to connect to the database, port is the port number used to connect to the database, and sid is the service name/id of the database:
jdbc:oracle:thin:@<host/ip>:<port>:<sid>
Username -- Username used to connect to the database
Password -- Password used to connect to the database
Password (Verify) -- Used to re-type the password entered in the Password field for verification purposes
Include Schemas/Databases -- Designates specific schemas/databases to monitor. Only those specified will be monitored. Multiple schemas/databases should be separated by commas. Note that this field is case sensitive
Baseline Interval -- Hour + offset, Day + offset, Week + offset, Month + offset, where offset is a positive integer
Max Rows Returned -- A positive integer
For the SQL Server (Snapshot) rule sets, the following connection parameters are displayed:
Connection URL -- URL used to connect to the database in the following format where ip is the ip address of the SQL server, and port is the port number used for access:
jdbc:jtds:sqlserver://<ip>:<port>
Username -- Username used to connect to the database
Password -- Password used to connect to the database
Password (Verify) -- Used to re-type the password entered in the Password field for verification purposes
Include Schemas/Databases -- Designates specific schemas/databases to monitor. Only those specified will be monitored. Multiple schemas/databases should be separated by commas. Note that this field is case sensitive
Baseline Interval -- Hour + offset, Day + offset, Week + offset, Month + offset, where offset is a positive integer
Max Rows Returned -- A positive integer
The following sections describe the various SQL Trace modules available in Configuration Change Console.
For the SQL Sever 2000 (SQL Trace) rule set, the following connection parameters are displayed:
Connection URL -- URL used to connect to the database, in the following format where ip is the ip address of the sql server, and port is the port number used for access:
jdbc:jtds:sqlserver://<ip>:<port>
Username -- Username used to connect to the SQL Server 2000 database. Note that this user must have sysadmin privileges
Password -- Password used to connect to the database
Password (Verify) -- Used to re-type the password entered in the Password field for verification purposes
The following section describes the Trace module available in Configuration Change Console.
The following sections describe the various SQL Audit modules available in Configuration Change Console.
For the SQL Server (SQL Audit) rule set, the following connection parameters are displayed:
Connection URL -- URL used to connect to the database in the followign format where ip is the ip address of the SQL server, and port is the port number used for access:
jdbc:jtds:sqlserver://<ip>:<port>
Username -- Username used to connect to the database
Password -- Password used to connect to the database
Password (Verify) -- Used to re-type the password entered in the Password field for verification purposes
For the SQL Sever 2000 (SQL Audit) rule set, the following connection parameters are displayed:
Connection URL -- URL used to connect to the database, in the following format where port is the port number used for access:
jdbc:jtds:sqlserver://localhost:<port>
Username -- Username used to connect to the SQL Server 2000 database. Note that this user must have sysadmin privileges
Password -- Password used to connect to the database
Password (Verify) -- Used to re-type the password entered in the Password field for verification purposes