go-操作oracle数据库

1. linux oracle  安装
centos7.2 64位
1.oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
2.oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm
3.oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm


rpm -hiv 依次安装


加入以下内容到 etc/profile
export ORACLE_HOME=/usr/lib/oracle/12.1/client64
export ORACLE_BASE=/usr/lib/oracle/12.1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8


source /etc/profile  即刻生效




创建文件  /usr/lib/oracle/12.1/client64/network/admin
内容如下 ：
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.233.194)(PORT = 2521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCL)