Monday, January 30, 2012

Enterprise Manager (Emctl) Droping and Recreating..

First of all ;
drop user SYSMAN cascade;
drop user MGMT_VIEW cascade;
drop role MGMT_USER;
drop public synonym MGMT_TARGET_BLACKOUTS;
drop public synonym SETEMVIEWUSERCONTEXT;
drop public synonym MGMT_AVAILABILITY;
view raw drop.sql hosted with ❤ by GitHub
if its needed to set host;
export ORACLE_HOST=ip
view raw export_host hosted with ❤ by GitHub

u can drop by using
emca -deconfig dbcontrol db -repos drop
view raw drop_emca.sql hosted with ❤ by GitHub


or recreating
emca -config dbcontrol db -repos recreate
view raw create_emca.sql hosted with ❤ by GitHub



No comments:

Post a Comment