Use PL/SQL to connect to other Oracle databases

1. Download InstantClientOracle official website address: www. oracle. comtechnetworkdatabasefeaturesinstant-clientindex-097480.ht

1. Download Instant Client Oracle official website address: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.ht

1. Download the Instant Client

Oracle official website address:

The downloaded file is a compressed file. The decompressed file is named instantclient_11_2, which is placed in your favorite directory, for example, D:/instantclient_11_2.

2. D:/instantclient_11_2,

Enter the following content in the Text Editor:

MyOracle =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.1.4) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

Modify your local host name and remote database instance name

3. Add an environment variable named TNS_ADMIN. The value is the path of the tnsnames. ora file. For example, my local machine is D:/instantclient_11_2/network/admin.

4. Set the ORACLE language and add the environment variable NLS_LANG. The value is SIMPLIFIED CHINESE_CHINA.ZHS16GBK.

5. download and install the PL. SQL. Developer configuration application

Configure tools> preferences> connection

Oracle Home

D:/instantclient_11_2

OCI library

D:/instantclient_11_2/oci. dll

6. Disable PL/SQL Developer and restart Developer.

The host name appears in the PL/SQL Developer list. Enter the user name and password to log on to the remote oracle 11g database.