1, to use PL/SQL need to install the Oracle client (this is necessary, otherwise plsql will not use, this client can go to Oracle official Web download, called instance client, as far as possible with the newer version on it, The Windows version of the big is more than 50 m, as well as the lite version of more than 20 m, address: http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/ index.html, pick a version of the system that suits you. ）
Oracle Client installation is simple, directly extracted, put in your favorite directory even if installed (such as I put in E:\instantclient_11_2 here, Instantclient_11_2 is the client extracted from the directory).
2, the client to use Oracle also need to configure, in the Oracle Client directory (E:\instantclient_11_2) to create a new folder name network, and then go to the network directory and then create a new directory admin, Then into the admin directory, in this directory to create a connection to the Oracle database configuration file Tnsnames.ora (this name, the other name is invalid), the file content is as follows:
WPSDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.12.3) (PORT = 1521))
(Connect_data =
(SERVER = oracle1)
(service_name = wpsdb.huacai.com)
)
)
There is no space at the beginning of the first line, the WPSDB1 is the instance name of the ORACLE database (ORACLE_SID) (Some people say this can be casually written I haven't tried ...) ),
The second line does not matter, after the equal sign empty can
The third line is very important, the IP behind the host is the Oracle database host IP, if there is a domain name resolution can be used hostname, the latter port is the Oracle listening ports, typically 1521 (the port can be used on the Oracle host command netstat- Ntlp|grep Tnslsnr view).
Row four does not matter, empty value can
Line five, that Oracle1 is my host name for Oracle's host (available command hostname view)
Line six is very important, there is a lot of information on the web that this place to fill Oracle SID, not (I put the SID value of Oracle after the error: ORA-12154 TNS: Listener currently does not recognize the service requested in the connection descriptor), In fact, this should be filled in the Oracle service name, to see this service name can be used on the Oracle host on the Oracle Account Input command lsnrctl Status View, I get the results of the execution of a few lines:
Services Summary ...
Service "Wpsdb.huacai.com" has 2 instance (s).
Instance "WPSDB1", status ready, have 2 handler (s) for the This service ...
Instance "WPSDB2", status ready, have 1 handler (s) for the This service ...
Compare the above service_name the value I added, it should be easy to determine what your service name is.
3, such as the above configuration after the Plsql can not log on to Oracle use, because it can not find your Oracle client, but to enter the software, enter the software, choose Tools->preferences, in the Oracle home and OCI The path of the Oracle client in the library two column and the paths of the OCI files (the Oci.dll file is directly under the Instantclient_11_2 folder), so what I'm filling out in these two options is "E:\instantclient_11_2 "and" E:\instantclient_11_2\oci.dll ". Log in again to be able to log in successfully. Restart PL/SQL if not yet.
4, sometimes may appear the client to the Chinese support bad question, may refer to the following third article environment variable setting:
On the desktop, right-click My Computer, select Properties, select Environment variables in the Advanced page, and in the system variables, increase:
1) variable name: oracle_home
Variable Value: E:\instantclient_11_2
2) variable name: tns_admin
Variable Value: E:\instantclient_11_2
3) variable name: Nls_lang
Variable value: Simplified Chinese_china. Zhs16gbk
4) Modify the path variable and add E:\instantclient_11_2 later
Configuring PL/SQL Developer remote access to the Oracle database
