-
I have Oracle 8.1.6 on Sun Solaris. If I open a session, and leave it idle for about couple of seconds (about a minute), and then try to execute SQL statement it shows following error:
ORA-12571: TNS:packet writer failure
What is the cause and how can I eliminate this and keep the session open for indefinite period?
-
I had same error "constantly". based on oracle:
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.
the problem is I can not recreate it manully (when I see the error on trace file the process back to normal)
anyone has idea?
-
Check the profile that you have assigned for the user. There you might have set the idle time limit low, which would disconnect the session connection to the user if the session were to be idle (i.e. literally dead) for the specified period then it would be disconnected by the server.
Good luck,
Sam
-
For last couple of months i am encountering the below errors in my production environment.
Today i encountered this error
ORA-12571: TNS:packet writer failure
ORA-12500: TNS:listener failed to start a dedicated server process
Few days back the below error was seen
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
HPUX Error: 32: Broken pipe
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
HPUX Error: 23: File table overflow
I am just wondering when all things working fine and all of sudden why these errors. what is the reason? I have the following version of oracle
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for HPUX: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production
Any help is greatly appreciated. Thanks in advance...