Reconfigure Oracle em

One mistake can lead to a lot of work. when you 've installed Oracle Database 11g, you can't change the <br/> Windows hostname without reinstalling Oracle Enterprise Manager. </P> <p> these are the steps: </P> <p> 1. change the % ORACLE_HOME % \ Network \ admin \ listener. ora file from an IP number to machine name. </P> <p> 2. change the % ORACLE_HOME % \ Network \ admin \ tnsnames. ora file from an IP number to a machine Nam E. </P> <p> 3. change the c: \ windows \ system32 \ drivers \ etc \ hosts file by adding this line beneath the default <br/> localhost line (for the new hostname value ): </P> <p> 127.0.0.1 localhost <br/> 172.16.113.128 mclaughlin11g mclaughlin11g.techtinker.com </P> <p> 4. change the Windows hostname by navigating: Start> Control Panel> System (classic view) from the <br/> random assignment of VMWare Fusion. </P> <p> 5. Reboot the machine, and then drop the EM configuration with the following commands: </P> <p> C: \ data> set oracle_sid = orcl <br/> C: \ data> emca-deconfig dbcontrol DB-repos drop </P> <p> 6. you'll receive the following prompts, enter the Oracle SID and port number without double quotes but you <br/> must enter all passwords with double quotes (at least in Oracle Database 11g): </P> <p> started emca at Jul 1 3, 2008 8:26:42 am <br/> em configuration assistant, version 11.1.0.5.0 production <br/> copyright (c) 2003,200 5, Oracle. all rights reserved. </P> <p> enter the following information: <br/> database Sid: orcl <br/> listener port number: 1521 <br/> password for sys User: <br/> password for sysman User: <br/> do you wish to continue? [Yes (y)/NO (n)]: y </P> <p> 7. you shoshould then drop the sysman user manually because it doesn't happen without your balance (or, it <br/> didn't happen when I did it ). if you don't drop the sysman schema, You'll raise an error when you try to <br/> recreate it: </P> <p> config: ORA-20001: sysman already exists .. <br/> ORA-06512: At line 17 </P> <p> oracle. sysman. assistants. util. sqlengine. sqlfatalerrorexcept Ion: ORA-20001: sysman already exists .. <br/> ORA-06512: At line 17The java stack trace will look like this, more or less based on version and release: </P> <p> at oracle.sysman.assistants.util.sqlengine.sqlengine.exe cuteimpl (sqlengine. java: 1530) <br/> at oracle.sysman.assistants.util.sqlengine.sqlengine.exe cutescript (sqlengine. java: 880) <br/> at oracle.sysman.assistants.util.sqlengine.sqlplusengine.exe Cutescript (sqlplusengine. java <br/> at oracle.sysman.assistants.util.sqlengine.sqlplusengine.exe cutescript (sqlplusengine. java <br/> at oracle. sysman. emcp. emreposconfig. createrepository (emreposconfig. java: 492) <br/> at oracle. sysman. emcp. emreposconfig. invoke (emreposconfig. java: 218) <br/> at oracle. sysman. emcp. emreposconfig. invoke (emreposconfig. java: 147) <br/> at oracle. sysman. emcp. emconfig. perform (EMCON Fig. java: 222) <br/> at oracle. sysman. emcp. emconfigassistant. invokeemca (emconfigassistant. java: 535) <br/> at oracle. sysman. emcp. emconfigassistant. emconfigassistant. java: 1215) <br/> at oracle. sysman. emcp. emconfigassistant. statusmain (emconfigassistant. java: 519) <br/> at oracle. sysman. emcp. emconfigassistant. main (emconfigassistant. java: 468) </P> <p> drop the user and dependent on version A few other objects, like: </P> <p> drop user sysman cascade; <br/> drop public synonym setemviewusercontext; <br/> drop role mgmt_user; <br/> drop public synonym mgmt_target_blackouts; <br/> drop user mgmt_view; 8. you can then create the EM environment with the following syntax: </P> <p> C: \ data> emca-config dbcontrol DB-repos create </P> <p> 9. again, you'll receive the following prompts, enter the Oracle Sid and port number without double quotes but <br/> you must enter all passwords with double quotes (at least in Oracle Database 11g ): </P> <p> started emca at Jul 13,200 8 8:28:48 am <br/> em configuration assistant, version 11.1.0.5.0 production <br/> copyright (c) 2003,200 5, Oracle. all rights reserved. </P> <p> enter the following information: <br/> database Sid: orcl <br/> listener port number: 1521 <br /> Password for sys User: <br/> password for Dbsnmp User: <br/> password for sysman User: email Address for communications (optional): <br/> outgoing mail (SMTP) server for communications (optional ): <br/> Reset </P> <p> you have specified the following Settings </P> <p> database ORACLE_HOME ................ c: \ app \ admi Nistrator \ product \ 11.1.0 \ db_1 </P> <p> Local hostname ................ mclaughlin11g <br/> listener port number ................ 1521 <br/> database Sid ................ orcl <br/> email address for communications ............... <br/> outgoing mail (SMTP) server for communications ............... </P> <p> ----------------------------------------------------------------- </P> <p> do you wish to continue? [Yes (y)/NO (n)]: y </P> <p> A note to me, remember Haste makes waste. i'm just gglad that rebuilding the marklogic server was easy. </P> <p>
From: http://blog.mclaughlinsoftware.com/oracle-architecture-configuration/changing-windows-hostname-and-oracle-enterprise-manager/