In the past, I’ve just dropped and recreated dbconsol: Login to SQLPLUS as user SYS or SYSTEM, and drop the sysman account & mangement objects: drop user sysman cascade; drop role MGMT_USER; drop user MGMT_VIEW cascade; drop public synonym MGMT_TARGET_BLACKOUTS; drop public synonym SETEMVIEWUSERCONTEXT; commit; Cleanup the External DB Console Configuration files by issuing: emca -deconfig dbcontrol db -repos drop Recreate the DB Console Repository & external Configuration files by issuing: emca -config dbcontrol db -repos create From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dan Norris Sent: Tuesday, March 31, 2009 8:16 AM To: Mayen.Shah@xxxxxxxxxx Cc: JDunn@xxxxxxxxx; Oracle L; oracle-l-bounce@xxxxxxxxxxxxx Subject: Re: Change of hostname Changing db control isn't that hard. I don't have the exact syntax handy, but I know you will use the emca command to tell db control to reconfigure itself. Dan Please excuse my typos, I sent this from my iPhone. On Mar 31, 2009, at 7:57 AM, Mayen.Shah@xxxxxxxxxx wrote: listener.ora tnsnames.ora If you have database control configured, it has host name part of configuration. Thanks Mayen "John Dunn" <JDunn@xxxxxxxxx> Sent by: oracle-l-bounce@xxxxxxxxxxxxx Mar 31 2009 08:48 AM Please respond to JDunn@xxxxxxxxx To oracle-l@xxxxxxxxxxxxx cc Subject Change of hostname Sys admin wants to change the hostname of the server running Oracle 10. What oracle configuration do I need to change so oracle will still work? John CONFIDENTIALITY NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by email reply.