ORA-12543: TNS:destination host unreachable
Hi, I have 2 machines:
#1 centos 5.* with 11gR2 [IP=10.1.1.66]
#2 centos 6.2 with 11gR2 virtual machine [IP=10.1.1.78 bridged (the host machine runs ubuntu 11.10 ip=10.1.1.52)]
DBs and listeners are up and functioning on both machines and both of them can ping each other without problems.
Tnsnames.ora and listener.ora settings are mirrored on both machines.
The problem is #2 can connect to #1's db with sqlplus scott/tiger@ORCL but when I try to connect from #1 to #2 with sqlplus scott/tiger@ORCL1 I get a ORA-12543: TNS:destination host unreachable.
I've spent all day on this, I really hope someone can help me understand why (not why I spent all day on this, I don't really wanna know why I did that).
Thanks in advance.
Edited by: 928506 on Apr 18, 2012 7:04 AM