Search This Blog

Showing posts with label Database. Show all posts
Showing posts with label Database. Show all posts

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)

Monday, March 29, 2010

Accelerating SQL Database Operations on a GPU with CUDA

I have been watching nVidia's CUDA technologies for a while.

What I am waiting for is a solution for SQL Database (Oracle/DB2/Sybase/SQL Server/MySQL).

Here is a publish documents by Peter Bakkum and Kevin Skadron

Accelerating SQL Database Operations on a GPU with CUDA

Project base on SQLite focuse on SELECT queries.
Good point!

Will keep eye on it!