Oracle TCPS

Learn how to establish a connection to a secure Oracle database.

If the oozie_database_is_secure property is enabled, then the JDBC URL generated for Oracle looks like:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=<HOST>)(PORT=<PORT>))(CONNECT_DATA=(SERVICE_NAME=<DB_NAME>)))

The values of <HOST>, <PORT>, and <DB_NAME> come from the following Oozie properties set in Cloudera Manager:

<HOST> and <PORT> – oozie_database_host
<DB_NAME> – oozie_database_name

While the above specifies the protocol as TCPS, this JDBC URL on its own might not be enough to establish a connection to a secure Oracle database. If you need to specify a trustStore, keyStore, or Oracle wallet properties for the connection, use the oozie_database_connection_properties and/or oozie_datasource_properties properties.

For example,

Oracle TCPS

We want your opinion

How can we improve this page?