Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

tnsping not work in 12.1 client

user7903245Jan 10 2016 — edited Jan 12 2016

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

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

Connected to:

Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

SQL>

Would there be any advice on the investigation?

Much appreciated,

This post has been answered by BPeaslandDBA on Jan 11 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 9 2016

Added on Jan 10 2016

#general-database-discussions

14 comments

5,002 views