Win Install PLSQL connect remote Oracle

Since I do not want to install the Oracle client/oracle server, after installing the Oracle server on the virtual machine Linux, the implementation on win just installs PL/SQL connection to remote Oracle.

1. Download the PL/SQL tool installation (my 32-bit)

2. Download Instantclient-basic-win32-11.2.0.1.0.zip

3. After extracting the Instantclient-basic-win32-11.2.0.1.0.zip, the Tnsnames.ora will be downloaded on the Oracle server to modify the host

4. Configure Environment variables

Variable Name variable value
Tns_admin E:\ProgramFiles\instantclient_11_2

5. Modify Tools-->preferences

6. An error has been encountered:

1. Connection Timeout, Solution: Turn off the firewall, turn on 1521 terminal

2.lsnrctl Start (lsnrctl start for Oracle listener)
Error message:
The listener supports no services
The command completed successfully

Solution: Added in Oracle server file Listener.ora, Sid_list_listener = (Sid_list = (Sid_desc = (Global_dbname = instance name) (Sid_name = instance name)), followed by heavy Boot monitoring.

3. Changed the host contents of file Listener.ora and Tnsnames.ora.

Win Install PLSQL connect remote Oracle