on Unix it is called alert_SID.log, but live in the same place
"Ed Stevens" <spamdump_at_nospam.noway.nohow> wrote in message
news:3d8b8046.24650846_at_ausnews.austin.ibm.com...
> On 20 Sep 2002 11:49:20 -0700, my_papa_at_yahoo.com (Peace On Earth) wrote:
>
> >I am trying to run the
> >
> >$ORACLE_HOME/rdbms/admin/catalog.sql
> >
> >script during database creation. It is taking forever to do it - now
> >past 60 minutes - the script seems to have stopped executing. Is it
> >supposed to act like this or is something wrong? Is there any way
> >around it? Earlier today I tried it and after about 60 minutes I
> >pressed CTRL-C but it merely went to next statement which in turn got
> >frozen.
> >
> >OS is AIX poppy 3 4 000FA3FD4C00
> >
> >Oracle Running is 8.1.6
> >
> >Thank You
> >
> >Riz
>
> Since you're running CATALOG.SQL, I presume that 'during database
creation' is a
> sort of generality. For you to be connected and running the script, the
> database should have already been created.
>
> That being said, the first thing I'd do with this problem is take a look
at your
> alert log. Look for messages beginning with 'ORA-' In NT the file is
called
> <sid>ALRT.LOG and is located in the directory indicated by the
> background_dump_dest parm in the init<sid>.ora file. I presume the names
and
> locations will be similar in Unix type systems.
>
>
> --
> Ed Stevens
> (Opinions expressed do not necessarily represent those of my employer.)
Received on Fri Sep 20 2002 - 18:15:58 CDT
