1. 系统要求
需要安装Oracle的客户端,Oracle客户端下载地址请点击这里
2. Oracle客户端安装步骤
(1). Download the appropriate Instant Client packages for your platform. All installations require the Basic or Basic Light package.
(2). Unzip the packages into a single directory such as C:\oracle\instantclient_18_3
(3). Add this directory to the PATH environment variable. If you have multiple versions of Oracle libraries installed, make sure the new directory occurs first in the path
(4). 在目录下C:\oracle\instantclient_18_3创建子目录“network/admin”,在该目录下新建文件tnsnames.ora
(5). 在tnsnames.ora文件就可以写Oracle的连接串了,例如:
ORACLE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORACLE)
)
)
经过这5步,Oracle客户端就安装完毕了。
备注:如果只是让PL_SQL Developer能够链接到数据库的话,则只需要下载Basic安装包即可
3. PL/SQL Developer安装步骤
(1)从官网上下载PL/SQL Developer(根据自己的系统来选择32位版本或者64位版本)
(2)点击进行安装,安装过程需要输入注册码
PLSQL Developer 12 注册码
product code: 4vkjwhfeh3ufnqnmpr9brvcuyujrx3n3le
serial Number:226959
password: xs374ca
(3)安装完毕之后,启动然后弹出数据库链接的界面,点击取消,然后点击Configure->Preferences.进入
Oracle->Connection.按照下图进行设置
(4)重启PL/SQL Developer即可
相关资源链接:
Oracle Instant Client FAQ