I have 2 databases servers both oracle 8i .
Ora1 on WinNT
Ora2 on Linux
I am creating a connecttion from wint nt to Ora2(i.e linux db) via
sql*plus tool . I am able to connect successfully. I have configured
the tnsnames.ora with the appropriate service name for linux db server.
Now i am trying to use the sqlplus utility of linux to connect to
winnt database. I have configured
the tnsnames.ora with the appropriate service name for winnt db server.
But sqlplus of linux just doesnt seem to recognize the service name
of winnt .
error ora-12154 : Tns:could not resolve service name.
i can ping the winnt machine from linux without any problems.
Is there any configuration i have to make for using an oracle client
application in linux & oracle db server on winnt. Why is not detecting
the oracle db on winnt