Oracle Enterprise Manager Console: How to Recreate

Tags: Oracle, Enterprise, Manager, OEM, Console, dbconsole, emctl, OracleDBConsole, recreate

the solution is simple, you have to unplug the network cable and start the console service ( you have to do it every time you want to start the console)

emctl start dbconsole

if console still not starting then recreate it:

1. start the listener

lsnrctl start

2. remove the console

cd %ORACLE_HOME%/ora11gr2/bin
emca -deconfig dbcontrol db -repos drop

NB: it may take up to 30mn, be patient

3. recreate the console

set oracle_unqname = TESTDB
set ORACLE_HOSTNAME = MYPC
emca -config dbcontrol db -repos recreate

be patient it may take long time too.

4. now unplug the network cable and start the console service, it should start

if it does not or if it start but you cant login, then

a. verify that windows time zone is the same as oracle time zone defined in

%ORACLE_HOME%\ora11gr2\MYPC_testdb\sysman\config\emd.properties  
at line **agentTZRegion=GMT**

to know witch timezone code to use, run this:

SELECT * FROM v$timezone_names where upper(TZNAME) like '%MAURITANIA%';

Replace Mauritania by your country.

b. enable system account

alter user system account unlock;

c. unplug the network cable and start the console service again.

I hope this helps, it worked for me.

source:  https://stackoverflow.com/questions/12584951/oracledbconsole-cant-start-after-restarting-windows?utm_medium=organic&utm_source=google_rich_qa&utm_campaign=google_rich_qa

No Comments

You must log on to comment.