===== Oracle connector =====

==== Purpose ====
  * With the Oracle connector, you can connect to an Oracle database via a JDBC driver.\\
  * The database will then be monitored by querying information from the database with SQL requests
  * To create connector, there are two steps:
    * Create a user profile in the database and register it in Pro.Monitor
    * Create and set connector parameters

==== Create user profile ====
  * User profiles can be created via the Configure menu
  * Once created, the user profile can be selected in the connector form
  * Note: A user profile is by default associated with a company . You can explicitly set a profile to be cross companies. The effect is that it will be selectable from connectors of any companies.
  * The corresponding user must be created in the database as well.

==== Create connector ====
  * Select the system in the Systems tree and select “Add connector” in its contextual menu, choose Oracle type.
  * Fill in the connector parameters:
    * **Title** The display name of the connector
    * **Host:** The hostname or IP address of the database host
    * **Port:** The port of the database service (Default is often 1521)
    * **Database name:** The database to connect to
    * **User:** The user profile to use for the connection
    * **Properties:** Optional properties to add to the connection parameters (separated with semicolon (;)
**Press Save & Test** to save the profile and check the connection is working

{{.:connector_oracle.png}}

==== SSH ====
  * In case you must connect to a database through an SSH tunnel, you can enable the SSH option and fill in the parameter:
    * **Host:** The host where the entrance of the tunnel is created.
    * **Port:** The local port of the SSH tunnel
    * **User:** The user to authenticate on the SSH end point.

==== Custom timeout ====
  * See [[.:common|Custom timeouts]]

{{:products:promonitor:6.7:userguide:configuration:systemsconnectors:pasted:20190304-173746.png}}

==== Authorizations ====
The Oracle monitors will need to peform SELECT queries on the below tables:
  * V$RMAN_BACKUP
  * ALL_ERRORS
  * V$FILESTAT
  * DBA_DATA_FILES
  * v$sysstat
  * ALL_OBJECTS
  * V$LIBRARYCACHE
  * V$RESOURCE_LIMIT
  * V$LOG_HISTORY
  * DBA_FREE_SPACE