Skip Headers
Oracle® Enterprise Manager Cloud Control Advanced Installation and Configuration Guide
12c Release 2 (12.1.0.2)
E24089-21
  Go To Table Of Contents
Contents
Go To Index
Index

Previous
Previous
 
Next
Next
 

D Using RepManager Utility

This appendix describes the RepManager utility. In particular, this appendix covers the following:

Overview

RepManager is a utility that enables you to upgrade and drop Oracle Management Repository, selectively purge plug-ins, and load dlf messages to Oracle Management Repository. This utility is available in the Oracle Management Service (OMS) home:

For UNIX operating systems:

$<OMS_HOME>/sysman/admin/emdrep/bin/RepManager

For Microsoft Windows operating systems:

$<OMS_HOME>/sysman/admin/emdrep/bin/RepManager.bat

This utility is invoked by Repository Configuration Assistant while installing a complete Enterprise Manager system, and by Repository Upgrade Configuration Assistant while upgrading to Enterprise Manager Cloud Control. For information about these Configuration Assistants, see What Are Configuration Assistants?.


Note:

If you want to drop the Enterprise Manager schema completely, then use the RepManager available in the OMS home. Do not use the one in database home because it cannot remove the Enterprise Manager schema completely.

Supported Actions and Commands

Table D-1 shows the list of actions and their associated commands supported by the RepManager utility.

Table D-1 Actions and Commands Supported by RepManager

Action Command Description Example

preupgrade

$<OMS_HOME>/sysman/admin/emdrep/bin/RepManager <repository_database_host> <repository_database_port> <repository_database_sid> -dbUser sys -dbPassword <sys password> -dbRole sysdba -reposName sysman -action preupgrade [-mwHome <Middleware home>]-pluginDepList "<pluginid1>=<pluginid1 home>,<pluginid2>=<pluginid2 home>" -dlfSources "<oms home>,<plugin1 home>,<plugin2home>"

Use this action to perform steps before upgrading an Oracle Management Repository with the following parameters:

  • Specify the host, port, and SID to connect to Oracle RDBMS where Oracle Management Repository is to be upgraded.

  • Specify the database user and password, repository name (SYSMAN) and password for SYSMAN user, and Middleware home to upgrade the Oracle Management Repository.

  • Specify the comma-separated list of plug-in-information according to dependency to be deployed. You can pass a file with this option, the contents being the comma-separated list of plug-in-information according to dependency to be deployed. If the pluginDepList is missing or has a value of empty list i.e. "{}", $<OMS_HOME>/sysman/admin/emdrep/plugininfo/pluginDepList is read, by default, to get plug-in dependency list.

  • Specify the comma-separated locations for DLF files from platform/plugins. You can pass a file with this option, the contents being the comma-separated locations for DLF files from platform/plugins. If the dlfSources option is missing or has a value of empty list i.e., "{}", $<OMS_HOME>/sysman/admin/emdrep/plugininfo/dlfSources is read, by default, to get dlf resource locations. If this option is missing and default dlfSources file is not present, only dlf files for platform will be picked. If this is present, only the DLFs under these sources will be picked up.

$<OMS_HOME>/sysman/admin/emdrep/bin/RepManager example.com 1521 db3 -dbUser sys -dbRole sysdba -reposName sysman -action preupgrade -mwHome /scratch/weblogic/middleware -pluginDepList <pluginid1>=<pluginid1 home>,<pluginid2>=<pluginid2 home>

upgrade

$<OMS_HOME>/sysman/admin/emdrep/bin/RepManager <repository_database_host> <repository_database_port> <repository_database_sid> -dbUser sys -dbPassword <sys password> -dbRole sysdba -reposName sysman -action upgrade [-mwHome <Middleware home>]-pluginDepList "<pluginid1>=<pluginid1 home>,<pluginid2>=<pluginid2 home>" -dlfSources "<oms home>,<plugin1 home>,<plugin2home>"

Note: Run preupgrade before performing upgrade action.

