Use PL/SQL without installing the Oracle client

To connect to Oracle, you often need to install an ORACLE client of hundreds of megabytes, which is very troublesome. This section describes how to use a thin client that does not need to be installed with PL

To connect to Oracle, you often need to install an ORACLE client of hundreds of megabytes, which is very troublesome. This section describes how to use a thin client that does not need to be installed with PL

To connect to Oracle, you often need to install an ORACLE client of hundreds of megabytes, which is very troublesome. This section describes how to connect to the oracle database by using a thin client that does not require installation.

In fact, these operations are very simple. If you write them here, you should consider it as a knowledge management. If you forget how to configure them, open this blog.

First download the installation package

Download Oracle Instantclient Basic package from the official Oralce website. The address is as follows: Find the Instant Client in the middle of the page and select the appropriate version to download from the Instant Client Downloads.

Step 2: unzip the installation package
1> after downloading, decompress the compressed file to a local path, for example, C:/instantclient.
2> Create the network/admin folder in this path and create tnsnames in the C:/instantclient/network/admin folder. ora file, the file content is the TNS information of the database to be connected. For example:

WORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.4) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)

)

The red part is my personal settings. The ORACLE Database Server IP address is 192.168.1.4 and the database service name is orcl. If you do not know the service name, run the following command:

Show parameter service_name

Step 3: Set Environment Variables
Create in user variable:

Variable name: nls_lang

Variable value: SIMPLIFIED CHINESE_CHINA.ZHS16GBK

Add C: \ instantclient to the system variable Path.

Step 4: Configure pl/SQL developer
Start PL/SQL Developer. On the logon window, click the cancel button to go to the main interface. Click Tools> Preferences. The following two parameters must be configured in Connection:
Oracle Home: C: \ instantclient
OCI Library: C: \ instantclient \ oci. dll

Now that the configuration is complete, pl/SQL developer can be used normally.

-------------------------------------- Split line --------------------------------------

Use PL/SQL to connect to Oracle without installing the Oracle client

Remote connection configuration of Oracle Client and PL/SQL

On Linux, how does one install and configure InstantClient and 64-bit PL/SQL? Id = 100170 & cid = 7

Settings for automatic transaction submission by PL/SQL Developer

PL/SQL Developer log on to Oracle 12c

PL/SQL Developer Practical Skills

-------------------------------------- Split line --------------------------------------