"RSH" <RSH_Oracle_at_worldnet.att.net> wrote in message
news:_ODx8.48480$QC1.3441022_at_bgtnsc04-news.ops.worldnet.att.net...
> Oh, ps--
>
> If the installer created your database, there should be no need to run
> CATPROC and CATALOG on your own; the installer should run all the
necessary
> /rdbms/admin scripts automatically. But you should not be getting piles of
> errors even if you did decide to run them again yourself...
>
> RSH.
>
>
> "RSH" <RSH_Oracle_at_worldnet.att.net> wrote in message
> news:6LDx8.48475$QC1.3440881_at_bgtnsc04-news.ops.worldnet.att.net...
> > 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
> >
> >
>
>
Just a thought.
They do, of course, need to be run as SYS.
Paul
Received on Wed Apr 24 2002 - 15:31:00 CDT
