TSNAMES error in new latest version

Toad for Oracle
1

Good morning, I have updated to the new version of TOAD Oracle
I can't connect to the database.

Toad for Oracle Base Edition (64-bit)
Add-Ons:
17.1.717.3711
Windows 10 64b

tsnames01
tsnames011038×616 24.8 KB

In the Beta version everything is normal and I access without problems

Toad for Oracle Base Edition (64-bit)
Add-Ons:
17.1.717.3711
Windows 10 64b

tsnames01--beta
tsnames01--beta985×570 21.8 KB

2

Do you have a tnsnames.ora file? If so, where is it located?

3

Hi John !
It is my mistake

I already corrected it. I put the tsnames in the path of toad.exe

Thank you

1 Like
4

Hello ccevallos,
Could you please elaborate the steps involved while rectifying this issue?
Even i am facing the same issue.
Please help me.
Thank you in advance.

5

Hi Shivaraj,

I tried to reproduce Carlos's problem but was unable to. Please let me know where your tnsnames.ora file is located.

It should be in one of the following locations:

  1. In the location specified by a TNS_ADMIN environment variable
  2. In the same folder as Toad.exe,
  3. or, if using an Oracle client, in the network\admin folder of your client.

image
image1173×719 33.8 KB

If the file is in one of these locations and Toad is unable to locate your tnsnames.ora, then there is a bug and we need to fix it.

Thanks.

6

First and foremost, I would like to express my gratitude for your prompt and courteous response.
"I'm new to Toad for Oracle and I'm currently setting up a trial version (17.1). I'm reaching out to confirm the appropriate version of Oracle Instant Client Downloads for Windows to install for compatibility. Additionally, if there are any recommended next steps after installation, I'd be grateful for your guidance."

7

You don't need an Oracle client at all if you don't want to use one.

If you do want one, just make sure it is the same bitness (32/64) as Toad.

After that, just make sure that your tnsnames.ora file is in one of the locations mentioned above and then you should be ready to go.

If you have any problems, just let us know.

1 Like
8

Good afternoon!.
I put the tnsnames.ora file in the "C:\Program Files\Quest Software\Toad for Oracle 2024 R1 Edition\Toad for Oracle 17.1" path

1 Like
9

Excuse me, I'm curious about the purpose of the tnsnames.ora file in this context. Could you please clarify what information needs to be included for it to function correctly?

10

This file is not specific to Toad. Its purpose is to help you identify your databases so you can tell client programs like Toad what to connect to.

You can google for information about this file. This result looks pretty good.

https://www.orafaq.com/wiki/Tnsnames.ora

12

Apologies for what may seem like a basic question, as I'm relatively new to this. Could you please assist me?"

error_1
error_11296×1060 153 KB

I have placed the file in the path mentioned above. Could you please confirm if the default username and password are being used? Despite that, an error persists. I have attached the file for your reference.

13

Sorry, I don't know what your username/password values are. Also it looks like the values in your tnsnames.ora file may be incorrect (or the database is just unreachable).

You should talk to the person in your organization who created or knows more about the database that you are trying to connect to.

1 Like
14

Thank you for the information. I'll reach out to someone in my organization familiar with this specific database to ensure the connection details are accurate.