SSH connection on Oracle Cloud Service

[Philippe Malera]

Is there a way to connect to an Oracle Cloud database, where an SSH connection is required?
In Oracle SQL Developer, there is an "SSH Host" window where we can configure this, do we have something similar in "PL-SQL Developer".
More info here:

 

[Marco Kalter]

You will have to configure Oracle Net for this. See also this link:
https://docs.oracle.com/cloud/lates...233-9793-47EC-8DFC-AFD6CF32866C.htm#CSDBI3449

 

[Philippe Malera]

Thanks

 

[PLSQLDevWorld]

Hi Can you please advise if above has worked? Are you able to connect to Oracle Cloud Database using PLSQL Developer? If so can you please share step by step process?

 

[PLSQLDevWorld]

Hi Marco

Can you please provide some step by step guide if I can connect to oracle instance in aws cloud please?

 

[PLSQLDevWorld]

Hey Guys

Can you please help? I need to know if we can connect to Oracle instance in cloud using the PLSQL Developer?

@Marco

Can you please advise?

 

[patch]

If you put something like this
---
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = )))(CONNECT_DATA =(SERVER = DEDICATED) (SERVICE_NAME = ) ) )
---
in the database field of the OracleLogon screen, then you should be ok.
At least, this used to work ;-)

 

[Valentino]

When using the Always Free Cloud, go to the database page and select DB Connection and download the Wallet to a secure location. Extract the items from the zip file to where your TNSnames file is located after copying the current files in this location to a backup folder.

You probably don't need all the files from the Wallet zip...Don't forget to merge the 2 TNSnames files as needed.

Open PL/SQL Developer and log in.

At least this worked for me.

 

[Frank Huijbreghs]

This last post from Valentino did not work for me.
I downloaded the wallet zip file, unzipped it into my default tnsnames location.

These are the files:
cwallet.sso
ewallet.p12
keystore.jks
ojdbc.properties
sqlnet.ora
tnsnames.ora
truststore.jks

Starting PL/SQL Developer and logging in gives me ORA-12560
In Oracle SQL Developer the wallet zip file works.

What am i doing wrong?

 

[Emoracle]

a little bit late, but for the community:

- in the sqlnet.ora you have to set the wallet_path to the correct directory

- You need a client version 12 and further

When I tested with an Oracle 11 XE Home it didnt work.
When I set the oci.dll by hand to my 12.2 instant client, disabling autodetection, I was able to connect to my free autonomous transaction database... Yeah!