ORACLE客户端安装_Linux+绿色版

安装客户端软件

可采用可视化安装,或直接下载免安装包【E:\software\oracle\client11 and 18】

现通过免安装方式处理:

#unzip instantclient-basic-linux.x64-18.5.0.0.0dbru.zip -d /usr/local/oracle/

#unzip instantclient-sqlplus-linux.x64-18.5.0.0.0dbru.zip -d /usr/local/oracle/

#mkdir /usr/local/oracle/instantclient_18_5/network/admin/

#cd mkdir /usr/local/oracle/instantclient_18_5/network/admin/

#vi tnsnames.ora

ORCL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

配置root用户的环境变量

#cd

#vi .bashrc

export ORACLE_HOME=/usr/local/oracle/instantclient_18_5

export TNS_ADMIN=$ORACLE_HOME/network/admin

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

export LD_LIBRARY_PATH=$ORACLE_HOME

export PATH="$ORACLE_HOME:$PATH"

#source .bashrc

验证结果

#sqlplus system/oracle@orcl

SQL>select 1 from dual;


版权声明:本文为weixin_47745154原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。