Use the Oracle 10.1g client in Linux

1. Download necessary resource packages

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

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, So that you only need to ensure 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
Libnnz10.so	Orannzsbb10.dll	Security library

End