Windows7 under PL/SQL Configuring remote connection to Oracle database

PL/SQL Developer is an integrated development environment that specializes in developing applications for Oracle databases. At the same time, PL/SQL is a procedural language

Called the process SQL language (procedural language/sql). PL/SQL is an extension of the Oracle database to the statement. In normal SQL

The use of the statement adds to the characteristics of the programming language. PL/SQL is available only for Oracle databases, and MySQL does not currently support PL/SQL.

Because of the working relationship, the SQL statement needs to be manipulated recently and the database is oracle10g. Operation database is not always directly on the server, it is generally

Remote, so find the Oracle client, generally recommended PL/SQL. So, download software, surf the internet for information, after a toss, finally finished, the following share the whole process. My operating system is WINDOWS7 Enterprise Edition 64-bit.

1. Preparation Conditions
Oracle Install Client
:http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html(32-bit, current PL/SQL only supports 32-bit)
PL/SQL
:http://pl-sql-developer.software.informer.com/download/
2. Installation Steps
1) Unzip the downloaded Instantclient-basic to a directory where my directory is D:\Oracle Install client\instantclient_12_1
Creating a directory under this directory Network/admin/,admin directory creates tnsnames.ora, which acts as a hosts file in Linux and provides tnsname
To the host name or IP.
What I have configured here is:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.18.200) (PORT = 1521))
(Connect_data =
(server = dedicated)//use private server mode to connect to the server mode matching, if not on the server according to the mode of automatic adjustment
(service_name = ORCL)
)
)
Below is a detailed description of the following major configuration items:
PROTOCOL: The communication protocol between client and server, generally TCP, without modification;
Host: hostname or IP address of the machine on which the database is listening;
Port: The database listens on the port being listened to, Oracle defaults to 1521;
SERVICE_NAME: On the server side, after using system login, sqlplus>show parameter service_name command to view
Example: sql> show parameter service_name;

          NAME                                   type         VALUE
          ----------------------------------------- ------------------------
          service_names                          string      ORCL
   
  2) Configure environment variables:
   oracle_home:d:\oracle Install client\instantclient_12_1  //is above Oracle install The directory where the client extracted the Oci.dll.

tns_admin:%oracle_home%\network\admin\//tnsnames.ora file is in the same location as the 1th step.
Nls_lang:simplified Chinese_china. ZHS16GBK//Set character sets or something, specific parameter information can be viewed http://www.cnblogs.com/debuging/archive/2012/09/10/2679213.html
Path last added:%oracle_home%
3) Install PL/SQL
The installation process is no longer described here, as is the case with other software installations.
3. After installation, open PL/SQL
Login window, the database drop-down list will show the database you just configured, of course, with the correct configuration.

So far, the configuration is complete.

This article is from the Eagle Eye blog, so be sure to keep this source http://eagle2014.blog.51cto.com/7992740/1416641