Configure TNSNAMES for SOLARIS & LINUX
How can i configure the TNSNAMES file on the server that has Solaris as its Operating System(OS) and another server that has LINUX as its Operating System(OS).
I tried to configure the TNSNAMES on LINUX server and connected it but it gives an error.
The following is how i have defined in my TNSNAMES file on the client machine:
TZR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = tzr)
)
)
VIS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.67)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = VIS)
)
)
For SID TZR the toad and workflow is getting connected but for VIS it is giving me the following error:
ORA-12537: TNS: connection closed.
NOTE: TZR server has OS Windows 2003 server installed while VIS server has LINUX as its OS
Please can any one help me how to connect to the database?
Thanking you in advance,
Chetan