PL/SQL How to connect to Oracle remotely

How to connect to Oracle remotely with Plsql on a computer that does not have Oracle installed

Download Instantclient, my is WIN7, download is Instantclient-basiclite-nt-12.1.0.1.0.zip

Unzip to a fixed directory such as C:\instantclient_plsql

Create a file in the extracted directory Network\admin\tnsnames.ora

Edit the contents of the file, and note that IP and prot are used by remote Oracle

# Tnsnames.ora Network Configuration file:c:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora# Generated by Oracle configuration Tools.

ORCL = (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.176.110) (PORT = 1521)) (C Onnect_data = (SERVER = dedicated) (service_name = ORCL)))

Extproc_connection_data = (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1))) (CO Nnect_data = (SID = plsextproc) (PRESENTATION = RO)))

Set Plsql, menu is tools\prefrence

Restart the Plsql, you can connect remotely

PL/SQL How to connect to Oracle remotely