I've had this a couple of times ... in my case databases startup triggers
were the problem ...
If you can logon with a non-sysdba user without getting 'database startup or
shutdown in progress' than it's most probably a database
startup trigger ... set _system_trig_enable=false - try again - and look
into all your database startup triggers...
"ShravanaKumar" <shravanakumar.ks_at_siemens.com> wrote in message
news:4045E290.81E80A72_at_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 - 13:26:58 CST
