安装 PL/SQL 15
OMIT
Oracle Instant Client Downloads for Microsoft Windows (x64) 64-bit
https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html
配置
# tnsnames.ora Network Configuration File:
E:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ocrl =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP) (HOST=192.168.12.223)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=ocrl)
)
)
一键登录
在快捷键加上参数
"F:\Program Files\PLSQL Developer 14\plsqldev.exe" userid=username/password@orcl
这样双击,不需要每次都填密码,直接登录