lockups using Oracle10g on SUSE9.3 2005-09-09 - By Clayton
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?
>
> Swapping?
>
> Any disk activity?
>
> What sort of hardware do you use? Raid? SCSI? IDE ?
AMD64 (SUSE 9.3 installed in 32 bit mode)
1GB RAM
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:
/opt/oracle/product/10g/oradata/masalan/redo03.log
-- ---- ---- ---
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
example:
-- ---- ---- ---- ---
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[3647]: syslog-ng version 1.6.5
starting
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
work desktop).
C.
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
