Re: Oracle 8.05 + Solaris 2.6 and catrep.sql

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Sun, 11 Jul 1999 07:33:59 +0200
Message-ID: <931671202.28655.0.pluto.d4ee154e@news.demon.nl>

Hi William,

Such scripts need to be run in svrmgrl connected as internal. There should be no problem in re-running it. Your errors point to a too low number of open_cursors in init<sid>.ora.

Hth,

Sybrand Bakker, Oracle DBA

William Shenfield <william.shenfield_at_crowntech.co.uk> wrote in message news:3787C175.DB050D28_at_crowntech.co.uk...
> Hi,
>
> I have just performed a clean install of Oracle Enterprise Server 8.0.5
> on
> a fully patched Solaris 2.6 machine. Following the install
> instructions, after root.sh has been run, it states you need to run
> catrep.sql. I did this using sqlplus and logged in as user system.
> Although it stated "Commit Completed" at the end, it reported many
> (100's) of errors/warnings (e.g. ORA-00604 error occurred at recursive
> sql level 1 & ORA-01000 maximum open cursors exceeded) - is this normal
> ?
>
> Regards William
> ============
>
Received on Sun Jul 11 1999 - 00:33:59 CDT