Configure cx_Oracle on CentOS

[root@oradb]~# uname -a
Linux oradb.egolife.com 2.6.32-220.el6.x86_64 #1 SMP Tue Dec 6 19:48:22 GMT 2011 x86_64 x86_64 x86_64 GNU/Linux

[root@oradb]~# python     
Python 2.6.6 (r266:84292, Dec  7 2011, 20:48:22) 
[GCC 4.4.6 20110731 (Red Hat 4.4.6-3)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> exit()

[root@oradb]~# ll software 
total 276
-rw-r--r--. 1 root   root     275117 Jul 25 10:16 cx_Oracle-5.1.2-11g-py26-1.x86_64.rpm
drwxr-xr-x. 8 oracle oinstall   4096 Aug 21  2009 database

[root@oradb]~# rpm -ihv software/cx_Oracle-5.1.2-11g-py26-1.x86_64.rpm 
Preparing...                ########################################### [100%]
   1:cx_Oracle              ########################################### [100%]

[root@oradb]~# su - oracle
[oracle@oradb]~# python
Python 2.6.6 (r266:84292, Dec  7 2011, 20:48:22) 
[GCC 4.4.6 20110731 (Red Hat 4.4.6-3)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import cx_Oracle
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ImportError: libclntsh.so.11.1: cannot open shared object file: No such file or directory
>>> exit()

[oracle@oradb]~# locate libclntsh.so.11.1
/db/oracle/product/11.2.0/db_1/inventory/Scripts/ext/lib/libclntsh.so.11.1
/db/oracle/product/11.2.0/db_1/inventory/backup/2012-11-30_04-38-40AM/Scripts/ext/lib/libclntsh.so.11.1
/db/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1
/root/software/database/stage/ext/lib/libclntsh.so.11.1

[oracle@oradb ~]$ cat ~/.bash_profile 
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
    . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

#2013-1-22	oracle 11gR2 settings
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_BASE=/db/oracle
export ORACLE_HOME=/db/oracle/product/11.2.0/db_1
export ORACLE_SID=DBTEST
export LD_LIBRARY_PATH=/db/oracle/product/11.2.0/db_1/lib
export PATH=$PATH:$ORACLE_HOME/bin

alias sqlplus='rlwrap sqlplus'

[oracle@oradb ~]$ python
Python 2.6.6 (r266:84292, Dec  7 2011, 20:48:22) 
[GCC 4.4.6 20110731 (Red Hat 4.4.6-3)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import cx_Oracle
>>> connection = cx_Oracle.connect('dev/dev@dbtest')
>>> connection = cx_Oracle.connect('dev/[email protected]:1521:/dbtest')
>>> connection.version
'11.2.0.1.0'