Configuration of Oracle 11g real-time client on Windows

Oracle 11g real-time clientInWindowsThe configuration process on is relatively simple. This article introduces the configuration of Oracle 11g on Windows 2000 as an example.

1. Extract the compressed file to the root directory of drive D;

2. edit the environment, add d: \ instantclient_11_1 to the PATH before other Oracle Directories), add the system environment variable TNS_ADMIN to d: \ instantclient_11_1, and set ORACLE_HOME to d: \ instantclient_11_1; NLS_LANG is ''american _ america. ZHS16GBK''

For example, on Windows 2000, choose Start> Settings> Control Panel> system> advanced> environment variables ", edit the PATH in the system Variable list. Set the system environment variable TNS_ADMIN to d: \ instantclient_11_1, the system environment variable ORACLE_HOME to d: \ instantclient_11_1, and the system environment variable NLS_LANG to american_america.zhs16gb

3. Edit the d: \ instantclient_11_1 \ tnsnames. ora file:

 
 

  
  
MYDB =  
  
  
 
  
  
(DESCRIPTION =  
  
  
 
  
  
(ADDRESS_LIST =  
  
  
 
  
  
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.5)(PORT = 1521))  
  
  
 
  
  
)  
  
  
 
  
  
(CONNECT_DATA =  
  
  
 
  
  
(SID = HBDB)  
  
  
 
  
  
(SERVER = DEDICATED)  
  
  
 
  
  
)  
  
  
 
  
  
) 
 
 

Where:

MYDB: database instance name

10.0.0.5: database server address

HBDB: Database SID

The configuration of the Oracle 11g real-time client on Windows is introduced here. I hope you will get some benefits!