DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: LISTENER status unknown

  1. #1
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681

    LISTENER status unknown

    Hi Friends,

    I have the following listener status log for our ora10g db with SID=ora10 :

    =================================
    Listener Parameter File /u01/app/oracle/product/10.1.0.2/network/admin/listene
    r.ora
    Listener Log File /u01/app/oracle/product/10.1.0.2/network/log/listener.
    log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=P520)(PORT=1521)))
    Services Summary...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "ora10" has 1 instance(s).
    Instance "ora10", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully
    ================================

    What does >>Instance "ora10", status UNKNOWN<< mean? why it is unknown?

    Thanks a lot

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    becuase the database hasnt registered itself with the listener, so the listener doesnt know what state the database is in

  3. #3
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    thanks davey....

    Do i have to register it? or just leave it that way? does it matter?


    Thanks again

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    if your listener is called LISTENER and listens on port 1521 when the databases comes up (9i and higher) it should register itself and the status will change to READY.

    Any no it doesnt really matter - it just saves you having to list things in the listener.ora file

  5. #5
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    thanks how do i register the database to the listener?

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    it should do itself on startup if the defaults are set, otherwise you need to set the local_listener parameter

  7. #7
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    I didnt do itself at startup , how do i set the local_listener parameter?

  8. #8
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    As dave pointed out, are you using the default listener or different listener. check your listener.ora parameter file.


    Also check your services

    lsnrctl services
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width