Configure the Oracle10g real-time client in Windows

In Windows, configure Oracle10g real-time client. Keywords: Configure windows database Oracle

Installation Guide

Installation steps:

1. Download the corresponding real-time client package for your platform. All installations require basic or basic lite packages.

2. decompress the package to a single directory, such as "instantclient ".

3. Set the Database loading path in your environment to point to the directory ("instantclient") identified in step 2 "). On many UNIX platforms, LD_LIBRARY_PATH is the corresponding environment variable. On Windows, path should be used.

4. Start and use your application.

How to configure the Oracle10g real-time client in Windows

There are a lot of simplified Oracle client versions on the Internet, but these are not from the official hands of Oracle, it is inevitable that there may be some problems. After an hour, I finally completed the configuration of the Oracle10g real-time client.

1, first to download the client on the Oracle site (first to register a user name to download) http://www.oracle.com/technology/global/cn/tech/oci/instantclient/instantclient.html

For Windows, you can download it here.

Http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html

2. Package Description

Notes on the Real-time client package

Basic all files required to run OCI, occi, and JDBC-OCI applications OCI

Occi

JDBC

Simplified version of basic, which only supports English error messages and Unicode, ASCII, and western European character set (only 10.2) OCI

Occi

JDBC

JDBC supplemental package * supports rowset operations in XA, internationalization, and JDBC

SQL * Plus * is an additional database and executable file SQL * Plus used to run SQL * Plus together with the real-time client.

ODBC supplemental package * supports the additional database of ODBC applications through the real-time client (not all platforms) ODBC

SDK * using the real-time client to develop an additional title file and sample makefile for the Oracle Application

Optional packages are marked with asterisks.

The corresponding software package that can be downloaded is

Instant Client package-Basic: All files required to run OCI, occi, and JDBC-OCI applications

Instantclient-basic-win32-10.2.0.1-20050930.zip (34,390,521 bytes)

* Instant Client package-Basic lite: smaller version of the basic, with only English error messages and Unicode, ASCII, and western European character set support (10.2 Only) (compared with the file above, this text support is only limited to Western European text, and is not supported for Chinese, so if the character set of the database is Chinese, it is best to use the first one)

Instantclient-basiclite-win32-10.2.0.1-20050930.zip (10,373,186 bytes)

* Instant Client package-jdbc supplement: additional support for XA, internationalization, and rowset operations under JDBC

Instantclient-jdbc-win32-10.2.0.1-20050930.zip (1,469,840 bytes)

* Instant Client package-SQL * Plus: additional libraries and executable for running SQL * Plus with Instant Client instantclient-sqlplus-win32-10.2.0.1-20050930.zip (720,691 bytes)

* Instant Client package-SDK: Additional header files and an example makefile for developing Oracle Applications with Instant Client instantclient-sdk-win32-10.2.0.1-20050930.zip (823,201 bytes)

* Instant Client package-ODBC: additional libraries for enabling ODBC applications Co., instantclient-odbc-win32-10.2.0.1-20050930.zip (718,159 bytes)

Generally, you only need to download the first package. If you want to use sqlplus, you can also download this package.

Installation steps:

1. Download the corresponding real-time client package for your platform. All installations require basic or basic lite packages.

2. decompress the package to a single directory, such as "C: instantclient ".

3. Configure Environment Variables

Add C: instantclient to path (before other Oracle Directories ).

For example, on Windows 2000, choose Start> Settings> Control Panel> system> advanced> environment variables ", edit the path in the system Variable list.

If the Oracle Net service name defined in the tnsnames. ora file is used, copy tnsnames. ora to C: instantclient, and add the user environment variable tns_admin to set your decompression directory, such as C: instantclient. (You can also define the default service name in the local environment variable. )

Set the required Oracle global language environment variable. The character set corresponding to nls_lang is

Simplified chinese_china.zhs16gbk.

Set the following three environment variables (take the decompressed directory c: instantclient as an example)

Environment variable name variable value

Path C: instantclient

Tns_admin C: instantclient

Nls_lang simplified chinese_china.zhs16gbk

4. set tnsnames. ora copies the content from the server or other places, or creates a text document to copy the following content to your file. Modify the red part for your own configuration, save the disk, and rename it tnsnames. ora

Localdb =

(Description =

(Address_list =

(Address = (Protocol = TCP) (host = 127.0.0.1) (Port = 1521 ))

)

(CONNECT_DATA =

(SID = mysid)

)

)

5. Start and use your application.

For example, start sqlplus

C: instantclientsqlplus system/manager @ localdb

6. Oracle ODBC Installation

C: instantclientodbc_install or C: instantclientodbc_install ZHS

Now the client has been configured.