PLSQL Oracle10g thin green client connection to Oracle

I have always hoped that the Oracle client will not be installed on the client. No matter whether I use Java, Delphi, and C ++, when I know that Oracle10g has released the Instant Client lightweight client, I will start searching for relevant information, finally, we can contribute our methods and hope to help you.

According to the test, there is no problem in connecting to oracle9.2 with the Oracle10g generation Instant Client. According to the product manager of the Instant Client, there is no problem in connecting to 8i.


Use of Instant Client in Oracle 10g
========================================================== ======================================

Starting from 10 Gb, Oracle provides a lightweight customer package called
Instant Client. After installing it, you do not need to install a large
Oracle client. This is an improvement for application distribution.
(About 27 m after winrar3.3 compression)

Steps:
1. Download several packages from OTN and decompress them to a directory. c: \ Instant Client

Instantclient-basic-win32-10.1.0.2.zip: this is the core package
Instantclient-jdbc-win32-10.1.0.2.zip: a package containing JDBC driver
Instantclient-sqlplus-win32-10.1.0.2.zip: the simplest sqlplus package

2. Configure the environment variables and the tnsnames. ora/sqlnet. ora File

First, add c: \ Instant Client to the path variable.

If your machine has never installed Oracle software
The following key should not exist:
HKEY_LOCAL_MACHINE \ SOFTWARE \ oracle

Therefore, we can write a batch file and manually add it.
Environment variables, such:
Set nls_lang = simplified chinese_china.zhs16gbk
>>>> It is useless to set this parameter here. You can set this parameter in the system environment variable.
Add an nls_lang in, or add one in the registry:
[HKEY_LOCAL_MACHINE \ SOFTWARE \ oracle]
"Nls_lang" = "simplified chinese_china.zhs16gbk ",
In this way, the Chinese character problem can be solved, on the premise that you are on the client
Set settings must be consistent with those on the server side.

Finally, configure tnsnames. ora and sqlnet. ora.
If the sample file is not found, copy one from the server.

3. If you develop a Java application, you must configure some environment variables,
For example, classpath, java_home, etc. The classes12.jar file is
Required. Add others as needed.

4. If the following error occurs when sqlplus is started:
ORA-12545: connect failed because target host or object does not exist
Change the host in tnsnames. ora to an IP address.