DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: listener

  1. #1
    Join Date
    Oct 2002
    Posts
    17

    listener

    dear all:

    why my listener all always miss?
    yesterday ,I start the listener , today morining ,I cant find the listener ,why?

    please give some advice!@

    B.Regards &thanks
    joyloce

  2. #2
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    What OS are you using?

    You may set TRACE_LEVEL_listener_name ON in listener.ora file to check it out.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  3. #3
    Join Date
    May 2002
    Location
    California, USA
    Posts
    175
    Check your listener.log file size. Sometimes when the size becomes larger the listener hangs and might die.

    Also see if you can find any clues in the listener.log file as well.

    Hope that helps,

    clio_usa
    OCP 8/8i/9i DBA
    Last edited by marist89; 11-01-2002 at 11:36 AM.

  4. #4
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587

    Re: listener

    Originally posted by joyloce
    dear all:

    why my listener all always miss?
    yesterday ,I start the listener , today morining ,I cant find the listener ,why?

    please give some advice!@

    B.Regards &thanks
    joyloce
    What do you mean you can't find it?
    Did you look under you desk, or maybe in the hall. My listener is also pretty naughty...
    POST some meaningful errors.
    What error did you get??
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  5. #5
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525

    Re: Re: listener

    Originally posted by Tarry
    What do you mean you can't find it?
    Did you look under you desk, or maybe in the hall. My listener is also pretty naughty...
    POST some meaningful errors.
    What error did you get??
    Tarry,

    can you keep you listener under control, it's just come in here an pinched my lunch
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  6. #6
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Jim,
    I apologize on his behalf, yesterday he ended up listening under some lady colleague's skirt. He's got to stay on the workstation, I'm gonna ground him..
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  7. #7
    Join Date
    Oct 2002
    Posts
    17
    dear all:
    sun solaris and oracle version 8.1.6.3

    1. if the listener.log file is great, can I delete the file?

    2.the following is the error ,how can I resolve the issue?
    04-NOV-2002 02:00:41 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=mppiss1)(USER=oracle))
    (COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=36716544)) * stop * 0
    No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=wxweb)))
    No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.38.13.251)(
    PORT=1521)))

    B.Regard & Thanks
    joyloce

  8. #8
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    It seems that user ORACLE on host MPPISS1 has stopped it at 2:00 AM. Is it a scheduled job? Check it out.

    You might establish a password to secure the listner using the Listner Control utility CHANGE_PASSWORD command.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  9. #9
    Join Date
    Oct 2002
    Posts
    17
    Originally posted by Calvin_Qiu
    It seems that user ORACLE on host MPPISS1 has stopped it at 2:00 AM. Is it a scheduled job? Check it out.

    You might establish a password to secure the listner using the Listner Control utility CHANGE_PASSWORD command.
    dear Calvin_Qiu :

    I have check the scheduled job ,it isn't a scheduled job ?
    I can't find the reason now!

    Thanks
    joyloce

  10. #10
    Join Date
    May 2002
    Location
    California, USA
    Posts
    175

    Smile

    Enable the listener tracing, start it up again, and check the trace file when stops again.

    Hope that helps,

    clio_usa
    OCP 8/8i/9i DBA

    Visit our Oracle DBA site

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