Toad World® Forums

Unable to see instant client and connect in TOAD

TOAD 12.12.0.39

DBaas 12.2

Instant Client: 12.2 for 64bit

We are connecting to our Oracle Cloud database, using Instant Client.

This has been working well for months since I installed Instant lient and suddenly this morning, I get the error message: "c:\oracle\instantclient_12_2" does not exist (see image below)

  • Instant client has been installed appropriately C:\Oracle\instantclient_12_2
  • PATH variable has been set up appropriately
    I've already removed and re-installed Instant Client. I'm hoping I won't have to re-install Toad. Is there anything else that I should be checking that might have got corrupted?

Thanks for the help

Annelize

IC.png

After some more digging, I found that I was missing the system Variable TNS_ADMIN and have now set that to the path of my instant client.

However, I am still not able to connect - the message is sqlnet.ora file could not be located. Why is it looking for a .ora file if I am connecting with Isntant Client? We have a cloud database....

I would disregard the “does not exist” and the message that sqlnet.ora could not be located for now. Looking at the code for Toad’s connection error advice it could use a little tweaking when you’re using direct connect like that.

The ORA-12170 error is what I would focus on. Did you try tnsping? It seems that there is a problem getting to the database. Can you connect with SQL*Plus?

Michael

Thank you Michael, we’ve just figured out that it’s a firewall issue. I couldn’t connect to our database via SQL Developer either.