This discussion is archived
7 Replies Latest reply: Jul 3, 2011 7:14 PM by 871566 RSS

Oracle 11g Listener Supports No services

453394 Newbie
Currently Being Moderated
I have installed Oracle 11g in Linux (Centos). i created a starter database using dbca. I also created a listener.ora using netca.

I have observed that that the listener.ora was only generated like this after running netca:
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST =proky.warnerbro.com)(PORT = 1521))
    )
  )
Now when i start this listener, I get a message: "The listener supports no services".

I have read on some forums that something like this should be included:
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = $$###$)
      (ORACLE_HOME =$ORACLE_HOME)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = $ORACLE_HOME)
      (SID_NAME = orcl)
    )
   
  )
So, my question is, do dba's edit this manually or there should be a tool or wizard that would generate this text in listener.ora.

thanks in advance,

Anton

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points