Hi All,
- RHEL6.5, x86_64
[oracle@ip-172-111 ~]$ ls -alF /opt/oracle/product/12.1/client64/bin/tnsping
-rwxr-xr-x. 1 oracle oinstall 0 Jul 7 2014 /opt/oracle/product/12.1/client64/bin/tnsping*
I have this situation where tnsping command doesn't spit anything, no response, no error, nothing,
while I can actually connect to the remote database as defined in the tnsnames entry via sqlplus command.
Please see the below
[root@ip-172-1-1-1 sbin]# tnsping TESTDB
[root@ip-172-1-1-1 sbin]#
[root@ip-172-1-1-1 sbin]# which tnsping
/opt/oracle/product/12.1/client64/bin/tnsping
[root@ip-172-1-1-1 sbin]#
[root@ip-172-1-1-1 sbin]# sqlplus TESTUSER/TESTUSER@TESTDB
SQL*Plus: Release 12.1.0.2.0 Production on Sun Jan 10 21:58:47 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
SQL>
Running the set of commands on oracle user results in the same:
root@ip-172-111 ~]# su - oracle
[oracle@ip-172-111 ~]$ tnsping TESTDB
[oracle@ip-172-111 ~]$
[oracle@ip-172-111 ~]$ which tnsping
/opt/oracle/product/12.1/client64/bin/tnsping
[oracle@ip-172-111 ~]$
[oracle@ip-172-111 ~]$ sqlplus TESTDB/TESTDB@TESTDB
SQL*Plus: Release 12.1.0.2.0 Production on Mon Jan 11 17:46:12 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
SQL>
Would there be any advice on the investigation?
Much appreciated,