Linux 安装Oracle Instant Client

水深无声 2021-12-11 02:59 362阅读 0赞

# 下载客户端 #

[Instant Client Downloads for Linux x86-64 (64-bit)][Instant Client Downloads for Linux x86-64 _64-bit]  
根据个人数据库版本下载对应的客户端，由于本人数据库版本较旧，是10g，所以客户端下的10.2.0.5版本。

# 上传至Linux目录下 #

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RvbmdfY2hs_size_16_color_FFFFFF_t_70]  
上传工具很多，本人使用的xftp。

# 进行安装 #

![在这里插入图片描述][20190712105015295.png]

# 安装之后进行确认 #

![在这里插入图片描述][20190712105134366.png]

# 配置环境变量 #

### 1.编辑文件 ###

vim ~/.bash_profile

### 2.编辑之后的文件内容 ###

# .bash_profile
    
    # Get the aliases and functions
    if [ -f ~/.bashrc ]; then
            . ~/.bashrc
    fi
    
    # User specific environment and startup programs
    
    PATH=$PATH:$HOME/bin
    export ORACLE_HOME=/usr/lib/oracle/10.2.0.5/client64
    export TNS_ADMIN=$ORACLE_HOME/network/admin
    export ORACLE_BASE=/usr/lib/oracle/10.2.0.5
    export LD_LIBRARY_PATH=$ORACLE_HOME/lib
    export PATH=$ORACLE_HOME/bin:$PATH
    export PATH

### 3.退出保存 ###

:wq

### 4.使刚才配置文件生效 ###

source ~/.bash_profile

# 创建tnsnames.ora配置文件 #

**根据配置文件中的TNS\_ADMIN变量，到指定路径下创建，所以我需要在/usr/lib/oracle/10.2.0.5/client64/network/admin目录下进行创建。**

cd  /usr/lib/oracle/10.2.0.5/client64
    mkdir -p /network/admin
    vi /usr/lib/oracle/10.2.0.5/client64/network/admin/tnsnames.ora

文件内容依据自己实际情况编辑，如我的是

JDEDB1 =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.XX.XX)(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = XXXX)
        )
      )

编辑好之后，退出保存。

# 最后一步测试 #

[root@centostest admin]# sqlplus account/password@JDEDB1
    
    SQL*Plus: Release 10.2.0.5.0 - Production on Fri Jul 12 11:10:07 2019
    
    Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.
    
    
    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
    With the Partitioning, OLAP and Data Mining options
    
    SQL>

[Instant Client Downloads for Linux x86-64 _64-bit]: https://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RvbmdfY2hs_size_16_color_FFFFFF_t_70]: /images/20211210/7cdd0e4ae7d94f40997f4f64b30da096.png
[20190712105015295.png]: /images/20211210/117d0a86a0c044198ca55c24aa2a9ea0.png
[20190712105134366.png]: /images/20211210/7ee29d70310443f5a11891e4f9282951.png