Plsql develope connecting Oracle database Configuration

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