PLSQL Developer 通过oracle客户端 连接oracle

在oracle的安装目录下面有一个\network\admin目录,没有的话自己建立，修改tnsnames.ora配置文件，加入

自己定义的名称_ip地址  =
    (DESCRIPTION   =
        (ADDRESS_LIST   =
            (ADDRESS   =   (PROTOCOL  =   TCP)(HOST   =   ？.？.？.？)(PORT   =   1521))
        )
        (CONNECT_DATA   =   (SID   =？)(SERVER   =   DEDICATED))
    )

例如：

ORCLTEST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.19.108)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )