Major announcement: simplified and green version of Oracle client

Source: Internet
Author: User

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.

 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.