Re: [suse-oracle] lockups using Oracle10g on SUSE9.3
Anton Dischner wrote:
> Hi Clayton,
> any entries in alert<your_sid_>.ora, /var/log/messages ?
> When it's locked up do you see any activity in top processes?
> Any disk activity?
> What sort of hardware do you use? Raid? SCSI? IDE ?
AMD64 (SUSE 9.3 installed in 32 bit mode)
HD is a 150GB SATA drive, no RAID.
There is no disk activity.. nothing. It's a hard lock up (so can't
check any processes). No keyboard response... can't ssh in from another
computer. It's completely unresponsive.
The last line in the alert<sid>.log file is:
Fri Sep 9 09:01:10 2005
Private_strands 7 at log switch
Thread 1 advanced to log sequence 336
Current log# 3 seq# 336 mem# 0:
This is a regular/repeating log entry.
At this point the dB was working fine.
There are no unusual entries in my /var/log/messages file either... For
Sep 9 10:11:47 deepthought su: (to root) clayton on /dev/pts/1
Sep 9 10:14:08 deepthought su: (to oracle) clayton on /dev/pts/3
Sep 9 10:14:09 deepthought su: (to oracle) clayton on /dev/pts/3
Sep 9 10:27:12 deepthought syslog-ng: syslog-ng version 1.6.5
Sep 9 10:27:14 deepthought logger: (Oracle CSSD will be run out of init)
It locked up shortly after I did an su to oracle - where I tried to do a
connect / as sysdba (around 10:14:30) I rebooted 13 minutes later
(waited to see if it would recover). This pattern is repeated through
the log file each time it locked up and I did a hard reset.
Leaving Oracle alone, the computer runs along fine (it doubles as my
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting