Oracle11gR2 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. 2. Directly decompress the package to the directory you want to store, such as C: instantclient_11_23. Edit the environment variable TNS_ADMIN to C: instantclient_11_2ORACLE_HOME and set it to C: instantclient_11_24. Edit the TN

1. Download the real-time client that suits your system first. You can download the client from the address below. 2. Directly decompress the package to the directory you want to store, for example, C: instantclient_11_2. 3. Edit the environment variable TNS_ADMIN to C: instantclient_11_2 ORACLE_HOME and set it to C: instantclient_11_2 4. Edit the connection configuration file tnsname.

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

　　

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.