前言:
Oracle客户端安装体积很大,虽然满足了PLSQL工具连接oracle所需配置,但是也给电脑增加负担。为了能减轻电脑负担同时又满足PLSQL配置所需,我们可以去官网下载精简客户端。
百度网盘
链接:https://pan.baidu.com/s/1lHdjMLUAmlVn5lVRuhmcYw
提取码:vmyu
1.下载oracle精简版客户端
下载地址:Instant Client for Windows 32-bit
2.把下载的Basic版压缩包解压,放到D:\oracleClient\instantclient_19_11 (路径根据个人喜好)
3.在环境变量中配置新增3个变量
ORACLE_HOME=D:\oracleClient\instantclient_19_11
TNS_ADMIN=D:\oracleClient\instantclient_19_11
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
path+=D:\oracleClient\instantclient_19_11
4.在/home/Oracle/instantclient_11_2目录下新建一个tnsnames.ora文件,内容如下:
# tnsnames.ora Network Configuration File: D:\oracleClient\instantclient_19_11\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
5.安装PLSQL,点击next直至安装完成
6.打开PLSQL,选择cancel后进入PLSQL
7.选择菜单栏 tools > Preferences设置连接
8.关闭PLSQL重新打开,就可以连接远程oracle数据库了
9.破解PLSQL,点击菜单栏 Help > Register
Product Code(产品编号):4t46t6vydkvsxekkvf3fjnpzy5wbuhphqz
serial Number(序列号):601769
password(口令):xs374ca
10.点击Register后,再点击菜单栏 Help > About,可以看到已经激活成功