How to connect PLSQL to Oracle Database

Time:2019-12-19

For the first time, I connected to Oracle database in this way, and Baidu did it for nearly two hours. Baidu’s resources are not reliable. After reading a lot of them, they are not complete. After reporting all kinds of errors, they can’t connect to the database. They collate their own data, hoping to give reference to other peers, and can’t guarantee that everyone can operate successfully! After all, sometimes it really depends on character, ha ha!

Step 1: install PLSQL client first. PLSQL client is necessary. My colleague gave me a simple installation of PLSQL (English version client) (next step, next step…). I won’t explain!

The second step: Download Oracle client, I am the 64 operating system with the download address: https://www.jb51.net/database/576109.html, providing resources, the brothers are very capable. During the period, 32 so-called perfect edition said that it supports 64 bit operating system, spent 5 points, is not practical, really black! It is recommended that if it is a 64 bit operating system, download the address client I gave above.

Then extract and install the Oracle 64 bit client instant client v11.2.0.3.0 (64 bit)

I chose the above items, and then I will install the next step

Step 3: configure PLSQL — tools — connect and configure Oracle home directory name path and coi library path

Step 4: configure Oracle home in the system environment variable

Finally, configure listening: write tnsnames.ora under the D: \ Oracle \ instant client \ network \ admin folder to the library you want to connect to


# tnsnames.ora Network Configuration File: F:\oracle\product.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: your local name
Address: address of the server
Protocol: the protocol used, here is TCP
Port: listening port number of the server
Service Name: server service name

Congratulations on connecting!

Why I am Chinese PLSQL? Because I have Chinese PLSQL package download address: https://www.jb51.net/software/207526.html

Add that if the database appears garbled: configuration environment variable: NLS ﹣ lang = simplified machine ﹣ china.zhs16gbk, it can be solved

The above is the whole content of this article. I hope it will help you in your study, and I hope you can support developepaer more.

Recommended Today

Build HTTP service with C + + Mongoose

Mongoose source code address:https://github.com/cesanta/mo… Mongoose user manual:https://www.cesanta.com/devel… Mngoose set up HTTP service #include <string> #include “mongoose.h” using namespace std; static const char *s_http_port = “8000”; static void ev_handler(mg_connection *nc, int ev, void *ev_data) { struct http_message *hm = (struct http_message *) ev_data; if (ev == MG_EV_HTTP_REQUEST) { std::string uri; if (hm->uri.p && hm->uri.p[0] == ‘/’) […]