Installation and use of Oracle Instant client under Windows "Go"

"Go" installation and use of Oracle Instant client under Windows

reprinted from Placidcreatefinal Edit Placidcreate

"Install" Download the instant client file from the official Oracle website (http://www.oracle.com/technetwork/topics/winx64soft-089540.html)

In general, Basic, Sqlplus, ODBC, and JDBC are sufficient:

Instantclient-basic-win32-11.2.0.1.0.zip

Instantclient-sqlplus-win32-11.2.0.1.0.zip

Instantclient-odbc-win32-11.2.0.1.0.zip

Instantclient-jdbc-win32-11.2.0.1.0.zip

Unzip the above zip file into the same directory for easy search and use, such as: C:\OracleInstantClient_11_2.

"Configure and use"

The directory where Oracle Instant Client Installation (decompression) is assumed to be: C:\OracleInstantClient_11_2

A Use of Sqlplus:
(1) Direct use: Run cmd to the command line console and enter the command in the C:\OracleInstantClient_11_2 directory:

Sqlplus j2ee/[email protected]//10.10.10.1:1521/ora10
Format: sqlplus user/[email protected]//IP Address: Port number/sid or service_name

(2) using aliases:

ora10 =
(DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP) (HOST = 10.10.10.1) (PORT = 1521))
  )
     (service_name = ora10)
  )
)
this: Sqlplus j2ee/[email protected] , you can.

If it is not in the C:\OracleInstantClient_11_2 directory, you need to specify:
Set path=c:\oracleinstantclient_11_2;%path%
Set Tns_admin=c:\oracleinstantclient_11_2

Two Use of PL/SQL Developer:
After installing PL/SQL developer, cancel login at startup, enter interface, tools-preferences ... , set two input boxes:
Oracle home:c:\oracleinstantclient_11_2
OCI Library:c:\oracleinstantclient_11_2\oci.dll

Then, if the Tnsnames.ora file is placed directly under C:\OracleInstantClient_11_2, the environment variable tns_admin=c:\oracleinstantclient_11_2 needs to be set;
If the Network\admin directory is established under C:\OracleInstantClient_11_2, and the Tnsnames.ora file is placed, the tns_admin variable can be ignored.

Three Use of Toad:

(1) Create a new directory:
Create the Network\admin directory under C:\OracleInstantClient_11_2.
(2) Create a Tnsnames.ora file (or a copy) in the Network\admin directory, which configures the database you want to connect to;
(3) Setting up environment variables:
Tns_admin=c:\oracleinstantclient_11_2\network\admin (required)
path=%path%; C:\OracleInstantClient_11_2 (required)
Oracle_home=c:\oracleinstantclient_11_2 (required)
Ld_library_path=c:\oracleinstantclient_11_2 (required)
Sqlpath=c:\oracleinstantclient_11_2 (optional)
Nls_lang=simplified Chinese_china. ZHS16GBK (optional)

(iv) Use of Oracle SQL Developer:

In fact, Oracle SQL Developer does not require the prior installation of the Oracle client, but after the configuration in the reference (c), you can use the Tnsnames.ora file to simplify the connection configuration. In Oracle SQL developer, right-click Connect, New Connection, select TNS for the connection type, and then select the database you want to connect to in the network alias, which is listed in the network alias as read from the Tnsnames.ora file.

Summary
According to the configuration in (iii), the comparison specification, so that instant client with the sqlplus, PL/SQL Developer, TOAD, and Oracle Developer can be used normally.

Installation and use of Oracle Instant client under Windows "Go"