database open hangs

From: ShravanaKumar <shravanakumar.ks_at_siemens.com>
Date: Wed, 03 Mar 2004 19:20:08 +0530
Message-ID: <4045E290.81E80A72@siemens.com>

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
connected
SQL>startup
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 ?

Thanks,

Best Regards,
Shravana Kumar. Received on Wed Mar 03 2004 - 07:50:08 CST