Configure the lite version of the Oracle client

Generally, it is only used as a client to access Oracle and does not need to install a large Oracle database. Sometimes I often forget how to configure the lite version of Oracle. This article creates a record backup. You can download the client suitable for your own system from the http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html, usually dozens of M, download the Basic version. After downloading and decompressing it to a directory, it can be used as an Oracle client, but some configuration is required. For example, if I put it in the D: \ Oracle directory, set the environment variable configuration as follows:
Www.2cto.com ORACLE_HOME points to D: \ OracleTNS_ADMIN points to D: \ OracleNLS_LANG. Set the value to the beginning of the SIMPLIFIED CHINESE_CHINA.ZHS16GBKPath environment variable to add D: \ Oracle. My local D: \ Oracle file is: the cfg suffix file and Sample are useless, listerner. ora is the listening file of the Oracle server, and it is useless here, sqlnet. the ora file is useless. The file directory of the latest win64 version that I downloaded is as follows, the 1.3 JDBC library is replaced by the classes12.jar package and the ojdbc14.jar package that supports JDK1.4 and later versions with ojdbc5.jar and ojdbc6.jar. The client connection file tnsnames. ora is configured as follows: cqyxtx =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 172.23.1.253) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = yxtx)
)
) Indicates that the connection IP address is 172.23.1.253 and the port is the default 1521 yxtx database instance. The database connection name is cqyxtx. Open PL/SQL and select Tools> preferences. The configuration is as follows:
Such as www.2cto.com, PL/SQL can be used as the oracle client.