I am trying to connect to test database where I running two instances. I also update both TNSNAME.ORA and LISTNER.ORA. From some reason when I try to connect through sql from client side to one of the instance giving an error….

ORA-12513: TNS: service handler found but it has registered for a different protocol

But I can connect to other instance without any problem.

I’m not sure what is wrong…any idea?