Hi shruti,

See did u change tnsnames.ora manually? Don't use any gui (i think u're not using gui, since u're in linux). U have to manually change it. Sending you my Unix server's tnsnames.ora which connects to Sun Solaris.

extproc_connection_data =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
(CONNECT_DATA = (SID = extproc))
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= gayatri)(Port= 1521))
(CONNECT_DATA = (SID = ORCL))
)
extproc_connection_data =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = td))
(CONNECT_DATA = (SID = td))

tdnew =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(Host = 10.31.8.121)(Port = 1521))
(CONNECT_DATA = (SID = td))
)

I hope u can u it fast if not then mail me on [email protected]

Best wishes
Darshil