When creating a custom data source, use the appropriate Database Name format and Host Name format for your DB System database version and type.

12c / VM

Database Name <pdb_name>.<db_domain>
Host Name <db_hostname>-scan.<db_domain>

12c / Bare Metal

Database Name <pdb_name>.<db_domain>
Host Name <db_hostname>.<db_domain>

11g / VM

Database Name <db_unique_name>.<db_domain>
Host Name <db_hostname>-scan.<db_domain>

11g / Bare Metal

Database Name <db_unique_name>.<db_domain>
Host Name <db_hostname>.<db_domain>


The resulting URL based on your database version and type are:

12c / VM

jdbc:oracle:thin:@//<db_hostname>-scan.<db_domain>:<db_port>/<pdb_name>.<db_domain>

12c / Bare Metal

jdbc:oracle:thin:@//<db_hostname>.<db_domain>:<db_port>/<pdb_name>.<db_domain>

11g / VM

jdbc:oracle:thin:@//<db_hostname>-scan.<db_domain>:<db_port>/<db_unique_name>.<db_domain>

11g / Bare Metal

jdbc:oracle:thin:@//<db_hostname>.<db_domain>:<db_port>/<db_unique_name>.<db_domain>