How to connect to autonomous cloud database

rlog

Hi

I am trying to create a new Source Control project connecting to an autonomous database hosted in Oracle Cloud.  In order to connect to this database in (e.g. sql developer) I have to download the client credentials wallet and use that along with the tns entry.

I have tried a manual connection which results in a timeout, and have also tried adding the contents of the .zip wallet download from oracle into my local Oracle network\admin folder, and updating tnsnames.ora to add the connection string, but I still get a timeout.  Any tips?

Thanks

rlog

To add more info, when using TNS connection I have done the following:

1. Checked 'OS/Wallet authentication'
2. Added one of the three (low, medium, high) tns entries into tnsnames.ora from the client credentials download.
3. Added the following two lines to my sqlnet.ora file
   WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="?/network/admin")))
   SSL_SERVER_DN_MATCH=yes
4. Copied cwallet.sso, ewallet, keystore.jks and truststore.jks into the /network/admin folder.

When I run in Redgate Source Control I just get a timeout.

Can anyone help?  This must be a fairly common situation.

Eddie D

Hi, thank you for your forum post.

Sadly, I do not have any experience in configuring an Oracle Wallet.  You have found the option to enable and I understand that the wallet location needs to be entered into the sqlnet.ora file in the network\admin directory of your Oracle Client.

A support ticket has been created for you.  I will send the setup instructions passed to me when support for the Oracle Wallet was first added to Redgate's Oracle tools back in April 2017 via this support ticket.  To my knowledge these instructions have not changed in the period since the above date.

Many Thanks
Eddie

dprkr

Was/is there a resolution to this?  I am having the same problem connecting to autonomous cloud database.  I can connect from SQL developer and sqlcl (using tns) but not from Schema Compare 5

rlog

I still have an open support ticket, hoping to get a resolution in the next few days.

Phil_Factor

I'd be grateful for a solution to this as well.