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)
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)