Re: Advanced Replication with Oracle 8i

Road Warrior wrote:
>
> I have a problem installing advanced replication with the replication
> manager (in enterprise manager for windows NT).

You do need to run - successfully - catrep.sql on both sites.
Check also catalog.sql.
You can select invalid objects to see if everything has compiled properly - usually you'll get some errs first time, you may need to explicitely drop objects that didn't compile previously. I use a third-party GUI called PL/SQL Developer which automatically displays invalid objects - allows you to select and compile them, and gives a command window for executing. Plus you can run scripts, browse db, build objects, etc.

Connect as sys to do all this.
And then as your repadmin user to manage the actual replication.
What rollback segment are you using as default? I don't remember needing anything huge. Have you set-aside enough space for rollbacks and is all that space made available?

>
> I have 2 database and wanna do Master To Master replication. So,
> Bidirectionale and asynchrone..
>
> I run CATREP.sql .. But should I run this script on both database.?
> Should I run it connected to SYS or SYSTEM..??
> Some error occure when I run the script.. Seem to be Rollback extent no
> enough high..
>
> But the big problem is when I use the replication manager , When I create
> the master sites..
> He create the repadmin user but I got the problem.. :
> ORA-4068 existing state of package have been discarded..
> Not execute package body SYSTEM.DBMS_REPCAT_ADMIN does not exist..
>
> I look in the database and I can not find this packaged..
>
> What should I do..!!!!!!??
Received on Tue May 30 2000 - 00:00:00 CEST