Oracle client download

Source: Internet
Author: User

Oracle client download

Oracle refers to a user with a level of capacity. The following describes how to install and assemble a column (using instantclient-win32-10.2.0.3-.zip ).
Oracle provides six compressed packages to be downloaded from the Oracle client:
Instantclient-basic-win32-10.2.0.3-20061115.zip Basic all files required to run OCI, OCCI and JDBC-OCI applications
Simplified instantclient-basiclite-win32-10.2.0.3-20061115.zip version
Instantclient-jdbc-win32-10.2.0.3-20061115.zip jdbc package
Instantclient-odbc-win32-10.2.0.3-20061115.zip odbc package
Instantclient-sdk-win32-10.2.0.3-20061115.zip sdk
The instantclient-sqlplus-win32-10.2.0.3-20061115.zip will download this package if you want to use the sqlplus Program

: Http://www.oracle.com/technetwork/topics/winsoft-085727.html

Ps: in fact, the content of the basic compressed package can be found on the server, which is the following files:
Oci. dll
Ocijdbc10.dll
Ociw32.dll
Orannzsbb10.dll
Oraocci10.dll
Oraociei10.dll
Sqlnet. ora
Tnsnames. ora
Classes12.jar
Ojdbc14.jar

Therefore, if you want to create a simple client without jdbc or sqlplus, you can directly find these files on the server side (with sqlnet. ora, tnsnames. ora files), copy them to a directory. Then follow the steps below.

Installation steps:

1. Download the appropriate package. All the packages must be basic or basiclite (except for the basiclite package, all others are downloaded. What is the difference between basic and basiclite, to be studied)

2. Decompress all programs to a directory (for example, c: \ oracleclient)

3. Add three environment variables
Environment variable name variable value
Path: add c: \ oracleclient to the environment variable path.
TNS_ADMIN create this variable and add c: \ oracleclient
Create this variable in NLS_LANG and add: SIMPLIFIED CHINESE_CHINA.ZHS16GBK.

Of course, the above operations can also be performed directly in the Registry (TNS_ADMIN, NLS_LANG requires a new string value ):
[HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Control \ Session Manager \ Environment]
"PATH" = "d: \ OracleInstantClient"
"NLS_LANG" = "AMERICAN_AMERICA.ZHS16GBK"
"TNS_ADMIN" = "d: \ OracleInstantClient"

4. Copy A tnsnames. ora file from the server (there are two files with this name on the server, and you only need to copy the file in lower case), and then modify the following section
GONG =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST =
192.168.3.102 (enter the server name or IP address here)
) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =
Gong (here is the service name and also the sid Name)
)
)
)

5. ODBC Installation
Find odbc_install.exe in the directory and run it directly.

6. The program has been installed. You can start sqlplus under the command line.

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.