oracle listener.ora的host不能使localhost，而應該是該機器名，否則不能用ip地址進行串連，listener.ora

oracle listener.ora的host不能使localhost，而應該是該機器名，否則不能用ip地址進行串連，listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = AY140316135826Z)(PORT = 1521))
    )

  )

SID_LIST_LISTENER=
  (SID_LIST=
 (SID_DESC=
         (GLOBAL_DBNAME=orcl)
         (SID_NAME=orcl)   
         (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/)
       )
      )

oracle串連，localhost可以串連，19216812就不可以串連，解答，內有詳細說明各位幫我看看吧!!!

把這台機器上的防火牆關掉試試 192.168.1.2
 
ORACLE tnsnamesora與listenerora裡面host都是系統自動產生為localhost

listener.ora修改後需要重啟監聽