C Using the RepManager Utility

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

Overview of the RepManager Utility

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

For UNIX operating systems:

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

For Microsoft Windows operating systems:

$<ORACLE_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.

Note:

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

Actions and Commands Supported by the RepManager Utility

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

WARNING:

The RepManager in drop mode puts the database in quiesce mode by "ALTER SYSTEM QUIESCE RESTRICTED;" command.

Table C-1 Actions and Commands Supported by RepManager

Action Command Description Example

preupgrade

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

Use this action with the following parameters to perform the preupgrade steps before upgrading a Management Repository.

  • Specify the host, port, and SID to connect to the database where the Management Repository has to be upgraded.

  • Specify the database user (SYS) and password, the database role (SYSDBA), the repository name (SYSMAN) and password, and the Middleware home to upgrade the Management Repository. Here, Middleware home is the Oracle home where the WebLogic Server, OMS, and other components are configured.

  • Specify a comma-separated list of plug-ins to be deployed according to the dependency. You can pass a file with this option, the contents being a comma-separated list of plug-in IDs. If the -pluginDepList parameter is not set, or is left with an empty list (for example, "{}"), then the following is read, by default, to retrieve the plug-in dependency list:

    $<ORACLE_HOME>/sysman/admin/emdrep/plugininfo/pluginDepList

  • Depending on how the plug-ins can be deployed, specify whether they must be deployed as SYS or SYSMAN, which is the repository user. To deploy them as SYSMAN, set the -runAsReposUser parameter to TRUE. If you do not pass this parameter, by default, the plug-ins will be deployed as SYS user.

  • Specify a comma-separated locations for DLF files from platform/plug-ins. You can pass a file with this option, the contents being comma-separated locations for DLF files from platform/plug-ins. If the -dlfSources parameter is not set, or is left with an empty list (for example, "{}"), then the following is read, by default, to retrieve the dlf resource locations:

    $<ORACLE_HOME>/sysman/admin/emdrep/plugininfo/dlfSources

    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.

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

upgrade

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

Note: Run preupgrade before performing upgrade action.

Use this action with the following parameters to upgrade a Management Repository.

  • Specify the host, port, and SID to connect to the database where the Management Repository has to be upgraded.

  • Specify the database user (SYS) and password, the database role (SYSDBA), the repository name (SYSMAN) and password, and the Middleware home to upgrade the Management Repository. Here, Middleware home is the Oracle home where the WebLogic Server, OMS, and other components are configured.

  • Specify a comma-separated list of plug-ins to be deployed according to the dependency. You can pass a file with this option, the contents being a comma-separated list of plug-in IDs. If the -pluginDepList parameter is not set, or is left with an empty list (for example, "{}"), then the following is read, by default, to retrieve the plug-in dependency list:

    $<ORACLE_HOME>/sysman/admin/emdrep/plugininfo/pluginDepList

  • Depending on how the plug-ins can be deployed, specify whether they must be deployed as SYS or SYSMAN, which is the repository user. To deploy them as SYSMAN, set the -runAsReposUser parameter to TRUE. If you do not pass this parameter, by default, the plug-ins will be deployed as SYS user

  • Specify a comma-separated locations for DLF files from platform/plug-ins. You can pass a file with this option, the contents being comma-separated locations for DLF files from platform/plug-ins. If the -dlfSources parameter is not set, or is left with an empty list (for example, "{}"), then the following is read, by default, to retrieve the dlf resource locations:

    $<ORACLE_HOME>/sysman/admin/emdrep/plugininfo/dlfSources

    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.

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

transX

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

Note: You can also run -doTransX. 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 with the following parameters to load the translation resources to the Management Repository.

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

  • Specify the repository name (SYSMAN) and password, and the Middleware home to load translation resources to Oracle Management Repository. Here, Middleware home is the Oracle home where the WebLogic Server, OMS, and other components are configured.

  • Specify a comma-separated locations for DLF files from platform/plug-ins. You can pass a file with this option, the contents being comma-separated locations for DLF files from platform/plug-ins. If the -dlfSources parameter is not set, or is left with an empty list (for example, "{}"), then the following is read, by default, to retrieve the dlf resource locations:

    $<ORACLE_HOME>/sysman/admin/emdrep/plugininfo/dlfSources

    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.

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

resume

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

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

  • Specify the host, port, and SID to connect to the database where the action has to be resumed.

  • Specify the database user (SYS) and password, the database role (SYSDBA), the repository name (SYSMAN) and password for the SYSMAN user, and the Middleware home where the action has to be resumed. Here, Middleware home is the Oracle home where the WebLogic Server, OMS, and other components are configured.

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

$<ORACLE_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

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

OR

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

Ensure that there are no active sessions, scheduler jobs, and dbms_jobs running for SYSMAN, SYSMAN_MDS SYSMAN122130_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.

Use this action with the following parameters to remove all the Enterprise Manager repository schemas.

  • Specify the host, port, and SID to connect to the database in which all the schemas have to be dropped.

  • Specify the database user (SYS) and password, the database role (SYSDBA), the repository name (SYSMAN) and password, and the Middleware home. Here, Middleware home is the Oracle home where the WebLogic Server, OMS, and other components are configured.

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.

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

OR

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

pluginpurge

$<ORACLE_HOME>/sysman/admin/emdrep/bin/RepManager -action pluginpurge <repository_database_host> <repository_database_port> <repository_database_sid> -dbUser sys -dbPassword <sys password> -dbRole sysdba -reposName sysman -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 with the following parameters to deinstall a plug-in from the Management Repository.

  • Specify the host, port, and SID to connect to the database from which the plug-in has to be deinstalled.

  • Specify the database user (SYS) and password, the database role (SYSDBA), the repository name (SYSMAN) and password, and the Middleware home. Here, Middleware home is the Oracle home where the WebLogic Server, OMS, and other components are configured

  • Specify a comma-separated list of plug-ins to be purged from Enterprise Manager Repository with EM-EXT model.

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

Note:

For information on the support for -action drop and -action dropall commands, see Table 2-5.

Note:

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