Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!news.glorb.com!newsread.com!newsprint.newsread.com!newsfeed1.easynews.com!easynews.com!easynews!easynews-local!news.easynews.com.POSTED!not-for-mail From: "koert54" Newsgroups: comp.databases.oracle.server References: <4045E290.81E80A72@siemens.com> Subject: Re: database open hangs Lines: 41 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Message-ID: <6kq1c.1667813$9p3.309765@news.easynews.com> X-Complaints-To: abuse@easynews.com Organization: EasyNews, UseNet made Easy! X-Complaints-Info: Please be sure to forward a copy of ALL headers otherwise we will be unable to process your complaint properly. Date: Wed, 03 Mar 2004 19:26:58 GMT Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:256222 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" wrote in message news: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. >