| FATAL ERROR IN TWO-TASK SERVER: error = 12571 [message #57064] |
Sun, 18 May 2003 12:11  |
merksmiot
Messages: 1
Registered: May 2003
|
Junior Member |
|
|
can anyone help me to prevent this error
i hearby showing the actual error
*** 2003-05-02 16:29:28.000
*** SESSION ID:(48.11651) 2003-05-02 16:29:28.000
FATAL ERROR IN TWO-TASK SERVER: error = 12571
*** 2003-05-02 16:29:28.000
ksedmp: internal or fatal error
ORA-12571: TNS:packet writer failure
Current SQL statement for this session:
select DRM_DRUG_DESC,DRM_DRUG_CODE from H2002.drug_master where drm_drug_code in ( select distinct(DBD_DRM_DRUG_CODE) from H2002.drug_batch_details where dbd_stock > 0 and dbd_lcm_code=1) order by DRM_DRUG_DESC asc
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_ksedmp+101 CALLrel _ksedst+0 0
_opitsk+1152 CALLrel _ksedmp+0 2
_opiino+54f CALLrel _opitsk+0 0 0
_opiodr+546 CALLreg 00000000 3C 4 EA1FBD8
_opidrv+246 CALLrel _opiodr+0 3C 4 EA1FBD8 0
_sou2o+19 CALLrel _opidrv+0
_opimai+11b CALLrel _sou2o+0
_OracleThreadStart@ CALLrel _opimai+0 2 EA1FE74
4+35f
77E92CA5 CALLreg 00000000
--------------------- Binary Stack Dump ---------------------
*** 2003-04-30 15:59:19.000
*** SESSION ID:(91.12264) 2003-04-30 15:59:19.000
FATAL ERROR IN TWO-TASK SERVER: error = 12571
*** 2003-04-30 15:59:19.000
ksedmp: internal or fatal error
ORA-00028: your session has been killed
Current SQL information unavailable - no session.
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_ksedmp+101 CALLrel _ksedst+0 0
_opitsk+1152 CALLrel _ksedmp+0 2
_opiino+54f CALLrel _opitsk+0 0 0
_opiodr+546 CALLreg 00000000 3C 4 3C96FBD8
_opidrv+246 CALLrel _opiodr+0 3C 4 3C96FBD8 0
_sou2o+19 CALLrel _opidrv+0
_opimai+11b CALLrel _sou2o+0
_OracleThreadStart@ CALLrel _opimai+0 2 3C96FE74
4+35f
77E92CA5 CALLreg 00000000
--------------------- Binary Stack Dump ---------------------
*** 2003-05-14 10:56:48.000
*** SESSION ID:(31.11310) 2003-05-14 10:56:47.000
FATAL ERROR IN TWO-TASK SERVER: error = 12571
*** 2003-05-14 10:56:48.000
ksedmp: internal or fatal error
ORA-12571: TNS:packet writer failure
Current SQL statement for this session:
SELECT PTM_FIRST_NAME ,PTM_AGE, DECODE(PTM_SEX,1,'MALE','FEMALE'), PTM_KNOWN_AS,PTM_IPOP_NO FROM H2002.INPATIENT_MASTER, H2002.PATIENT_MASTER WHERE IPM_STATUS <> 3 AND IPM_PTM_CODE = PTM_CODE ORDER BY PTM_FIRST_NAME
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_ksedmp+101 CALLrel _ksedst+0 0
_opitsk+1152 CALLrel _ksedmp+0 2
_opiino+54f CALLrel _opitsk+0 0 0
_opiodr+546 CALLreg 00000000 3C 4 538EFBD8
_opidrv+246 CALLrel _opiodr+0 3C 4 538EFBD8 0
_sou2o+19 CALLrel _opidrv+0
_opimai+11b CALLrel _sou2o+0
_OracleThreadStart@ CALLrel _opimai+0 2 538EFE74
4+35f
77E92CA5 CALLreg 00000000
--------------------- Binary Stack Dump ---------------------
|
|
|
|
|
|
| Re: FATAL ERROR IN TWO-TASK SERVER: error = 12571 [message #58574 is a reply to message #57068] |
Thu, 18 September 2003 06:36  |
andy
Messages: 92
Registered: December 1999
|
Member |
|
|
I have similar problem. Can anybody tell me how do I solve this problem?
OS = Windows 2003 Advanced Server
Oracle Version = 8i
Oracle Product = 8.1.6.0.0
This error happened when i run a batch program which execute a very long PL/SQL.
Please advice....
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
