Re: catalog error.

On 24 Apr 2002 12:14:20 -0700, kimtitu_at_yahoo.com (Kim Titu) wrote:

>Hi group,
> I am new to oracle. I just install my 8.1.7 server on RH7.2 and a
>database is created during the installation process. After i start the
>database and try to run
>catalog.sql and catproc.sql, i get many errors. Is this normal to have
>so many errors. Most of them are the same error. I cannot catch what
>errors are they when they flies through my screen. After that, i
>create a table in the database, successful. When i try to drop it, i
>cannot do that. I get this error.
> ORA-04098: trigger 'SYS.JIS$ROLE_TRIGGER$' is invalid and failed
>re-validation.
>
>I bet this error has something to do with my catalog error. Can some
>one point out?
>
>Thanks.
>
>Kim TItu

Both the catalog and catproc script can be re-run indefinitely. This is accomplished by dropping and recreating every object. So, on the first run, errors during drop ... are completely normal and expected.
You should issue
spool catalog.log
before starting catalog.sql
and spool catproc.sql
before starting catproc.sql

Your best bet is to connect as SYS
and issue
select * from user_errors where name = 'JIS$ROLE_TRIGGERS' and maybe post them here, if you can't resolve them yourself, or get in touch with Oracle Support

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Apr 24 2002 - 15:55:00 CDT