Connecting to Oracle Autonomous Database
Once the Autonomous Database is created on Oracle cloud, then you can download the client credentials zip file. You will need the admin userid and password to perform this download. Unzip the client credentials zip file on endpoint where it will be used, which most likely will be FlexDeploy server as we generally use localhost endpoint for JDBC activities. For example, /home/flexdeploy/.wallets/<wallet zip name> is location where specific wallet file was unzipped. Make sure to secure this folder to FlexDeploy and/or Endpoint user, so that it is not readable by all users.
- Database URL Syntax : jdbc:oracle:thin:@service_high?TNS_ADMIN=/home/flexdeploy/wallets/<extracted wallet zip folder name>
- service_high is one of the entries in the tnsnames.ora file where client credentials zip file was unzipped
- TNS_ADMIN value in URL points to the location of the unzipped client credentials zip file
- Database URL Long Connection String Format Syntax : jdbc:oracle:thin:@(description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=<hostname>))(connect_data=(service_name=<serice_name>))(security=(ssl_server_cert_dn="CN=<hostname>,OU=Oracle BMCS US,O=Oracle Corporation,L=Redwood City,ST=California,C=US")))
- Examples for the same can be found here