Oracle Database (also known as Oracle RDBMS) is a multi-model relational database management system developed and marketed by Oracle Corporation.
Supported platforms
-
Unix
-
Linux
-
Widows
-
AWS RDS
-
OCI DBaaS on Bare Metal
-
OCI DBaaS on VM
Supported versions
-
11.2
-
12c
-
12cR
-
18c
-
19c
-
21c
Supported features
| Mode |
Feature |
Availability |
|---|---|---|
| Security |
TLS/SSL |
Available |
|
Password Vault |
Available |
|
|
Kerberos |
Available |
|
| In-place masking |
Multi-tenant |
Available |
|
Streams/Threads |
Available |
|
|
Batch Update |
Available |
|
|
Drop Indexes |
Available |
|
|
Disable Triggers |
Available |
|
|
Disable Constraints |
Available |
|
|
Identity Column Support |
Available |
|
| On-the-fly masking |
Truncate |
Available |
|
Disable Triggers |
Available |
|
|
Disable Constraints |
Available |
|
| Profiling |
Multi-tenant |
Available |
|
Streams |
Available |
TLS/SSL setup instructions
To enable TLS/SSL connectivity with an Oracle connector:
-
Add the database’s certificate to the setup application. Follow instructions in the Adding a Certificate section under the TrustStore settings page.
-
Restart the Delphix Continuous Compliance engine.
-
Create an Oracle connector in Continuous Compliance Engine with JDBC URL, similar to below examples, depending upon the Oracle database and certificate configuration.
SSL connection with BASIC Oracle connector is not supported.jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=servername)(PORT=2484))(CONNECT_DATA=(SERVICE_NAME=servicename))) jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=servername)(PORT=2484))(CONNECT_DATA=(SID=SID_NAME))) jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=servername)(PORT=2484))(CONNECT_DATA=(SID=SID_NAME))(SECURITY=(SSL_SERVER_CERT_DN="CN=<certificate cn_name>")))