OraFAQ Forum: Networking and Gateways » Cannot insert through database link from 10g to 8.1.7

Home » RDBMS Server » Networking and Gateways » Cannot insert through database link from 10g to 8.1.7 (Oracle 10.2, Windows 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cannot insert through database link from 10g to 8.1.7 [message #302691]

Tue, 26 February 2008 11:29

rfcdba
Messages: 1
Registered: February 2008
Location: Massachusetts

Junior Member

I cannot insert into a table from a 10g database through a database link to an Oracle 8 database. I can do the same insert into an Oracle 9 database. Below is the error I get.

ORA-02068: following severe error from ORA8DB
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
ORA-02063: preceding line from ORA10G
Any ideas??

Report message to a moderator

Re: Cannot insert through database link from 10g to 8.1.7 [message #302696 is a reply to message #302691]

Tue, 26 February 2008 12:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Code: [Select all] [Show/ hide]

02068, 00000, "following severe error from %s%s"
// *Cause: A severe error (disconnect, fatal Oracle error) received from
//         the indicated database link.  See following error text.
// *Action: Contact the remote system administrator.

There should also be 1 or 2 trace files which might provide additional details about the cause of this failure.

Typically ORA-00600 are Oracle bugs & require a Service Request be submitted.

Report message to a moderator

Re: Cannot insert through database link from 10g to 8.1.7 [message #302700 is a reply to message #302691]

Tue, 26 February 2008 12:08

Michel Cadot
Messages: 68756
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

10g to 8i or the opposite database links are not supported.

Regards
Michel

Report message to a moderator

Re: Cannot insert through database link from 10g to 8.1.7 [message #302717 is a reply to message #302700]

Tue, 26 February 2008 14:52

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It seems that you'll have to have Oracle 9i instance in between 8.1.7 and 10g. Create database links (from 8.1.7 to 9i, and from 9i to 10g). Insert data from 8.1.7 to 9i via its database link, and have a database trigger which will transfer data further to 10g.

Report message to a moderator

Previous Topic:	TNSnames.ora
Next Topic:	Remote connection to Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 17 03:06:45 CDT 2025