Home » SQL & PL/SQL » Client Tools » TNSNAMES not detected (oracle 12c Windows 7)
TNSNAMES not detected [message #651729] Tue, 24 May 2016 01:32 Go to next message
muktha_22
Messages: 526
Registered: December 2009
Senior Member
Hi,

I have a peculior issue,

Have installed Toad 12.1.0.22 version on Windows 7 OS (64 Bit).
The client version is 11.2.0.3.0.

When I am trying to connect, it showing only first 3 tnsnames alias entries, in the TOAD Login.
(Image attached)

But at the same times, if login with the DIRECT instead of TNS|LDAP, it is working.

Here is the actual TNSNAMES.ORA file.

12c =
 (DESCRIPTION = 
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = <IP ADDRESS>)(PORT = 1521))
   )
 (CONNECT_DATA =
   (SERVICE_NAME = <SID>)
 )
)


live12c =
 (DESCRIPTION = 
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = <IP ADDRESS>)(PORT = 1521))
   )
 (CONNECT_DATA =
   (SERVICE_NAME = <SID>)
 )
)


LIVE =
 (DESCRIPTION = 
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = <IP ADDRESS>)(PORT = 1521))
   )
 (CONNECT_DATA =
   (SERVICE_NAME = <SID>)
 )
)


testdb12c
 (DESCRIPTION = 
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = <IP ADDRESS>)(PORT = 1521))
   )
 (CONNECT_DATA =
   (SERVICE_NAME = <SID>)
 )
)


NEW
 (DESCRIPTION = 
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = <IP ADDRESS>)(PORT = 1521))
   )
 (CONNECT_DATA =
   (SERVICE_NAME = <SID>)
 )
)



And here is the SQLNET file:


SQLNET.AUTHENTICATION_SERVICES = (NTS,NONE)

NAMES.DIRECTORY_PATH = (TNSNAMES, EZCONNECT)



Thanks and Regards
Muktha
./fa/13134/0/


[mod-edit: image inserted into message body by bb]

[Updated on: Tue, 24 May 2016 01:49] by Moderator

Report message to a moderator

Re: TNSNAMES not detected [message #651731 is a reply to message #651729] Tue, 24 May 2016 02:09 Go to previous messageGo to next message
Frank Naude
Messages: 4531
Registered: April 1998
Senior Member
The last 2 entries are incorrect. Looks like you may be missing an equals sign after the names. Try to change 'testdb12c' to 'testdb12c =' and 'NEW' to 'NEW ='.
Re: TNSNAMES not detected [message #651732 is a reply to message #651731] Tue, 24 May 2016 02:11 Go to previous messageGo to next message
muktha_22
Messages: 526
Registered: December 2009
Senior Member
Hi Feank,

I am such an idiot.

Thanks a lot.

Regards
Muktha
Re: TNSNAMES not detected [message #651733 is a reply to message #651732] Tue, 24 May 2016 02:13 Go to previous message
Frank Naude
Messages: 4531
Registered: April 1998
Senior Member
Not at all, it happens to the best of us Smile
Previous Topic: Query lines to mimic excel formula
Next Topic: Oracle number format
Goto Forum:
  


Current Time: Thu Nov 23 20:04:03 CST 2017

Total time taken to generate the page: 0.06636 seconds