Toad 12.7.0.121 : ORA-12154: TNS:could not resolve the connect identifier specified

Toad for Oracle & DevOps Toolkit
1

Toad is installed in a Microsoft Windows 8.1 environment with Oracle 10.2.0.1 client (32 bit).

Message specification :

Items Checked

TNS_ADMIN environment variable is defined as “c:\app\oracle\product\10.2.0\NETWORK\ADMIN”

“c:\app\oracle\product\10.2.0\NETWORK\ADMIN\tnsnames.ora” was located

The following connect descriptor was found for xxx.CSI.IT in the tnsnames.ora file

xxx_yyy.CSI.IT = ( DESCRIPTION = ( ADDRESS = ( PROTOCOL = TCP ) ( HOST = xxx.CSI.IT ) ( PORT = 1550 ) ) ( CONNECT_DATA = ( SID = yyy ) ) )

“c:\app\oracle\product\10.2.0\NETWORK\ADMIN\sqlnet.ora” was located

NAMES.DIRECTORY_PATH specifies TNSNAMES in the sqlnet.ora file

Steps to Take
Try to ping xxx.CSI.IT using the Ping button on the toolbar
Try to TNSPing xxx_yyy.CSI.IT using the TNS Ping button on the toolbar

So :

The ping works ok and so tnsping does.

Toad 12.6.0.53 is installed in the same machine and works very well with no workaround.

What’s the mess with it ?

p.s. one of my colleagues has same stuff with Microsoft Windows 7 Pro environment … other one has not with an old Microsoft Windows XP Pro environment (!!!) [:O]

Any help is accepted… ASAP [:D]

Thanks

2

Are Toad 12.6 and 12.7 both 32 bit? Are they using the same Oracle client?

3

sure … :slight_smile: … that’s what I wrote

4

Tracing the Oracle client … a first file shows that all my tnsnames.ora is loaded in the right way, the second file is :

(1976) [22-JUN-2015 17:11:10:172] — TRACE CONFIGURATION INFORMATION FOLLOWS —

(1976) [22-JUN-2015 17:11:10:173] New trace stream is c:\app\oracle\product\10.2.0\NETWORK\log\cli_1976_1.trc

(1976) [22-JUN-2015 17:11:10:173] New trace level is 16

(1976) [22-JUN-2015 17:11:10:173] — TRACE CONFIGURATION INFORMATION ENDS —

(1976) [22-JUN-2015 17:11:10:173] — PARAMETER SOURCE INFORMATION FOLLOWS —

(1976) [22-JUN-2015 17:11:10:173] Attempted load of system pfile source c:\app\oracle\product\10.2.0\NETWORK\ADMIN\sqlnet.ora

(1976) [22-JUN-2015 17:11:10:173] Parameter source loaded successfully

(1976) [22-JUN-2015 17:11:10:173]

(1976) [22-JUN-2015 17:11:10:173] Attempted load of local pfile source C:\Program Files (x86)\Dell\Toad for Oracle 2015 Suite\Toad for Oracle 12.7\sqlnet.ora

(1976) [22-JUN-2015 17:11:10:173] Parameter source was not loaded

(1976) [22-JUN-2015 17:11:10:173]

(1976) [22-JUN-2015 17:11:10:173] -> PARAMETER TABLE LOAD RESULTS FOLLOW <-

(1976) [22-JUN-2015 17:11:10:173] Successful parameter table load

(1976) [22-JUN-2015 17:11:10:173] -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-

(1976) [22-JUN-2015 17:11:10:173] trace_directory_client = c:\app\oracle\product\10.2.0\NETWORK\log

(1976) [22-JUN-2015 17:11:10:173] NAMES.DIRECTORY_PATH = (TNSNAMES)

(1976) [22-JUN-2015 17:11:10:173] trace_level_client = 16

(1976) [22-JUN-2015 17:11:10:173] SQLNET.AUTHENTICATION_SERVICES = (none)

(1976) [22-JUN-2015 17:11:10:173] trace_unique_client = true

(1976) [22-JUN-2015 17:11:10:173] trace_file_client = cli

(1976) [22-JUN-2015 17:11:10:173] trace_timestamp_client = ON

(1976) [22-JUN-2015 17:11:10:173] — PARAMETER SOURCE INFORMATION ENDS —

(1976) [22-JUN-2015 17:11:10:173] — LOG CONFIGURATION INFORMATION FOLLOWS —

(1976) [22-JUN-2015 17:11:10:173] Log stream will be “C:\Program Files (x86)\Dell\Toad for Oracle 2015 Suite\Toad for Oracle 12.7\sqlnet.log”

(1976) [22-JUN-2015 17:11:10:173] Log stream validation not requested

(1976) [22-JUN-2015 17:11:10:173] — LOG CONFIGURATION INFORMATION ENDS —

(1976) [22-JUN-2015 17:11:10:173] nlstdipi: entry

(1976) [22-JUN-2015 17:11:10:173] nlstdipi: exit

(1976) [22-JUN-2015 17:11:10:173] nigini: entry

(1976) [22-JUN-2015 17:11:10:174] nigini: Count in the NL global area is now 1

(1976) [22-JUN-2015 17:11:10:174] nigini: Count in NI global area now: 1

(1976) [22-JUN-2015 17:11:10:174] nrigbi: entry

