Re: second alertfile ?

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 Sun Aug 08 1999 - 19:45:35 CDT