Welcome 微信登录

首页 / 数据库 / MySQL / 在Linux操作系统下使用Oracle 10.1g廋客户端

一、下载必要的资源包 从Oracle官方网站上下载安装包，选择Version 10.1.0.5即可。http://www.oracle.com/technetwork/topics/linuxsoft-082809.htmlVersion 10.1.0.5   Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applicationsinstantclient-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 JDBCinstantclient-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:oracleproduct10.2.0db_1NETWORKADMIN目录下拷贝即可，这样您只要保证在WINDOWS下该文件配置正确即可。三、环境变量配置        1、在/etc/profile文件里添加如下配置ORACLE_HOME=/home/instantclient10_1PATH=$ORACLE_HOME/bin:$PATHLD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATHexport 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 - ProductionWith 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
完Oracle用存储过程返回游标Oracle事务处理多条sql语句相关资讯      Oracle教程 
  • Oracle中纯数字的varchar2类型和  （07/29/2015 07:20:43）
  • Oracle教程：Oracle中查看DBLink密  （07/29/2015 07:16:55）
  • [Oracle] SQL*Loader 详细使用教程  （08/11/2013 21:30:36）
  • Oracle教程：Oracle中kill死锁进程  （07/29/2015 07:18:28）
  • Oracle教程：ORA-25153 临时表空间  （07/29/2015 07:13:37）
  • Oracle教程之管理安全和资源  （04/08/2013 11:39:32）
本文评论 查看全部评论 （0）
表情： 姓名： 字数