RE: Change of hostname

From: Stephens, Chris <>
Date: Tue, 31 Mar 2009 08:18:40 -0500
Message-ID: <>

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;


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: [] On Behalf Of Dan Norris Sent: Tuesday, March 31, 2009 8:16 AM
Cc:; Oracle L; 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.  


Please excuse my typos, I sent this from my iPhone.

On Mar 31, 2009, at 7:57 AM, wrote:         

	If you have database control configured, it has host name part of configuration. 

"John Dunn" <>
Sent by:

Mar 31 2009 08:48 AM

Please respond to




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?                                 


        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.

Received on Tue Mar 31 2009 - 08:18:40 CDT

Original text of this message