Embrace Oracle (Install using Oracle)

• Here provide baidu cloud link for your download: link: pan.baidu.com/s/1ttkY0hDO… Extraction code: 4193
• PLSqlDeveloper is just a visual data application for Oracle, similar to MySQL’s Navicat
• The installation directory is:

• 
  
  

• Detailed installation tutorial: PLSqlDeveloper (please click me crazy!)

3. Use PLSQL to connect to the Oracle database

• Because we only need to install OracleDatabase 11G on the server, the external connection, of course, the server also exposed the port, we will talk about later
• Ok, now that we have OracleDatabase 11g installed, let’s try to connect with the PLSQL software we just downloaded
• He may report an error:

• 
  
  

• PLSQL does not start because the oracle client is not installed or PLSQL is not told where to install the Oracle client

• There are two possible solutions:

• 1. Install the client, we did not specify the system variable, tell PLSQL, the client installation path, configuration as follows:

• 
  
  

• Is 2. We clear ourselves is to install oracle client, but may we install the client and PLSQL version does not take the installation, I accidentally install client is 32-bit, PLSQL installation is 64, the results have been landing, the results to a website, website clear, said digits to correspond, Otherwise, the connection fails

• 
  
  

• 32-bit clients can only use 32-bit PLSQL. 64-bit clients can only use 64-bit PLSQL

• Finally unified is 32 bits, login success!

4. Talk about the server Oracle and local PLSQL cooperation

• Under normal circumstances, we only need to install oracle client server, local installation of PLSQL tool, remote connection to oracle database, the following is how to operate
• Ora-12541 :TNS: no listener error ora-12541: no listener error ora-12541: no listener error ora-12541: no listener error ora-12541: no listener error ora-12541: no listener error ora-12541: no listener error ora-12541: no listener error ora-12541: no listener error ora-12541: no listener error ora-12541: no listener error ora-12541: no listener error

• 
  
  

• The server exposed ports are as follows:
• The specific operation: see article blog.csdn.net/yztezhl/art…
• After the operation is complete, we also need to expose a port 1521 on Ali Cloud

• 
  
  

• The Oracle client is now installed on our server

• How does local PLSQL connect to the server’s Oracle

• Install the PLSQL developer tool first, please note that the same as the server, the server client is downloaded using the link above, is 32 bits, here PLSQL tool also need to download the corresponding 32 bits

• After the PLSQL tool is installed, since we need to connect to Oracle remotely, we should also install the Oracle client, because we need the Oracle program to facilitate the PLSQL connection, there are two options, you can choose by yourself

• Solution 1: install the OracleDatabase client 32-bit on the local PC

• Scheme 2: Since the size of Oracle Client is more than 2G, and the space of my computer is relatively small, I do not want to install a Client of more than 2G on the computer, because we only need remote connection, so we can consider downloading a small Client Instant Client with a size of 70M instead of Oracle Client. The main function of the Instant Client is to enable remote connection

• Instant Client Indicates the server

• Download website: 32-bit download: www.oracle.com/database/te… 64 download: www.oracle.com/database/te…

• Baidu cloud download: download the 32-bit: pan.baidu.com/s/1pFtL7TAP… Extract code: s89f 64 downloads: pan.baidu.com/s/1XtD15RJf… Extraction code: lgfy

• This is the folder we installed, the directory is as follows:

• 
  
  

• The oci.dll file is the path we will configure on the PLSQL tool

• 
  
  

• Tip: The Instant Client also needs to use 32 bits, otherwise there will be unexpected problems

• The PLSQL Oracle Client is not correctly installed (PLSQL is connected to a remote database) : www.mamicode.com/info-detail…

5. OracleDatabase is different from Instant Client

• OracleDatabase is very complete, rich Client, including the Instant Client in the oci. DLL; You can create Oracle databases and tables locally
• Oci. DLL is extracted from OracleDatabase Client, so it can only connect to Oracle. You cannot create Oracle databases or tables locally
• The computer configuration is not so good, afraid of too much card, so I don’t consider installing oracle client, just need to install the client on the server, we can connect locally, everyone’s computer configuration point, or recommended installation!

6. Check whether the OracleDatabase client is 32-bit or 64-bit.

7. How to uninstall Oracle11g client completely

• Just install oracle, will introduce the uninstall Oracle, strange embarrassed, but still have to introduce, there is a install there is uninstall tutorial
• How to uninstall oracle11g client completely:
• 1, Stop oracle services: go to computer Management, in the services, find all services starting with Oracle, right click and choose Stop
• 2. In the Start menu, locate the Universal Installer, run Oracle Universal Installer, and click Uninstall product
• 3. In the product list window, click all items to expand, select all items except OraDb11g_home1, and click Delete
• After uninstalling, delete OraDb11g_home1
• 4, Press the Windows logo key and R key, open the run window, enter regedit, open the registry, expand HKEY_LOCAL_MACHINE\SOFTWARE, find oracle, delete
• 5. Expand HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all items starting with Oracle
• 6. Expand HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application and delete all items starting with Oracle.
• 7. In HKEY_CLASSES_ROOT, delete entries starting with ORA
• 8, restart the computer, delete the Oracle directory, delete the Oracle installation directory app, etc