PLSQL Developer连接oracle

建立 tnsnames.ora文件 输入下面内容 放到pl/sql安装目录里就可以了host地址这些请修改成自己要连接的

# TNSNAMES.ORA Network Configuration File:C:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

databasename =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.153)(PORT = 1521)) 
      )
      (CONNECT_DATA =
        (SERVICE_NAME = test1)   
      )
    )

test1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.153)(PORT = 1521))
    )
    (CONNECT_DATA =
       (SID = test1)
    )
  )

win2003 +oracle 10g + plsqldev715 测试通过

转载于:https://www.cnblogs.com/skyapplezhao/archive/2010/08/14/1799669.html