Use PL/SQL without installing the Oracle client

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 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 URL is as follows: publish Client. select a suitable version for downloading in 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 a network/admin folder in this path and a tnsnames. ora file in the C:/instantclient/network/admin folder. 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 the environment variable
Create in user variable: variable name: nls_lang variable value: SIMPLIFIED CHINESE_CHINA.ZHS16GBK add C: \ instantclient to 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 has been configured. Now pl/SQL developer can be used properly.

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

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

Remote connection configuration of Oracle Client and PL/SQL

Install and configure InstantClient and 64-bit PL/SQL on Linux

PL/SQL Developer log on to Oracle 12c

PL/SQL Developer Practical Skills

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