linux安装oracle客户端

页面导航:首页 > 数据库 > oracle > linux安装oracle客户端

linux安装oracle客户端

来源: 作者: 时间:2016-02-16 09:27 【

1、准备好所需要的安装包,http: www oracle com technetwork database features instant-client index-097480 html这个网址有各种操作系统的客户端oracle-instantclient-basic-10 2 0 5-1 i386 rpmoracle-in

1、准备好所需要的安装包,http://www.oracle.com/technetwork/database/features/instant-client/index-097480.这个网址有各种操作的客户端

oracle-instantclient-basic-10.2.0.5-1.i386.rpm
oracle-instantclient-devel-10.2.0.5-1.i386.rpm
oracle-instantclient-jdbc-10.2.0.5-1.i386.rpm
oracle-instantclient-sqlplus-10.2.0.5-1.i386.rpm

先安装oracle-instantclient-basic-10.2.0.5-1.i386.rpm,其他依次安装

2、创建用户、组和目录

[[email protected] oracle]# groupadd oinstall
[[email protected] oracle]# groupadd dba
[[email protected] oracle]# useradd -g oinstall -G dba oracle
[[email protected] oracle]# passwd oracle
Changing password for user oracle.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
[[email protected] oracle]# mkdir -p /home/oracle/network/admin
[[email protected] oracle]# chown -R oracle:oinstall /home/oracle
[[email protected] oracle]# chmod -R 755 /home/oracle

3、将oracle服务器上面的tnsnames.ora拷贝出来,放到/home/oracle/network/admin目录下面。
4、修改环境变量

[[email protected] ~]$ vi .bash_profile

export ORACLE_HOME=/home/oracle
export SQLPATH=/home/oracle/network/admin
export TNS_ADMIN=/home/oracle/network/admin
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
export LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.5/client/lib/:/usr/lib/oracle/10.2.0.5/client/lib:$LD_LIBRARY_PA
TH
export PATH=$PATH:$ORACLE_HOME:$LD_LIBRARY_PATH

[[email protected] ~]$ source .bash_profile 环境变量立即生效

5、可以正常连接oracle服务器了

[[email protected] ~]$ sqlplus zhgy//orcl

Tags:

文章评论

最 近 更 新
热 点 排 行
Js与CSS工具
代码转换工具

<