Oracle PLSQL

1、PLSQL免安装版

A.PLSQL V12

PLSQL.zip

B.PLSQL安装包和激活码工具 V8

PLSQL8.zip

注册激活

B.PLSQL V7

PLSQL英文免安装版.rar

2、Oracle客户端连接轻量版

instantclient-basic-windows.x64-19.3.0.0.0dbru.zip

3、在Docker的Oracle容器查看配置

A.Docker安装Oracle数据库的实例可参考

语雀内容

B.查看Docker服务器中Oracle实例的配置信息

[root@fcant-hadoop001 ~]# docker exec -it oracle bash
[oracle@dbcef03180fe /]$ cd /home/oracle/app/oracle/product/11.2.0/dbhome_2/network/admin
[oracle@dbcef03180fe dbhome_2]$ cd /home/oracle/app/oracle/product/11.2.0/dbhome_2/network/admin
[oracle@dbcef03180fe admin]$ ll
total 20
-rw-r--r-- 1 oracle oinstall  381 Dec 29  2015 listener.ora
drwxr-xr-x 2 oracle oinstall 4096 Aug 23  2014 samples
-rw-r--r-- 1 oracle oinstall  187 May  8  2007 shrept.lst
-rw-r--r-- 1 oracle oinstall  239 Aug 23  2014 sqlnet.ora
-rw-r----- 1 oracle oinstall  425 Jan  4  2016 tnsnames.ora
[oracle@dbcef03180fe admin]$ cat listener.ora 
# listener.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_2/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))
    )
  )
ADR_BASE_LISTENER = /home/oracle/app/oracle
[oracle@dbcef03180fe admin]$ cat tnsnames.ora 
# tnsnames.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_2/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_HELOWIN =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
HELOWIN =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = helowin)
    )
  )
[oracle@dbcef03180fe admin]$

4、配置Oracle客户端

A.在解压包下创建文件夹：[network/ADMIN]

B.在新建的ADMIN文件夹下添加配置文件tnsnames.ora

tnsnames.ora内容如下

ORACLR_CONNECTION_DATA = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) 
    ) 
    (CONNECT_DATA = 
      (SID = helowin) 
      (PRESENTATION = RO) 
    ) 
  ) 
HELOWIN =                   
  (DESCRIPTION = 
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) 
    (CONNECT_DATA = 
      (SERVER = DEDICATED) 
      (SERVICE_NAME = helowin) 
    ) 
  )

C.客户端配置数据依据服务端

左为客户端连接配置，右为服务端数据库配置信息，客户端的配置依据服务端

5、在PLSQL配置Oracle客户端

6、登录连接