Re: ORA-12571:TNS:PACKET WRITER FAILURE - NOT A TECH, BUT NEED 8i HELP BADLY

jwolfsie_at_hallofsports.com (Jonathan Wolfsie) wrote in message news:<3409e16f.0110021005.60463ec8_at_posting.google.com>...
> My company has recently been deserted by the tech folks managing our
> systems, including the Oracle 8i db, which is the back-end to our
> website. Here's our platform:
>
> Compaq Proliant 3000
> OS:NT 4.0, OP 6
> Cold Fusion Server 4.0
> Oracle 8i - ver. 8.1.5
>
> Our website was running flawlessly until the following changes were
> made -
>
> Upgraded to service pack 6
> Installed NIMDA virus patch (from Microsoft)
> Updated Compaq controllers and bios (recommended by Compaq)
>
> After all was installed, we now experience the following symptoms from
> Oracle:
>
> - The database, which normally starts up almost instantly, is taking
> approx 8 minutes to get going

This probably means it is recovering from having crashed.

> - After up and running without issue for approx 5-10 minutes, the db
> shuts down with the following error message: ORA-12571:TNS:PACKET
> WRITER FAILURE. When the db is up, there is no connectivity problem
> with cold fusion server, the site runs as it were normal.

You might want to address the situation that caused everyone to leave, then
get some more help <ahem>.

Find where your tnslsnr is writing it's log files out to, and see if there
are any messages. find the alert.log (it perhaps has your instance name in
it) and see if it has any helpful clues. Find a file called init*.ora and
see if it has a reference to a background dump destination where it may be
writing some trace files.

12571, 00000, "TNS:packet writer failure" // *Cause: An error occurred during a data send. // *Action: Not normally visible to the user. For further details, turn
// on tracing and reexecute the operation. If error persists, contact // Oracle Customer Support.

I don't know much about windows, but on some platforms this error is an
indicator of a "lack of resources." Be sure you don't have any extra communications protocols and the one you are using is at the top of the list.
Be sure you don't have any unnecessary services. OracleAgent OracleStartSID OracleTNSListener OracleWWWListener9999 might be necessary. (SID refers to
the name of your database, often ORCL on default installs). Don't run \
anything besides Oracle. Optimize machine for network access. Check the Registry for all Oracle threads to run at NORMAL priority. Be sure everything
fits in memory. Ask Oracle Support if SP6 is really what you want. Be sure
the controllers aren't tripping over their own feet - you should put logs, data
indices all on separate devices, if possible.

If all else fails, upgrade to unix.

>
> I am in the unfortunate position of having to manage this issue with
> no experience, so any help or suggestions would be EXTREMELY
> appreciated.
>
> Thanks...JW
Received on Tue Oct 02 2001 - 19:02:12 CDT