Re: catalog error.

The Oracle installer creates many log files. Between OFA (an architecture for putting things certain places for well-meant reasons) and your own installation, they might be in various places. $ORACLE_HOME/orainst is a starter place. Or if and when you finally give up, you can use brute force and use NT's file finder for files owned by the oracle owner, with an extent of .log; or in UNIX, do a find command.

If you ran CATPROC and CATALOG on your own, directly, well, the best would be to destroy the existing database (shut it down, remove all files) , go to the $ORACLE_HOME/rdbms/admin directory and copy those files to your own directory somewhere else, and use VI or whatever to add:

!rm /tmp/catalog.log
set echo on
spool catalog.log

to the top of CATALOG, and the equivalent to CATPROC, and SPOOL OFFs at the end of each (the copies you made, I mean); and the begin again, and the errors will be recorded for your examination.

You might also check your ALERT log and things in bdump and udump, but I'd start over fresh, if it were me.

RSH.
"Kim Titu" <kimtitu_at_yahoo.com> wrote in message news:f7ad0b58.0204241114.5073eb6f_at_posting.google.com...
> 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
Received on Wed Apr 24 2002 - 14:32:18 CDT