PLSQL developer connecting to Oracle database configuration tutorial

Time:2019-12-11

Tools to install:

1. Download and install Oracle:

Download address:

http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/index.html

Detailed installation is not described in detail here. It should be noted that the downloaded two files need to be decompressed to the same directory and the path configuration of environment variables (try to use English character path):

在这里插入图片描述 

II. Install 32-bit instant client

Download 32-bit instant client (lightweight client) as the local Oracle environment (in the old version, the 64 bit instant client version seems to conflict with PLSQL).

url:http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

2. After the installation free version is decompressed, select a path (customized) of the computer, such as e: \ PLSQL \ instantclient ﹣ 12 ﹣ 2. Create two folders: network and Admin. Admin is a subfolder of the network folder, such as instantclient ﹣ 12 \ network \ admin, and then create the file tnsnames.ora. The basic configuration is as follows:


LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) )

ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) 

Where port: 1521 is the port number.

Host = localhost means that the access address IP is local.

Note: you can also copy the network file directly from the Oracle installation path to e: \ PLSQL \ instantclient ﹣ 12 ﹣ 2. Such as:

在这里插入图片描述 ————————————————

III. install PLSQL developer

1. This machine is win10 (64 bit) installed with PLSQL developer 10.0.5.1710.

PLSQL developer download address: https://www.allroundautomation.com/registered/plsqldev.html

2. After installation, do not log in temporarily. Click the “cancer” option to enter the page directly. In Tools > Preferences > connection, configure Oracle home and OCI library as follows:

11234Oracle

Home: fill in the decompression address of the installation free version. OCI Library: fill in the oci.dll address under the decompression address of the installation 12.

在这里插入图片描述

Click Apply after filling in

Note: try to use English character address.

3. Restart PLSQL after the above steps are completed. If the configuration is correct, the option to fill in the corresponding database name will appear. Enter the Oracle account password to log in normally, as shown in the figure.

在这里插入图片描述 在这里插入图片描述

Attempt to query operation, completed successfully! Problem: after configuring Oracle home and OCI library, reopen PLSQL to find that there is no database option.

Solution: the configured path may contain Chinese, orinstantclient_12_2\NETWORK\ADMIN\tnsnames.oraIf the configuration of is wrong or the environment is wrong, check carefully and make sure it is correct. In addition, the version of instantclient ﹣ 12 ﹣ 2 and PLSQL also ensure that there is no conflict.

DO YOUR BEST!

summary

The above is the PLSQL developer Oracle database configuration tutorial introduced by Xiaobian to you. I hope it can help you. If you have any questions, please leave me a message and Xiaobian will reply to you in time. Thank you very much for your support of the developepaer website!
If you think this article is helpful to you, welcome to reprint, please indicate the source, thank you!

Recommended Today

Promise handwritten promise from getting started to getting offer

1. Implementation of promise constructor Promise constructor is used to declare the sample object, and an executor function needs to be passed in. It includes the resolve function and reject function, as well as several important attributes: status attribute, result attribute and callback function queue. Basic framework of constructor The resolve function is used to […]