[Oracle] Linux下安装oracle 客户端

谁践踏了优雅 2022-09-25 00:20 249阅读 0赞

CentOS6

1.安装 oracle 客户端  
\[root@nxkteserver DL\]\# sudo rpm -ivh oracle-instantclient12.1-basic-12.1.0.2.0-1.x86\_64.rpm  
Preparing...                \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\]  
   1:oracle-instantclient12.\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\]  
\[root@nxkteserver DL\]\# sudo rpm -ivh oracle-instantclient12.1-devel-12.1.0.2.0-1.x86\_64.rpm      
Preparing...                \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\]  
   1:oracle-instantclient12.\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\]  
\[root@nxkteserver DL\]\# sudo rpm -ivh oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86\_64.rpm  
Preparing...                \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\]  
   1:oracle-instantclient12.\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\]

2.创建sqlnet.ora和tnsnames.ora两个文件  
\[root@nxkteserver DL\]\#  
\[root@nxkteserver client64\]\# pwd  
/usr/lib/oracle/12.1/client64  
\[root@nxkteserver client64\]\# mkdir -p network/admin  
\[root@nxkteserver client64\]\# ls  
bin  lib  network  
\[root@nxkteserver client64\]\# cd network  
\[root@nxkteserver network\]\# cd admin  
 \[root@nxkteserver admin\]\# vi tnsnames.ora  
3.將下面內容寫入tnsnames.ora  
db\_name =  
  (DESCRIPTION =  
    (ADDRESS =  
        (PROTOCOL = TCP)  
        (HOST = 10.111.111.111)  
        (PORT = 1903))  
    (CONNECT\_DATA =  
      (SERVER = DEDICATED)  
      (SERVICE\_NAME = db\_name)  
    )  
  )

4.配置环境变量  
session级别配置  
\[root@nxkteserver client64\]\# export LD\_LIBRARY\_PATH=/usr/lib/oracle/12.1/client64/lib  
\[root@nxkteserver client64\]\# export TNS\_ADMIN=/usr/lib/oracle/12.1/client64/network/admin  
\[root@nxkteserver client64\]\# export ORACLE\_HOME=/usr/lib/oracle/12.1/client64

5.配置环境变量  
\[root@nxkteserver client64\]\# vi /root/.bash\_profile  
添加三行  
TNS\_ADMIN=/usr/lib/oracle/12.1/client64/network/admin  
LD\_LIBRARY\_PATH=/usr/lib/oracle/12.1/client64/lib  
PATH=$PATH:$HOME/bin:/usr/lib/oracle/12.1/client64/bin  
用hostname命令獲取主機名并將其寫入/etc/hosts，非常重要！！！  
\[root@TEVM02 admin\]\# hostname  
TEVM02  
\[root@TEVM02 admin\]\# !v  
vi /etc/hosts  
增加一行10.132.38.93 TEVM02  
vi /etc/ld.so.conf  
添加一行/usr/lib/oracle/10.2.0.4/client64/lib/  
ldconfig生效

6.用sqlplus連接oracle  
\[root@TEVM02 admin\]\# sqlplus [user/password@db\_name][user_password_db_name]  
SQL\*Plus: Release 12.1.0.2.0 Production on Wed Oct 28 11:03:57 2015  
Copyright (c) 1982, 2014, Oracle.  All rights reserved.  
Connected to:  
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production  
With the Partitioning, OLAP, Data Mining and Real Application Testing options  
SQL> exit  
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production  
With the Partitioning, OLAP, Data Mining and Real Application Testing options  
\[root@TEVM02 admin\]\#

sqlplus连不上oracle可能是环境变量设置问题，可能的解决方式：

vi /etc/profile

最下面添加三行

export ORACLE\_HOME=/usr/lib/oracle/10.2.0.4/client64  
export ORACLE\_BASE=/usr/lib/oracle/10.2.0.4  
export LD\_LIBRARY\_PATH=$ORACLE\_HOME/lib:$LD\_LIBRARY\_PATHexport NLS\_LANG=AMERICAN\_AMERICA.AL32UTF8

保存退出后souce /etc/profile 让配置生效

[user_password_db_name]: mailto:user/password@db_name