Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g43g2000cwa.googlegroups.com!not-for-mail
From: "Bluey" <vito.rinaldi@bluecrystal.com.au>
Newsgroups: comp.databases.oracle.server
Subject: Re: Server Name Change using Oracle 10G, db console does not work.
Date: 8 Aug 2005 05:02:59 -0700
Organization: http://groups.google.com
Lines: 40
Message-ID: <1123502579.463183.248140@g43g2000cwa.googlegroups.com>
References: <1123421001.123018.139310@f14g2000cwb.googlegroups.com>
   <jMtJe.84266$G8.22937@text.news.blueyonder.co.uk>
NNTP-Posting-Host: 220.238.160.237
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1123502584 701 127.0.0.1 (8 Aug 2005 12:03:04 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 8 Aug 2005 12:03:04 +0000 (UTC)
In-Reply-To: <jMtJe.84266$G8.22937@text.news.blueyonder.co.uk>
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: g43g2000cwa.googlegroups.com; posting-host=220.238.160.237;
   posting-account=ONGMVA0AAADps5mzNdmf3b_1V420fAzV
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:249086

I have a solution for the server renaming so dont worry about that one
any more...here it is:

.Logon SQLPLUS as user SYS and drop the sysman account and mangement
objects:

a. drop user sysman cascade;
b. drop role MGMT_USER;
c. drop user MGMT_VIEW cascade;
d. drop public synonym MGMT_TARGET_BLACKOUTS; e. drop public synonym
SETEMVIEWUSERCONTEXT;

2.At a command Prompt, run emca -x <SID> to remove the existing
configuration files.
Running the emca -x <SID> should remove the hostname_sid directory in
the Oracle home directory

3.Delete the following folder
ORACLE_HOME\OC4J\J2EE\OC4J_DBCONSOLE_<MACHINE NAME>, 4.Delete the
following service from registry.
HKEY_LOCAL_MACHINE/SYSTEM/CURRENTCONTROLSET/SERVICES/ORACLEDBCONSOLE<SID>

5.Reboot the machine.Before rebooting the machine make sure that the
files mentioned in step 2, step 3 and step 4 is deleted.

6.Set the ORACLE_HOME and ORACLE_SID

cd $ORACLE_HOME/bin

Start EMCA by entering the following command

$PROMPT> emca

and give the necessary parameters.
After this try to access the dbconsole URL mentioned at the end of emca
configuration.

Vito Rinaldi
Blue Crystal Solutions