Database Control

Deinstall

• Enterprise Manager Database Control is no longer supported in 12.1 and above and will be removed post upgrade while executing catuppst.sql.

• To save time, this action may be completed BEFORE the upgrade by invoking emremove.sql.

• This is an optional preparation step to speed up the upgrade.

• This script removes Oracle Enterprise Manager Database Control from the target database.

• It does not affect Oracle Enterprise Manager Cloud Control.

Stop dbconsole (if it is running):

emctl stop dbconsole

Connect to the Database using the SYS account AS SYSDBA:

export NEWVER=12.1.0.2

cd /u01/app/oracle/product/${NEWVER}/rdbms/admin

sqlplus / as sysdba

spool /tmp/emremove.log

SET ECHO ON;

SET SERVEROUTPUT ON;

@emremove.sql

spool off

exit

rm -r ${ORACLE_HOME}/$(hostname)_${ORACLE_SID}

rm -r ${ORACLE_HOME}/oc4j/j2ee/OC4J_DBConsole_$(hostname)_${ORACLE_SID}

rm -r ${ORACLE_HOME}/$(hostname)_${ORACLE_SID}.upgrade

rm -r ${ORACLE_HOME}/oc4j/j2ee/OC4J_DBConsole_$(hostname)_${ORACLE_SID}.upgrade