Use this action to upgrade an Oracle Management Repository with the following parameters:

  • Specify the host, port, and SID to connect to Oracle RDBMS where Oracle Management Repository is to be upgraded.

  • Specify the database user and password, repository name (SYSMAN) and password for SYSMAN user, and Middleware home to upgrade the Oracle Management Repository.

  • Specify the comma-separated list of plug-in-information according to dependency to be deployed. You can pass a file with this option, the contents being the comma-separated list of plug-in-information according to dependency to be deployed. If the pluginDepList is missing or has a value of empty list i.e. "{}", $<OMS_HOME>/sysman/admin/emdrep/plugininfo/pluginDepList is read, by default, to get plug-in dependency list.

  • Specify the comma-separated locations for DLF files from platform/plugins. You can pass a file with this option, the contents being the comma-separated locations for DLF files from platform/plugins. If the dlfSources option is missing or has a value of empty list i.e. "{}", $<OMS_HOME>/sysman/admin/emdrep/plugininfo/dlfSources is read, by default, to get dlf resource locations. If this option is missing and default dlfSources file is not present, only dlf files for Platform would be picked. If this is present, only the DLFs under these sources will be picked up.

$<OMS_HOME>/sysman/admin/emdrep/bin/RepManager example.com 1521 db3 -dbUser sys -dbRole sysdba -reposName sysman -action upgrade -mwHome /scratch/weblogic/middleware -pluginDepList <pluginid1>=<pluginid1 home>,<pluginid2>=<pluginid2 home>

transX

$<OMS_HOME>/sysman/admin/emdrep/bin/RepManager <repository_database_host> <repository_database_port> <repository_database_sid> -reposName sysman -action transx [-mwHome <Middleware home>] -dlfSources "<oms home>,<plugin1 home>,<plugin2home>"

Note: You can also run -do transX. By default, it is set to true. If you set the value to false, no translation bundles are loaded. This is applicable for -dlfSources for preupgrade and upgrade actions.

Use this action to load the translation resources to the Oracle Management Repository with the following parameters:

  • Specify the host, port, and SID to connect to Oracle RDBMS to load translation resources to Oracle Management Repository.

  • Specify the database user and password, repository name (SYSMAN) and password for SYSMAN user, and Middleware home to load translation resources to Oracle Management Repository.

  • Specify the comma-separated locations for DLF files from platform/plugins. You can pass a file with this option, the contents being the comma-separated locations for DLF files from platform/plugins. If the dlfSources option is missing or has a value of empty list i.e. "{}", $<OMS_HOME>/sysman/admin/emdrep/plugininfo/dlfSources is read, by default, to get dlf resource locations. If this option is missing and default dlfSources file is not present, only dlf files for Platform would be picked. If this is present, only the DLFs under these sources will be picked up.

$<OMS_HOME>/sysman/admin/emdrep/bin/RepManager example.com 1521 db3 -reposName sysman -action transx -mwHome /scratch/WLS/middleware

resume

$<OMS_HOME>/sysman/admin/emdrep/bin/RepManager <repository_database_host> <repository_database_port> <repository_database_sid> -dbUser sys -dbPassword <sys password> -dbRole sysdba -reposName sysman -resume retry -checkpointLocation <directory where schemamanager stores checkpoints> [-mwHome <Middleware home>]

Use this action to resume the last failed action, for example, upgrade.

  • Specify the host, port, and SID to connect to Oracle RDBMS where the action is to be resumed.

  • Specify the database user and password, repository name (SYSMAN) and password for SYSMAN user, and Middleware home where the action is to be resumed.

  • Specify the location at which to resume the step. The checkpoint location is $<OMS_HOME>/sysman/log/schemamanager.

$<OMS_HOME>/sysman/admin/emdrep/bin/RepManager example.com 1521 db3 -dbUser sys -dbRole sysdba -reposName sysman -resume retry -checkpointLocation /scratch/weblogic/middleware/oms/sysman/log/schemamanager -mwHome /scratch/weblogic/middleware

drop

OR

dropall

