ORA-03113 when updating a table over a database link [message #617232] |
Thu, 26 June 2014 06:13 |
|
sss111ind
Messages: 636 Registered: April 2012 Location: India
|
Senior Member |
|
|
I am accessing the data through a dblink to update the table but it was throwing the following error sometimes even if the dblink is up and running.
ORA-02068: following severe error from xxxxxx
ORA-03113: end-of-file on communication channel.
[SPLIT from a hijacked topic by LF]
[Updated on: Thu, 26 June 2014 10:43] by Moderator Report message to a moderator
|
|
|
Re: Checking Remote database is up or not [message #617233 is a reply to message #617232] |
Thu, 26 June 2014 06:25 |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
ORA-02068: following severe error from stringstring
Cause: A severe error (disconnect, fatal Oracle error) received from the indicated database link. See following error text.
Action: Contact the remote system administrator.
|
|
|
|
|
|
|
Re: Checking Remote database is up or not [message #617280 is a reply to message #617277] |
Thu, 26 June 2014 12:52 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
I believe Materialized View from 10.2 to 11.2 will not work. I remember trying that at one time and it didn't work. I don't know if it was a known bug or just not implemented for 10g to 11g, or whether a patch fixed it.
I am sorry, my reason was not really helpful, but hopefully it will help out in some way.
|
|
|
|
Re: Checking Remote database is up or not [message #617305 is a reply to message #617302] |
Fri, 27 June 2014 02:45 |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
To use MV was just my suggestion for your process, not solution for the issue regarding dblink. MV is what is meant for your requirement.
Regarding the dblink issue, I suggest you probe the same questions to the remote side DBA.
|
|
|