Location Connection for Oracle - DSS 6 | Data Source Solutions Documentation

Documentation: Location Connection for Oracle - DSS 6 | Data Source Solutions Documentation

Location Connection for Oracle

This section describes the connection details required for creating Oracle location in Data Source Solutions DSS. 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 DSS 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 the Oracle Database using a local connection. For more information about connection methods, see Connecting to Oracle Database or ASM Instance section.
SID	Unique name identifier of the Oracle instance/database. Example: ORA1900	Oracle_SID
Oracle TNS	Connect to the Oracle Database using a TNS (Transparent Network Substrate) connection. For more information about connection methods, see Connecting to Oracle Database or ASM Instance section.
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 DSS 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 DSS to the Amazon RDS for Oracle database.	Database_User
PASSWORD	Password of the USER for connecting DSS 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 DSS to the primary database.	Oracle_Dataguard_Primary_User
PASSWORD	Password of the USER for connecting DSS 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 SERVICE `Since 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 DSS to the CDB.	Oracle_Container_Root_User
ROOT CONTAINER PASSWORD	Password of the ROOT CONTAINER USER for connecting DSS 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: dss-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: DSS1900	Agent_Oracle_RAC_Service
AGENT HOST	Hostname or IP-address of the server on which the DSS agent is installed/running.	Agent_Host
AGENT PORT	TCP/IP port number of the DSS agent on the RAC nodes.	Agent_Port
AGENT USER	The operating system username for the RAC nodes where the DSS agent is running.	Agent_User
PASSWORD	The password for the operating system user account.	Agent_Password