oracle 远程tns配置

BYRUIY =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rui-oracle11g)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = byRuiy)
    )
  )


192.168.11.177 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.177)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ahwater)
    )
  )

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rui-oracle11g)(PORT = 1521))
)
)

ADR_BASE_LISTENER = /DBSoftware/app/oracle

~
~

原文地址:https://www.cnblogs.com/ruiy/p/7171496.html