Navigate to the Oracle cartridge agent library directory (cd. {fglam location}\agents\Oracle\{cartridge version}\lib
Run the connection utility batch file (e.g. oracle-connection-test-5.7.5.50-bat.bat or .\oracle-connection-test-5.7.5.41-ksh.ksh)
Enter the path location for the Foglight java home when the bin folder is located (e.g. {foglight}\jre)
Users will be presented with the following options.
Oracle Connection Test:
1. Oracle Connection
2. SSH Connection
3. WMI Connection
4. WinShell Connection
5. VMWare Connection
6. Exit
Select the option corresponding to the connection being tested.
As examples:
To test an Oracle Database Agent connection, select option 1
- Create a subfolder called "test" in the lib folder
- Enter the hostname, then press Enter
- Enter the DB_Instance name and press Enter
- Enter the port and press Enter, or press Enter to use default port 1521
- Enter a 1 or 2 for the Authentication type (1 SID, 2 Service Name)
- Enter the DB Username, and press Enter
- Enter the DB Password, and press Enter
- Enter a 1, 2, or 3 for the SQL Query to test (1 None, 2 SQL, 3 File)
- Enter the Connection Time Out in seconds, and press Enter
- Enter a 1 or 2 to run in a separated thread (1 No, 2 Yes)
To test a WMI connection using the Agent Manager services, select option 3
- Enter the target hostname, then press Enter
- Enter the FglAM hostname, then press Enter
- Enter the Agent name, then press Enter
- Enter the RMI port and press Enter, or press enter to accept the default
- Enter a WMI query to test and press Enter, or press Enter to accept the default query
- Enter a Connection TimeOut value in seconds, then press Enter
To test a WinShell connection using JInterop (this requires Windows registry permissions), select option 4
- Enter the target hostname, then press Enter
- Enter the FglAM hostname, then press Enter
- Enter the Agent name, then press Enter
- Enter the RMI port and press Enter, or press enter to accept the default
- Enter a test script to test and press Enter, or press Enter to accept the default
- Enter a Connection TimeOut value in seconds, then press Enter