Re: catreq.sql script on linux

No, no, no, no, no.

Whoever told you that was wrong. Catrep MUST be run as SYS or connected internal, never SYSTEM. What ***should*** be done in large replication systems is move the def* tables. There's a bulletin from Support on how to do this. But catrep also build the dbms_ packages that are used by replication, and they need to be owned by SYS, not SYSTEM.

HTH. Pete

Glen Upreti wrote:

> In a class that I took, it was recommended that you run the catrep.sql
> script as system and set systems tablespace to something other than the
> system tablespace if you are going to be using replication. The
> replication tables can get rather large and have a lot of activity.
> --glen
>
> Pete Sharman wrote:
> >
> > I'm not familiar with this problem, but in any case if you're not using
> > replication you don't need to run catrep at all. All it does is build data
> > dictionary views and lots of packages for replication to work.
> >
> > HTH.
> >
> > Pete
> >
> > Roger Jackson wrote:
> >
> > > Bernhard,
> > >
> > > There is an error in the documentation on page 4-2. catrep.sql should be
> > > run as the Oracle user not the root user and requires you to start Server
> > > Manager to run it.
> > >
> > > Cheers,
> > >
> > > Roger
> > >
> > > Bernhard Buchreiter <bernhard.buchreiter_at_mhsg.ac.at> wrote in message
> > > news:3774A01C.2332EC0E_at_mhsg.ac.at...
> > > > After installing Oracle 8.0.5 on a host running Linux (SUSE 6.0)
> > > > the Oracle Documentation (Release 8.0.5 Installation Guide Page 4-2)
> > > > wants the catrep.sql script be executed - but I found no further
> > > > information how to do that.
> > > > When I start svrmgrl and type "connect internal" I get the message
> > > > "Connected."
> > > > But when I try to execute
> > > > svrmgr>@?/rdbms/admin/catrep.sql
> > > > I get a lot of Errors:
> > > > ORA-01012: not logged on
> > > >
> > > > What do I do wrong??
> > > >
> > > > Thanks for help.
> > > > Bernhard
> > > >
> > > >
> > > > --
> > > > University of Music and Dramatic Arts in Graz
> > > > Ing. Bernhard Buchreiter
> > > > Leonhardstrasse 15 Tel. +43-316-3891813
> >
> > --
> >
> > Regards
> >
> > Pete
>
> --
> |-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-|
> Glen Upreti
> Senior Oracle DBA
> Northern Arizona University
> Phone (520)523-8393 Fax(520)523-7407
> Glen.Upreti_at_NOSPAMnau.edu

--
Regards

Pete

Received on Tue Jun 29 1999 - 10:47:11 CDT