1.
Download
Instantclient_11_2.zip
PL/SQL
2.
Unzip the instantclient_11_2.zip to the appropriate folder,
For example: E:\oracleclient\instantclient_11_2,
--------------------------------------------------------------------------------
Write a Sqlnet.ora file under this folder
Content:
NAMES. Directory_path= (TNSNames)
Sqlnet. Authentication_services= (NTS)
--------------------------------------------------------------------------------
Then create a network/admin-level folder underneath the directory,
For example: E:\oracleclient\instantclient_11_2\network\admin
Write a Tnsnames.ora file under this folder
The content format is as follows:
168=*pl/sql Instance Name
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.89.168) (port = 1522)) * Database connection + port
)
(Connect_data =
(service_name = ORCL) * DB instance Name
)
)
--------------------------------------------------------------------------------
3.
Add an environment variable to my computer, properties, advanced, environment variables,
The variable is named Tns_admin and the value is the path to the Tnsnames.ora file, for example: E:\oracleclient\instantclient_11_2
4.
After installing Plsql, start, Cancel, and click Tools->preferences->connection:
Oracle home=e:\oracleclient\instantclient_11_2
OCI Library=e:\oracleclient\instantclient_11_2\oci.dll
Restart Plsql, enter the user name, password, select the PL/SQL instance name to enter the database
5.
The initial login may have the problem of Chinese garbled, the solution is as follows:
Add an environment variable to my computer, properties, advanced, environment variable: variable name: Nls_lang variable Value: American_america. Zhs16gbk
Reconnect to display Chinese correctly.
If you want to convert to the UTF8 character set, you can assign "Nls_lang" to "American_america." UTF8, other codes ibid.
Oracle does not install Oracle Client connection database directly with PL/SQL