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 v220.127.116.11.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.