Devart Forums

I am use ODAC Net Edition version 5.55.1.24 for Delphi 5 use Net mode Link Oracle8i,o/s is XP Pro Sp2.

Program is run a long time,but have onerror event from TOraSession,
Where EDAError Code Same time have
ORA-1 at a time
ORA-12571 two time.

if happen ORA-1,ORA-12571 error,I Must ReSet My PC,TOraSession is success Link oracle.

If you know please help me.

Thanks

Please describe the situation more detailed. Specify steps to reproduce the error. And if it is possible send us small sample that demonstrates your problem with scripts to create server side objects.

Thank you Ask Me.below is my Program run steps.

Program is abidingly run if not error.

1.Link At Form Show
OraSession:TOraSession;

with OraSession do
begin
UserName:=s_O_User;
Password:=s_O_PassWord;

if s_O_NET='T' Then
begin
Server:=s_O_IP+':'+s_O_Port+':'+s_O_SID;
end;
Options.Net := True;
Connected:=True;
end;

2.Program is one minute run
a.use Q1:TOraQuery run
SELECT * FROM LIST_MASTER Where STATUS='N' And LINE='A1' order by CREATE_DATE

if RecordCount>0 then
run detial sql
select * from LIST_DETAIL Where SEQNO='20061225A1001' order by SN

b. use Q2:TOraQuery run
aperiodicity update data

3.Recode DataError
procedure TDM1.OraSession_GetPickDataError(Sender: TObject; E: EDAError;
var Fail: Boolean);
begin
Memo1.Lins.Add(DatetoStr(Now)+TimetoStr(Now)+':'+Ora Error:'+IntToStr(E.ErrorCode)+'.' );
end;

a.Recode Error have
2006/5/29 03:53:01 : Ora Error:1.
2006/5/29 03:53:01 : Ora Error:12571.
2006/5/29 03:53:01 : Ora Error:12571.
2006/5/29 08:44:00 : Ora Error:1.
2006/5/29 08:44:00 : Ora Error:12571.
2006/5/29 08:44:00 : Ora Error:12571.
2006/5/29 08:44:00 : Ora Error:1.
2006/5/29 08:44:00 : Ora Error:1.
2006/5/29 08:44:00 : Ora Error:1.
2006/5/29 08:44:00 : Ora Error:1.
b.Prg Can Not normal Run Close Prg,Run Prg anew.
Recode Error have
2006/5/29 09:42:04 : Ora Error:12571.
2006/5/29 09:42:04 : Ora Error:12571.
2006/5/29 09:42:04 : Ora Error:1.
2006/5/29 09:42:04 : Ora Error:1.
c.ReSet PC Run Prg anew is Ok.

4.2006/6/5 My Customer is answer Prg have Error it errocode
have 2006/5/30 10:02:04 :Ora Error:1034.
and Show NetWork Error 55

Send us please small demo project to demonstrate the problem to ODAC support address and include script to create server objects.

Dear Friends
I too had the same error when I work with oracle, I was advised to format the PC to solve the problem, see this error happens when port 1521 is blocked, normal cases Windows firewall wont block this port, when this port is blocked tnsping80 won't work and because of this oracle pop up the error code 12571.
Why this port is blocked ?, its due to corrupted winsock files, download winsock fixing software from internet run it, this will solve the problem.
I tried this and problem got solved.I took nearly two days to resolve this issue, if anyone has any other suggestions please email me
[email protected]
Thank You
RANEESH CHITOOTHARAYIL