Connecting toad to oracle cloud database 19C

[msfaiz2011]

How to connect oracle cloud database 19C through toad

[Gary.Jerep]

These other ToadWorld posts should help:

TOAD connection to Oracle Cloud Autonomous Database using Wallet

There are two possibilities that I know of to get this to work. The first is to get a "Regional wallet" from Oracle Cloud Infrastructure (OCI) from your autonomous transaction processing (ATP) database, put that on your local workstation, and update your sqlnet.ora to reflect the path to the regional wallet. The regional wallet will work for the ATP's you have defined in your region and you won't need an individual Instance Wallet. The trade off is the same as the benefit, a single wallet ope…

How to connect to an Oracle Cloud Database

Aug 25, 2015 1:36:00 PM by John Dorlon This is a companion discussion topic for the original entry at https://blog.toadworld.com/how-to-connect-to-an-oracle-cloud-database#:~:text=The%20other%20way%20to%20connect,PuTTY%20and%20run%20putty.exe.&text=b)%20On%20the%20left%2C%20under,node%20and%20click%20%22Auth%22.

[msfaiz2011]

Hi Mr Gary .Jerep

      Iam not asking for autonomous database , i have EBS instance 12.2 and database is 19C and os is oracle linux 7.5 which is running on OCI, so please any one have solution how to connect the instance thro toad.

[JohnDorlon]

There is not a one-size-fits-all answer to this, but the short answer is this:

Set up your Oracle client so that you can connect to your DB using SQL*Plus. Then Toad will connect.

You may have to use a wallet. You may have to open a tunnel with something like PuTTY. You probably will have to edit your tnsnames.ora.

[msfaiz2011]

Thanks John ,now iam successfully connected to oracle cloud instance.