Use the Oracle10.1g client in Linux

1. Download the necessary resource package and download the installation package from the official Oracle website. Select Version10.1.0.5. Www. oracle. comtechnetworktopics

1. Download the necessary resource package from the official Oracle website and select Version 10.1.0.5. Http://www.oracle.com/technetwork/topics/

1. Download necessary resource packages

Download the installation package from the official Oracle website and select 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 *.

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 every UNIX platforms, LD_LIBRARY_PATH is the appropriate environment variable. on Windows, PATH shoshould be used.

4. Start your application and enjoy.

Ii. Directory Arrangement

Decompress the preceding files to the/home/instantclient10_1 directory.

/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, etc.

The tnsnames. ora file can be copied from the X: \ oracle \ product \ 10.2.0 \ db_1 \ NETWORK \ ADMIN directory. This ensures that the file is correctly configured in WINDOWS.

Iii. environment variable configuration

1. Add the following configuration in the/etc/profile file:

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. Effective command

# Source profile

3. view environment variables

# Env | grep ORACLE_HOME

Iv. Verify the effect

Use sqlplus to query. If the following information appears, the orale client is basically installed.

Username: username

Password: password

Service name: myoracle

The three basic information should be configured according to your own system.

# Sqlplus username/password @ myoracle

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

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connected:

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 shocould be unzipped into one directory, for example,/home/instantclient10_1 on UNIX or c: \ instantclient10_1 on

Iv. dynamic database comparison

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