Submit a ticketCall us

Welcome to the NEW Success Center. Search all resources (documentation, videos, training, knowledge base articles) or browse resources by product. If you are unable to find what you are looking for, please contact us at customersuccess@solarwinds.com

 

 

 

 

Home > Success Center > ipMonitor > Monitor Oracle databases

Monitor Oracle databases

Table of contents
No headers

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

  1. Download and install the Oracle OLE DB Provider on the ipMonitor host machine.
  2. After installing the Oracle Provider, run the Oracle Net Configuration Assistant in Start > Oracle > Configuration and Migration Tools > Net Configuration Assistant.
  3. Select the Local Net Service Name Configuration option, and then click Next.
  4. Select the Add option, and then click Next.
  5. 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.
  6. In the Protocol box, select the protocol used for database access, typically TCP, and then click Next.
  7. In the Host name box, enter the host name of the database computer.
  8. If your database communicates on port 1521, select Use the standard port number of 1521, and then click Next.
  9. If your database communicates on a different port, select Use another port number, enter the new port number, and then click Next.
  10. After you are prompted to perform a connection test, select the Yes, perform a test option.
  11. 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.
Last modified
15:24, 13 Nov 2015

Tags

Classifications

Public