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.