Fatal Error...

[romulofbp]

Hello everybody !!

Could anybody explain me the message below ? The message below is the little part of the real message.

Hugs.

Rômulo.
(Brazil)

Dump file D:\Oracle\admin\luana\udump\ORA00139.TRC
Tue Dec 04 10:28:15 2001
ORACLE V8.1.5.0.0 - Production vsnsta=0
vsnsql=d vsnxtr=3
Windows NT V4.0, OS V5.101, CPU type 586
Oracle8i Release 8.1.5.0.0 - Production
With the Java option
PL/SQL Release 8.1.5.0.0 - Production
Windows NT V4.0, OS V5.101, CPU type 586
Instance name: orcl

Redo thread mounted by this instance: 1

Oracle process number: 12

Windows thread id: 139, image: ORACLE.EXE


*** 2001.12.04.10.28.15.164
*** SESSION ID:(11.58) 2001.12.04.10.28.15.134
FATAL ERROR IN TWO-TASK SERVER: error = 12571
*** 2001.12.04.10.28.15.164
ksedmp: internal or fatal error
Current SQL statement for this session:
INSERT INTO NF_SAIDA ( ID_EMPRESA,NRO_VENDA,NRO_PEDIDO,SERIE_PEDIDO,DT_MOVTO,ID_TP_VENDA,ID_CLIENTE,ID_VENDEDOR,CFO,ID_UF,V AL_BRUTO,VAL_DESCONTO,VAL_TOTAL,VAL_SEGURO,VAL_FRETE,ID_CONDICAO,BASE_ICMS1,ALIQUOTA_ICMS1,VAL_ICMS1 ,BASE_ICMS2,ALIQUOTA_ICMS2,VAL_ICMS2,BASE_ICMS3,ALIQUOTA_ICMS3,VAL_ICMS3,BASE_ICMS4,ALIQUOTA_ICMS4,V AL_ICMS4,BASE_SUBS,VAL_SUBST,VAL_ISENTO,VAL_OUTROS,MENSAG,OBSERV,DT_CANCELAMENTO,SITUACAO,ENTREGA,DT _APROVA_CRED,USER_APROV_CRED,DT_ATU,USER_ATU ) VALUES ( :b1,:b2,:b3,:b4,:b5,:b6,:b7,:b8,:b9,:b10,:b11,:b12,:b13, NULL , NULL ,:b14,NVL(:b15,0),NVL(:b16,0),NVL(:b17,0),NVL(:b18,0),NVL(:b19,0),NVL(:b20,0),NVL(:b21,0),NVL(:b22,0 ),NVL(:b23,0),NVL(:b24,0),NVL(:b25,0),NVL(:b26,0),NVL(:b27,0),NVL(:b28,0),NVL(:b29,0),NVL(:b30,0), NULL , NULL ,:b31,:b32,:b33,:b34,:b35,:b36,USER )
----- Call Stack Trace -----

[julian]

The error you get, namely 12571, maans breakdown of communications in the two-task layer.

Tha following instructions due to Metalink might help you:

- Shutdown the database
- Stop the listener
- Remove all the *.dat files in the c:\orant\otrace80\admin directory
- Specify the parameter HASH_JOIN_ENABLED = FALSE in the file
INIT(sid).ORA file
- Specify the parameter EPC_DISABLED =TRUE in the registry
(REGEDT32 -> HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE)
- Restart the database
- Specify the parameter TCP_KEEPALIVE in the Windows NT registry

HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Tcpip/Parameters

Edit - Add value : KeepAliveTime (REG_DWORD)

Decimal -> 180000 (for example = 3 minutes)


- Edit the file listener.ora. Configure the parameter
TRACE_LEVEL_LISTENER = OFF

- Remove unused protocol addresses, like Named Pipes and SPX, from the LISTENER.ORA file
- Start the listener
- Specify the SQLNET.EXPIRE_TIME = 0 parameter in the sqlnet.ora file

- Monitor your network

[romulofbp]

Thanks Julian,

I will do it.

Regards

Rômulo.