Wikipedia

Search results

Tuesday, 3 June 2014

The listener supports no services

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