Link to home
Avatar of hi4ppl
hi4ppl

asked on

Cann't connect from another server to oralce

I can connect locally like normal :

sqlplus sys as sysdba

Open in new window

I can also connect

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

Open in new window

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 unreadable the command I used is

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

Open in new window

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 bellow error

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

Open in new window


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 coonect 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

it's fresh installation of oracle in linux centos 6.6
ASKER CERTIFIED SOLUTION
Avatar of Zephyr ICT
Zephyr ICT
Flag of Belgium image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of hi4ppl
hi4ppl

ASKER

HI Thanks I didn't do iptables -F before now that I did it works fine.... but can you tell me how can I enable the iptable and add rule  to allow that connection ... I don't want to disable iptable for all
SOLUTION
Avatar of Alex [***Alex140181***]
Alex [***Alex140181***]
Flag of Germany image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.