Oracle DB. was hanging, no error messages in alert_LOG , but sys log say something ...

[Jeff Schussele]

Syed,

The stm log is named activity_log & is located in
/var/stm/logs/sys.

Also Ruediger has suggested look in Oracle's listener log.

HTH,
Jeff

[Volker Borowski]

Hi,

Oracle has additional trace files, that may show something.
Try to find files like "**.trc" and try to get some infor from these ones.
The timstamp of this file should be related to the last entry in your alert file.

Hope this helps
Volker

[T G Manikandan]

All your questions will be answered here

http://docs.hp.com/hpux/onlinedocs/diag/stm/stm_faq.htm

Thanks