Re: Oracle 8i Listener Problem

jdd_at_sunbeltnetwork.com (John Dornisch) wrote in news:c74f9da0.0207050824.1a702b03_at_posting.google.com:

> Hello,
>
> I am experiencing a periodic problem with an oracle listener. Oracle
> 8.1.5 running on a Solaris 2.8 Box.
> The Problem... In the past week since Sunday. The listener will die
> for no obvious reason I can restart the listner using lsnrctl and it
> will work fine for about a day and then die again.
> I have a trace file from the last time it died but I have no idea what
> to look for.
>
> Any help in diagnosing this problem or ideas on what to look for in
> the trace file would be greatly appreciated.
>
> Thanks
> John D.

What trace level have you set in the listener.ora file? 0, USER, ADMINISTRATOR, or SUPPORT?. SUPPORT will give the most information.

Post the trace file you end up with.

While you're at it, how about the listener.ora from $ORACLE_HOME/network/admin and the recent part (the part surrounding the time of the listener dying) of the log file from $ORACLE_HOME/network/log?

-- 
Jason Baugher 
Virtual Adept Professional Consulting Services
1406 Adams St.
Quincy, IL 62301
(217) 221-5406
http://baugher.pike.il.us/virtualadept
jason_at_baugher.pike.il.us