1. Download the Oracle JCE 8 files.
You can download the Oracle JCE 8 policy files from the following website:
2. Replace the files in the following directory on the Secure Agent machine: <AGENT_HOME>\jre\lib\security\
3. Restart the Secure Agent.
1. Extract the certificate bundle zip file that contains the keystore (ewallet.p12) and truststore (truststore.jks) files.
Note: Ensure that the trust store and key store files are in the PKCS12(.p12) format.
2. Run the following command to convert the existing truststore.jks file into a truststore.p12 file.
keytool -importkeystore -srckeystore truststore.jks -destkeystore truststore.p12 -srcstoretype JKS -deststoretype
PKCS12 -deststorepass [PASSWORD_FOR_NEW_PKCS12_TRUSTSTORE]
3. Enter the source trust store password when prompted.
Runtime environment that contains the Secure Agent used to access Oracle Autonomous Data Warehouse Cloud.
User name for the database login. The user name cannot contain a semicolon.
Password for the database login. The password cannot contain a semicolon.
Name of the machine that hosts the database server.
Network port number used to connect to the database server. Default is 1521.
Service name or System ID (SID) that uniquely identifies the Oracle database.
Specify the SID in the following format to connect to Oracle databases: SID:<ORACLE_SID>
Schema used for the Oracle connection.
The code page of the database server.
The method that the Secure Agent uses to encrypt the data exchanged between the Secure Agent and the database server. Select SSL Auto
as the encryption method.
Not applicable when you use the Hosted Agent.
Crypto Protocol Version
Cryptographic protocols to use when you enable SSL encryption.
Validate Server Certificate
Validates the certificate that is sent by the database server. If you specify the HostNameInCertificate parameter, Secure Agent also validates the host name in the certificate. Select True to validate the server certificate.
The location and name of the trust store file. You must specify the absolute path of the truststore (truststore.p12) file.
Trust Store Password
The password to access the contents of the trust store file.
Host Name in Certificate
Optional. Host name of the machine that hosts the secure database.
If you specify a host name, the Secure Agent validates the host name included in the connection with the host name in the SSL certificate.
[use CN value from tnsnames.ora file as the hostname in certificate]
The location and the file name of the key store. You must specify the absolute path of the keystore (ewallet.p12) file.
Key Store Password
The password for the key store file required for secure communication.
The password for the individual keys in the key store file required for secure communication. Applicable when individual keys in the key store file has a different password than the key store file.
The following image shows the configured Oracle connection properties to connect to Oracle Autonomous Data Warehouse Cloud:
What can we do to improve this information (2000 or fewer characters)