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

This article mainly explains "what is the method of using PL/SQL to connect Oracle clients without installation". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "what is the method of using PL/SQL to connect to Oracle without installation of Oracle client?"

1. Download PL/SQL and Instant Client to download PL/SQL

Download address:

Https://www.allroundautomations.com/bodyplsqldevreg.html

My download version is: plsqldev1207x64. The download link is as follows:

Http://files.allroundautomations.com/plsqldev1207x64.msi

Download the Chinese language pack: Language pack under the corresponding version

Https://www.allroundautomations.com/plsqldevlang/120/index.html

To download Instant Client from the official website of Oracle, you need to register an Oracle account

Download address:

Https://www.oracle.com/technetwork/database/database-technologies/instant-client/downloads/index.html

My system is Windows 1064 bit, and my download version is: instantclient-basic-windows.x64-12.2.0.1.0.zip. The download link is as follows:

Https://download.oracle.com/otn/nt/instantclient/122010/instantclient-basic-windows.x64-12.2.0.1.0.zip?AuthParam=1553153165_6ead4567efd24df14d2b873e715c4d78

2. Configure Instant Client

Extract the Instant Client package (instantclient-basic-windows.x64-12.2.0.1.0.zip) and put the extracted folder (instantclient_12_2) in the D:\ Program Files directory

Create the $instantclient_12_2\ NETWORK\ ADMIN directory in turn

In the ADMIN folder, then create the tnsnames.ora file in the following format:

The identification name of the login server, for example: ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = server's IP address) (PORT = server port, default 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = service name, for example: orcl)

The above content needs to be modified according to your actual configuration.

PROTOCOL: the communication protocol between the client and the server, usually TCP

HOST: the hostname or IP address of the machine where the database is located

PORT: the port of the database listener, which can be viewed on the server side of the listener.ora file or through the lsnrctl status [listener name] command in the database server. It is usually port 1521.

SERVICE_NAME: use the "SHOW PARAMETER SERVICE_NAME" command to view it in the database, which is generally the same as DBNAME.

3. Install PL/SQL installation

Click the downloaded installation package plsqldev1207x64.msi, Next-- > I accept-- > modify the installation path and choose to install the trial version "Install trial version" next step: Next-- > full version: Complete next step: Next-- > Install-- > end: Finish

Sinicization

Install; chinese.exe

activation

Open PL/SQL, cancel at the login page, enter PL/SQL, and click help-> Register-- >

Run the activation tool "keygen.exe"-> Click "Generate"

Product Code: product number

Serial Number: serial number

Password: password

Click "Register"

Configure PL/SQL

Open PL/SQL, cancel at the login page point, enter PL/SQL, and configure-> preferences (Perference)-- > Oracle-> Connect in the tools menu.

Fill in D:\ Program Files\ instantclient_12_2 in the Oracle home directory (Oracle_home)

Fill in D:\ Program Files\ instantclient_12_2\ oci.dll in the OCI library (OCI Library)

Turn off automatic updates

Open PL/SQL, cancel at the login page point, enter PL/SQL, and configure-> preferences (Perference)-> other-> updates and messages in the tools menu.

Update-- > check the interval between online updates: never (prohibited), make sure to save.

This is fine. Start PL/SQL and log in to the server.

Plsql developer login failed, unable to initialize oci.dll

If your computer is 64-bit, install a 32-bit oracle database on your virtual machine

To use the sqlplus command on the local command line, install the corresponding 64-bit instantclient customer server tools

To use in plsql developer, you should install the corresponding 32-bit instantclient customer service tools

So you can install two different versions of instantclient customer service tools to meet the requirements.

At this point, I believe you have a deeper understanding of the "installation-free Oracle client to use PL/SQL to connect to Oracle". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.