Como eliminar el repositorio de Oracle Enterprise Manager 11gR1

A veces estamos complicados por la instalación y configuración del repositorio de Oracle Enterprise Manager (10.2.0.5 o 11gR1) y la verdad que no basta con solo eliminar los binarios, también es importante eliminar el repositorio que ha sido creado en la base de datos existente.
Para recrear el repositorio de OEM, una alternativa que pueden utilizar es eliminar el usuario SYSMAN y SYSMAN_MDS del repositorio.

Vamos a explicar cada uno de los argumentos que el utilitario RepManager utiliza para la eliminación del repositorio:

$/sysman/admin/emdrep/bin/RepManager

1.-
Hostname donde reside el servidor de base de datos.

2.-
Puerto donde escucha el proceso listener.

3.-
SID = Oracle System ID, utilizado para identificar una base de datos en el sistema.

4.- -dbUser sys
Usuario dueño del diccionario de Datos.

5.- -dbPassword
Clave del usuario sys

6.- -dbRole sysdba

7.- -reposName sysman
Nombre de esquema dueño del repositorio de Enterprise Manager

8.- -reposPassword
Clave del usuario sysman

9.- -action dropall
El argumento "-action dropall" va a eliminar completamente el repositorio de Oracle Enterprise manager, eliminado los principales usuarios llamados SYSMAN y SYSMAN_MDS.

Existen más opciones:
CREATE, UPDATE, TRANSX, RESUME, DROP

10.- -mwHome

Directorio donde se encuentran los Home's de varios productos como por ejemplo: Agent11g, oms11g,wlserver entre otros.

11.- -mwOraHome

Directorio Instalación de Oracle Weblogic 10.3.2

12.- -oracleHome

Directorio donde se encuentra instalado el oms11g


Ejecutando RepManager:

$ORACLE_HOME/sysman/admin/emdrep/bin/RepManager oraroots 1521 reproots -action dropall -dbUser sys -dbPassword xxx?xxx -dbRole sysdba
-mwHome /oracle/app/middleware -mwOraHome /oracle/app/middleware/wlserver_10.3 -oracleHome /oracle/app/middleware/oms11g

OUTPUT:

processing arguments
compiling arguments for validation
Enter password for: sys
done checking required user credentials...
done creating arguments...
creating logger..
Connection exception in action logger path calculated: /oracle/app/middleware/oms11g/sysman/log/schemamanager/
action logger path calculated: /oracle/app/middleware/oms11g/sysman/log/schemamanager/
action logger path calculated finally: /oracle/app/middleware/oms11g/sysman/log/schemamanager/
no action logger file name from previous session
action logger filename after search: emschema.log
action logger filename finally: emschema.log
filename: /oracle/app/middleware/oms11g/sysman/log/schemamanager/emschema.log
newly created: /oracle/app/middleware/oms11g/sysman/log/schemamanager/emschema.log
Driver: oracle.jdbc.driver.OracleDriver
jdbcUrl = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=oraroots)(Port=1521)))(CONNECT_DATA=(SID=reproots)))
action to perform is: drop
action is non-transx - RCU based action
action logger path calculated finally: /oracle/app/middleware/oms11g/sysman/log/schemamanager/m_111810_0914_AM/m_111810_0914_AM.DROP/
action logger path calculated finally: /oracle/app/middleware/oms11g/sysman/log/schemamanager/m_111810_0914_AM/m_111810_0914_AM.DROP/
action logger filename finally: emschema.log.DROP
filename: /oracle/app/middleware/oms11g/sysman/log/schemamanager/m_111810_0914_AM/m_111810_0914_AM.DROP/emschema.log.DROP
already exists: /oracle/app/middleware/oms11g/sysman/log/schemamanager/m_111810_0914_AM/m_111810_0914_AM.DROP/emschema.log.DROP
action logger path calculated finally: /oracle/app/middleware/oms11g/sysman/log/schemamanager/m_111810_0914_AM/m_111810_0914_AM.DROP/
process_id:7ylvziv43e9i
Still Running...
Processing command line ....
Repository Creation Utility - Checking Prerequisites
Checking Global Prerequisites
Still Running...
Still Running...
Repository Creation Utility - Checking Prerequisites
Checking Component Prerequisites
Repository Creation Utility - Drop
Repository Drop in progress.
Still Running...
Percent Complete: 9
Still Running...
Still Running...
Percent Complete: 45
Percent Complete: 49
Still Running...
Percent Complete: 100
Repository Creation Utility: Drop - Completion Summary
Database details:
Connect Descriptor : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=oraroots)(Port=1521)))(CONNECT_DATA=(SID=reproots)))
Connected As : sys
Prefix for (prefixable) Schema Owners : DEFAULT_PREFIX
RCU Logfile : /oracle/app/middleware/oms11g/sysman/log/schemamanager/m_111810_0914_AM/m_111810_0914_AM.DROP/rcu.log
Component schemas dropped:
Component Status Logfile
EM Repository Drop Success /oracle/app/middleware/oms11g/sysman/log/schemamanager/m_111810_0914_AM/m_111810_0914_AM.DROP/em_repos_drop.log

Repository Creation Utility - Drop : Operation Completed
Completed...
exiting the thread...
[Initializing the EM RCU Runner, Running the Schema Action, Schema Action Completed Successfully]
action logger path calculated finally: /oracle/app/middleware/oms11g/sysman/log/schemamanager/m_111810_0914_AM/m_111810_0914_AM.DROP/
drop mds schema...
Enter DBA Password
Processing command line ....
Repository Creation Utility - Checking Prerequisites
Checking Global Prerequisites
Repository Creation Utility - Checking Prerequisites
Checking Component Prerequisites
Repository Creation Utility - Drop
Repository Drop in progress.
Percent Complete: 9
Percent Complete: 9
Percent Complete: 18
Percent Complete: 47
Percent Complete: 100
Repository Creation Utility: Drop - Completion Summary
Database details:
Connect Descriptor : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=oraroots)(Port=1521)))(CONNECT_DATA=(SID=reproots)))
Connected As : sys
Prefix for (prefixable) Schema Owners : SYSMAN
RCU Logfile : /oracle/app/middleware/oms11g/emmds.log
Component schemas dropped:
Component Status Logfile
Metadata Services Success /oracle/app/middleware/oms11g/mds.log

Saludos,
Alberto Silva Gallardo.
Viva Linux!!!!!