Re: Server Name Change using Oracle 10G, db console does not work.

From: Bluey <vito.rinaldi_at_bluecrystal.com.au>
Date: 8 Aug 2005 05:02:59 -0700
Message-ID: <1123502579.463183.248140@g43g2000cwa.googlegroups.com>

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:

1. drop user sysman cascade;
2. drop role MGMT_USER;
3. drop user MGMT_VIEW cascade;
4. 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 Received on Mon Aug 08 2005 - 07:02:59 CDT