Home > Databases, Oracle > Oracle 11g Enterprise Management Console Reinstall / Recreate

Oracle 11g Enterprise Management Console Reinstall / Recreate

In some cases when you install Oracle 11g (11.2.0)  the Enterprise Management Console fails to be created even when you follow standard procedure or in case you rename or change the server name or IP (the case of having a installation of Oracle 11g on a virtual machine)

In this case you need to recreate the Oracle 11g Enterprise Management Console…

These steps mainly are for the case the console does not work in case of IP Change

Drop and re-create Oracle db console
1. Change the %ORACLE_HOME%\network\admin\listener.ora file from an IP number to machine name.
2. Change the %ORACLE_HOME%\network\admin\tnsnames.ora file from an IP number to a machine name.
3. Change the C:\WINDOWS\System32\drivers\etc\hosts file by adding a line below the default localhost line for the new Hostname value

oracle_em_change_host_name
4.Drop the em configuration with the following commands
C:\Data> set ORACLE_SID=”replace with hostname”
C:\Data> emca -deconfig dbcontrol db -repos drop

 

oracle_em_recreate

 

5. Create the em environment with the following command:

C:\Data> set ORACLE_SID=WS08
C:\Data> emca -config dbcontrol db -repos create

 

oracle_em_recreate4

 

If you get the below error while creating dbconsole;

SEVERE: Dbcontrol Repository already exists Fix the error(s) and run EM Configuration Assistant again in standalone mode;
oracle.sysman.emcp.exception.EMConfigException: ‘job_queue_processes’ must be greater than or equal to 1. Fix the error(s) and run EM Configuration Assistant again in standalone mode.

Run the following command in SQLPLUS or SQL developer:

show parameter job_queue_processes ;

ALTER SYSTEM SET job_queue_processes=10;

And execute the create command again

 



oracle_em_recreate1

 

 

 



 

 

 

oracle_em_recreate3

oracle_em_recreate2

 

Advertisements
Categories: Databases, Oracle Tags: ,
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: