在编写tnsname.ora文件之前应该先在plsql中的首选项中配置Oracle目录
1编写tnsname.ora
XMHJ =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.10.10.10)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
2在Oracle登录窗口直接填写
填写内容:172.10.10.10:1521/orcl