Re: second alertfile ?

> Just a long shot..do you have any auditing turned on?
>

Bulls eye...

Thanks for your reply, I figured it out but forgot to share this with the newsgroup. I still think it's stange to enable a buggy feature by default after an installation.

Thanks Rob.

>
> robie wrote:
>
> > Doug,
> > Thanks for you reply.
> >
> > >The last poster who had this problem had recently changed file permissions
> > >somewhere,
> > >so Oracle started an alert log in a new place..
> > >
> > >- Dc.
> >
> > Oracle keeps writing to the normal messages to
> > $ORACLE_BASE/admin/bdump/alert_sid.log.
> > Only some tracefiles are placed in ORACLE_HOME/rdbms/log.
> >
> > ------------- cut --------------------
> > The tracefiles always contain the following :
> > *** 1999.08.06.14.36.35.000
> > Exception signal: 10 (SIGBUS), code: 1 (Invalid address alignment), addr:
> > 0x6f72
> > 616b, PC:
> > *** 1999.08.06.14.36.35.000
> > ksedmp: internal or fatal error
> > ORA-07445: exception encountered: core dump [] [SIGBUS] [Invalid address
> > alignme
> > nt] [1869767019] [] []
> > Current SQL information unavailable - no session.
> > ------------- cut --------------------
> >
> > Could the last line "no session" mean that the process is detached from the
> > server-process and the the user-process writes to the default location?
> >
> > Rob.
> >
> > >
> > >robie wrote:
> > >
> > >> 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 Fri Aug 13 1999 - 16:49:35 CDT