本文转载自budongs
一、下载
官网安装包(1106版本)下载链接:
官网中文语言包(110版本) 下载链接:
〔中文语言包的使用方法为:运行中文语言包程序(默认程序名为“chinese.exe”),然后将语言包安装在PLSQL主程序所在目录下即可 。若启动仍非中文,则依次点击 Tools ->Preferences->User Interface -> Appearance -> Language ,然后选择 Chinese.lang〕
百度云安装包&中文语言包下载链接:
链接:https://pan.baidu.com/s/1c16Uq56
密码: hm38
二、安装
1.双击运行plsqldev1106.exe开始进行安装(运行后会弹出对话框,点击“是”进行即可进入安装)
![PL/SQL Developer的安装以及与64位Oracle Database进行连接 PL/SQL Developer的安装以及与64位Oracle Database进行连接](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwzVndiRzloWkMxcGJXRm5aWE11YW1saGJuTm9kUzVwYnk5MWNHeHZZV1JmYVcxaFoyVnpMekV4TnpZek1qZ3ROREpoTURFME1qWmhNRGcxTmpKbU5TNXdibWMvYVcxaFoyVk5iMmR5TWk5aGRYUnZMVzl5YVdWdWRDOXpkSEpwY0NVM1EybHRZV2RsVm1sbGR6SXZNaTkzTHpndy5qcGc%3D.jpg?w=700&webp=1)
2.加载需要一段时间,请耐心等待
![PL/SQL Developer的安装以及与64位Oracle Database进行连接 PL/SQL Developer的安装以及与64位Oracle Database进行连接](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwzVndiRzloWkMxcGJXRm5aWE11YW1saGJuTm9kUzVwYnk5MWNHeHZZV1JmYVcxaFoyVnpMekV4TnpZek1qZ3RZVFptTXpFNE56RXlNRFl5TTJObU55NXdibWMvYVcxaFoyVk5iMmR5TWk5aGRYUnZMVzl5YVdWdWRDOXpkSEpwY0NVM1EybHRZV2RsVm1sbGR6SXZNaTkzTHpRd09RPT0uanBn.jpg?w=700&webp=1)
3.加载完成后,将出现用户协议界面,点击“I Argee”即可进行后续操作
![PL/SQL Developer的安装以及与64位Oracle Database进行连接 PL/SQL Developer的安装以及与64位Oracle Database进行连接](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwzVndiRzloWkMxcGJXRm5aWE11YW1saGJuTm9kUzVwYnk5MWNHeHZZV1JmYVcxaFoyVnpMekV4TnpZek1qZ3RaVGcwTXpneE5tWXdNVGRtWXpZMFpTNXdibWMvYVcxaFoyVk5iMmR5TWk5aGRYUnZMVzl5YVdWdWRDOXpkSEpwY0NVM1EybHRZV2RsVm1sbGR6SXZNaTkzTHpjd01BPT0uanBn.jpg?w=700&webp=1)
4.之后将进行安装目录的选择,选择完成后点击“Next”进行后续操作
![PL/SQL Developer的安装以及与64位Oracle Database进行连接 PL/SQL Developer的安装以及与64位Oracle Database进行连接](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwzVndiRzloWkMxcGJXRm5aWE11YW1saGJuTm9kUzVwYnk5MWNHeHZZV1JmYVcxaFoyVnpMekV4TnpZek1qZ3RPVFpqWkRBNVlXTmpOVFkxTURZMU55NXdibWMvYVcxaFoyVk5iMmR5TWk5aGRYUnZMVzl5YVdWdWRDOXpkSEpwY0NVM1EybHRZV2RsVm1sbGR6SXZNaTkzTHpVMU5BPT0uanBn.jpg?w=700&webp=1)
5.接下来将选择是否创建桌面快捷方式与开始菜单,以及安装到哪个用户,选择完成后点击“Next”进行后续操作
![PL/SQL Developer的安装以及与64位Oracle Database进行连接 PL/SQL Developer的安装以及与64位Oracle Database进行连接](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwzVndiRzloWkMxcGJXRm5aWE11YW1saGJuTm9kUzVwYnk5MWNHeHZZV1JmYVcxaFoyVnpMekV4TnpZek1qZ3RObVE0TTJGak1qZGpaV0ppT0RNd015NXdibWMvYVcxaFoyVk5iMmR5TWk5aGRYUnZMVzl5YVdWdWRDOXpkSEpwY0NVM1EybHRZV2RsVm1sbGR6SXZNaTkzTHpVME9BPT0uanBn.jpg?w=700&webp=1)
6.之后进行安装内容的选择,此处建议为默认,选择完成后点击“Finish”正式执行安装
![PL/SQL Developer的安装以及与64位Oracle Database进行连接 PL/SQL Developer的安装以及与64位Oracle Database进行连接](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwzVndiRzloWkMxcGJXRm5aWE11YW1saGJuTm9kUzVwYnk5MWNHeHZZV1JmYVcxaFoyVnpMekV4TnpZek1qZ3RZV0kwTnpZd05qa3dOamxsTURZMFpTNXdibWMvYVcxaFoyVk5iMmR5TWk5aGRYUnZMVzl5YVdWdWRDOXpkSEpwY0NVM1EybHRZV2RsVm1sbGR6SXZNaTkzTHpVMk1BPT0uanBn.jpg?w=700&webp=1)
7.安装需要一段时间,请耐心等待
![PL/SQL Developer的安装以及与64位Oracle Database进行连接 PL/SQL Developer的安装以及与64位Oracle Database进行连接](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwzVndiRzloWkMxcGJXRm5aWE11YW1saGJuTm9kUzVwYnk5MWNHeHZZV1JmYVcxaFoyVnpMekV4TnpZek1qZ3ROalU1TURNeE16TTVNV1UxT0RWaVlTNXdibWMvYVcxaFoyVk5iMmR5TWk5aGRYUnZMVzl5YVdWdWRDOXpkSEpwY0NVM1EybHRZV2RsVm1sbGR6SXZNaTkzTHpVME5RPT0uanBn.jpg?w=700&webp=1)
8.安装完成后将弹出概要信息窗口,点击“Close”便可完成安装。如果安装的Oracle Database版本为64位,则接下来还需要与其进行连接
![PL/SQL Developer的安装以及与64位Oracle Database进行连接 PL/SQL Developer的安装以及与64位Oracle Database进行连接](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwzVndiRzloWkMxcGJXRm5aWE11YW1saGJuTm9kUzVwYnk5MWNHeHZZV1JmYVcxaFoyVnpMekV4TnpZek1qZ3ROREUzWVdJNE0yTTVOekV4TUdRMU5DNXdibWMvYVcxaFoyVk5iMmR5TWk5aGRYUnZMVzl5YVdWdWRDOXpkSEpwY0NVM1EybHRZV2RsVm1sbGR6SXZNaTkzTHpVMU1RPT0uanBn.jpg?w=700&webp=1)
三、与64位Oracle Database进行连接
1.下载Oracle Clinet (32-bit)
官网下载链接:
instantclient-basic-nt-11.2.0.4.0.zip
百度云下载链接:
链接: https://pan.baidu.com/s/1bZyFi2
密码: gpx6
2.下载完成后将其解压(解压目录无强制要求,例如将其解压至C:\Oracle Clinet)
![PL/SQL Developer的安装以及与64位Oracle Database进行连接 PL/SQL Developer的安装以及与64位Oracle Database进行连接](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwzVndiRzloWkMxcGJXRm5aWE11YW1saGJuTm9kUzVwYnk5MWNHeHZZV1JmYVcxaFoyVnpMekV4TnpZek1qZ3RaVGN4WVRka05XRTFNMlJtTmpVellTNXdibWMvYVcxaFoyVk5iMmR5TWk5aGRYUnZMVzl5YVdWdWRDOXpkSEpwY0NVM1EybHRZV2RsVm1sbGR6SXZNaTkzTHpVd01BPT0uanBn.jpg?w=700&webp=1)
3.在解压后的 instantclient_11_2 目录下新建NETWORK\ADMIN目录(即建立两层目录),拷贝Oracle Database安装目录中的 tnsnames.ora 文件(假设Oracle Database的安装目录为默认设定,则tnsnames.ora文件在C:\app\TY1969\product\11.2.0\dbhome_1\NETWORK\ADMIN中,以此类推即可找到tnsnames.ora文件)至之前新建的ADMIN目录中
![PL/SQL Developer的安装以及与64位Oracle Database进行连接 PL/SQL Developer的安装以及与64位Oracle Database进行连接](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwzVndiRzloWkMxcGJXRm5aWE11YW1saGJuTm9kUzVwYnk5MWNHeHZZV1JmYVcxaFoyVnpMekV4TnpZek1qZ3RNakprTkdZNVlUazFNVGcwWmpNMFpDNXdibWMvYVcxaFoyVk5iMmR5TWk5aGRYUnZMVzl5YVdWdWRDOXpkSEpwY0NVM1EybHRZV2RsVm1sbGR6SXZNaTkzTHpReE5RPT0uanBn.jpg?w=700&webp=1)
![PL/SQL Developer的安装以及与64位Oracle Database进行连接 PL/SQL Developer的安装以及与64位Oracle Database进行连接](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwzVndiRzloWkMxcGJXRm5aWE11YW1saGJuTm9kUzVwYnk5MWNHeHZZV1JmYVcxaFoyVnpMekV4TnpZek1qZ3RPVEJsT1RGa09HRmhNV0l5TWpZMU5TNXdibWMvYVcxaFoyVk5iMmR5TWk5aGRYUnZMVzl5YVdWdWRDOXpkSEpwY0NVM1EybHRZV2RsVm1sbGR6SXZNaTkzTHpjd01BPT0uanBn.jpg?w=700&webp=1)
![PL/SQL Developer的安装以及与64位Oracle Database进行连接 PL/SQL Developer的安装以及与64位Oracle Database进行连接](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwzVndiRzloWkMxcGJXRm5aWE11YW1saGJuTm9kUzVwYnk5MWNHeHZZV1JmYVcxaFoyVnpMekV4TnpZek1qZ3RaamszTkRSak5qaG1PRFV4WVRKaE5TNXdibWMvYVcxaFoyVk5iMmR5TWk5aGRYUnZMVzl5YVdWdWRDOXpkSEpwY0NVM1EybHRZV2RsVm1sbGR6SXZNaTkzTHpRd05RPT0uanBn.jpg?w=700&webp=1)
4.如果安装的Oracle Database为64位版本 ,则打开PQ/SQL Developer后会发现Datebase处为空。此时直接点击“Cancel”(或点击右上角“X”),以非登录模式进入PQ/SQL Developer
![PL/SQL Developer的安装以及与64位Oracle Database进行连接 PL/SQL Developer的安装以及与64位Oracle Database进行连接](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwzVndiRzloWkMxcGJXRm5aWE11YW1saGJuTm9kUzVwYnk5MWNHeHZZV1JmYVcxaFoyVnpMekV4TnpZek1qZ3RPVFU0TWpOak9ESmhOVFZtTldNellTNXdibWMvYVcxaFoyVk5iMmR5TWk5aGRYUnZMVzl5YVdWdWRDOXpkSEpwY0NVM1EybHRZV2RsVm1sbGR6SXZNaTkzTHpRek53PT0uanBn.jpg?w=700&webp=1)
5.之后依次点击Tools/工具->Preference/首选项->Connection/连接,在“Oracle Home/Oracle主目录”处填写解压后的 instantclient_11_2 目录路径(例如为C:\Oracle Clinet\instantclient_11_2),在“ OCI library/OCI库”处填写解压后的 instantclient_11_2 文件夹目录中 oci.dll 文件的路径(例如为C:\Oracle Clinet\instantclient_11_2 \oci.dll),填写完成后点击“OK/确定”,然后关闭PQ/SQL Developer
![PL/SQL Developer的安装以及与64位Oracle Database进行连接 PL/SQL Developer的安装以及与64位Oracle Database进行连接](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwzVndiRzloWkMxcGJXRm5aWE11YW1saGJuTm9kUzVwYnk5MWNHeHZZV1JmYVcxaFoyVnpMekV4TnpZek1qZ3RPV1ptWWpZNE4yVm1ORFV5TnpNd05pNXdibWMvYVcxaFoyVk5iMmR5TWk5aGRYUnZMVzl5YVdWdWRDOXpkSEpwY0NVM1EybHRZV2RsVm1sbGR6SXZNaTkzTHpZMk9RPT0uanBn.jpg?w=700&webp=1)
6.接下来重新打开PQ/SQL Developer,验证是否连接成功,如果Datebase处为非空则说明已连接成功,此时便可登录数据库
![PL/SQL Developer的安装以及与64位Oracle Database进行连接 PL/SQL Developer的安装以及与64位Oracle Database进行连接](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwzVndiRzloWkMxcGJXRm5aWE11YW1saGJuTm9kUzVwYnk5MWNHeHZZV1JmYVcxaFoyVnpMekV4TnpZek1qZ3RaR0l6TVRFek5ERmtNelkwTkRabVpDNXdibWMvYVcxaFoyVk5iMmR5TWk5aGRYUnZMVzl5YVdWdWRDOXpkSEpwY0NVM1EybHRZV2RsVm1sbGR6SXZNaTkzTHpRME1BPT0uanBn.jpg?w=700&webp=1)