Oracle¶

Install¶

server¶

downlaod server

   #修改/etc/selinux/config文件，设置为disable
   sed 's/SELINUX=.*$/^SELINUX=disable/g'  /etc/selinux/config

   docker pull wnameless/oracle-xe-11g

   docker run -d -p 49160:22 -p 49161:1521 wnameless/oracle-xe-11g
   #49160是ssh访问端口,初始密码admin
   #49161是数据库访问端口

.. code::

     hostname: localhost
     port: 49161
     sid: xe
     username: system/sys
     password: oracle

静默安装(待验证) * Centos7安装Oracle 11gR2 * CentOS 7静默（无图形化界面）安装Oracle 11g

Client¶

Download client
Install client
- oracle-instantclient-basic*.rpm
- oracle-instantclient-sqlplus*.rpm
- oracle-instantclient-devel*.rpm

dpkg -i  oracle-instantclient-basic*.rpm
dpkg -i  oracle-instantclient-sqlplus*.rpm
dpkg -i  oracle-instantclient-devel*.rpm

export  ORACLE_HOME=/usr/lib/oracle/11.2/client64
export  TNS_ADMIN=$ORACLE_HOME/network/admin
export  NLS_LANG='simplified chinese_china'.ZHS16GBK
export  LD_LIBRARY_PATH=$ORACLE_HOME/lib
export  PATH=$ORACLE_HOME/bin:$PATH

# connect
sqlplus64 system/oracle@//192.168.8.204:49161/xe

select name from v$database;

cat test.sql
SELECT table_name FROM user_tables;
exit;

sqlplus64 system/oracle@//192.168.8.204:49161/xe @/root/test.sql