I have installed oracle 817 on my Nt server. I am able to connect to the newly installed oracle using the sqlplus provided in the /home/bin directory.
However, I wanted to connect to the other boxes running the oracle using sqlplus. I have made the entries in home/network/admin/tnsnames.ora for the other instances also.
I am not able to connect to other boxes.
Later I have installed a oracle client on other directory and I am trying to access the other instance from the client..It does not connect to the other instances but goes to only the new instance created on my machine.
Please clarify to me how can I access both my instance as well as the other instance. Which sqlplus.exe should I use..?
the one in the server home path or the one in the client?