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, please use the oozie_database_connection_properties and/or oozie_datasource_properties properties.

For example,