(1976) [22-JUN-2015 17:11:10:174] nrigbni: entry

(1976) [22-JUN-2015 17:11:10:174] nrigbni: Unable to get data from navigation file tnsnav.ora

(1976) [22-JUN-2015 17:11:10:174] nrigbni: exit

(1976) [22-JUN-2015 17:11:10:174] nrigbi: exit

(1976) [22-JUN-2015 17:11:10:174] nigini: exit

(1976) [22-JUN-2015 17:11:10:174] niqname: Hst is already an NVstring.

(1976) [22-JUN-2015 17:11:10:174] niqname: Inserting CID.

(1976) [22-JUN-2015 17:11:10:174] nigtrm: Count in the NI global area is now 0

(1976) [22-JUN-2015 17:11:10:174] nrigbd: entry

(1976) [22-JUN-2015 17:11:10:174] nrigbd: exit

(1976) [22-JUN-2015 17:11:10:174] nigtrm: Count in the NL global area is now 0

(1976) [22-JUN-2015 17:11:10:174] nlse_term_audit: entry

(1976) [22-JUN-2015 17:11:10:174] nlse_term_audit: exit

please note :

(1976) [22-JUN-2015 17:11:10:174] nrigbni: Unable to get data from navigation file tnsnav.ora

very odd behaviour !

5

I’ve never used TNSNAV.ORA before, but such a low-level trace doesn’t really tell me anything.

Can you make any connection at all (to another database) with Toad 12.7?

I have never seen a case where TNSPING works but Toad can’t connect, if both are using the same Oracle Home, so I am not sure what else to tell you other. If there are any unused Oracle Homes still on your computer, I would remove them, and make sure they are completely gone from system path and registry.

6

  1. I can connect to 60 databases with Toad 12.6 but no one of them with Toad 12.7

  2. tnsping maybe does not use connection objects that Toad does (?)

  3. no other Oracle Home is present

  4. the Windows registry has no ambiguous Oracle Home

all of these points were verified before I started to post here

(12.6 is still installed and still works)

Is there some kind of regression test not verified in 12.7 ?

7

Can you post the contents of your 12.7 Support Bundle (from the Help menu).

8

here is it !
supportbundle.txt (79.1 KB)

9

It’s just a guess, but try rearranging your Path so that this:

C:\app\oracle\product\oracleXE\app\oracle\product\11.2.0\server\bin

comes after this:

C:\app\oracle\product\10.2.0\bin

10

I’m afraid but I did it too : I dropped all the voices in the path involving XE and it didn’t work … but as I said in the first post : one of my colleagues had same stuff with Microsoft Windows 7 Pro environment and its path is aware of any other stuff. He had Toad version 12.6 before and it works well. The only difference between me (with Windows 8.1 Pro) my colleague (with Windows 7 Pro) and the other colleague (with Windows XP Pro still) is that the colleague (with XP) uninstalled version 12.6 before and we (with 8.1 and 7) didn’t. But uninstall previous version of Toad is not a specification.

11

I don’t think having Toad 12.6 and 12.7 installed on the same machine is a problem. I have many versions of Toad installed.

I don’t think windows 8.1 is a problem either. I don’t personally have a copy of it to test on now, but I know that it is tested.

I don’t know why it’s not working, but I think trying a newer client is the easiest and best thing to try now. You can use a 12c client with a database as old as 10.2.

It’s OK to have multiple Oracle clients installed at once. I have 4 of them.

12

Problem solved …

My colleague (one with XP) suggested me to copy all installation of Toad in another location.

So I did.

Instead of C:\Program Files (x86)\Dell\Toad for Oracle 2015 Suite\Toad for Oracle 12.7\Toad.exe in C:\Dell\Toad for Oracle 12.7\Toad.exe

All works well.

Then I uninstalled all and I reinstalled it with care. When the installer permits to change where to install I choose the location I said before.

All is well.

Suggestion : I think that for all the people that want to use Toad in windows from 7 to 8.1 it’s better to choose installation location excluding “Program Files (x86)” path

Thanks to all !

13

Oh, yeah! I forgot about that old problem. It was solved with the 11g client. WIth the 10g client and older, if there is a paren in the path to the executable, the client can’t connect.

14

Yes, that does explain it!

This has been a known issue for a long time with Oracle 10 client. I suppose 12.6 was installed into a directory that does not contain ()

From: sergiovalle [mailto:bounce-sergiovalle@toadworld.com]

Sent: Tuesday, June 23, 2015 1:40 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Toad 12.7.0.121 : ORA-12154: TNS:could not resolve the connect identifier specified

RE: Toad 12.7.0.121 : ORA-12154: TNS:could not resolve the connect identifier specified

Reply by sergiovalle

Problem solved …

My colleague (one with XP) suggested me to copy all installation of Toad in another location.

So I did.

Instead of C:\Program Files (x86)\Dell\Toad for Oracle 2015 Suite\Toad for Oracle 12.7\Toad.exe in C:\Dell\Toad for Oracle 12.7\Toad.exe

All works well.

Then I uninstalled all and I reinstalled it with care. When the installer permits to change where to install I choose the location I said before.

All is well.

Suggestion : I think that for all the people that want to use Toad in windows from 7 to 8.1 it’s better to choose installation location excluding “Program Files (x86)” path

Thanks to all !

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.