PL/SQL Developer是一款Oracle开发调试管理工具,当前基于官方最新的PL/SQL Developer 14版本安装并配置Oracle数据库连接。
本文基于Windows10_1909系统环境进行验证,其他系统环境不保证一定可用,请自行测试。
PLSQL Developer 14版本默认自带中文语言了,无需额外安装汉化包。
不配置tns,直接连接plsql方法见文末!!!
首先下载PLSQL Developer 14 (64 bit)和instantclient,instantclient截至本文发文前最新版本是19.11.0.0.0。
注意:instantclient版本不一定要用最新的,部分情况下使用最新版本会出现连接报错
PLSQL Developer 14下载:
官方下载地址:https://www.allroundautomations.com/files/trial/plsqldev1405x64.msi
本地下载地址:https://down.whsir.com/downloads/plsqldev1405x64.msi
instantclient官方下载地址:
https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html
https://www.oracle.com/cn/database/technology/instant-client.html
注意这里官方提供两个版本Basic Package和Basic Light Package,你可以理解成完整版和最小化版本,因为PLSQL主要需要oci.dll,所以此处下载最小化的包就行,即instantclient-basiclite-windows.x64-19.9.0.0.0dbru.zip
官方下载地址:https://download.oracle.com/otn_software/nt/instantclient/19900/instantclient-basiclite-windows.x64-19.9.0.0.0dbru.zip
本地下载地址:https://down.whsir.com/downloads/instantclient-basiclite-nt-19.9.0.0.0dbru.zip
附instantclient其他版本下载地址,使用配置方法与19版本一致:
https://down.whsir.com/downloads/instantclient-basiclite-win64-10.2.0.5.zip
https://down.whsir.com/downloads/instantclient-basiclite-win-x86-64-11.1.0.7.0.zip
建议使用此版本:https://down.whsir.com/downloads/instantclient-basic-windows.x64-11.2.0.4.0.zip
https://down.whsir.com/downloads/instantclient-basiclite-windows.x64-12.1.0.2.0.zip
https://down.whsir.com/downloads/instantclient-basiclite-windows.x64-12.2.0.1.0.zip
https://down.whsir.com/downloads/instantclient-basiclite-windows.x64-18.5.0.0.0dbru.zip
https://down.whsir.com/downloads/instantclient-basiclite-windows.x64-19.11.0.0.0dbru.zip
product code : ke4tv8t5jtxz493kl8s2nn3t6xgngcmgf3 serial Number: 264452 password: xs374ca 或者也可用下面这个 product code: 4vkjwhfeh3ufnqnmpr9brvcuyujrx3n3le serial number: 226959 password: xs374ca
NLS_LANGSIMPLIFIED CHINESE_CHINA.ZHS16GBK
D:\edge\instantclient-basic-windows.x64-21.7.0.0.0dbru\instantclient_21_7\network\admin
ORCL =(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.220.133)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ORCL) ))
资源库 » 【Oracle客户端】PLSQL Developer 15 (64 bit)最新版安装使用教程(亲测)【Oracle客户端】PL