1,将plsql developer 安装在oracle 安装目录下
2,在D:\oracle\product\11.2.0\client_1\network\admin 增加tnsnames.ora
具体内容如下:
ORCL_127.0.0.1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
(SERVER = DEDICATED)
)
)
在plsql developer 下自动出现信息
成功