| TNSNAMES not detected [message #651729] |
Tue, 24 May 2016 01:32  |
muktha_22
Messages: 527
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
[mod-edit: image inserted into message body by bb]
[Updated on: Tue, 24 May 2016 01:49] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
