I can connect locally like normal :

sqlplus sys as sysdba

I can also connect

sqlplus sys/pass@hostname:1521/servicename as sysdba

the service I get from when I do lsrnctl status but when I try to connect this from other system where oracle is running I get following error:

ORA-12543: TNS: Destination host unreachable 

the command I used is

sqlplus sys/pass@hostname:1521/servicename as sysdba

which with the same I can connect locally but not from remove server. I try to check

telnet 192.1368.0.15 1521

given me below error

telnet: connnect to address hostname: no route to host:

I try to disable the iptables from the target host where oracle is installed no luck. What is wrong with this? Everything works locally I can connect and even ping the TNS.

One thing I notice my SID is orcl but the service instance that shows in lsnrctl status it shows as orclXDB

  • Looks like your instance didn't register with the listener. What happens if you connect locally and run alter system register. Also what does tnsping hostname give you? Are you aware that you the "hostname" part isn't really a "hostname" but a "TNS name" - as defined in tnsnames.ora – a_horse_with_no_name Jul 9 '15 at 6:19
  • when I run alter system register it says system altered... when I do tnsping and the ip it replay OK ( 0 msec) – hi4ppl Jul 9 '15 at 7:01
  • @a_horse_with_no_name : no, there is absolutely nothing in the error messages that looks like the instance did not register. Also 'hostname' is not a name from tnsnames.ora but it is the name of the database – miracle173 Jul 9 '15 at 7:24
  • @miracle173: of course hostname needs to resolve to the alias defined in tnsnames.ora. From the manual "You must enter (...) a net service name to connect to a database". If lsnrctl status doesn't show the service than this does indicate the instance didn't register. – a_horse_with_no_name Jul 9 '15 at 7:47
  • @a_horse_with_no_name : I wanted to write "Also 'hostname' is not a name from tnsnames.ora but it is the name of the database server". hi4ppl uses Easy Connection Identifier and not a tnsname. – miracle173 Jul 9 '15 at 8:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.