Home » Server Options » Streams & AQ » Ora-03113 in alert log for stream replication (11g r2, linux)
Ora-03113 in alert log for stream replication [message #657076] Thu, 27 October 2016 08:15 Go to next message
qazims92
Messages: 37
Registered: July 2016
Location: Lahore Pakistan
Member
hi experts,

I am getting following error in Alert log while working on Stream Replication.

ORA-03113: end-of-file on communication channel
PING[ARC1]: Heartbeat failed to connect to standby 'TARGET.NETSOLPK.COM'. Error is 3113.

Kindly help.

Regards,
Qazi
Re: Ora-03113 in alert log for stream replication [message #657077 is a reply to message #657076] Thu, 27 October 2016 08:19 Go to previous messageGo to next message
BlackSwan
Messages: 25715
Registered: January 2009
Location: SoCal
Senior Member
qazims92 wrote on Thu, 27 October 2016 06:15
hi experts,

I am getting following error in Alert log while working on Stream Replication.

ORA-03113: end-of-file on communication channel
PING[ARC1]: Heartbeat failed to connect to standby 'TARGET.NETSOLPK.COM'. Error is 3113.

Kindly help.

Regards,
Qazi
What is OS name & version?
What is Oracle DB version to 4 decimal places.

ORA-00600/ora-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
Re: Ora-03113 in alert log for stream replication [message #657078 is a reply to message #657077] Thu, 27 October 2016 08:22 Go to previous messageGo to next message
qazims92
Messages: 37
Registered: July 2016
Location: Lahore Pakistan
Member
Thanks for response.

11.2.0.1.0
Windows

Regards,
Qazi
Re: Ora-03113 in alert log for stream replication [message #657079 is a reply to message #657078] Thu, 27 October 2016 08:28 Go to previous messageGo to next message
BlackSwan
Messages: 25715
Registered: January 2009
Location: SoCal
Senior Member
qazims92 wrote on Thu, 27 October 2016 06:22
Thanks for response.

11.2.0.1.0
Windows

Regards,
Qazi
I'm confused between above & below
>(11g r2, linux)
What is OS & database on each end of the Streams Replication?

When was last it worked without error?
What changed since then?
Re: Ora-03113 in alert log for stream replication [message #657087 is a reply to message #657076] Thu, 27 October 2016 11:53 Go to previous messageGo to next message
Michel Cadot
Messages: 65194
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

From previous topic, still answered:

Michel Cadot wrote on Wed, 26 October 2016 09:11

Michel Cadot wrote on Fri, 21 October 2016 16:46

Why Streams and not a materialized view?
Re: Ora-03113 in alert log for stream replication [message #657104 is a reply to message #657087] Fri, 28 October 2016 00:28 Go to previous messageGo to next message
qazims92
Messages: 37
Registered: July 2016
Location: Lahore Pakistan
Member
Thanks Blackswan and Michel.

My Os is Windows.

My source db has version 11.2.0.1.0 and My target db has version 11.2.0.4.0 .

I am getting ORA-03113 on source and getting ORA-07445 on target.

Now my question is that version differnce can be the cause of these errors?

Michel, We have to replicate 300 tables so MV replication is not accepted option.


Thanks in advance.

Regards,
Qazi
Re: Ora-03113 in alert log for stream replication [message #657107 is a reply to message #657104] Fri, 28 October 2016 01:05 Go to previous messageGo to next message
Michel Cadot
Messages: 65194
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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.
You can also read this article: Troubleshooting Internal Errors.
And MOS notes:
ORA-600/ORA-7445/ORA-700 Error Look-up Tool (Doc ID 153788.1)

Re: Ora-03113 in alert log for stream replication [message #657108 is a reply to message #657104] Fri, 28 October 2016 01:06 Go to previous messageGo to next message
Michel Cadot
Messages: 65194
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
My source db has version 11.2.0.1.0 and My target db has version 11.2.0.4.0 .
Why don't you upgrade source to 11.2.0.4?

[Updated on: Fri, 28 October 2016 01:38]

Report message to a moderator

Re: Ora-03113 in alert log for stream replication [message #657109 is a reply to message #657108] Fri, 28 October 2016 01:35 Go to previous messageGo to next message
qazims92
Messages: 37
Registered: July 2016
Location: Lahore Pakistan
Member
Hi Michel,

Difference in Oracle version is the issue?

Regards,
QAzi
Re: Ora-03113 in alert log for stream replication [message #657110 is a reply to message #657109] Fri, 28 October 2016 01:38 Go to previous messageGo to next message
Michel Cadot
Messages: 65194
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Don't know, check MOS.

Re: Ora-03113 in alert log for stream replication [message #657114 is a reply to message #657076] Fri, 28 October 2016 01:56 Go to previous messageGo to next message
John Watson
Messages: 7148
Registered: January 2010
Location: Global Village
Senior Member
Are you are using downstream capture? I have always found the default upstream capture easier, faster, and more reliable.
Re: Ora-03113 in alert log for stream replication [message #657115 is a reply to message #657104] Fri, 28 October 2016 01:59 Go to previous message
John Watson
Messages: 7148
Registered: January 2010
Location: Global Village
Senior Member
Quote:
Michel, We have to replicate 300 tables so MV replication is not accepted option.
300 tables is not problem. I have used MV replication with more than 700 tables no problem.


Quote:
11.2.0.1.0
Windows
This may be your problem. There were many stabilizations in Streams through the 11.2.x releases. I would never attempt it on 11.2.0.1.
Previous Topic: Question about CDC
Next Topic: Queuing Arabic text
Goto Forum:
  


Current Time: Sat Nov 18 13:41:32 CST 2017

Total time taken to generate the page: 0.02915 seconds