oracle client install-linux

1.ҪԶʹoracleļעһ¡

oracle-instantclient-basic-10.2.0.4-1.i386.zip

oracle-instantclient-devel-10.2.0.4-1.i386.zip //sdk ģļû˵ش˵

oracle-instantclient-sqlplus-10.2.0.4-1.i386.zip

//鿴oraclesql䣬Ȼ޷ȥֻԶoracle ĹԱˡ

߲ͬͬϵͳģ뵽ٷվأϸ˵

2.ȴͻ˵İװĿ¼,Ŀ¼ԶûʱҪһ¡

mkdir -p /opt/oracle/network/admin

unzip oracle-instantclient-basic-10.2.0.4-1.i386.zip

unzip oracle-instantclient-sqlplus-10.2.0.4-1.i386.zip

ļѹǰĿ¼ͬһĿ¼instantclient_10_2

Ŀ¼ļᵽ /opt/oracle/lib

ѹoracle-instantclient-devel-10.2.0.4-1.i386.zip ѽѹļ /opt/oracle/sdk

vi /etc/profile //ע⣬ûĻijûֻûļˡ

export LD_LIBRARY_PATH=/opt/oracle/lib

[] source /etc/profile //ʹļ

[] echo $ORACLE_HOME //鿴һõĻǷɹ

Ϊûװoracle ݿ⣬ҪӰװoracle ݿĿ¼ļ

listener.ora sqlnet.ora tnsnames.ora

(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.107)(PORT = 1521)) //192.168.1.107 IPַ ,˿ںţ1521

(SERVICE_NAME = bossdata) //bossdata ȫ

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

(ORACLE_HOME = \opt\oracle) //ע⣬Ǹղõ$ORACLE_HOME

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.107)(PORT = 1521)) //˵

sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

//⣬Ļûĵ㡣

SQL*Plus: Release 10.2.0.4.0 – Production on Sun Aug 1 12:20:08 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production

With the Partitioning, OLAP and Data Mining options

LOFTERѳӡ20ƬҪ

this.p= m:2, b:2, loftPermalink:, id:fks_, blogTitle:oracle client install-linux, blogAbstract:

1.ҪԶʹoracleļעһ¡

, blogTag:, blogUrl:blog/static/4382352, isPublished:1, istop:false, type:0, modifyTime:81, publishTime:52, permalink:blog/static/4382352, commentCount:0, mainCommentCount:0, recommendCount:0, bsrk:-100, publisherId:0, recomBlogHome:false, currentRecomBlog:false, attachmentsFileIds:[], vote:, groupInfo:, friendstatus:none, followstatus:unFollow, pubSucc:, visitorProvince:, visitorCity:, visitorNewUser:false, postAddInfo:, mset:000, mcon:, srk:-100, remindgoodnightblog:false, isBlackVisitor:false, isShowYodaoAd:false, hostIntro:͵,ߵ¡, hmcon:1, selfRecomBlogCount:0, lofter_single:

/if$fn(x.visitorNickname,8)escape

$a.selfIntroescapeif great260$suplement/if

list a as x if x_index

$fn2(x.publishTime,yyyy-MM-dd HH:mm:ss)

if !!(blogDetail.preBlogPermalink)

/if if !!(blogDetail.nextBlogPermalink)

if x.publisherUsername==visitor.userNameelse/if

if defined(newslist)&&newslist.length

0 list newslist as x if x_index

$x.nickNameescapeͶƱ var first_option = true list x.voteDetailList as voteToOption if voteToOption==1 if first_option==false,/if $b[voteToOption_index] /if /list if (x.role!=-1) ,$c[x.role] /if

if x.userName==/if /if /list