DB version : 11.2.0.3
Linux SQL*Plus Client version : 11.2.0.1
Windows 7 SQL*Plus Client version : 11.2.0.4
OS : DB running on Oracle Linux 6.5 , SQL*Plus Client running on Oracle Linux 6.6
I am trying to connect to an EBS DB .
Using easy connect syntax, I can connect to the remote DB from SQL*Plus in my Windows (DOS) laptop.I have a Linux server in my office which is connected to the same network as my Windows Laptop. But, when I try to connect to the remote DB from this Linux server, I get the below error.
$ sqlplus APP_SUPPORT/tiger@10.80.16.197:1521/PROD
SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 3 20:31:57 2017
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-12545: Connect failed because target host or object does not exist
From the Linux server, I can ping the DB server and there is no Firewall. Then why can I connect from Window DOS and why can't I connect from Linux server which is connected to same network in my office ? Is this some EBS specific issue ? I know EBS Listeners are configured weirdly.
--- Ping test
$ ping 10.80.16.197
PING 10.80.16.197 (10.80.16.197) 56(84) bytes of data.
64 bytes from 10.80.16.197: icmp_seq=1 ttl=57 time=6.24 ms
64 bytes from 10.80.16.197: icmp_seq=2 ttl=57 time=3.47 ms
64 bytes from 10.80.16.197: icmp_seq=3 ttl=57 time=3.31 ms
64 bytes from 10.80.16.197: icmp_seq=4 ttl=57 time=3.30 ms
64 bytes from 10.80.16.197: icmp_seq=5 ttl=57 time=3.29 ms
64 bytes from 10.80.16.197: icmp_seq=6 ttl=57 time=3.17 ms
Enter user-name: ^C
$
$
--- Checking from Linux server if there is a Firewall . The 'Connection established' message proves that there is no firewall
$
$ telnet 10.80.16.197 1521
-bash: telnet: command not found
$
$ ssh -vp 1521 10.80.16.197
OpenSSH_5.3p1, OpenSSL 1.0.1e-fips 11 Feb 2013
debug1: Reading configuration data /etc/ssh/ssh_config
debug1: Applying options for *
debug1: Connecting to 10.80.16.197 [10.80.16.197] port 1521.
debug1: Connection established.
debug1: identity file /home/tadba/.ssh/identity type -1
debug1: identity file /home/tadba/.ssh/identity-cert type -1