Oracle 11gR2 real-time client configuration (Windows)

Oracle 11gR2 real-time client configuration (Windows)

1. Download the real-time client that suits your system first. You can download the client from the address below.

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

2. decompress the package directly to the directory you want to store, for example, C: \ instantclient_11_2.

3. Edit Environment variables:

Set TNS_ADMIN to C: \ instantclient_11_2.

ORACLE_HOME is set to C: \ instantclient_11_2

4. Edit the connection configuration file tnsnames. ora, which must be created in the real-time client directory (C: \ instantclient_11_2. Enter the following content 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: database instance name

192.168.3.259: IP address of the database

1521: Database Port

5. Then you can use PLSQL Developer and TOAD to manage Oracle databases.