Location Connection for Oracle
This section describes the connection details required for creating Oracle location in Fivetran HVR. For information about the pre-requisites, access privileges, and other configuration requirements for creating Oracle location, see Oracle Requirements.
If the managed secrets feature is enabled, option USE TOKEN INSTEAD is displayed in the fields designated for entering secrets.
| Field | Description | Equivalent Location Property |
|---|---|---|
| ORACLE_HOME | Directory path where either Oracle or the Oracle client is installed. When connecting to an Oracle instance through an HVR Agent installed on the database server, this field should point to the ORACLE_HOME directory of the Oracle source database.In all other cases, it should point to the directory where an Oracle client is installed. Example: D:\oracle or distr/oracle | Oracle_Home |
| Local connect to database | Connect to Oracle database using local connection. | |
| SID | Unique name identifier of the Oracle instance/database. Example: ORA1900 | Oracle_SID |
| Oracle TNS | Connect to Oracle database using TNS (Transparent Network Substrate). | |
| ORACLE TNS | Connection string for connecting to the Oracle database using TNS. The format for the connection string is host:port/service_name. Alternatively, you can add the connection details into the clients tnsnames.ora file and use that net service name in this field. This method requires easy connect enabled | Oracle_TNS |
| USER | Username for connecting HVR to the Oracle database. | Database_User |
| PASSWORD | Password of the USER. | Database_Password |
- If creating an Oracle location with Active Data Guard, the above connection parameters are required for connecting to the standby database. The connection parameters for the primary database is available in section Connection Parameters for Data Guard below.
- If creating an Oracle location with pluggable database (PDB), the above connection parameters are for connecting to the PDB. And, the connection parameters for the container database (CDB) is available in section Connection Parameters for Container Database below.
- If creating an Amazon RDS for Oracle location, ignore the above connection parameter description instead see section Connection Parameters for Amazon RDS for Oracle below.
- For connecting to Oracle RAC, see section Connection Parameters for Oracle RAC below.
Connection Parameters for Amazon RDS for Oracle
Following are the connection parameters required for connecting to Amazon RDS for Oracle:
| Field | Description | Equivalent Location Property |
|---|---|---|
| ORACLE_HOME | The ORACLE HOME path of the EC2 instance. | Oracle_Home |
| Oracle TNS | Connect to Oracle database using TNS (Transparent Network Substrate). | |
| ORACLE TNS | The connection string for connecting to the RDS database. The format for the connection string is AWS_Endpoint:Port/DB_Name. Alternatively, the connection details can be added into the client's tnsnames.ora file and specify that net service name in this field. | Oracle_TNS |
| USER | Username for connecting HVR to the Amazon RDS for Oracle database. | Database_User |
| PASSWORD | Password of the USER for connecting HVR to the Amazon RDS for Oracle database. | Database_Password |
Connection Parameters for Data Guard
Following are the connection parameters required for connecting to primary database (in Step 4. Configure Capture/Integrate):
| Field | Description | Equivalent Location Property |
|---|---|---|
| DATA GUARD PRIMARY TNS | TNS connection string for connecting to the primary database. The format for the connection string is host:port/service_name. | Oracle_Dataguard_Primary_TNS |
| USER | Username for connecting HVR to the primary database. | Oracle_Dataguard_Primary_User |
| PASSWORD | Password of the USER for connecting HVR to the primary database. | Oracle_Dataguard_Primary_Password |
Connection Parameters for Container Database
Following are the connection parameters required for connecting to container database:
| Field | Description | Equivalent Location Property |
|---|---|---|
ROOT CONTAINER RAC SERVICESince v6.1.0/27 | Service name of the Oracle database for the root container. | Oracle_Container_Root_RAC_Service |
| ROOT CONTAINER TNS | Connection string required for connecting to the CDB. The format for the connection string is host:port/service_name. | Oracle_Container_Root_TNS |
| ROOT CONTAINER USER | Username for connecting HVR to the CDB. | Oracle_Container_Root_User |
| ROOT CONTAINER PASSWORD | Password of the ROOT CONTAINER USER for connecting HVR to the CDB. | Oracle_Container_Root_Password |
Connection Parameters for Oracle RAC
Following are the connection parameters required for connecting to Oracle RAC (in Step 2. Select Agent Connection):
| Field | Description | Equivalent Location Property |
|---|---|---|
| ORACLE SCAN ADDRESS | Single Client Access Name (SCAN) DNS entry which can be resolved to IP address. Example: hvr-cluster-scan | Agent_Host |
| ORACLE SCAN PORT | Port number of the Oracle RAC database available on the remote server. | Agent_Oracle_RAC_Port |
| ORACLE SCAN SERVICE | Service name of the Oracle RAC database available on the remote server. Example: HVR1900 | Agent_Oracle_RAC_Service |
| AGENT HOST | Hostname or IP-address of the server on which the HVR agent is installed/running. | Agent_Host |
| AGENT PORT | TCP/IP port number of the HVR agent on the RAC nodes. | Agent_Port |
| AGENT USER | The operating system username for the RAC nodes where the HVR agent is running. | Agent_User |
| PASSWORD | The password for the operating system user account. | Agent_Password |