Re: Server Startup Never Finishes!

hanj_at_mailcity.com (Jining Han) wrote in news:1ba3bb20.0110210532.7fda4391 @posting.google.com:

> 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
>

While this may sound like an off the wall suggestion and I'm not sure it will work in any case and I don't have access to a system upon which to test, add an additional LARGE data file to your "TEMP" tablespace before opening the database. In other words STARTUP MOUNT
ALTER TABLESPACE TEMP ADD DATAFILE '-------------' 2000M; ALTER DATABASE OPEN; It just might give SMON more room in which to work.

HTH & YMMV! Received on Sun Oct 21 2001 - 09:11:28 CDT