Thursday, March 26, 2015

Firewall Cause Oracle Listeners Can Not be connected.

for some reason, when I type tnsping in cmd.exe    it says  "no listener"
but the services.msc has a service "OracleOraDb11g_home1TNSListener"   it is started.


1. what I did is remove: the listener using "Net Configuration Assistant" to remove listener.
2. Then "REMOVE" c:\Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
remove listner.ora file.
3.   Stop the Windows Server 2008 R2 firewall setting.
    I think this is the problem, the firewall causing the problem.


4.  Finally Add New listener again!!
then it worked.

the differences are in the file below it uses hostname instead of ip address.

# listener.ora Network Configuration File: C:\Oracle\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\Oracle\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\Oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 3ds.localdomain)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = C:\Oracle

No comments:

Post a Comment