Oracle 11GR2 Instant Client configuration (Windows)

1, the first to download the instant client for their own system, can be downloaded through the address below.

Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

2, directly extract to the directory you want to store, such as: c:instantclient_11_2

3. Edit Environment variables:

Tns_admin set to C:instantclient_11_2

Oracle_home set to C:instantclient_11_2

4, edit the connection profile Tnsnames.ora, the file needs to be created in the Instant Client directory (c:instantclient_11_2) itself. Enter the following in the file:

MYDB =

(DESCRIPTION =

(Address_list =

(address = (PROTOCOL = TCP) (HOST = 192.168.3.250) (PORT = 1521))

)

(Connect_data =

(SERVER = dedicated)

(service_name = MYDB)

)

)

MYDB: Is the database instance name

192.168.3.259: Is the IP address of the database

1521: is the port of the database

5, and then you can use software like Plsql Developer and TOAD to manage Oracle databases.