Plsql developer connecting to a remote Oracle database

The traditional way to connect to a remote database is to install an Oracle locally. Then use the Network configuration Assistant. Then connect with PL/SQL Dev. It is not very convenient because the database needs to be installed locally

?

The second method is described below

1, first to the Oracle website to download three required compression package

Detailed address is: http://www.oracle.com/technetwork/topics/winsoft-085727.html

Required Packages:

Instantclient-basic-nt-12.1.0.1.0.zip
Instantclient-odbc-nt-12.1.0.1.0.zip
Instantclient-sqlplus-nt-12.1.0.1.0.zip

Download Plsql Developer

Unzip all the downloaded installation packages and place them in the same folder. For example, in D:\oracle

2, "Control Panel"-"System"-"advanced"-"Environment variables"-"System variables" add several environment variables:

Nls_lang =? Simplified Chinese_china. ZHS16GBK (or American_america. ZHS16GBK)
Tns_admin = D:\oracle
Ld_library_path = D:\oracle
SQLPath = D:\oracle

Add D:\oracle at the end of the path variable

3. Create the Tnsnames.ora file under D:\oracle. In the file, the following code is configured as a flat. Write your own easy error, it is recommended to install the Oracle database folder down the copy. Assuming that you have Oracle installed on your computer, the file's folder is under D:\Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN, which is my folder

# Tnsnames.ora Network Configuration file:d:\oracle\product\11.2.0\dbhome_1\network\admin\tnsnames.ora# Generated by Oracle configuration Tools. LISTENER_ORCL = (  ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521)) Oraclr_connection_data =  (DESCRIPTION =    (address_list = (      ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))    )    (Connect_data =      (SID = Clrextproc)      (PRESENTATION = RO)))  

ORCL =? (DESCRIPTION =?? (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))?? (Connect_data =??? (SERVER = dedicated)??? (service_name = ORCL)?? )? )

in the above file. ORCL is a connection identifier that can be changed by itself. Host is the address of the remote oracleserver. Port is Oracle's service port, which, if not changed, is 1521 by default. SERVICE_NAME is the remote instance name. Can be changed directly above, but also new to add a piece of code, such as the following:

zyback=  (DESCRIPTION = (    ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.88) (PORT = 1521))    (Connect_data =      ( SERVER = dedicated)      (service_name = zyback)    )  )

4. Execute Odbc_install.exe under D:\oracle folder, install ODBC driver

5, configure Plsql developer client,

Turn off restart Plsql Developer, enter user, password, database,

This allows you to remotely access Oracle databases in other locations.

Plsql developer connecting to a remote Oracle database