RE: Change of hostname

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.

Other related posts: