Home » Server Options » Replication » Oracle Streams (Oracle 11g - Oracle 10g, in windows server 2008 r2)  () 1 Vote
Oracle Streams [message #544467] Wed, 22 February 2012 00:17 Go to next message
msnsathesh
Messages: 4
Registered: February 2012
Location: China
Junior Member

hi guys,

Actually am trying to replicate two db servers from one in hong kong and another in china. when am trying to establish the replication, am getting error 'ORA-04052: error occurred when looking up remote object' like this...

but the same way i have tried in my local network, it is working fine.

i have tried schema replication through enterprise manager grid control....

kindly put your ideas to solve this issue.thanks in advance.
Re: Oracle Streams [message #544478 is a reply to message #544467] Wed, 22 February 2012 00:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-04052: error occurred when looking up remote object %s%s%s%s%s
 *Cause:  An error has occurred when trying to look up a remote object.
 *Action: Fix the error.  Make sure the remote database system has run
          KGLR.SQL to create necessary views used for querying/looking up
          objects stored in the database.

Regards
Michel
Re: Oracle Streams [message #544499 is a reply to message #544478] Wed, 22 February 2012 02:14 Go to previous messageGo to next message
msnsathesh
Messages: 4
Registered: February 2012
Location: China
Junior Member

thanks for your kind reply.

Actually i can't find such file in my remote database.. what is the alternative for this?
Re: Oracle Streams [message #544513 is a reply to message #544499] Wed, 22 February 2012 02:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is CATRPC.SQL now.

Regards
Michel
Re: Oracle Streams [message #544524 is a reply to message #544513] Wed, 22 February 2012 04:37 Go to previous messageGo to next message
msnsathesh
Messages: 4
Registered: February 2012
Location: China
Junior Member

Thx for your immediate reply.

That file is present in my db_home folder.... wat can i do with help of that...
Re: Oracle Streams [message #544525 is a reply to message #544524] Wed, 22 February 2012 04:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You connect as SYS on the remote server and execute it.
Take care to execute the script that matches for the version.

Regards
Michel
Re: Oracle Streams [message #544612 is a reply to message #544525] Thu, 23 February 2012 00:14 Go to previous message
msnsathesh
Messages: 4
Registered: February 2012
Location: China
Junior Member

i have executed that without any error.

but y'day i have deleted the replication job in enterprise manager.
now i cannot able to establish another setup for replication in enterprise manager. wat can i do now............

And if am trying to do recovery, it is still showing the same error such s error occured during remote access.
Previous Topic: how to replicate
Next Topic: How to connect mview to mlog?
Goto Forum:
  


Current Time: Thu Mar 28 07:02:35 CDT 2024