Emca-repos Drop
Emca-repos Create
Emca-config Dbcontrol DB
Are you successful in all three steps without an error? Did you finally notice that Dbcontrol has been activated?
, run DBCA, select the configuration database option, and then follow the prompts to reconfigure Enterprise Manager.
, perform this emca-config Dbcontrol db
, check the log for detailed logs to see which step is the error?
, the DB instance is not available ... Can you connect to the database?
, restart the machine, disconnect the network, turn off antivirus software, firewall, and delete the failed record,run-cmd-> emca-deconfig dbcontrol db-repos drop.
Reconfigure Emca-config Dbcontrol Db-repos Create
Reprint: http://www.infocool.net/kb/Oracle/201604/80993.html
After the deletion, people often think of using the command to recreate the repository, but after I have tried to create a good repository using this method, the ORACLEDBCONSOLEORCL service still fails to start, the Enterprise Manager is still unusable, and then thought of using DBCA to create, So in the Run window input: DBCA, start the database configuration Assistant, in the first step to select the "Configuration database option", the following operation only need to click on the next step, note that when you choose whether to use the EM repository, it must be selected, the default is not selected, DBCA Check that there is no EM archive in the system, so it will be re-created, ORACLEDBCONSOLEORCL service will be added again, this will take a while, if the DBCA reconfiguration process without errors, after the configuration is over, The ORACLEDBCONSOLEORCL service will start normally and Oracle Enterprise Manager can be used normally. If you delete the EM data archive is not complete, run DBCA may error, generally sysman users and their objects are not removed cleanly, when encountering this problem, only need to run once again emca–repos drop.
If the Sysman user and its owning object are deleted when the EM repository is deleted, but the Oracledbconsole[sid] service is not deleted, if the service can be started and can be accessed through the browser, then the Emca–repos can be used at this time Create to recreate the EM repository.
Summarize
After this adventure, always feel that Oracle's ORACLEDBCONSOLE[SID] service is very fragile, in the absence of any misoperation, restart the computer, it may not start, but at this time, we must keep calm, more thinking, the way is always there, not the last resort, Do not reinstall, it is recommended that you manually stop the ORACLEDBCONSOLE[SID] service, the listener service, and the database service before restarting the system.
Stop after the ORACLEDBCONSOLEORCL service on the local computer starts