一朗徊、創(chuàng)建所需目錄
mkdir -p /home/用戶(hù)名/software/python3.6.1
mkdir -p /home/用戶(hù)名/priv/byd
mkdir -p /home/用戶(hù)名/priv/byd/src/python
mkdir -p /home/用戶(hù)名/priv/byd/org
二名斟、修改byd目錄的權(quán)限
cd /home/用戶(hù)名/priv/
ll
chmod 777 byd/
ll
三术幔、將安裝包放到byd中,并將包備份到org中
在byd中解包:
cd /home/用戶(hù)名/priv/byd
tar zxvf Python-3.6.1.tgz
tar zxvf cx_Oracle-6.0.2.tar.gz
四挪哄、安裝python-3.6.1(如果在make編譯報(bào)錯(cuò)字符集錯(cuò)誤归敬,可以暫時(shí)將LANG修改為C待成功安裝成功后再改回來(lái))
env | grep LANG
ls
cd Python-3.6.1
配置:
./configure --prefix=/home/用戶(hù)名/software/python3.6.1
編譯:
make
安裝:
make install
五烁设、配置環(huán)境變量
vi /home/用戶(hù)名/.bashrc
# .bashrc
# Source global definitions
if [ -f /etc/bashrc ]; then
??????? . /etc/bashrc
fi
# User specific aliases and functions
#add bash execut command's time
#export HISTTIMEFORMAT='%F?? %T 命令: '
export PATH=$PATH:/home/用戶(hù)名/software/python3.6.1/bin
wq
source /home/用戶(hù)名/.bashrc
env | grep PATH
六、安裝cx_Oracle
cd /home/用戶(hù)名/priv/byd/
ls
cd cx_Oracle-6.0.2
ls
安裝:
python3 setup.py install
source /home/monitor/.bashrc
env | grep PATH
python3
env | grep LANG
----LANG=zh_CN.GB18030
測(cè)試腳本
cd src/python/
vi connora.py
#!/home/用戶(hù)名/software/python3.6.1/bin/python3
import os,sys
import cx_Oracle
db=cx_Oracle.connect('monitor/monitor@21.0.129.73/flrdb')
csr=db.cursor()
sql='select * from flr.flr_clr_date_desc'
csr.execute(sql)
rslt=csr.fetchall()
print ( "All Result is:%s" % rslt )
csr.close()
db.close()
wq
python3 connora.py
python3
env | grep CPDS