Oracle客户端配置说明 centos

为什么80%的码农都做不了架构师？>>>   

1.下载oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm 

   oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm 

   oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm

2.查看rpm包的默认安装路径
[root@localhost tmp]# rpm -qpl oracle-instantclient-sqlplus-10.2.0.5-1.x86_64.rpm 
/usr/bin/sqlplus64
/usr/lib/oracle/10.2.0.5/client64/bin/sqlplus
/usr/lib/oracle/10.2.0.5/client64/lib/glogin.sql 

3.依次执行如下命令:

[root@localhost tmp]# rpm -ivh --relocate /usr=/oracle oracle-instantclient-basic-10.2.0.5-1.x86_64.rpm 
[root@localhost tmp]# rpm -ivh --relocate /usr=/oracle oracle-instantclient-devel-10.2.0.5-1.x86_64.rpm
[root@localhost tmp]# rpm -ivh --relocate /usr=/oracle oracle-instantclient-sqlplus-10.2.0.5-1.x86_64.rpm

3.sqlnet.ora和tnsnames.ora创建
这两个文件默认是不存在，所以要手工创建
[root@localhost tmp]# mkdir -p /oracle/lib/oracle/10.2.0.5/client64/network/admin

然后在admin目录下创建这两个文件

sqlnet.ora内容如下:

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

tnsnames.ora内容如下：

别名 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 要连接的数据库IP )(PORT = 端口))
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

 

转载于:https://my.oschina.net/body/blog/692963