美文网首页
Oracle客户端 for Ubuntu

Oracle客户端 for Ubuntu

作者: Time一柒 | 来源:发表于2019-07-18 10:10 被阅读0次
1. 下载安装包

oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.zip
oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.zip
oracle-instantclient11.2-sdk-11.2.0.4.0-1.x86_64.zip

2. 解压到opt/oracle
3.在 instantclient_11_2 目录下创建 network/admin 目录,使用命令
mkdir  -p network/admin
4. 并在 admin 目录下创建 tnsnames.ora 文件(如果不用数据库连接软件,好像不需要)
     ZKL =  
        (DESCRIPTION =  
          (ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.111.111)(PORT = 1521))  
          (CONNECT_DATA =  
            (SERVER = DEDICATED)  
            (SERVICE_NAME = orcl)  
           )  
        )
5. 配置用户变量vim ~/.bashrc
ORACLE_HOME=/opt/oracle/instantclient_11_2
PATH=$ORACLE_HOME:$PATH
LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export ORACLE_HOME PATH LD_LIBRARY_PATH
6. 配置完毕后,进行刷新环境变量,进行生效source ~/.bashrc测试sqlplus /nolog
出现下面结果
SQL*Plus: Release 11.2.0.4.0 Production on 星期二 1月 5 11:14:31 2019
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
SQL> 

相关文章

网友评论

      本文标题:Oracle客户端 for Ubuntu

      本文链接:https://www.haomeiwen.com/subject/bllklctx.html