侦听器在连接到我公司网络时不起作用

Question

我有一个奇怪的问题，Oracle侦听器工作正常，没有问题，但当我连接到我的公司网络时，侦听器不工作，有人能就这个问题向我提出建议吗？

我正在使用xe oracle 11。

注意：主机在此设置为"xxxxxx.xxxx.xxxxx.xxx"，因为我不知道是否正式允许我在网络之外列出我的计算机名称。

我的tnsnames.ora

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxx.xxxx.xxxxx.xxx)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )
EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
ORACLR_CONNECTION_DATA = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 
    ) 
    (CONNECT_DATA = 
      (SID = CLRExtProc) 
      (PRESENTATION = RO) 
    ) 
  )

我的听众.oa

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:oraclexeapporacleproduct11.2.0server)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:oraclexeapporacleproduct11.2.0server)
      (PROGRAM = extproc)
    )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxx.xxxx.xxxxx.xxx)(PORT = 1521))
    )
  )
DEFAULT_SERVICE_LISTENER = (XE)

感谢

Answer 1

我已经替换了listener.ora和tnsnames.ora (path oraclexeapporacleproduct11.2.0servernetworkadmin)中的RAJESH-PC.xxxxx.xx.com with RAJESH-PC (hostname) or localhost ，并重新启动了我的系统。连接到VPN后工作正常。

listener.ora
===========
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = RAJESH-PC)(PORT = 1521))
    )
  )

或

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )
  
  
  
  

tnsnames.ora

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = RAJESH-PC)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

或

XE=（说明=（ADDRESS=（PROTOCOL=TCP）（HOST=localhost）（PORT=1521））（连接数据=（服务器=专用）（服务名称=XE）))

Answer 2

解决方案2

请在主机文件路径（C:WindowsSystem32driversetchosts）中添加以下主机详细信息

127.0.0.1 localhost
localhost RAJESH-PC RAJESH-PC.xxxxx.xx.com
127.0.0.1 RAJESH-PC RAJESH-PC.xxxxx.xx.com