vincent's Blog

install oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
install oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm
install cx_Oracle-5.1.1-11g-py26-1.x86_64.rpm


vi /etc/profile

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/oracle/11.2/client64/lib
export ORACLE_HOME=/usr/lib/oracle/11.2/client64

source /etc/profile


#!/usr/bin/env python
#coding=utf8

import sys
import os
import cx_Oracle


hostname='1.1.1.1'
sid='SID'
username='user'
password='pwd'
port='1521'


threshold='80'

SqlStr='select count(1) from V$session'
SqlStr2="SELECT value FROM v$parameter WHERE name = 'sessions'"
SqlStr3="select count(1) from V$session where STATUS='ACTIVE'"

dsn = cx_Oracle.makedsn(hostname, 1521, sid)
conn = cx_Oracle.connect(username+'/'+password+'@' + dsn)
cursor = conn.cursor()

cursor.execute(SqlStr)
TotalSession = cursor.fetchone()

print TotalSession





## Nagios execution environment problem
display Error

Check_oracle_session.py:11:<module>:ImportError: libclntsh.so.11.1: cannot open shared object file: No such file or directory



vi /etc/ld.so.conf.d/oracleClient.conf
add
/usr/lib/oracle/11.2/client64/lib/


ldconfig

ldconfig -p | grep 'libclntsh.so.11.1'
        libclntsh.so.11.1 (libc6,x86-64) => /usr/lib/oracle/11.2/client64/lib/libclntsh.so.11.1

ref https://cx-oracle.readthedocs.org/en/latest/
ref https://pypi.python.org/pypi/cx_Oracle
ref http://dbaportal.eu/sidekicks/sidekick-cx_oracle-code-paterns/#part6.1
ref http://www.programering.com/q/MTOzIjNwATc.html