A colleague has done a new connection with a user non-dba and it works so I understand that drop command hangs and it didn't enter in quiesce mode,correct? Thanks El 30/08/2011 18:09, "Oliver" <ofabelo@xxxxxxxxx> escribió: > Thanks to all. It hangs,so it didn't enter in quiesce mode. > Can someone paste me the manual steps for dropping EM manually? thanks > beforehand. > El 30/08/2011 17:55, "Sweetser, Joe" <JSweetser@xxxxxxxx> escribió: >> I agree with Sreejith but would suggest the quiesce state is a little more > restrictive than just not accepting new connections. From here: > http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/start004.htm >> >> Is this: >> Occasionally you might want to put a database in a state that allows only > DBA transactions, queries, fetches, or PL/SQL statements. Such a state is > referred to as a quiesced state, in the sense that no ongoing non-DBA > transactions, queries, fetches, or PL/SQL statements are running in the > system. >> >> But if your emca process is hanging with both drop and recreate, then that > may not be the issue. >> >> -joe >> >> -----Original Message----- >> From: Sreejith Nair [mailto:sreejithsna@xxxxxxxxx] >> Sent: Tuesday, August 30, 2011 10:42 AM >> To: ofabelo@xxxxxxxxx >> Cc: Sweetser, Joe; Oracle L >> Subject: Re: Backups failing >> >> Quiesce mode means no new connections will be accepted. This is when you > use emca for dropping. With 11.2 database will not come in quiesce mode when > dropping em repository and objects. >> >> However, I am not sure whether dropping em 'manually' will put database in > quiesce mode for 10g. >> I have done this ( manual drop ) in 11.2 and database does not go in > quiesce mode. In my case also. Dropping using emca and Repmanager did hang, > which is why I went for manual drop. >> >> Sreejith >> ~Sent from my samsung phone >> >> ------- Original message ------- >>> From: Oliver <ofabelo@xxxxxxxxx> >>> To: sreejithsna@xxxxxxxxx >>> Cc: JSweetser@xxxxxxxx, oracle-l@xxxxxxxxxxxxx >>> Sent: 30/8/'11, 21:36 >>> >>> What is quiesce mode? >>> Can someone paste me the content of that note? thanks. >>> I've executed recreate but it hangs too,so I've executed drop first > (although it hangs too). >>> Thanks beforehand. >>> El 30/08/2011 16:18, "Sreejith Nair" <sreejithsna@xxxxxxxxx> escribió: >> >> >> Confidentiality Note: This message contains information that may be > confidential and/or privileged. If you are not the intended recipient, you > should not use, copy, disclose, distribute or take any action based on this > message. If you have received this message in error, please advise the > sender immediately by reply email and delete this message. Although ICAT > Managers, LLC, Underwriters at Lloyd's, Syndicate 4242, scans e-mail and > attachments for viruses, it does not guarantee that either are virus-free > and accepts no liability for any damage sustained as a result of viruses. > Thank you.