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

This article mainly explains "the detailed configuration of plsql connecting to oracle database". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn the detailed configuration of plsql connecting to oracle database.

Methods and steps for detailed configuration of plsql connection to oracle database

The first step: first install the plsql client, the plsql client is necessary, my colleague gave the plsql (English version client) installation is very simple (next step. No explanation!

Step 2: download oracle client. Mine is a 64-bit operating system.

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

Add that if the database is garbled: configure the environment variable: NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK can solve it.

At this point, I believe you have a deeper understanding of the "detailed configuration of plsql connecting to the oracle database". 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.