Currently I have 3 oracle homes configured on one server machine.
8.1.7, 9.0 and 9.2
When I am trying to connect with 8.1.7 SQLPlus to 9.2 or 9.0 instance I get message TNS: could not resolve service name.
When I am connecting with 9.2 or 9.0 to 8.1.7 I have no issues.
I am missing something in the configuration ,could you point me to the right direction.