Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 11g Listener Supports No services

antonyuloFeb 19 2009 — edited Jul 3 2011
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

Comments

Satish Kandi
If you have created the database before creating the listener, you need to explicitly register the instance with the listener.

If the listener is up and running when the database is started, PMON will directly register the instance with available listener.

You can use

ALTER SYSTEM REGISTER;

and check if listener is supporting your instance now.
Centinul
You can edit it manually, or use tools provided by Oracle. Oracle provides tools called the Net Configuration Assistant and Net Manager.

I highly recommend you read the proper SQL*Net Administrators guide available on OTN for your database version.

HTH!
669771
Hi,

is your database running?

chel lsnrctl status listener

yes, alter system register help me many times

Regards,
Tom
htp://oracledba.cz
antonyulo
Thanks guys.

Another question though.

How can I edit the listener that is used by emctl (database control)? Cause I have edited my listener.ora. I have removed an entry originally listened to by database control. For Example, originally there was a listener called listener3 which was used by emctl. Now I run netca and remove "listener3" and add one listener "listener". If i check listener.ora at ORACLE_HOME/network/admin, the file now has an entry listener and no more listener3.

However when I start emctl, it says there that is still uses the "listener3" listener
So even if i issued a "alter system register" at sqlplus, I still can't find my database on emctl.
674481
Hey thank you guys - alter system register just helped as well.
871566
where do u type this line command? mind share?
sb92075
868563 wrote:
where do u type this line command? mind share?
which command?
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 31 2011
Added on Feb 19 2009
#general-database-discussions
7 comments
37,919 views