1. 准备instanceclient
在Oracle官方下载instanceclient:https://www.oracle.com/cn/database/technology/instant-client.html
将instance解压到instanceclient_home位置,之后再配置tnsname数据库连接串:编辑[instanceclient_home]/network/admin/tnsnames.ora(没有则先创建文件)
myorcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ORALCE_HOST_ADDR)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
2. 配置plsql developer
Configure --> Preferences --> connection
编辑Oracle Home(instanceclient的放置路径instanceclient_home)和OCI library([instanceclient_home/oci.dll])
3. plsql developer连接oracle数据库
在Database的下拉菜单中选择在tnsnames.ora中已经配置完成的连接,输入用户名密码即可