1).Delete DB Control Configuration Files using EMCA scripts
In 10.2g run, $emca -deconfig dbcontrol db Then enter sid as prompt
and then y.
2).Delete DB Control Configuration Files Manually:
Remove the following directories from your filesystem:
$ORACLE_HOME/hostname_sid
$ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_hostname_sid
3).Delete DB Control Repository using RepManager:
Invoke following command, RepManager hostname listener_port sid -
action drop
But don't delete by RepManager. It puts the database in quiescence
mode.
it gave me
-bash: RepManager: command not found
4).Delete DB Control Repository Objects Manually
drop user sysman cascade;
drop role MGMT_USER;
drop user MGMT_VIEW cascade;
5).Delete DB Control Configuration Files and Repository Objects using
EMCA
For 10.2,
>emca -deconfig dbcontrol db -repos drop
Halim, a Georgia Tech graduate Senior Database Engineer/Data Architect based in Atlanta, USA, is an Oracle OCP DBA and Developer, Certified Cloud Architect Professional, and OCI Autonomous Database Specialist. With extensive expertise in database design, configuration, tuning, capacity planning, RAC, DG, scripting, Python, APEX, and PL/SQL, he combines technical mastery with a passion for innovation. Notably, Halim secured 16th place worldwide in PL/SQL Challenge Cup Playoff on the year 2010.
Monday, September 28, 2009
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
-
ASSM states3 weeks ago
-
UKOUG Discover 20241 month ago
-
-
-
-
-
-
-
-
Moving Sideways8 years ago
-
-
Upcoming Events...11 years ago
-
No comments:
Post a Comment