database open hangs

Giganews Newsgroups
Subject: database open hangs
Posted by:  ShravanaKumar (shravanakumar.…
Date: Wed, 03 Mar 2004

Hello All,

We are using oracle 9.2.0 for SUN solaris 2.8

The database open seems to hang when i startup the database.

Alert log file says "ALTER DATABASE OPEN". it hangs after that. i don't
see any error there.

SQL>connect / as sysdba
ORACLE instance started.

Total System Global Area 555189776 bytes
Fixed Size 730640 bytes
Variable Size 335544320 bytes
Database Buffers 218103808 bytes
Redo Buffers 811008 Bytes
Database mounted.

Any hints why the database open hangs ?


Best Regards,
Shravana Kumar.