Re: second alertfile ?

Hi Rob,

You are sure you didn't change init<sid>.ora parameters over time? Unix ports of Oracle have the core_dump_dest init<sid>.ora parameter, apparently this is not set in your database. The dumps will end up as sub directories in that 'root'. Also the alert doesn't for mysterious reasons contain any info about core dumps. The ideal setup for trace directories is IMHO $ORACLE_BASE/admin/<sid>/bdump

                                                  /cdump
                                                  /udump

Hth,

Sybrand Bakker, Oracle DBA

robie <rlaarhoven_at_sql-integrator.nl> wrote in message news:933861603.516416_at_newsreader2.wirehub.nl...
> Hi there,
>
> I noticed three core_xxx directories in the homedir of oracle-user. I
looked
> at the $ORACLE_BASE/admin/bdump/alert_sid.log file, there were no entries
> about these core dumps.
> Then I found a sid_ora_xxx.trc file in the $ORACLE_HOME/rdbms/log
directory
> and in the same dir there was a second alert_sid.log file.
> This new alert_file only contains three messages about three trace_files
> (ora-7445).
> The alert file in the oracle_base contains all the other messages
> (shutdown,startup,log-switches etc).
>
> Why does oracle put these messages in this directory?
>
> Sun Solaris
> RDBMS 7.3.4.4
>
> Thank you,
> Rob.
>
>
Received on Thu Aug 05 1999 - 13:19:54 CDT