Rebuilding Oracle's EM

Today do not know how, whim, put the machine out of the domain, and then ready to oracle11g control to deal with

At the beginning, did not have any intentions, the Internet casually find a bit of information, and then dry, and then nothing to dry, but also to spoil the thing.

No way, I had to do some good work.

Surf the internet for some information, many is about the 10g of EM reconstruction, after several operations

Also did not solve what, instead of the service control to get out.

It seems that the internet is unreliable, to rely on their own.

OK, here's my own solution:

1, regardless of the situation, execute at the doc command prompt (if the control in the service is still in, stop it, but estimate the root Qibulai)

Emca-repos Drop

Well, although the internet is unreliable, but this is also learned on the Internet.

2. Enter the SQL command prompt

Wait, how do I get into the SQL command prompt? The amount, also by the way to write, before the database can not get up, the Internet to find information reconstruction SPFile also said at the command prompt to do what, poor I database are not into, don't know where to lose SQL, that depressed ...

Under CMD, enter

Sqlplus/nolog

Hey, come in, then enter.

Conn/as SYSDBA

Call, Done (Khan, lost a few letters)

3. Enter the following four SQL statements at the SQL command prompt to find all synonyms starting with Mgmt_, Smp_, Emd_, ecm_, and save them

Execute at the SQL command prompt
Select ' Drop public synonym ' | | Synonym_name | | '; ' from all_synonyms where synonym_name like ' mgmt_% ';
Select ' Drop public synonym ' | | Synonym_name | | '; ' from all_synonyms where synonym_name like ' smp_% ';
Select ' Drop public synonym ' | | Synonym_name | | '; ' from all_synonyms where synonym_name like ' emd_% ';
Select ' Drop public synonym ' | | Synonym_name | | '; ' from all_synonyms where synonym_name like ' ecm_% ';

Good people do the bottom, because SQL out too much, the cmd window does not fit? Click on the icon in the upper left corner, choose the default value, you can modify the configuration (mainly to modify the high buffer), but here you need to reopen the cmd window.

Now say, haha, deliberately, reopen the cmd window, and then enter a command bar, write a few more times to remember next time.

4, delete the relevant data and configuration (n drop command)

Execute at the SQL command prompt
Drop user Sysman cascade;
Drop role Mgmt_user;
Drop user Mgmt_view cascade;
Drop user mgmt_availability cascade;
...... n the drop public synonym command, all SQL found in the previous step, open a Notepad, copy all the SQL, paste directly into the window can be.

5, the last step, the fate of it, estimated, maybe, well, it should be possible. (if not, look at the log, and then deal with it)

Here is the premise that the listener configuration must be configured to access your database (such as in Plsql can access the database), in the command will also be prompted, 11g will also prompt you to enter the listener, but you can directly enter not input.
At the doc command prompt
Emca-config Dbcontrol Db-repos Create

Or

Emca-repos Create
Emca-config Dbcontrol DB

God bless you, success.

Better be a good person once, put the SQL inside the package up.

Rebuilding oracle11g's EM command

Rebuilding Oracle's EM