oracle 10g Lite Installation Steps Sharing

  • 2021-11-24 03:13:55
  • OfStack

Today, I encountered a software requirement to install oracle client, so I considered installing a simplified version. I downloaded instantclient-basic-win32-10. 2.0. 4. zip from http://www.oracle.com/technology/software/tech/oci/instantclient/index.html, which supports multiple languages. Although the final streamlined version is installed successfully, but the software is still no way to use, it is estimated that the streamlined version does not have the files it needs. However, it is good to learn to install a simplified version, hehe!
The installation steps of the simplified version are as follows:

1-Extract instantclient-basic-win32-10. 2.0. 4. zip into a folder such as d:\ oracleclient

2-Modify environment variables, right-click "My Computer", select "Properties", select "Environment Variables" in 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 at the end

3-Create tnsnames file. Create a new text file under d:\ oracleclient, named tnsnames. ora, and add the following database configuration:


PIDTLT =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.188.100)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = pid10gdb)
    )
  )

Modify the corresponding database alias, host address, service_name

4-Of course, you can also download instantclient-sqlplus-win32-10. 2.0. 4. zip, unzip it into the same folder, use Start-> Run cmd to dos command line, and run sqlplus system/oracle @ pidtlt under d:\ oracleclient to connect to the database!
To uninstall, just delete all four values in step 2 and delete the folder d:\ oracleclient!


Related articles: