FreeLists / oracle-l / RE: DATABASE HANGS WITH SHUTDOWN IMMEDIATE

["Nahata, Naveen \(US - Glen Mills\)" <nnahata@xxxxxxxxxxxx>]

In a cmd window, when you click accidentally (and the window is in a "QuickEdit 
Mode"), it select a small portion. When you right click/press enter, it copies 
the selection to the clip-board.
 
Until you do so, it stops displaying fresh console output on the command 
window. 
 
To get rid of this annoying (but often useful) feature, open a cmd window -> 
right click on the title bar -> properties -> go to options tab -> uncheck 
"QuickEdit mode" and "Insert Mode".
 
Naveen


________________________________

        From: Jared Still [mailto:jkstill@xxxxxxxxx] 
        Sent: Monday, May 01, 2006 1:08 PM
        To: mln@xxxxxxxxxxx 
        Cc: oracle-l@xxxxxxxxxxxxx
        Subject: Re: DATABASE HANGS WITH SHUTDOWN IMMEDIATE
        
        
        One more thing:  the OP did not mention the platform.
        
        On windows, there's an interesting thing that happens in a CMD window 
        when doing shutdown immediate.
        
        The shutdown will appear to hang.  It may go on quite awhile. 
        
        Try hitting the <ENTER> key in this situation.  
        
        The CMD window will hang, and will not respond until hitting <ENTER>.
        
        It is not consistent behavior, but is also not unusual (happened to me 
last week) 
        
        I've read the explanation of why this happens, but cannot recall what 
it is.
        
        Jared
        
        
        
        On 4/29/06, Mogens Nørrgaard < mln@xxxxxxxxxxxx 
<mailto:mln@xxxxxxxxxxxx> > wrote: 


                I agree with the other members who responded that probably it's 
just a case of SMON having to do a lot of work - and not using old-school 
tablespace types. There is one other possibility perhaps: The ugly, old bug 
w.r.t. memory leaking and Shutdown immediate just hanging. I think the usual 
workaround still works:
                
                event="10262 trace name context forever, level 0"
                
                Again, it's probably just a completely normal thing you're 
seeing, but it MIGHT be the bug rearing its head again.
                
                
                Mogens
                
                
                
                Ahmed Ullah wrote: 

                        
                        Hello all:
                        
                         
                        
                        We have Oracle 9.2.0.5 database ( single Note RAC ). 
There were some heavy batch jobs running which cuased the db hang ( only sys 
connection was working ).
                        
                         
                        
                        We tried to bring down the database after cleaning all 
sessions. It did not go down with SHUTDOWN IMMEDIATE. We had to abort it. I 
tried to bring down the DB three times with SHUTDOWN IMMEDIATE it never went 
down.
                        
                         
                        
                        SMON was trying to cleanup the used extents ( Metalink 
Note - 1076161.6 ) as we could see in the alert log file - Waiting for smon to 
disable tx recovery.
                        
                         
                        
                        SQL> select count(block#) from fet$;
                        
                         
                        
                        COUNT(BLOCK#)
                        
                        -------------
                        
                                   38
                        
                         
                        
                        fet$ - free extents
                        
                         
                        
                        SQL> select count(block#) from uet$;
                        
                         
                        
                        COUNT(BLOCK#)
                        
                        -------------
                        
                                52905
                        
                         
                        
                        uet$ - used extents
                        
                         
                        
                        We can share the alert log and system level 10 trace 
files if anyone wants. These traces were generated when db hung. 
                        
                         
                        
                        Appreciate your help.
                        
                         
                        
                        Thanks,
                        
                         
                        
                        -ahmed
                        
                         


                        _____________________________________________
                        "If we knew what it was we were doing, it wouldn't
                        be called research, would it?" --Albert Einstein
                         

                        

________________________________

                        New Yahoo! Messenger with Voice. Call regular phones 
from your PC 
<http://us.rd.yahoo.com/mail_us/taglines/postman5/*http://us.rd.yahoo.com/evt=39666/*http://messenger.yahoo.com>
  and save big. 





        -- 
        Jared Still
        Certifiable Oracle DBA and Part Time Perl Evangelist 


This message (including any attachments) contains confidential information 
intended for a specific individual and purpose, and is protected by law.  If 
you are not the intended recipient, you should delete this message. 


Any disclosure, copying, or distribution of this message, or the taking of any 
action based on it, is strictly prohibited. [v.E.1]