Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

avoid putting database in quiesce mode

user8363520Nov 15 2011 — edited Nov 7 2012
Hello all,

had a question with regards to dropping EM repositry.


When i run below on 11.2.0.2 i get a warning saying DB will be put in quiesce mode
emca -deconfig dbcontrol db -repos drop

———————————————————————-
WARNING : While repository is dropped the database will be put in quiesce mode.
———————————————————————-


but when i do the same for 11.2.0.1 it do not get any warning or anything...
is this something new for 11.2.0.2 ?? How can i avoid this??

As its hard for us to get some downtime for this system(which is 11.2.0.2)...
is there any other way to drop the repositry with putting DB in quiesce mode..

reson for this is, we are going to install OEM Agent on this, so need to drop the repositry of exsitnig DB


here is the exacty error...


$ emca -deconfig dbcontrol db -repos drop

STARTED EMCA at Nov 15, 2011 4:04:15 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: ORCL
Listener port number: 1521
Password for SYS user:
Nov 15, 2011 4:04:25 PM oracle.sysman.emcp.DatabaseChecks checkRestrictedMode
WARNING: ORA-01034: ORACLE not available

Nov 15, 2011 4:04:25 PM oracle.sysman.emcp.DatabaseChecks checkDataGuardEnabled
WARNING: ORA-01034: ORACLE not available

Password for SYSMAN user:

----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: N
$

Edited by: user8363520 on Nov 15, 2011 8:05 AM
This post has been answered by LKBrwn_DBA on Nov 15 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 5 2012
Added on Nov 15 2011
3 comments
2,323 views