Shulou(Shulou.com)05/31 Report--

This article introduces how to connect to the oracle database in PLSQL Developer, the content is very detailed, interested friends can refer to, hope to be helpful to you.

One: download and install Oracle:

Install 32-bit Instant Client

Download 32-bit Instant Client (lightweight client) as the local Oracle environment (the 64-bit Instant Client version in the old version seems to conflict with plsql).

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

two。 After decompressing the installation-free version, select a path under the computer (custom), such as E:\ PLSQL\ instantclient_12_2, and create two folders NETWORK and ADMIN under this path. ADMIN is a subfolder under the NETWORK folder, such as instantclient_12_2\ NETWORK\ ADMIN, and then create the file tnsnames.ora. The most 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 directly copy the corresponding network file from the Oracle installation path to E:\ PLSQL\ instantclient_12_2. Such as:

-

Third, install PLSQL Developer

1. This machine is a win10 (64-bit) installation version of PLSQL Developer10.0.5.1710.

PLSQL Developer download address: https://www.allroundautomations.com/registered/plsqldev.html

two。 After installation, do not log in temporarily, click the cancer option to go directly to the page, and configure Oracle Home (Oracle home directory) and OCI library (OCI library) in tools- > preferences- > connection (tools-preferences-connection), as follows:

Oracle

Home: fill in the decompression address of the installation-free version of instanclient_12_2. OCI library: enter the oci.dll address under the decompressed address of instanclient_12_2.

Click Apply after completing the form.

Note: try to use the address of English characters.

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

Try the query operation and complete successfully! Problem: after configuring Oracle Home (Oracle home directory) and OCI library (OCI library), reopen PLSQL and found that there are no database options.

Solution: it may be that the configuration path contains Chinese, or the configuration of instantclient_12_2\ NETWORK\ ADMIN\ tnsnames.ora is incorrect, or the environment is misconfigured. Check carefully and confirm that it is correct. In addition, instantclient_12_2 and PLSQL versions also ensure that there are no conflicts.

On how to connect to the oracle database in PLSQL Developer to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.