OraFAQ Forum: General » TWO-TASK SERVER: error = 12571

Home » Other » General » TWO-TASK SERVER: error = 12571 (Oracle 9i, R2 + Windows 2000)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TWO-TASK SERVER: error = 12571 [message #278359]

Sat, 03 November 2007 05:56

babuknb
Messages: 1736
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

Report message to a moderator

Re: TWO-TASK SERVER: error = 12571 [message #278361 is a reply to message #278359]

Sat, 03 November 2007 06:13

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.

Report message to a moderator

Re: TWO-TASK SERVER: error = 12571 [message #278366 is a reply to message #278359]

Sat, 03 November 2007 08:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

unset the variable TWO_TASK

Report message to a moderator

Re: TWO-TASK SERVER: error = 12571 [message #278556 is a reply to message #278366]

Mon, 05 November 2007 01:17

babuknb
Messages: 1736
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

Report message to a moderator

Re: TWO-TASK SERVER: error = 12571 [message #278567 is a reply to message #278556]

Mon, 05 November 2007 01:28

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And then?
Did you do what Ana and Arju have said?

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 17:50:59 CDT 2024