Oracle Instant Client instructions

Source: Internet
Author: User


1. Instant Clint description

Toad, PL/SQL Dev tools cannot use 64-bit oracle. Therefore, it is very troublesome to install 32-bit Oracle every time. To solve this problem, you can use the Oracle Instant Client.


Official Website description:



With Instant Client, you can run applications without installing standard Oracle clients or having ORACLE_HOME. OCI, occi, Pro * C, ODBC, and JDBC applications can run without modification, while significantly saving disk space. Even SQL * Plus can be used with instantclient. There is no need to re-compile, so there is no worry.


Instant Client:



We want toad to work properly, so here we download the 32-bit Instant Client. The star number is optional. Here we only download one basic package, which is only 50 MB, which is very small compared with the client's MB.



Ii. Instant Client Configuration


1. decompress the basic package to any directory. I will decompress it to drive D.


2. Create the Network/Admin directory under the Instant Client Directory and create the tnsnames. ora file. Modify the configurations of the net service.


3. Add D: \ instantclient_11_2 to the environment variable path.


4. Modify the Registry


Add relevant information in the following path:

HKEY_LOCAL_MACHINE \ SOFTWARE \ wow6432node \ oracle \


ORACLE_HOME = D: \ instantclient_11_2

SQL _path = D: \ instantclient_11_2

LD_LIBRARY_PATH = D: \ instantclient_11_2

Nls_lang = american_america.zhs16gbk

Tns_admin = D: \ instantclient_11_2 \ Network \ admin


5. Start toad and you will be able to use it normally.




1. I have Windows 7, and the Registry location is different from that of Windows XP.


Previous blogs also described the following:

Location of the nls_lang parameter in win7



2. you can also specify other directories for tns_admin. For example, if you have installed the Oracle server, you can directly reference the configuration of the server. In this way, you do not need to perform the second step. You can directly modify the path.

The advantage of using tnsnames. ora on the server is that you can directly use the net manager tool to configure related information.





Bytes -------------------------------------------------------------------------------------------------------

All rights reserved. reprinted articles are allowed, but source addresses must be indicated by links. Otherwise, the documents will be held legally responsible!


Skype: tianlesoftware






------- Add a group to describe the relationship between Oracle tablespace and data files in the remarks section. Otherwise, reject the application ----

Dba1 group: 62697716 (full); dba2 group: 62697977 (full) dba3 group: 62697850 (full)

Super DBA group: 63306533 (full); dba4 group: 83829929 dba5 group: 142216823

Dba6 group: 158654907 dba7 group: 172855474 DBA group: 104207940

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: 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.