Windows7 under PL/SQL Configuring remote connection to Oracle database

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.