RE: stupid sqlnet.log question

From: <Hannah.M.Doran_at_sb.com>
Date: Fri, 8 Dec 2000 11:12:15 -0500
Message-Id: <10704.124040@fatcity.com>

Yeah I know. A LITTLE strange - hrmf! VERY strange, but the production dba doesn't seem to be concerned! Our connection problem yestarday was due to a corrupted listener file. That's all the explanation that I got!

Anyway, I was hoping that there was a size limit parameter or something, like other trace files.....

Seems as if this file has been there since the application was first release, there's problaby 2 years of data in there! Unbelievable!

Thanks,

Hannah

"Kevin Kostyszyn" <kevin_at_dulcian.com> on 12/08/2000 10:02:43 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
Subject: RE: stupid sqlnet.log question

I am not completely sure if this is correct, but my best guess would be to mark rename the file .old and recreate it or just drop it. However, isn't it a little strange that your sqlnet.log file is 800MB, kind of looks like you are getting a lot of errors.
Sincerely,
Kevin

-----Original Message-----

Hannah.M.Doran_at_sb.com
Sent: Friday, December 08, 2000 7:46 AM
To: Multiple recipients of list ORACLE-L

Sorry for what may seem like a stupid question, but is there a way to automatically truncate the sqlnet.log file on Win NT? I'm in development, and
we have a separate prod group that is supposed to take care of our prod servers.
Some of my clients were having issues connecting yesterday to production. I went to check the sqlnet.log file on prod for more details and found the file to
be over 800MB (unacceptable). Obviously, I could not even open the file!

The prod group was remiss in truncating the log (even after my request) for me
so I had to *fly* in the dark to resolve the connection issue.

Any ideas?

Thanks,

Hannah

Unfortunaley, even though I am in development, I am responsible for supporting
our users on production issues, however do not have enogh access tot he production environment to truly be able to help ARGH!

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Hannah.M.Doran_at_sb.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kevin Kostyszyn
INET: kevin_at_dulcian.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message