plsql 中配置远程数据库连接

oracle : 配置数据库连接

 

// 数据库配置文件目录

E:\oracle\ora92\network\admin\tnsnames.ora

 

 

(数据库名)

DBNAME =
  (DESCRIPTION =
    (ADDRESS_LIST =                      服务器ip
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.6.40)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = oracleDB)
    )
  )