Server Startup Never Finishes!

Oracle tech support has not been able to help me with this for 3 days... and this happens to two 8.1.6.3 databases, and one 8.1.7.2 database, all running on the same HP-UX 11 box.

After shutting down these databases with abort option, startup never finishes, and alert.log shows

alter database open
Beginning crash recovery of 1 threads
Sun Oct 21 08:17:13 2001
Thread recovery: start rolling forward thread 1 Recovery of Online Redo Log: Thread 1 Group 3 Seq 43319 Reading mem 0   Mem# 0 errs 0: /oracle09/oradata/dev10/redo03a.log Sun Oct 21 08:17:15 2001
Thread recovery: finish rolling forward thread 1 Thread recovery: 11 data blocks read, 11 data blocks written, 5 redo blocks read
Crash recovery completed successfully
Sun Oct 21 08:17:15 2001
Thread 1 advanced to log sequence 43320
Thread 1 opened at log sequence 43320
  Current log# 2 seq# 43320 mem# 0:
/oracle06/oradata/dev10/redo02a.log
Successful open of redo thread 1.
Sun Oct 21 08:17:16 2001
ARC0: Beginning to archive log# 3 seq# 43319 Sun Oct 21 08:17:16 2001
SMON: enabling cache recovery
Sun Oct 21 08:17:16 2001
ARC0: Completed archiving log# 3 seq# 43319 Sun Oct 21 08:17:16 2001
SMON: enabling tx recovery

All database functions seem available and normal, but the process never finishes, and worse still, it eats up 100% of the CPU it's using to start the server (process name is oracle{SID}).

Any help would be greatly appreciate.

Thanks
Jining Received on Sun Oct 21 2001 - 08:32:15 CDT