Windows 2003 R2 Server hangs when starting Oracle 9.2 service
627732Mar 10 2008 — edited Mar 11 2008Hi,
I've been having an error with an Oracle 9.2.0.7 installation where the server will hang to the point where it needs to be powered off as it is completely unresponsive. It hangs when I start the Oracle service.
I've tried installing the system from scratch a few times(OS, OS patches, Oracle 9.2, Oracle 9.2.0.7 Patch set, Database) a few times however I keep having this same issue issue. I had the system running properly up until yesterday and I thought the issue was SP2 for Windows 2003 as I didn't patch the OS before installing everything however it is happening again now.
The listener is started and I can't even connect to an Idle instance through SQLPlus when this happens. I just get a TNS Listener error which I will list below. SInce this keeps happening, I'm wondering if it may be a hardware issue (Installed on an HP ML350) but I'm also wondering if it may be SP2 for WIndows 2003 server and was wondering if anyone else has seen this issue. I havne't found anything in the forum nor on Google so I thought I'd post here.
Here are the last entries in the DB log when it hangs;
ARC1: Archival started
Mon Mar 10 14:18:59 2008
ARCH: STARTING ARCH PROCESSES COMPLETE
Mon Mar 10 14:18:59 2008
ARC0: Becoming the 'no FAL' ARCH
Mon Mar 10 14:18:59 2008
ARC1: Becoming the heartbeat ARCH
Mon Mar 10 14:18:59 2008
ARC0: Becoming the 'no FAL' ARCHARC0: Thread not mounted
Mon Mar 10 14:18:59 2008
ARC1: Becoming the heartbeat ARCHARC1: Thread not mounted
Mon Mar 10 14:19:00 2008
Oracle Data Guard is not available in this edition of Oracle.
Mon Mar 10 14:19:00 2008
alter database mount exclusive