Странице

Ознаке

уторак, 27. јануар 2015.

Reinstall Oracle EM 11g after DB clone

Remove files & folders
emctl stop dbconsole
rm -rf $ORACLE_HOME/<hostname>_<db_unique_name>
rm -rf $ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_<hostname>_<db_unique_name>

Remove and reinitialize DB objects
DECLARE
CURSOR c1 IS
SELECT owner, synonym_name name
FROM dba_synonyms
WHERE table_owner = 'SYSMAN';
BEGIN
FOR r1 IN c1 LOOP
IF r1.owner = 'PUBLIC' THEN
EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM '||r1.name;
ELSE
EXECUTE IMMEDIATE 'DROP SYNONYM '||r1.owner||'.'||r1.name;
END IF;
END LOOP;
END;
/
DROP USER mgmt_view CASCADE;
DROP ROLE mgmt_user;
DROP USER sysman CASCADE;
alter user dbsnmp identified by <new dbsnmp password> ;
Create new configuration
emca -config dbcontrol db -repos create