Plsql Connecting Oracle

Install Client services only to use PL/SQL to connect Oracle

========================================

First download the Oracle corresponding client software, such as Instantclient_11_1 followed by the following steps.

1. Place the instantclient_11_1 in a non-Chinese directory.
2. Add environment variables.
3. Modify Oracle_home in Oracle.reg to the directory where the Instantclient_11_1 folder is located, run Oracle.reg
4. Modify the Tnsnames.ora file in the Instantclient_11_1 directory
such as: The name of the Listener =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.128) (PORT = 1521))
)
(Connect_data =
(service_name = database name)
)
)

Then add the environment variable:

Nls_lang=simplified Chinese_china. zhs16gbk//is primarily character set settings to prevent inconsistent coding
Tns_admin=c:\program files\oracle\instantclient_11_1
Path=c:\program files\oracle\instantclient_11_1;
5. Restart your computer

Plsql Connecting Oracle