Re: catreq.sql script on linux

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

Received on Tue Jun 29 1999 - 08:39:08 CDT