No question at this time
DBA Top 10
1 M. Cadot 16900
2 A. Kavsek 15000
3 B. Vroman 10300
4 M. Hidayathullah ... 8400
5 T. Boles 4700
6 P. Wisse 4400
7 J. Schnackenberg 3500
8 K. Van Nieuwenhov... 2100
9 A. Hudspith 800
9 T. P 800
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48095
Total active users1706
Act. users last 24h8
Act. users last hour0
Registered user hits last week389
Registered user hits last month1490
Go up

end of file communication error
Next thread: Sql script to find the count of dblink which is not accessible
Prev thread: Partitioning and Local Indexes

Message Score Author Date
Hi masters, I am facing one problem on my produ...... javed akhtar Jul 31, 2017, 10:41
Dear Javed, please check below mos notes. OE...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Mirza Hidayathullah Baig Jul 31, 2017, 11:32
thanks mirza... javed akhtar Jul 31, 2017, 11:50
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => se...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Michel Cadot Jul 31, 2017, 12:01
Dear team, i am still not finding any solution ...... javed akhtar Aug 01, 2017, 14:48
Did you do what I said? ... Michel Cadot Aug 01, 2017, 15:17
thanks a lot team for your kind support.... javed akhtar Aug 02, 2017, 12:02
So what was the problem and how did you solve it...... Michel Cadot Aug 02, 2017, 14:32
Hello Michel, this error was not related to ora...... javed akhtar Aug 28, 2017, 13:53

Follow up by mail Click here


Subject: end of file communication error
Author: javed akhtar, India
Date: Jul 31, 2017, 10:41, 136 days ago
Os info: linux
Oracle info: 11g
Message: Hi masters,

I am facing one problem on my production server, I have to fetch some amount of data from a remote server via DB link.

where select is running fine and i am getting the data in required time.

SQL> select count(1) from loan_running_details_south_ap@DB_ORCL_PHY_146 abc where abc.msisdn in (select distinct churndump.msisdn from churndump) and loanstatus=0;

COUNT(1)
----------
1426

Elapsed: 00:00:20.30


whereas when i am trying to update data in DB link it is not updating and getting end of file communication error.

SQL> update loan_running_details_south_ap@DB_ORCL_PHY_146 abc set loanstatus=3 where abc.msisdn in (select distinct churndump.msisdn from churndump) and loanstatus=0;

update loan_running_details_south_ap@DB_ORCL_PHY_146 abc set loanstatus=3 where abc.msisdn in (select distinct churndump.msisdn from churndump) and loanstatus=0
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 18393
Session ID: 116 Serial number: 15605


SQL> explain plan for update loan_running_details_south_ap@DB_ORCL_PHY_146 abc set loanstatus=3 where abc.msisdn in (select distinct churndump.msisdn from churndump) and loanstatus=0;







explain plan for update loan_running_details_south_ap@DB_ORCL_PHY_146 abc set loanstatus=3 where abc.msisdn in (select distinct churndump.msisdn from churndump) and loanstatus=0
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 26207
Session ID: 259 Serial number: 8560


thanks,
javed
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: end of file communication error
Author: Mirza Hidayathullah Baig, United Kingdom
Date: Jul 31, 2017, 11:32, 136 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Dear Javed,

please check below mos notes.

OERR: ORA-3113 "end-of-file on communication channel" Reference Note (Doc ID 19790.1)

i found one of the mos note having bug

Bug 13260060 - ORA-3113, ORA-3114 for query over database link after restarting remote DB (Doc ID 13260060.8)

Regards
Mirza
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: end of file communication error
Author: javed akhtar, India
Date: Jul 31, 2017, 11:50, 136 days ago
Message: thanks mirza
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: end of file communication error
Author: Michel Cadot, France
Date: Jul 31, 2017, 12:01, 136 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message:
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink/MOS and/or call Oracle support.
Have a look at alert.log and trace files.

Regards
Michel

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: end of file communication error
Author: javed akhtar, India
Date: Aug 01, 2017, 14:48, 135 days ago
Message: Dear team,

i am still not finding any solution for the same.i am getting this error after 15 mins whereas the same query is running fine on another server in the same subnet and server rack.

update loan_running_details_south_ap@DB_ORCL_PHY_146 abc set loanstatus=3 where abc.msisdn in (select distinct churndump.msisdn from churndump) and loanstatus=0
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 29764
Session ID: 6 Serial number: 45896

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: end of file communication error
Author: Michel Cadot, France
Date: Aug 01, 2017, 15:17, 135 days ago
Message:
Did you do what I said?

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: end of file communication error
Author: javed akhtar, India
Date: Aug 02, 2017, 12:02, 134 days ago
Message: thanks a lot team for your kind support.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: end of file communication error
Author: Michel Cadot, France
Date: Aug 02, 2017, 14:32, 134 days ago
Message:
So what was the problem and how did you solve it?

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: end of file communication error
Author: javed akhtar, India
Date: Aug 28, 2017, 13:53, 108 days ago
Message: Hello Michel,

this error was not related to oracle, i raised a request to network & os team and get to know that there is network packet drop issue in LB.

thanks for your support.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here