ubuntuan安装oracle,Ubuntu下安装oracle客户端

Ubuntu下安装oracle客户端

1) 下载zip包

http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

a. instantclient-basic-linux.x64-11.2.0.4.0.zip

b. instantclient-jdbc-linux.x64-11.2.0.4.0.zip

c . instantclient-sdk-linux.x64-11.2.0.4.0.zip

d. instantclient-sqlplus-linux.x64-11.2.0.4.0.zip

2) 解压到目录

a=> /usr/lib/oracle/11.2/client64/lib

b=> /usr/lib/oracle/11.2/client64/lib

c=> /usr/lib/oracle/11.2/client64/sdk

d=>/usr/lib/oracle/11.2/client64/lib

创建目录和文件连接:

$ sudo mkdir -p /usr/lib/oracle/11.2/client64/sqlplus/mesg

$ cd /usr/lib/oracle/11.2/client64/lib

$ sudo ln -s libclntsh.so.11.1 libclntsh.so

$ sudo ln -s libocci.so.11.1 libocci.so

$ sudo chown cl:cl ./*.so

$ sudo chmod 755 ./*.so

3) tnsnames.ora

$ sudo vi /usr/lib/oracle/11.2/client64/network/admin/tnsnames.ora

内容如下:

ORADBSID =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = ???.xxx.???.???)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = ORCL)

)

)

4) 配置 /etc/profile

增加下面内容:

# oracle 11g client x64

export ORACLE_HOME=/usr/lib/oracle/11.2/client64

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

export TNS_ADMIN=$ORACLE_HOME/network/admin

export PATH=$PATH:$ORACLE_HOME:$ORACLE_HOME/lib:$ORACLE_HOME/sdk/include

export ORACLE_SID=ORADBSID

export NLS_LANG="american_america.ZHS16GBK"

使生效:

. /etc/profile

5) 打开sqlplus

$ sqlplus user/password@ORADBSID

SQL*Plus: Release 11.2.0.4.0 Production on Fri Mar 10 23:43:08 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值