How to use PLSQLDeveloper14 to connect to Oracle11g

This article mainly introduces how to use PLSQLDeveloper14 to connect Oracle11g, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

1. Environment configuration 1. Install PLSQLDeveloper14

Https://www.allroundautomations.com/

Download address of PLSQL14:

Https://www.yisu.com/softs/740737.html

Download and install tutorial for PLSQL14

/ / www.yisu.com/article/222302.htm

two。 Download and extract the Oracle client

For example, version: instantclient-basic-nt-19.8.0.0.0dbru.zip

3. Configure window operating system environment variables

Computer (right button) → Properties → Advanced system Settings → Environment variable → system Environment variable → New

Variable name: NLS_LANG

Variable value: AMERICAN_AMERICA.ZHS16GBK

Variable name: TNS_ADMIN

Variable value: d:\ work\ java\ software\ instantclient_19_11

II. Tool configuration 1.Oracle client configuration

Create a file named "tnsnames.ora" in the create folder network/admin/, under the decompressed directory of the Oracle client (instantclient-basic-nt-19.8.0.0.0dbru.zip), and add the following:

Orcl155 = # # orcl155 is the custom name (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = connection IP) (PORT = connection port)) # # modify the machine to be connected IP and listening port of the device) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) # # database service name)) 2.PLSQLDeveloper14 configuration

Configure ➡ preferences ➡ connection

1. Add Oracle home directory: extract the Oracle client directory to the Oracle home directory my local path is: d:\ work\ java\ software\ instantclient_19_11

two。 Add OCI library: copy the oci.dll file under the directory extracted from the Oracle client as the path and add it to the OCI library. The location of my local oci.dll file is: d:\ work\ java\ software\ instantclient_19_11\ oci.dll

3. Restart the PLSQLDeveloper14 client

Login: enter the user password and select the database

Thank you for reading this article carefully. I hope the article "how to use PLSQLDeveloper14 to connect to Oracle11g" shared by the editor will be helpful to everyone. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!