Plsql develope connecting Oracle database Configuration

Source: Internet
Author: User

First, before we talk about Plsql develope connect to Oracle database configuration, let's talk about what to do if you don't have to plsql develope to connect to the Oracle database, which is to install the Oracle database natively, but this is a challenge for the Java laptop. , and the interface will be stuck for a long time without operation, can only be forced to shut down, it is very inconvenient to use, if the notebook configuration is high, and do not want to use Plsql, you can consider the direct installation of Oracle client.

Let's take a look at how to connect Oracle with PLSQ.

1, self-Baidu download Plsql client, personal comparison like from csdn up and down, you feel free. Download it and unzip it.

  

2, download instantclient, we can download from Oracle official website,: http://www.oracle.com/technetwork/database/features/instant-client/ Index-097480.html can also be downloaded from other sources, please feel free to do so.

3, download good after decompression, put in a notebook under a disk, such as D disk,:

   

4, is my configuration good plsql, just download instantclient No network folder, in the instantclient root directory of the new network folder, In the network folder inside the new Admin folder, in the Admin folder to create a new Tnsnames.ora file, this file can be downloaded from other places.

5. After building the relevant folders and files, open the Tnsnames.ora file and write the database configuration information under this file.
Orcl_test =

(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521))
)
(Connect_data =
(SERVER = dedicated)
(service_name = test)
)
)

Parameter description: Orcl_test is a custom database name, host is the database address, port is the port number, service_name is the database name

6, open the Plsqldev.exe,

7, select Tools, Preferences, connect, configure the Oracle home directory and the OCI library as shown in:

  

8. Configure Environment variables

  

  

Plsql develope connecting Oracle database Configuration

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.