Friday, August 9, 2013

Add tnsping into Oracle Instant Client on CentOS RHEL OEL

tnsping is a very handy tool from Oralce.
But it does not include with Oracle Instant Client!

To add it, you will need a Oracle Client software installed on the other machine with same OS (Notice:32/64 differently)

Then copy 3 files to the Oracle Instant Client folder:


scp root@192.168.1.4:/u01/app/oracle/product/10.2.0/db_1/bin/tnsping /usr/lib/oracle/10.2.0.5/client/bin/
mkdir -p /usr/lib/oracle/10.2.0.5/client/network/mesg
scp root@192.168.1.4:/u01/app/oracle/product/10.2.0/db_1/network/mesg/tnsus.msb /usr/lib/oracle/10.2.0.5/client/network/mesg/
scp root@192.168.1.4:/u01/app/oracle/product/10.2.0/db_1/network/mesg/tnsus.msg /usr/lib/oracle/10.2.0.5/client/network/mesg/



/etc/sqlnet.ora
NAMES.DIRECTORY_PATH= (TNSNAMES)

2 comments:

  1. Thanks for finally talking about > Addd tnsping into Oracle Instant Client on CentOS RHEL OEL | Miillion Dollar Server < Loved it!

    ReplyDelete