Oracle provides a feather-level client, which describes how to install the configuration (using Instantclient-win32-10.2.0.3-.zip) to do the following
Oracle provides 6 compressed package Oracle client downloads, respectively
Instantclient-basic-win32-10.2.0.3-20061115.zip Basic Run all the files required for OCI, OCCI, and JDBC-OCI applications
Instantclient-basiclite-win32-10.2.0.3-20061115.zipLite 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
Instantclient-sqlplus-win32-10.2.0.3-20061115.zip If you want to use the Sqlplus program, download this package
: http://www.oracle.com/technetwork/topics/winsoft-085727.html
PS: In fact, the contents of the basic compressed package can be found in the server, is the following several files
Oci.dll
Ocijdbc10.dll
Ociw32.dll
Orannzsbb10.dll
Oraocci10.dll
Oraociei10.dll
Sqlnet.ora
Tnsnames.ora
Classes12.jar
Ojdbc14.jar
So if you want to create a simple client without the need for JDBC and sqlplus, you can directly find these files on the server (plus the two files Sqlnet.ora, Tnsnames.ora) and copy them to a directory. Then follow the steps below to do it.
Installation steps:
1, download the appropriate package, all the packages need Basic or basiclite (this installation in addition to the Basiclite package, the rest of the download, as for the basic and basiclite the difference between the two, it remains to be researched)
2. Unzip all programs to a directory (e.g. C:\oracleclient)
3, add three environment variables
Environment variable Name Variable Value
Path Adding c:\oracleclient to the environment variable path
Tns_admin Create this variable and add c:\oracleclient to it
Nls_lang Create this variable, and then join: Simplified Chinese_china. Zhs16gbk
Of course, this can also be done directly in the registry (Tns_admin,nls_lang will need to create 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 from the server (the name of the file on the server there are two, as long as the copy of the lower case which can be), and then modify the following paragraph
GONG =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST =
192.168.3.102 (fill in the server name or IP address here)
) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name =
Gong (here is the service name, also the SID name)
)
)
)
Installation of 5,ODBC
Locate the Odbc_install.exe under the directory and run it directly.
6, the program has been installed, can be launched under the command line Sqlplus
Oracle Client Download
