CentOS6.5 / Oracle11g / The listener supports no services

환경

 

[CentOS6.5 + Oracle11g] The listener supports no services

 

 

vi $ORACLE_HOME/network/admin/listener.ora

## 아래 붉은색부분 추가 ------------------------------------------------------------------------------

SID_LIST_LISTENER  =

  ( SID_LIST =

     (SID_DESC =

       (SID_NAME = ora11)

        (ORACLE_HOME = /oracle/product/11g)

     )

  )

 

 

 

 

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

      (ADDRESS = (PROTOCOL = TCP)(HOST = 서버아이피 )(PORT = 1521))

    )

  )

 

ADR_BASE_LISTENER = /oracle

------------------------------------------------------------------------------