Re: database open hangs

Another hint :

Did you do a shutdown abort while an enormous transaction was going on ? That might explain the hang, though it can't explain it hanging for more than a few minutes.

Try to check how much CPU and I/O The Oracle processes, especially SMON, consume ("top" and "sar" can help you). If they work heavily, Oracle is probably recovering.

• Kenneth Koenraadt

On Wed, 03 Mar 2004 19:20:08 +0530, ShravanaKumar <shravanakumar.ks_at_siemens.com> wrote:

>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 - 14:09:04 CST