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

This article will explain in detail how to connect to the oracle database in plsql. The content of the article is of high quality, so the editor will share it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

The first step: first install the plsql client, the plsql client is a must, my colleague gave the plsql (English version client) installation is very simple (the next step.) do not make instructions!

The second step: download oracle client I am 64-bit operating system complimentary download address: https://www.jb51.net/database/576109.html, provide resources brother is very powerful, during the next 32-bit so-called perfect version said to support 64-bit operating system, spent 5 points, impractical, really black! It is recommended that if the 64-bit operating system downloads the address client I gave above.

Then extract and install the oracle64 bit client Instant Client v11.2.0.3.0 (64-bit)

I chose the above items, and then the next step is to install

Step 3: configure plsql-tools-connect configure oracle main directory name path and coi library path

Step 4: configure ORACLE_HOME in the system environment variables

Finally, configure listening: the tnsnames.ora under the folder D:\ Oracle\ Instant Client\ network\ admin writes to the library you want to connect to.

# tnsnames.ora Network Configuration File: F:\ oracle\ product\ 10.2.0\ client_1\ network\ admin\ tnsnames.ora# Generated by Oracle configuration tools. MES = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.6.6) (PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = orcl)))

MES: that's your local name

ADDRESS: address of the server

PROTOCOL: the protocol used, here is TCP's

PORT: the listening port number of the server

SERVICE_NAME: server service name

On how to connect to the oracle database in plsql to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.