服务器和服务器时如何配置oracle监听器客户在同一个盒子上

Question

我有 2 台 Oracle 数据库服务器。如何在本地服务器上配置侦听器和 TNS 名称，以便本地服务器可以运行外部程序并访问远程服务器？

到目前为止，我有以下非工作配置。这有什么问题吗？非常感谢。

****TNSNAMES.ORA****
local_instance =
  (description =
    (address_list =
      (address = (protocol = tcp)(host = localhost)(port = 1521))
      (address = (protocol = ipc)(key=extproc0))      
    )
    (connect_data =
      (service_name = local_instance)
    )
  )

remote_instance =
  (description =
    (address_list =
      (address = (protocol = tcp)(host = xxx.xxx.xxx.xxx)(port = 1521))
    )
    (connect_data =
      (service_name = remote_instance)
    )
  )

****LISTENER.ORA****  
listener =
  (description =
    (address = (protocol = tcp)(host = localhost)(port = 1526))
  )  

Answer 1

这对我们有用：

# TNSNAMES.ORA

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

local_instance =
  (description =
    (address_list =
      (address = (protocol = tcp)(host = localhost)(port = 1521))
    )
    (connect_data =
      (service_name = local_instance)
    )
  )

remote_instance =
  (description =
    (address_list =
      (address = (protocol = tcp)(host = xxx.xxx.xxx.xxx)(port = 1521))
    )
    (connect_data =
      (service_name = remote_instance)
    )
  )

# LISTENER.ORA
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\oracle\10.2.0_DB)
      (PROGRAM = extproc)
      (ENVS="EXTPROC_DLLS=ANY")
    )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )