Home » Other » General » TWO-TASK SERVER: error = 12571 (Oracle 9i, R2 + Windows 2000)
TWO-TASK SERVER: error = 12571 [message #278359] Sat, 03 November 2007 05:56 Go to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Hi

In my production database. I have face the below error.

FATAL ERROR IN TWO-TASK SERVER: error = 12571
ksedmp: internal or fatal error

How to re-solve this error.

Babu B
Re: TWO-TASK SERVER: error = 12571 [message #278361 is a reply to message #278359] Sat, 03 November 2007 06:13 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

ORA-12571:	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.
Re: TWO-TASK SERVER: error = 12571 [message #278366 is a reply to message #278359] Sat, 03 November 2007 08:10 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
unset the variable TWO_TASK
Re: TWO-TASK SERVER: error = 12571 [message #278556 is a reply to message #278366] Mon, 05 November 2007 01:17 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Trace information:

*** 2007-11-05 10:05:49.000
*** SESSION ID:(156.24228) 2007-11-05 10:05:49.000
FATAL ERROR IN TWO-TASK SERVER: error = 12571
*** 2007-11-05 10:05:49.000
ksedmp: internal or fatal error
Current SQL statement for this session:
UPDATE POMST SET PRINTED='Y' WHERE SL_NO = :b1

I traced particular session sql stat:

1  select sa.sql_text,ss.username,ss.osuser,to_char(ss.logon_time,'dd-mon-yy hh:mi:ss'),sq.sql_text,sq.FIRST_LOAD_TIME   from v$s
ession ss, v$sqlarea sa,v$sql sq where sa.hash_value=ss.prev_hash_value and sa.hash_value=sq.hash_value and
  2* ss.sid=156
SQL> /
 
SQL_TEXT                       USERNAME                       OSUSER
------------------------------ ------------------------------ ------------------------------
TO_CHAR(SS.LOGON_T SQL_TEXT                       FIRST_LOAD_TIME
------------------ ------------------------------ -------------------
ROLLBACK TO FM_1               SAMIINVENTORY                  hashim
05-nov-07 10:09:27 ROLLBACK TO FM_1               2007-07-09/08:24:54
 
1 row selected.


Babu
Re: TWO-TASK SERVER: error = 12571 [message #278567 is a reply to message #278556] Mon, 05 November 2007 01:28 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And then?
Did you do what Ana and Arju have said?

Regards
Michel
Previous Topic: I am unable to run install of Oracle 8i
Next Topic: Need Help
Goto Forum:
  


Current Time: Mon Dec 05 20:59:17 CST 2016

Total time taken to generate the page: 0.12153 seconds