配置 PLSQL 连接 Oracle

在编写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