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.ArticleBack up a record.

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:

• ORACLE_HOME points to D: \ oracle
• Tns_admin points to D: \ oracle
• Set the value of nls_langSimplified chinese_china.zhs16gbk
• Add D: \ oracle at the beginning of PATH environment variable;

My local D: \ oracle file is as follows:

The CFG suffix file and sample file are useless, and listerner. ora is the listening file on the Oracle server, and sqlnet. ora file is useless.

The file directory of the latest win64 version that I downloaded is as follows:

Replace the JDBC libraries supporting jdk1.2 and 1.3 from classes12.jar, jdk1.4 and the above ojdbc14.jar packages to support later versions of 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)
)
)

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:

In this way, PL/SQL can be used as the Oracle client.