I have a DB running in one server and I want to be able to connect to it from a remote server (RHEL server)..
So I installed the instant client 11.2 on the client side (basic + sqlplus) but I still get:
SQL*Plus: Release 220.127.116.11.0 Production on Fri Jun 28 10:58:11 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ORA-12543: TNS:destination host unreachable
I have configured properly the tnsnames and the sqlnet:
# TNSNAMES.ORA Network Configuration File:
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.4.37)(PORT = 1521))
(SERVICE_NAME = DP9A)
> more sqlnet.ora
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
Also I added some env variables:
I can ping the DB server from the client:
PING 172.16.4.37 (172.16.4.37) 56(84) bytes of data.
64 bytes from 172.16.4.37: icmp_seq=1 ttl=64 time=0.174 ms
64 bytes from 172.16.4.37: icmp_seq=2 ttl=64 time=0.262 ms
64 bytes from 172.16.4.37: icmp_seq=3 ttl=64 time=0.192 ms
64 bytes from 172.16.4.37: icmp_seq=4 ttl=64 time=0.231 ms
And I can access the DB from the DB server.