Tuesday 28 May 2013


The listener supports no services

If you face the above issue while starting listener, you may edit your listener.ora and tnsnames.ora file as per your environment.

LISTENER.ORA
----------------------

otm =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1523))
      (ADDRESS = (PROTOCOL = TCP)(HOST = server.xxxx.com)(PORT = 1523))
    )
  )
SID_LIST_otm =
  (SID_LIST =
        (SID_DESC =
         (SID_NAME = otm)
         (GLOBAL_DBNAME=otm.xxxx.com)
         (ORACLE_HOME = /otm/oracle/app/oracle/product/11.2.0)
        )
  )

ADR_BASE_LISTENER = /otm/oracle/app/oracle

TNSNAMES.ORA
------------

otm =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = server.xxxx.com)(PORT = 1523))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = otm.xxxx.com)
      (GLOBAL_DBNAME=otm.xxxx.com)
      (SID_NAME=otm)
    )
  )

Now restart listener successfully with services.........

No comments:

Post a Comment