分享

在linux操作系统下使用Oracle10.1g廋客户端

 goodwangLib 2014-04-09
 一、下载必要的资源包

         从Oracle官方网站上下载安装包,选择Version 10.1.0.5即可。


http://www.oracle.com/technetwork/topics/linuxsoft-082809.html


 


Version 10.1.0.5   Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications


 instantclient-basic-linux32-10.1.0.5-20060511.zip (31,413,713 bytes) (cksum - 384697539)


 


*Instant Client Package - JDBC Supplement: Additional support for XA, Internationalization, and RowSet operations under JDBC


 instantclient-jdbc-linux32-10.1.0.5-20060511.zip (4,649,614 bytes) (cksum - 753190421)


 


*Instant Client Package - SQL*Plus: Additional libraries and executable for running SQL*Plus with Instant Client 


instantclient-sqlplus-linux32-10.1.0.5-20060511.zip (331,854 bytes) (cksum - 722849044)


 


*Instant Client Package - SDK: Additional header files and an example makefile for developing Oracle applications with Instant Client 


instantclient-sdk-linux32-10.1.0.5-20060511.zip (294,618 bytes) (cksum - 4282446920)


 


Optional packages are marked with a *.


Installation Steps:


1. Download the appropriate Instant Client packages for your platform. All installations REQUIRE the Basic package.


2. Unzip the packages into a single directory such as "instantclient".


3. Set the library loading path in your environment to the directory in Step 2 ("instantclient"). On many UNIX platforms, LD_LIBRARY_PATH is the appropriate environment variable. On Windows, PATH should be used.


4. Start your application and enjoy.


  


二、目录安排


         把上述几个文件解压到/home/ instantclient10_1目录中


/home/ instantclient10_1


                  |_bin


                     |_sqlplus


                  |_lib


                     |_ libclntsh.so.10.1,libnnz10.so,libociei.so,libsqlplus.so


                  |_network


                     |_admin


                     |_tnsnames.ora


                  |_sqlplus


                     |_admin


                         |_glogin


                     |_mesg


                         |_sp1us.msb,sp1us.msg,sp1zhs.msb等


         tnsnames.ora文件可以从X:\oracle\product\10.2.0\db_1\NETWORK\ADMIN目录下拷贝即可,这样您只要保证在WINDOWS下该文件配置正确即可。


 


三、环境变量配置


        1、在/etc/profile文件里添加如下配置


ORACLE_HOME=/home/instantclient10_1


PATH=$ORACLE_HOME/bin:$PATH


LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH


export ORACLE_HOME PATH LD_LIBRARY_PATH


       2、生效命令


#source profile


       3、环境变量查看


#env |grep ORACLE_HOME


 


四、验证效果


        使用sqlplus查询,如果出现如下信息,orale client基本安装完成。


用户名:username


密  码: password


服务名: myoracle


三项基本信息要根据你自己系统实际配置。


# sqlplus username/password@myoracle


 


SQL*Plus: Release 10.1.0.5.0 - Production on Wed Sep 7 11:26:13 2011


 


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


 


 


Connected to:


Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production


With the Partitioning, OLAP and Data Mining options


 


SQL>


 


On other platforms the two packages should be unzipped into one directory, for example, /home/instantclient10_1 on UNIX or c:\instantclient10_1 on


四、动态库比较


        Windows. This table shows the Oracle client-side files required to deploy SQL*Plus Instant Client 10.1.
















































Platform



Description



Package



UNIX/Linux



Windows



sqlplus



sqlplus.exe



SQL*Plus executable



SQL*Plus



libsqlplus.so



not applicable



SQL*Plus library



glogin.sql



glogin.sql



SQL*Plus site profile



libclntsh.so.10.1



oci.dll



Client code library



Basic



libociei.so



oraociei10.dll



OCI Instant Client data shared library



libnnz10.so



orannzsbb10.dll



Security library




 




    本站是提供个人知识管理的网络存储空间,所有内容均由用户发布,不代表本站观点。请注意甄别内容中的联系方式、诱导购买等信息,谨防诈骗。如发现有害或侵权内容,请点击一键举报。
    转藏 分享 献花(0

    0条评论

    发表

    请遵守用户 评论公约

    类似文章 更多