You can monitor Oracle databases with the ADO and the ADO User Experience monitors. These monitors require that the appropriate OLEDB provider for your database be installed on the ipMonitor host computer.
The Oracle OLE DB Provider is available for download from the Oracle website.
You will need:
- The instance name of the Oracle Database you want to monitor.
- A username and password to access the Oracle Database.
- The TCP Port used by the Oracle Database.
To configure the OLE DB connection
- Download and install the Oracle OLE DB Provider on the ipMonitor host machine.
- After installing the Oracle Provider, run the Oracle Net Configuration Assistant in Start > Oracle > Configuration and Migration Tools > Net Configuration Assistant.
- Select the Local Net Service Name Configuration option, and then click Next.
- Select the Add option, and then click Next.
- In the Service Name box, enter the service name of the Oracle database, typically its global database name.the Oracle Database's Service Name. This is typically its Global Database name.
- In the Protocol box, select the protocol used for database access, typically TCP, and then click Next.
- In the Host name box, enter the host name of the database computer.
- If your database communicates on port 1521, select Use the standard port number of 1521, and then click Next.
- If your database communicates on a different port, select Use another port number, enter the new port number, and then click Next.
- After you are prompted to perform a connection test, select the Yes, perform a test option.
- If the connection test fails, you may have entered incorrect login credentials. Click Change Login, and then enter the correct user name and password required to access the Oracle Database.