欧美bbbwbbbw肥妇,免费乱码人妻系列日韩,一级黄片

使用Docker制作Python環(huán)境連接Oracle鏡像

 更新時(shí)間:2022年06月28日 10:45:53   作者:xiaogp  
這篇文章主要為大家介紹了使用Docker制作Python環(huán)境連接Oracle鏡像示例詳解,有需要的朋友可以借鑒參考下,希望能夠有所幫助,祝大家多多進(jìn)步,早日升職加薪

Python連接Oracle本地測(cè)試

依賴(lài)安裝準(zhǔn)備

Python、鏈接Oracle需要Python依賴(lài)和本地Oracle客戶(hù)端,測(cè)試環(huán)境Oracle版本12.1.0.2.0,開(kāi)發(fā)和測(cè)試環(huán)境為linux,先安裝linux客戶(hù)端,選擇zip解壓免安裝版本

Oracle linux客戶(hù)端

解壓到某個(gè)目錄

unzip instantclient-basic-linux.x64-12.1.0.2.0.zip

解壓后新建/network/admin文件夾

cd /opt/instantclient_12_1/
mkdir -p /network/admin

修改root用戶(hù)的環(huán)境變量

vim /etc/profile
export ORACLE_HOME=/opt/instantclient_12_1
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG="SIMPLIFIED CHINESE_CHINA".ZHS16GBK
export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"
export LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH
export PATH=$ORACLE_HOME:$PATH
source /etc/profile

下一步安裝Python依賴(lài)

pip install cx_Oracle

Python腳本測(cè)試

root@ubuntu:~# python
Python 3.7.6 (default, Jan  8 2020, 19:59:22) 
[GCC 7.3.0] :: Anaconda, Inc. on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import cx_Oracle as cx
>>> con = cx.connect('username', 'password', 'xxx.xxx.xxx.xxx:1521/ORCL')
>>> cursor = con.cursor() 
>>> cursor.execute("select * from emp") 
<cx_Oracle.Cursor on <cx_Oracle.Connection to c##als770ud1@192.168.61.79:1521/ORCL>>
>>> cursor.fetchall()
[(1, '張三'), (2, '李四'), (3, '王五')]
>>> 

制作Docker鏡像

創(chuàng)建Dockerfile

touch Dockerfile
# 將oracle本地客戶(hù)端文件夾移動(dòng)到同一級(jí)目錄
cp -r /opt/instantclient_12_1/ ./

Dockerfile

FROM python:3.7
ENV  PIPURL "https://mirrors.aliyun.com/pypi/simple/"
RUN pip install cx_Oracle --default-timeout=1000
COPY instantclient_12_1 /opt/instantclient_12_1
ENV ORACLE_HOME=/opt/instantclient_12_1
ENV TNS_ADMIN=$ORACLE_HOME/network/admin
ENV NLS_LANG="SIMPLIFIED CHINESE_CHINA".ZHS16GBK
ENV NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"
ENV LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH
ENV PATH=$ORACLE_HOME:$PATH
RUN apt-get update
RUN apt-get install -y libaio1

鏡像構(gòu)建

docker build -t xiaogp/python_oraqcle:v3 .

構(gòu)建完成

root@ubuntu:~/docker/PYTHON_ORACLE# docker images
REPOSITORY                              TAG                            IMAGE ID            CREATED             SIZE
xiaogp/python_oraqcle                    v3                             bb0100d9c3f5        39 seconds ago      1.1GB

啟動(dòng)鏡像測(cè)試一下

root@ubuntu:~/docker/PYTHON_ORACLE# docker run -it bb0100d9c3f5 /bin/bash
root@fbff875ba4d5:/# python
Python 3.7.9 (default, Jan 12 2021, 17:26:22) 
[GCC 8.3.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import cx_Oracle as cx
>>> con = cx.connect('username', 'password', 'xxx.xxx.xxx.xxx:1521/ORCL')
>>> cursor = con.cursor()
>>> cursor.execute("select * from emp")
<cx_Oracle.Cursor on <cx_Oracle.Connection to c##als770ud1@192.168.61.79:1521/ORCL>>
>>> cursor.fetchall()
[(1, '張三'), (2, '李四'), (3, '王五')]

可以鏈接,制作結(jié)束

以上就是使用Docker制作Python環(huán)境連接Oracle鏡像的詳細(xì)內(nèi)容,更多關(guān)于docker鏡像Python環(huán)境連接Oracle的資料請(qǐng)關(guān)注腳本之家其它相關(guān)文章!

相關(guān)文章

最新評(píng)論