Use this Knowledge Script to update the list of Oracle databases/instances on each UNIX host.
NOTE:This script cannot be run to update environments in all cases. If you do not use a listener.ora file to maintain listener information, or if you install a new Oracle version on the host, we recommend that you log in to the host and run the ckoracle utility. This utility will prompt you to enter required information for newly added or deleted Oracle databases/instances.
Oracle Database folders. When you drop a script on an Oracle Database folder, a job executes on that database and monitors only that database.
NOTE:You must run the Discovery_OracleUNIX script after running the UpdateInstances script to pick up any changes in the environment.
If databases have been deleted, you must delete the Oracle UNIX objects from the TreeView. This cannot be done by the module or AppManager itself.
The default interval for this script is Run Once.
Set the following parameters as needed:
|
Description |
How to Set It |
|---|---|
|
Required Parameter(s) |
|
|
Oracle Home to use as the client (usually newest Oracle version) |
Specify the Oracle Home directory that should be used as the client. If multiple versions of Oracle RBDMS are installed on the host, this is usually the Oracle Home directory of the newest version of Oracle. The default is blank. |
|
Optional Parameter(s) |
|
|
Location of sqlnet.ora, listener.ora, tnsnames.ora (TNS_ADMIN) |
Specify the directory where the Oracle Net/Net 8 files reside (such as the tnsnames.ora, listener.ora, and sqlnet.ora). It is only necessary to set this parameter when the files are not in the default location for each Oracle Home ($ORACLE_HOME/network/admin). The default is blank. |
|
Oracle Username |
Enter the username that OracleUNIX jobs will use for authentication with Oracle RDBMS during execution. This username will be passed to the NetIQ Security Manager. To use SYSDBA authentication, leave this parameter blank. The default is blank. |
|
Password for the Oracle Username |
Specify the password for the Oracle Username specified in the previous parameter. This password will be encrypted and passed to the AppManager Security Manager along with the Oracle username. The default is blank. |
|
Are all databases using the same listener? |
Select Yes if one listener is being used on the UNIX host, then specify the details of that listener below. The default is unselected. |
|
Name of listener |
Specify the name of the listener that is being used on the UNIX host. This parameter is only used when you set the Are all databases using the same listener? parameter to Yes. The default is LISTENER. |
|
Port used by listener |
Enter the port number of that the listener is listening on for the UNIX host. This parameter is only used when you set the Are all databases using the same listener? parameter to Yes. The default is 1521. |
|
Raise event if error occurs updating instances? |
Select Yes to raise an event when an error is detected while attempting to update the list of Oracle instances.The default is Yes. |
|
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event for successfully setting the monitoring options. The default is 10 (red event indicator). |
|
Raise event with current instance info if successfully updated? |
Select Yes to raise an event with the information collected on Oracle instances on the host during the update. The default is unselected. |
|
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event for successfully setting the monitoring options. The default is 40 (magenta event indicator). |