oracleDB python chines_miscode

oracle account lock: solution
http://www.cnblogs.com/jianqiang2010/archive/2011/09/01/2162574.html

like: show tables;
返回所有表
select table_name from all_tables;
返回当前用户的所有表(1)
select table_name from user_tables;
返回当前用户的所有表(2)
select table_name from tabs;

python:32/64
import struct
struct.calcsize("P")
sys.maxint
import struct
struct.calcsize("P")

python-oracle:
https://cx-oracle.readthedocs.io/en/latest/installation.html
sudo pip install cx_Oracle

https://github.com/bumpx/oracle-instantclient
ubuntu-oracle-client install
https://help.ubuntu.com/community/Oracle%20Instant%20Client

sudo sh -c "echo /opt/oracle/instantclient_12_1 > /etc/ld.so.conf.d/oracle-instantclient.conf"
ln -s libclntsh.so.12.1 libclntsh.so

sudo ldconfig
sudo apt-get install libaio1

 

docker pull store/oracle/database-instantclient:12.2.0.1

 

docker run -ti store/oracle/database-instantclient:12.2.0.1 sqlplus scott/tiger@//129.0.2.85:1521/orcl