To simplify the use of Oracle on personal computers and avoid occupying unnecessary resources, you do not need to install the Oracle client. Use OracleInstantClient to connect to oracle
To simplify the use of Oracle on personal computers and avoid occupying unnecessary resources, you do not need to install the Oracle client. Use Oracle InstantClient to connect to oracle
To simplify the use of Oracle on personal computers and avoid occupying unnecessary resources, you do not need to install the Oracle client. Method: use Oracle InstantClient to connect to the oracle database
1. Download the corresponding program, for example, 34,742,358 instantclient-basic-win32-10.2.0.4.zip (bytes)
Instantclient-basic-win32-10.2.0.3-20061115.zip
WIN64-bit system download link:
? _ Template =/ocom/print
2. decompress the Oracle Instatnt Client. For example, to D:/instantclient_10_2
3. environment variable configuration: "Control Panel"-"System"-"advanced"-"environment variable"-"system variable" add
NLS_LANG = AMERICAN_AMERICA.ZHS16GBK (or SIMPLIFIED CHINESE_CHINA.ZHS16GBK)
TNS_ADMIN = D: \ instantclient_10_2
LD_LIBRARY_PATH = D: \ instantclient_10_2
SQLPATH = D: \ instantclient_10_2
Add D: \ instantclient_10_2 to the end of the Path variable (Note: Use semicolons for different paths; interval)
4. Add the following file in D: \ instantclient_10_2, with the file name tnsnames. ora
5. Download the separate Oracle SDK and Oracle SQL PLUS to the installation directory, decompress the package, and run
Add ORA file content and format
Tnsnames. ora
# D:/instantclient_10_2/tnsname. ora
Mydb1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.47) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVER = dedicated)
(SERVICE_NAME = mydb1)
)
)
For more information about Oracle, see the Oracle topic page? Tid = 12
,