Connecting to remote DB fails even though the listener service is running
987650Jan 28 2013 — edited Jan 30 2013Hey All,
We're getting an odd error while trying to connect to our dbserver which is hosted remotely.
1. We can telnet into port 1521.
2. Doing a `sqlplus admin/passwd@//address:port/db_name` returns a:
ORA-12547: TNS:lost contact
3. sqlplus invites us to log in at that point:
Enter user-name:
3a. If you go ahead with it, you get
Enter password:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
the listener service
This just seems kind of weird. We can connect to the db locally. The permissions on bin/oracle seems to be set correctly, and it's probably not the firewall because we can telnet in. We've ruled out network issues.
Anyway, if anyone could give me an idea of where to look, it'd be greatly appreciated.