$<OMS_HOME>/sysman/admin/emdrep/bin/RepManager <repository_database_host> <repository_database_port> <repository_database_sid> -dbUser sys -dbPassword <sys password> -dbRole sysdba -reposName sysman -action drop [-mwHome <Middleware home>] [-mwOraHome <Oracle Home>]

OR

$<OMS_HOME>/sysman/admin/emdrep/bin/RepManager <repository_database_host> <repository_database_port> <repository_database_sid> -dbUser sys -dbPassword <sys password> -dbRole sysdba -reposName sysman -action dropall [-mwHome <Middleware home>] [-mwOraHome <Oracle Home>]

Ensure that there are no active sessions, scheduler jobs, and dbms_jobs running for SYSMAN, SYSMAN_MDS SYSMAN_OPSS, and SYSMAN_APM. Ensure that none of these users are logged in. To ensure this, stop the OMS using the command emctl stop oms -all on all OMS instances.

Note: If BI Pubilsher (BIP) had been installed and configured, then BIP should be stopped using the Admin Server before running this command.

Use this action to remove all Enterprise Manager repository schemas as follows:

  • Specify the host, port, and SID to connect to Oracle RDBMS from which all schemas are to be dropped.

  • Specify the database user and password, repository name (SYSMAN) and password for SYSMAN user, and Middleware home.

At the end, a confirmation message appears to confirm the status of this operation. If all the schemas were successfully dropped, then a message confirming the same appears. Otherwise, a message providing details on each of the schemas appears.

For example,

SYSMAN_OPSS schema is not cleaned. 
EM_X synonyms are not dropped.

$<OMS_HOME>/sysman/admin/emdrep/bin/RepManager example.com 1521 db3 -dbUser sys -dbRole sysdba -reposName sysman -action drop -mwHome /scratch/weblogic/middleware

OR

$<OMS_HOME>/sysman/admin/emdrep/bin/RepManager example.com 1521 db3 -dbUser sys -dbRole sysdba -reposName sysman -action dropall -mwHome /scratch/weblogic/middleware -mwOraHome /scratch/weblogic/middleware

pluginpurge

$<OMS_HOME>/sysman/admin/emdrep/bin/RepManager <repository_database_host> <repository_database_port> <repository_database_sid> -dbUser sys -dbPassword <sys password> -dbRole sysdba -reposName sysman -action pluginpurge -pluginPurgeList "<plugin_name>=<plugin_location>" [-mwHome <Middleware home>] -mwOraHome <Oracle Home>

Note: To purge multiple plug-ins, for the -pluginPurgeList argument, enter the plug-ins separated by a command. For example, <pluginid1>=<pluginid1 home>, <pluginid2>=<pluginid2 home>

Use this action to deinstall a plug-in from the repository as follows:

  • Specify the host, port, and SID to connect to Oracle RDBMS from which the plug-in is to be deinstalled.

  • To specify the comma-separated list of plug-in-information to be purged from Enterprise Manager Repository with EM-EXT model.

$<OMS_HOME>/sysman/admin/emdrep/bin/RepManager example.com 1521 db3 -dbUser sys -dbRole sysdba -reposName sysman -action pluginpurge -pluginPurgeList "oracle.sysman.myyempwpax.oms.plugin_12.1.0.2.0=/scratch/weblogic/middleware/plugins/oracle.sysman.myyempwpax.oms.plugin_12.1.0.2.0" -mwHome /scratch/weblogic/middleware



Note:

  • RepManager 12.1.0.2 supports -action dropall and -action drop. Both commands drop all schemas and users (SYSMAN, SYSMAN_BIP, SYSMAN_MDS, SYSMAN_APM, BIP, and SYSMAN_OPSS).

  • RepManager 11.1 supports -action dropall and -action drop. But -action dropall drops only users SYSMAN and SYSMAN_MDS. And -action drop drops users SYSMAN.

  • RepManager 10.2.0.5 supports only "-action drop" (drops only SYSMAN, the only users associated with the repository in this version)



Note:

If you do not specify passwords during RepManager actions, you will be prompted to do so.