d:\oraclexe\app\oracle\product\10.2.0\server\network\admin的tnsnames.ora中增加如下配置 demo= (description= (address_list= (address=(protocol=tcp)(host=218.17.160.22)(port=1521)) ) (connect_data= (service_name=demo) ) ) cmd中查看是否连接成功
d:\oraclexe\app\oracle\product\10.2.0\server\network\admin的tnsnames.ora中增加如下配置
demo =
  (description =
    (address_list =
      (address = (protocol = tcp)(host = 218.17.160.22)(port = 1521))
    )
    (connect_data =
      (service_name = demo)
    )
)
cmd中查看是否连接成功的方法
sqlplus njkf/njkf@218.17.160.22/demo
用 tnsping 连接名  次数       更方便 plsql