Re: second alertfile ?

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

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 Tue Aug 10 1999 - 09:47:57 CDT