Remotely connect to a database using Plsql without Oracle installed locally

There are more than one way to connect a database remotely. The main writing here is how to remotely connect to a database using the Plsql Visualizer without Oracle installed locally.

First, the premise

First you have to install the Plsql tool locally. The specific installation steps are not much to say.

ii. Download the file named Instant Client to Oracle website

is: http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/index.html

After extracting the compressed file, you will get a folder called Instantclient_11_2, which can be easily placed in the local directory. Like E:/instantclient_11_2.

Third, configure the Instantclient_11_2 file

Create a new directory network in the E:/instantclient_11_2 directory, In the network directory to build the admin directory, in the Admin directory to create a new file Tnsnames.ora, open write:

ORCL =
(DESCRIPTION =
      (address_list =
       (　　　　 ADDRESS = (PROTOCOL = TCP) (HOST = 10.6.8.10) (PORT = 1521))
     )
     (Connect_data =
       (service_name = ORCL)
     )
)
where ORCL is the host name of the remote database locally, 10.6.8.10 is the IP address of the remote server, and ORCL is the name of the remote database.

Third, configure environment variables

　　

　　1. Tns_admin=%tnsnames.ora Path%

Tns_admin is the variable name, and the%tnsnames.ora path% is the variable value. such as: e:/instantclient_11_2/network/admin%

2, Nls_lang = simplified Chinese_china. Zhs16gbk
Nls_lang is the variable name, simplified Chinese_china. The ZHS16GBK is a variable value that is configured for the client language.

iv. Configuration Plsql

Open PL/SQL, click "Cancel" to go in; Configure the Tools->preferences->connection, Chinese client is the tool--and the connection is preferred.

　　

　Configure your local OCI library directory name and Oci.dll file address inside the red box to add to it, application, restart the client is OK.

Remotely connect to a database using Plsql without Oracle installed locally