欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

在Linux操作系统下使用Oracle 10.1g廋客户端

程序员文章站 2022-05-30 17:50:34
...

一、下载必要的资源包 从Oracle官方网站上下载安装包,选择Version 10.1.0.5即可。 http://www.oracle.com/technetwork/topics/

一、下载必要的资源包

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

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