RE: Change of hostname

From: Stephens, Chris <chris_stephens_at_admworld.com>
Date: Tue, 31 Mar 2009 08:18:40 -0500
Message-ID: <7070047601C21A4CB387D50AD3661F6E0C82C5E2_at_050EXCHANGE.research.na.admworld.com>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dan Norris Sent: Tuesday, March 31, 2009 8:16 AM
To: Mayen.Shah_at_lazard.com
Cc: JDunn_at_sefas.com; Oracle L; oracle-l-bounce_at_freelists.org 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_at_lazard.com wrote:         

	listener.ora 
	tnsnames.ora 
	If you have database control configured, it has host name part of configuration. 
	
	Thanks 
	Mayen 
	
	
	

"John Dunn" <JDunn_at_sefas.com>
Sent by: oracle-l-bounce_at_freelists.org

Mar 31 2009 08:48 AM

Please respond to
JDunn_at_sefas.com

To

oracle-l_at_freelists.org

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.

--
http://www.freelists.org/webpage/oracle-l

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