Major announcement: simplified and green version of Oracle client

Http://blueram.javaeye.com/blog/425743

 

 

In large-scale project development, common databases are Oracle databases. However, an Oracle client requires a large disk. After installation, two functions are basically used: TNS Configuration Service name and sqlplus. During development, toad and PL/SQL developer are widely used. Therefore, the Oracle client installation disk is only required as a driver, and there is no need to install such a large space. Therefore, this article describes how to use the simplified Oracle client.

I use two simplified Oracle clients. You can choose either of them: 1. Oracle 9i (Version: 9.0.1.0.1) Simplified client green version
Occupies 35 MB of space, with sqlplus tool. Green version, super recommended !!! Usage:
1. Confirm the oraclehome directory. For example, I want to put the Oracle client under D: \ Program Files \ oracle.
2. Copy the ora90 directory to the D: \ Program Files \ oracle directory.
3. If your oraclehome directory is different from mine, use the Event Book to open the install_oracle9i.reg file and replace D: \ progra ~ 1 \ oracle, save.
4. Double-click install_oracle9i.reg to import the registry.
5. Open the D: \ Program Files \ oracle \ ora90 \ Network \ admin \ tnsnames. ora file in the Event Book, add your own database alias configuration, and save it. You can copy one of them and then modify it. The main change is = the alias above, host is the IP address, and SERVICE_NAME is the Instance name of the database server.
6. Run D: \ Program Files \ oracle \ ora90 \ bin \ sqlplusw.exe and enter the username/password @ alias. Uninstall method:
1. Double-click uninstall_oracle9i.reg to import the registry.
2. Delete the D: \ Program Files \ oracle directory.
: Http://www.fs2you.com/zh-cn/files/fda64a07-0705-11dd-85d4-00142218fc6e/ 2, Oracle 10g Instant Client Oracle Instant Client is a lite version of the Oracle client, do not need to install, but need a simple configuration. : Http://www.oracle.com/technology/software/tech/oci/instantclient/index.html
I downloaded 10.2.0.3 basic on the Win32 platform. The instant client has two versions: basic and basic lite.
The basic version includes all the files that support running OCI, occi, JDBC, JDBC-OCI and support for multiple languages.
Basic Lite is a basic Lite version that only contains English Error Descriptions and only supports Unicode, ASCII, and European character sets.
Therefore, if the database server is a Chinese character set (such as simplified chinese_china.zhs16gbk), you must download the basic version.
Basic lite occupies 25 MB space, while basic occupies MB space. If you want to support Chinese characters, 70 m more at once!
In addition, you can download sqlplus, but it is a command line version, not a graphical interface. 1. decompress the downloaded basic package and place it in the D: \ Program Files \ instantclient_10_2 directory. There are 8 files in total.
2. on the desktop, right-click "my computer", select "properties", select "environment variable" on the "advanced" page, and add:
1) variable name: ORACLE_HOME
Variable value: D: \ Program Files \ instantclient_10_2
2) variable name: tns_admin
Variable value: D: \ Program Files \ instantclient_10_2
3) variable name: nls_lang
Variable value: Simplified chinese_china.zhs16gbk
4) modify the PATH variable and add D: \ Program Files \ instantclient_10_2.

If you do not want to add it manually, download the setoraenv.rar attachment, decompress the attachment, and execute setoraenv. bat.
3. In D: \ progra ~ 1 \ instantclient_10_2 create a text file named tnsnames. ora. add your own database alias configuration to the file,
Example:
Mydb =
(Description =
(Address = (Protocol = TCP) (host = 172.16.1.16) (Port = 1521 ))
(CONNECT_DATA =
(Server = dedicated)
(SERVICE_NAME = ora10g)
)
.
4. decompress the files in the sqlplus compressed package to the D: \ Program Files \ instantclient_10_2 directory. There are 3 files in total.
Run sqlplus username/password @ dbname in the Directory D: \ Program Files \ instantclient_10_2 on the doscommand line to connect to the database.
Uninstall method:
1. on the desktop, right-click "my computer", select "properties", and select "environment variables" on the "advanced" Page. In system variables,
Delete the ORACLE_HOME, tns_admin, and nls_lang variables, modify the PATH variable, and remove the D: \ Program Files \ instantclient_10_2 directory.
2. delete D: \ progra ~ 1 \ instantclient_10_2 directory.

Iii. Use of third-party tools:
After configuring any of the above clients, you can install toad or PL/SQL developer. You can use it without any additional settings.