Rebuilding oracle's em

Source: Internet
Author: User

Today, I don't know what's going on. I just took the machine out of the domain and prepared to handle the control of oracle11g.

At first, I did not care much about it. I searched for some information on the Internet and followed it. Then I did nothing and broke things.

No way. You have to work hard.

 

I found some information online, many of which are about 10 Gb em reconstruction.

But the control in the service is not solved.

 

It seems that the Internet is also unreliable and you have to rely on yourself.

 

Okay. Here is my solution:

 

1. Execute the command at the doc command prompt no matter what the situation is (if the control in the service is still there, stop it, but it is estimated that it cannot be started at all)

Emca-repos drop

Well, although the Internet is not reliable, it is also learned on the Internet.

 

2. Enter the SQL command prompt

Wait, how do I enter the SQL command prompt? Well, let's write it by the way. When the database couldn't run in the past, I went online to search for information and re-built the spfile. I also said what I did at the command prompt. Sorry, I couldn't get into the database, I don't know where to lose the SQL. That's depressing ......

In cmd, enter

Sqlplus/nolog

Hey, come in. Enter it again.

Conn/as sysdba

Call, I'm done (sweat, I lose a few letters)

 

3. Enter the following four SQL statements at the SQL command prompt to find all synonyms starting with MGMT _, SMP _, EMD _, and ECM _ and save them

Run
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 guys do it, because there are too many SQL statements, and the cmd window cannot be placed? Click the icon in the upper left corner and select the default value. You can modify the configuration (mainly to modify the height of the buffer). However, you need to re-open the cmd window here.

Now, haha, intentionally, re-open the cmd window, and enter the command again. Write a few more times before remembering it.

 

4. Delete related data and configurations (N drop commands)

Run
Drop user sysman cascade;
Drop role MGMT_USER;
Drop user MGMT_VIEW cascade;
Drop user MGMT_AVAILABILITY cascade;
...... N drop public synonym commands, all the SQL statements found in the previous step, open a notepad, copy all the SQL statements, and paste them directly into the window.

 

5. The last step is to let us go. Maybe, well, it should be okay. (If not, check the log and process it again)

The premise is that the Listener Configuration must be configured to access your database (for example, you can access the database in plsql), and a prompt will be displayed in the command, you will be prompted to enter the listener at 11g, but you can press enter directly without entering it.
At the doc Command Prompt
Emca-config dbcontrol db-repos create

Or

Emca-repos create
Emca-config dbcontrol db

God bless you.

We 'd better try again and pack the SQL statements.

Re-build the em command of oracle11g

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.