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:
      (ADDRESS = (PROTOCOL = TCP)(HOST = 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_DESC =
      (SID_NAME = $$###$)
      (PROGRAM = extproc)
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (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,



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