Centos7 rpm安装oracle客户端

Centos7 rpm安装oracle客户端

1.获取oracle客户端文件(这里是12.1版本)

链接: 官网地址
链接: 百度网盘地址 提取码: zzyc

2.安装rpm客户端

rpm -ivh oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm 

rpm -ivh oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm

3.查询oracle安装位置(默认在/usr/lib)

find / -name oracle

4.修改环境变量

vim .bash_profile

export ORACLE_HOME=/usr/lib/oracle/12.1/client64                                                                      
export ORACLE_BASE=/usr/lib/oracle/12.1                                                                               
export LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib                                                              
export NLS_LANG=american_america.al32utf8                                                                             
sh -c "echo /usr/lib/oracle/12.1/client64/lib > /etc/ld.so.conf.d/oracle-instantclient.conf"                          
ldconfig 
# 最好修改一下字符集
LANG=zh_CN.UTF-8
LANGNLS_LANG="AMERICAN_AMERICA.UTF8"
NLS_LANG="AMERICAN_AMERICA.UTF8"
export SQLPATH TNS_ADMIN LANG LANGNLS_LANG NLS_LANG

5.填加tnsnames.ora连接配置文件

source .bash_profile

# 添加文件夹
mkdir -p $ORACLE_HOME/network/admin
cd $ORACLE_HOME/network/admin
vim tnsnames.ora
ORCL =                                                                                                                
  (DESCRIPTION =                                                                                                      
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.125)(PORT = 1521))                                                       
    (CONNECT_DATA =                                                                                                   
      (SERVER = DEDICATED)                                                                                            
      (SERVICE_NAME = orcl)                                                                                           
    )                                                                                                                 
  )                                                                                                                   

6.测试连接

cd $ORACLE_HOME/bin
#           用户名/密码@ip地址/s_id
./sqlplus test_username/test_password@192.168.0.125/orcl 

7.PyCharm的cx_Oracle连接失败问题(MAC下)

需要在将解压后文件夹修改为oracle,然后放置在MAC电脑的/opt目录下(没有则创建一个)