Re: Oracle8 8.0.5 (pre) for Linux install problems

Hi Steve,

       One possible theory is that you ran catrep as SYSTEM when you should have run it as SYS.

       That may take care of part of the difficulty. You might also want to download a newer version from the

       oracle web site. BTW any relation to pete?

Frampton Steve R wrote:

> Hello:
>
> I've had the 8.0.5 (Pre-production) CD for Linux for a few months now, but
> haven't had the time to dive in. I'm finally trying to do so now.
>
> As per the documentation, I ran the installation script, which worked
> fine. I then ran an SQL*Plus script called 'catrep.sql' which "loads the
> necessary packages and views for replication". While it appeared to do a
> lot of table creations, grants, etc. I ran into a *lot* of errors (I've
> snipped a few "choice" ones):
>
> *
> ERROR at line 1:
> ORA-00604: error occurred at recursive SQL level 2
> ORA-01000: maximum open cursors exceeded
>
> grant execute on dbms_rectifier_diff to execute_catalog_role
> *
> ERROR at line 1:
> ORA-04042: procedure, function, package, or package body does not exist
>
> DROP PUBLIC SYNONYM dbms_rectifier_diff
> *
> ERROR at line 1:
> ORA-01432: public synonym to be dropped does not exist
>
> GRANT EXECUTE ON dbms_repcat TO SYSTEM
> *
> ERROR at line 1:
> ORA-01749: you may not GRANT/REVOKE privileges to/from yourself
>
> I suppose the majority, if not all the messages, are being caused by the
> "maximum open cursors exceeded" problem. Is there a way to fix this?
> Don't tell me I have to recompile my kernel! ;-)
>
> Also, this version of Oracle appears to be missing SQL*Forms. Eek!
> Anybody know if this will be included in the 8i release? (I've already
> registered to get the CD sent)
>
> Thanks in advance...
>
> --------------< LINUX: The choice of a GNU generation. >--------------
> Steve Frampton <3srf@qlink.queensu.ca> http://qlink.queensu.ca/~3srf
Received on Fri Mar 05 1999 - 08:06:31 CST