Today, I met a software requirement to install the oracle client. So if I want to install a simplified version. Although the final Lite version is successfully installed, the software still cannot be used. It is estimated that the lite version does not have the files it needs. However, I learned how to install the lite version!
The installation steps of the lite version are as follows:
1-extract instantclient-basic-win32-10.2.0.4.zip to a folder, such as d: \ oracleclient
2-Modify environment variables, right-click "my computer", select "properties", select "environment variables" on the "advanced" tab, and add:
1) variable name: ORACLE_HOME variable value: d: \ oracleclient
2) variable name: TNS_ADMIN variable value: d: \ oracleclient
3) variable name: NLS_LANG variable value: SIMPLIFIED CHINESE_CHINA.ZHS16GBK
4) modify the Path variable and add d: \ oracleclient
3-create a tnsnames file. Create a text file named tnsnames. ora under d: \ oracleclient and add the following Database Configuration:
Copy codeThe Code is as follows:
PIDTLT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.188.100) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = pid10gdb)
)
)
Modify the database alias, host address, and service_name.
4-of course, you can also download instantclient-sqlplus-win32-10.2.0.4.zip, decompress it to the same folder, use start-> RUN cmd to doscommand line, and run sqlplus system/oracle @ pidtlt on d: \ oracleclient to connect to the database!
To uninstall the SDK, you only need to delete all the four values in step 1 and delete the d: \ oracleclient folder!