| TNS: Could resolve service name [message #16250] |
Thu, 18 November 2004 11:14 |
Alex
Messages: 190
Registered: August 1999
|
Senior Member |
|
|
Hello,
I am getting this following error from SQL Plus: TNS: Could resolve service name when I try connecting.
I have SSH Secure Client client set up to accept TCP on port 1530 which its destination is 1521 on another server, this is in Incoming Tunnel section.
I have tnsnames.ora
OPTD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1530))
)
(CONNECT_DATA =
(SID = optd)
(SERVER = DEDICATED)
when I do tngping OPTD, it finds it and displays ^ , and just gets stuck at that.
*I went to the registry and set the oracle home directory properly.
*For some reason when i do tngping it tells me: Used parameter files: C:oracleora91networkadminsqlnet.ora
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
