RE: Change of hostname
Date: Tue, 31 Mar 2009 08:18:40 -0500
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: 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
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.
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
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.