OraFAQ Forum: Replication » Oracle Streams

Home » Server Options » Replication » Oracle Streams (Oracle 11g - Oracle 10g, in windows server 2008 r2) (

) 1 Vote

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

Oracle Streams [message #544467]

Wed, 22 February 2012 00:17

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.

Report message to a moderator

Re: Oracle Streams [message #544478 is a reply to message #544467]

Wed, 22 February 2012 00:54

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

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

Report message to a moderator

Re: Oracle Streams [message #544499 is a reply to message #544478]

Wed, 22 February 2012 02:14

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?

Report message to a moderator

Re: Oracle Streams [message #544513 is a reply to message #544499]

Wed, 22 February 2012 02:54

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

Senior Member
Account Moderator

It is CATRPC.SQL now.

Regards
Michel

Report message to a moderator

Re: Oracle Streams [message #544524 is a reply to message #544513]

Wed, 22 February 2012 04:37

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...

Report message to a moderator

Re: Oracle Streams [message #544525 is a reply to message #544524]

Wed, 22 February 2012 04:45

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

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

Report message to a moderator

Re: Oracle Streams [message #544612 is a reply to message #544525]

Thu, 23 February 2012 00:14

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.

Report message to a moderator

Previous Topic:	how to replicate
Next Topic:	How to connect mview to mlog?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 11:18:54 CST 2025