Get the App
SLTechnology News&Howtos  ›  Servers  › 

How do I download plsql and connect to oracle?

Shulou Source: shulou.com Published: 2022-06-03 06:06:42 09月21日 Update

This article is to share with you the detailed tutorial of downloading plsql and connecting to oracle. I believe most people do not know how to install and configure it. In order to let you learn, I have summarized the following contents. Without saying much, let's read on.

Plsql download (click download immediately in normal download after entering):

Http://share.cnop.net/file426/1806028-428340587

1. Unpack and place this package in the root directory of system disk D:

two。 Set the environment variable:

User variable settings: right-click my computer-"Advanced -" environment variable, create the following items and fill in the following values:

LD_LIBRARY_PATH D:\ oracle

NLS_LANG AMERICAN_AMERICA.UTF8

SQLPATH D:\ oracle

TNS_ADMIN D:\ oracle

System variable: double-click path

Double-click Path, and the last variable value is entered (separate from the preceding; sign):

D:\ oracle

3. Change the connection information and go to the oracle directory to find tnsnames.ora

There are three places that need to be changed to your own information: ip, port (default 1521), and instance name.

4. Double-click the plsqldev.exe startup program: enter the user, password, select the database and click OK.

This is the end of the detailed tutorial on downloading plsql and connecting to oracle. I hope the above content can be of some help and learn more. If you like this article, you might as well share it for more people to see.

Tags: Variables information content tutorials more environment users directories articles systems input normal advanced three places most instances passwords data databases Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno MariaDB Shulou Information Microsoft Docker Shulou Tech Info