Skip Headers
Oracle® Enterprise Manager Cloud Control Upgrade Guide
12c Release 1 (12.1.0.1)
E22625-09
  Go To Table Of Contents
Contents
Go To Index
Index

Previous
Previous
 
Next
Next
 

20 Upgrading OMS and Repository for 1-System on Different Host Approach

To upgrade your existing Oracle Management Service (OMS) and Oracle Management Repository (Management Repository) with 1-System on a Different Host approach, follow these steps:

  1. On the remote host, install only the software binaries of Enterprise Manager Cloud Control.

    Note that Step(15) in Installing Software Binaries (graphical mode) and Step (4) in Installing Software Binaries (silent mode) instruct you to deinstall the Management Agent. However, in the case of a 1-system upgrade on a different host, DO NOT deinstall the Management Agent. You need the Management Agent installed on the OMS host during the 1-system upgrade on a different host to monitor the Enterprise Manager components.


    Note:

    This remote host must be different from the host where your existing, earlier release of Enterprise Manager is running.

  2. On the host where your existing, earlier release of Enterprise Manager is running, stop the OMS. To do so, run the following command from the OMS home:

    $<OMS_HOME>/bin/emctl stop oms -all


    Note:

    On Microsoft Windows, run the following command:

    %OMS_HOME%\bin\emctl stop oms -all


  3. On the remote host where you installed the software binaries of Enterprise Manager Cloud Control as described in Step (1), set the environment variable ORACLE_HOME to the OMS home, and MW_HOME to the middleware home.

    • In bash terminal, run the following command:

      export ORACLE_HOME=<absolute_path_to_oms_home>

      export MW_HOME=<absolute_path_to_middleware_home>

    • In other terminals, run the following command:

      setenv ORACLE_HOME <absolute_path_to_oms_home>

      setenv MW_HOME <absolute_path_to_middleware_home>


      Note:

      On Microsoft Windows, run the following commands:

      set ORACLE_HOME=<absolute_path_to_middleware_home>

      set MW_HOME=<absolute_path_to_middleware_home>


  4. Run the Management Repository-related prerequisite checks to verify if the Oracle Management Repository (Management Repository) its ready for upgrade:

    1. Create a directory for storing prerequisite results:

      mkdir <prereq_result_location>

      Example for UNIX platforms:

      mkdir $ORACLE_HOME/prerequisiteResults


      Note:

      Example for Microsoft Windows:

      mkdir %ORACLE_HOME%\prerequisiteResults


    2. Run the prerequisite checks:

      $ORACLE_HOME/install/requisites/bin/emprereqkit -executionType upgrade -prerequisiteXMLLoc $ORACLE_HOME/install/requisites/list -prereqResultLoc <prereq_result_location> -dbHost <REPOSITORY_HOST> -dbPort <PORT> -dbSid <REPOSITORY_SID> -dbUser SYS -dbPassword <db_password> -reposUser sysman -reposPassword <repo_user_password> -dbRole sysdba -runPrerequisites


      Note:

      On Microsoft Windows, run the following command:

      %ORACLE_HOME%\install\requisites\bin\emprereqkit.bat -executionType upgrade -prerequisiteXMLLoc %ORACLE_HOME%\install\requisites\list -prereqResultLoc <prereq_result_location> -dbHost <REPOSITORY_HOST> -dbPort <PORT> -dbSid <REPOSITORY_SID> -dbUser SYS -dbPassword <db_password> -reposUser sysman -reposPassword <repo_user_password> -dbRole sysdba -runPrerequisites


      For example,

      $ORACLE_HOME/install/requisites/bin/emprereqkit -executionType upgrade -prerequisiteXMLLoc $ORACLE_HOME/install/requisites/list -prereqResultLoc $ORACLE_HOME/prerequisiteResults -dbHost example.com -dbPort 1521 -dbSid dbview -dbUser SYS -dbPassword dbpass -reposUser sysman -reposPassword repopass -dbRole sysdba -runPrerequisites


      Note:

      Example for Microsoft Windows:

      %ORACLE_HOME%\install\requisites\bin\emprereqkit.bat -executionType upgrade -prerequisiteXMLLoc %ORACLE_HOME%\install\requisites\list -prereqResultLoc %ORACLE_HOME%\prerequisiteResults -dbHost example.com -dbPort 1521 -dbSid dbview -dbUser SYS -dbPassword dbpass -reposUser sysman -reposPassword repopass -dbRole sysdba -runPrerequisites



    Note:

    The output of this step confirms the prerequisite checks that passed and failed. You will see the status Pass or Fail.

  5. If the Management Repository-related prerequisite checks fail, run the post-corrective actions to automatically correct the issues:

    $ORACLE_HOME/install/requisites/bin/emprereqkit -executionType upgrade -prerequisiteXMLLoc $ORACLE_HOME/install/requisites/list -prereqResultLoc <prereq_result_location> -dbHost <REPOSITORY_HOST> -dbPort <PORT> -dbSid <REPOSITORY_SID> -dbUser SYS -dbPassword <db_password> -reposUser sysman -reposPassword <repo_user_password> -dbRole sysdba -useHistory -runCorrectiveActions


    Note:

    On Microsoft Windows, run the following command:

    %ORACLE_HOME%\install\requisites\bin\emprereqkit.bat -executionType upgrade -prerequisiteXMLLoc %ORACLE_HOME%\install\requisites\list -prereqResultLoc <prereq_result_location> -dbHost <REPOSITORY_HOST> -dbPort <PORT> -dbSid <REPOSITORY_SID> -dbUser SYS -dbPassword <db_password> -reposUser sysman -reposPassword <repo_user_password> -dbRole sysdba -useHistory -runCorrectiveActions


    For example,

    $ORACLE_HOME/install/requisites/bin/emprereqkit -executionType upgrade -prerequisiteXMLLoc $ORACLE_HOME/install/requisites/list -prereqResultLoc $ORACLE_HOME/prerequisiteResults -dbHost example.com -dbPort 1521 -dbSid dbview -dbUser SYS -dbPassword dbpass -reposUser sysman -reposPassword repopass -dbRole sysdba -useHistory -runCorrectiveActions


    Note:

    Example for Microsoft Windows:

    %ORACLE_HOME%\install\requisites\bin\emprereqkit.bat -executionType upgrade -prerequisiteXMLLoc %ORACLE_HOME%\install\requisites\list -prereqResultLoc %ORACLE_HOME%\prerequisiteResults -dbHost example.com -dbPort 1521 -dbSid dbview -dbUser SYS -dbPassword dbpass -reposUser sysman -reposPassword repopass -dbRole sysdba -useHistory -runCorrectiveActions



    Note:

    The output of this step confirms whether or not corrective actions were taken by the script. If corrective actions were taken by the script, then you will see the status Pass. Otherwise, you will see the status NA.

    If the status of the prerequisite check was Fail in the output of Step (4), and if it changed to NA in the output of Step (5), do the following:

    1. Access the following file:

      On UNIX platforms:

      $ORACLE_HOME/prerequisiteResults/log/LATEST/emprereqkit.out

      On Microsoft Windows platforms:

      %ORACLE_HOME%\prerequisiteResults\log\LATEST\emprereqkit.out

    2. Review the passed and failed tests and their corresponding corrective actions.

    3. For the failed tests, manually take corrective actions.


  6. Run the plug-in configuration assistant in prerequisite mode:

    $ORACLE_HOME/bin/pluginca -oracleHome $ORACLE_HOME -middlewareHome $MW_HOME -action prereqCheck -plugins <list_of_plugins> -oldOracleHome <old_oms_home> -installMode gcUpgrade -client gcinstaller -customParams "connectString=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<REPOSITORY_HOST>)(PORT=<PORT>)))(CONNECT_DATA=(SID=<REPOSITORY_SID>))),username=sysman"


    Note:

    The plug-ins to be mentioned for the <pluginslist> argument can be found in the following file:

    $ORACLE_HOME/sysman/install/plugins_installed.txt



    Note:

    On Microsoft Windows, run the following command:

    %ORACLE_HOME%\bin\pluginca -oracleHome %ORACLE_HOME% -middlewareHome %MW_HOME% -action prereqCheck -plugins <list_of_plugins> -oldOracleHome <old_oms_home> -installMode gcUpgrade -client gcinstaller -customParams "connectString=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<REPOSITORY_HOST>)(PORT=<PORT>)))(CONNECT_DATA=(SID=<REPOSITORY_SID>))),username=sysman"


    For example,

    $ORACLE_HOME/bin/pluginca -oracleHome $ORACLE_HOME -middlewareHome $MW_HOME -action prereqCheck -plugins "oracle.sysman.db=12.1.0.1.0,oracle.sysman.xa=12.1.0.1.0,oracle.sysman.emas=12.1.0.1.0,oracle.sysman.mos=12.1.0.1.0,oracle.em.sat=12.1.0.1.0,oracle.em.sidb=12.1.0.1.0,oracle.em.smdn=12.1.0.1.0,oracle.em.smad=12.1.0.1.0,oracle.em.smss=12.1.0.1.0,oracle.sysman.emct=12.1.0.1.0,oracle.sysman.ssa=12.1.0.1.0,oracle.sysman.emfa=12.1.0.1.0,oracle.sysman.empa=12.1.0.1.0,oracle.sysman.vt=12.1.0.1.0,oracle.em.ssad=12.1.0.1.0" -oldOracleHome <old_oms_home> -installMode gcUpgrade -client gcinstaller -customParams "connectString=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=example.com)(PORT=1521)))(CONNECT_DATA=(SID=dbview))),username=sysman"


    Note:

    Ensure that the old OMS home is accessible from the remote host where you are running this command.


    Note:

    Example for Microsoft Windows:

    %ORACLE_HOME%\bin\pluginca -oracleHome %ORACLE_HOME% -middlewareHome %MW_HOME% -action prereqCheck -plugins "oracle.sysman.db=12.1.0.1.0,oracle.sysman.xa=12.1.0.1.0,oracle.sysman.emas=12.1.0.1.0,oracle.sysman.mos=12.1.0.1.0,oracle.em.sat=12.1.0.1.0,oracle.em.sidb=12.1.0.1.0,oracle.em.smdn=12.1.0.1.0,oracle.em.smad=12.1.0.1.0,oracle.em.smss=12.1.0.1.0,oracle.sysman.emct=12.1.0.1.0,oracle.sysman.ssa=12.1.0.1.0,oracle.sysman.emfa=12.1.0.1.0,oracle.sysman.empa=12.1.0.1.0,oracle.sysman.vt=12.1.0.1.0,oracle.em.ssad=12.1.0.1.0" -oldOracleHome \\oldem\c$\EM\oms10g -installMode gcUpgrade -client gcinstaller -customParams "connectString=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=example.com)(PORT=1521)))(CONNECT_DATA=(SID=dbview))),username=sysman"


  7. Run Management Repository-related preupgrade checks:

    $ORACLE_HOME/sysman/admin/emdrep/bin/RepManager -doPurging yes <REPOSITORY_HOST> <PORT> <REPOSITORY_SID> -action preupgrade -dbUser SYS -reposName sysman -mwHome $MW_HOME -mwOraHome $ORACLE_HOME -oracleHome $ORACLE_HOME


    Note:

    On Microsoft Windows, run the following command:

    %ORACLE_HOME%\sysman\admin\emdrep\bin\RepManager -doPurging yes <REPOSITORY_HOST> <PORT> <REPOSITORY_SID> -action preupgrade -dbUser SYS -reposName sysman -mwHome %MW_HOME% -mwOraHome %ORACLE_HOME% -oracleHome %ORACLE_HOME%


    For example,

    $ORACLE_HOME/sysman/admin/emdrep/bin/RepManager -doPurging yes example.com 1521 dbview -action preupgrade -dbUser SYS -reposName sysman -mwHome $MW_HOME -mwOraHome $ORACLE_HOME -oracleHome $ORACLE_HOME


    Note:

    Example for Microsoft Windows:

    %ORACLE_HOME%\sysman\admin\emdrep\bin>RepManager -doPurging yes example.com 1521 dbview -action preupgrade -dbUser SYS -reposName sysman -mwHome %MW_HOME% -mwOraHome %ORACLE_HOME% -oracleHome %ORACLE_HOME%


  8. Upgrade the Management Repository:

    $ORACLE_HOME/sysman/admin/emdrep/bin/RepManager -doPurging yes -connectString "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<REPOSITORY_HOST> )(PORT=<PORT>)))(CONNECT_DATA=(SID=<REPOSITORY SID>)))" -action upgrade -dbUser SYS -reposName sysman -mwHome $MW_HOME -mwOraHome $ORACLE_HOME -oracleHome $ORACLE_HOME

    If the preceding command fails, then run the following:

    $ORACLE_HOME/sysman/admin/emdrep/bin/RepManager -doPurging yes -connectString "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<REPOSITORY_HOST> )(PORT=<PORT>)))(CONNECT_DATA=(SID=<REPOSITORY SID>)))" -resume retry -checkpointLocation $ORACLE_HOME/sysman/log/schemamanager -dbUser SYS -reposName sysman -mwHome $MW_HOME -mwOraHome $ORACLE_HOME -oracleHome $ORACLE_HOME


    Note:

    On Microsoft Windows, run the following command:

    %ORACLE_HOME%\sysman\admin\emdrep\bin\RepManager -doPurging yes -connectString "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<REPOSITORY_HOST> )(PORT=<PORT>)))(CONNECT_DATA=(SID=<REPOSITORY SID>)))" -action upgrade -dbUser SYS -reposName sysman -mwHome %MW_HOME% -mwOraHome %ORACLE_HOME% -oracleHome %ORACLE_HOME%

    If the preceding command fails, then run the following:

    %ORACLE_HOME%\sysman\admin\emdrep\bin\RepManager -doPurging yes -connectString "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<REPOSITORY_HOST> )(PORT=<PORT>)))(CONNECT_DATA=(SID=<REPOSITORY SID>)))" -resume retry -checkpointLocation $ORACLE_HOME/sysman/log/schemamanager -dbUser SYS -reposName sysman -mwHome %MW_HOME% -mwOraHome %ORACLE_HOME% -oracleHome %ORACLE_HOME%


    For example,

    $ORACLE_HOME/sysman/admin/emdrep/bin/RepManager -doPurging yes -connectString "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<example.com> )(PORT=1521)))(CONNECT_DATA=(SID=dbview)))" -action upgrade -dbUser SYS -reposName sysman -mwHome $MW_HOME -mwOraHome $ORACLE_HOME -oracleHome $ORACLE_HOME


    Note:

    Example for Microsoft Windows:

    %ORACLE_HOME%\sysman\admin\emdrep\bin\RepManager -doPurging yes -connectString "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=example.com)(PORT=1521)))(CONNECT_DATA=(SID=dbview)))" -action upgrade -dbUser SYS -reposName sysman -mwHome %MW_HOME% -mwOraHome %ORACLE_HOME% -oracleHome %ORACLE_HOME%


  9. Revert the corrective actions that were automatically taken in Step (5):

    $ORACLE_HOME/install/requisites/bin/emprereqkit -executionType upgrade -prerequisiteXMLLoc $ORACLE_HOME/install/requisites/list -prereqResultLoc <prereq_result_location> -connectString "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<REPOSITORY_HOST> )(PORT=<PORT>)))(CONNECT_DATA=(SID=<REPOSITORY_SID>)))" -dbUser SYS -dbPassword <db_password> -reposUser sysman -reposPassword <repo_user_password> -dbRole sysdba -useHistory -runPostCorrectiveActions


    Note:

    On Microsoft Windows, run the following command:

    %ORACLE_HOME%\install\requisites\bin\emprereqkit.bat -executionType upgrade -prerequisiteXMLLoc %ORACLE_HOME%\install\requisites\list -prereqResultLoc <prereq_result_location> -connectString "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<REPOSITORY_HOST> )(PORT=<PORT>)))(CONNECT_DATA=(SID=<REPOSITORY_SID>)))" -dbUser SYS -dbPassword <db_password> -reposUser sysman -reposPassword <repo_user_password> -dbRole sysdba -useHistory -runPostCorrectiveActions


    For example,

    $ORACLE_HOME/install/requisites/bin/emprereqkit -executionType upgrade -prerequisiteXMLLoc $ORACLE_HOME/install/requisites/list -prereqResultLoc $ORACLE_HOME/prerequisiteResults -connectString "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=example.com)(PORT=1521)))(CONNECT_DATA=(SID=dbview)))" -dbUser SYS -dbPassword dbpass -reposUser sysman -reposPassword repopass -dbRole sysdba -useHistory -runPostCorrectiveActions


    Note:

    Example for Microsoft Windows:

    %ORACLE_HOME%\install\requisites\bin\emprereqkit.bat -executionType upgrade -prerequisiteXMLLoc %ORACLE_HOME%\install\requisites\list -prereqResultLoc %ORACLE_HOME%\prerequisiteResults -connectString "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=example.com)(PORT=1521)))(CONNECT_DATA=(SID=dbview)))" -dbUser SYS -dbPassword dbpass -reposUser sysman -reposPassword repopass -dbRole sysdba -useHistory -runPostCorrectiveActions


  10. Create MDS schema in the Management Repository:

    $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/sysman/admin/emdrep/bin/mdsschemamanager.pl -action=-createRepository -connectString=<REPOSITORY_HOST>:<PORT>:<REPOSITORY_SID> -dbUser=SYS -dbPassword=<db_password> -mdsPassword=<new_mds_user_password> -mwHome=$MW_HOME


    Note:

    On Microsoft Windows, run the following command:

    %ORACLE_HOME%\perl\bin\perl %ORACLE_HOME%\sysman\admin\emdrep\bin\mdsschemamanager.pl -action=-createRepository -connectString=<REPOSITORY_HOST>:<PORT>:<REPOSITORY_SID> -dbUser=SYS -dbPassword=<db_password> -mdsPassword=<new_mds_user_password> -mwHome=%MW_HOME%


    For example,

    $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/sysman/admin/emdrep/bin/mdsschemamanager.pl -action=-createRepository -connectString=example.com:1521:dbview -dbUser=SYS -dbPassword=dbpass -mdsPassword=mdspass -mwHome=$MW_HOME


    Note:

    Example for Microsoft Windows:

    %ORACLE_HOME%\perl\bin\perl %ORACLE_HOME%\sysman\admin\emdrep\bin\mdsschemamanager.pl -action=-createRepository -connectString=example.com:1521:dbview -dbUser=SYS -dbPassword=dbpass -mdsPassword=mdspass -mwHome=%MW_HOME%


  11. Create OPS schema in the Management Repository:

    $ORACLE_HOME/sysman/admin/emdrep/bin/SecurityRepManager -action createRepository -connectString "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<REPOSITORY_HOST>)(PORT=<PORT>)))(CONNECT_DATA=(SID=<REPOSITORY_SID>)))" -dbUser SYS -dbPassword <db_password> -schemaPrefix sysman -schemaPassword <sysman_user_password> -component opss


    Note:

    On Microsoft Windows, run the following command:

    %ORACLE_HOME%\sysman\admin\emdrep\bin\SecurityRepManager -action createRepository -connectString "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<REPOSITORY_HOST>)(PORT=<PORT>)))(CONNECT_DATA=(SID=<REPOSITORY_SID>)))" -dbUser SYS -dbPassword <db_password> -schemaPrefix sysman -schemaPassword <sysman_user_password> -component opss


    For example,

    $ORACLE_HOME/sysman/admin/emdrep/bin/SecurityRepManager -action createRepository -connectString "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=example.com)(PORT=1521)))(CONNECT_DATA=(SID=dbview)))" -dbUser SYS -dbPassword dbpass -schemaPrefix sysman -schemaPassword sysmanpass -component opss


    Note:

    Example for Microsoft Windows:

    %ORACLE_HOME%\sysman\admin\emdrep\bin\SecurityRepManager -action createRepository -connectString "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=example.com)(PORT=1521)))(CONNECT_DATA=(SID=dbview)))" -dbUser SYS -dbPassword dbpass -schemaPrefix sysman -schemaPassword sysmanpass -component opss


  12. Configure the OMS:

    $ORACLE_HOME/bin/omsca NEW -lock_console -lock_upload -CONFIGURE_REPEATER true -nostart [-RESPONSE_FILE <absolute_location_to_response_file>]


    Note:

    On Microsoft Windows, run the following command:

    %ORACLE_HOME%\bin\omsca NEW -lock_console -lock_upload -CONFIGURE_REPEATER true -nostart [-RESPONSE_FILE <absolute_location_to_response_file>]



    Note:

    The argument -RESPONSE_FILE <absolute_location_to_response_file> is optional.

    The response file must contain the following variables:

    -AS_HOST=<hostname>
    -AS_USERNAME=<admin serverr username>
    -AS_HTTPS_PORT=<admin server https port>
    -MSPORT=<managed server http port>
    -MS_HTTPS_PORT=<managed server https port>
    -EM_INSTANCE_HOME=<MW_HOME/gc_inst by default>
    -EM_NODEMGR_PORT=<node manager https port>
    -WEBTIER_ORACLE_HOME=<MW_HOME/Oracle_WT>
    -REP_USER=SYSMAN
    -REP_CONN_STR=<connection string>
    -NM_USER=<node manager username>
    -EM_DOMAIN_NAME=<domain name>
    -EM_INSTANCE_HOST=<hostname where the instance home will reside>
    -EM_UPLOAD_PORT=<upload http port>
    -EM_UPLOAD_HTTPS_PORT=<upload https port>
    -EM_CONSOLE_PORT=<console http port>
    -EM_CONSOLE_HTTPS_PORT=<console https port>
    

    Example 20-1 Reponse File Format for UNIX

    -AS_HOST=example.com
    -AS_USERNAME=weblogic
    -AS_HTTPS_PORT=7101
    -MSPORT=7201
    -MS_HTTPS_PORT=7301
    -EM_INSTANCE_HOME=/home/john/oracle/em/middleware/gc_inst
    -EM_NODEMGR_PORT=7401
    -WEBTIER_ORACLE_HOME=/home/john/oracle/em/middleware/Oracle_WT
    -REP_USER=SYSMAN
    -REP_CONN_STR=(DESCRIPTION\=(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=example.com)(PORT\=1521)))(CONNECT_DATA\=(SID\=dbview)))
    -NM_USER=nodemanager
    -EM_DOMAIN_NAME=GCDomain
    -EM_INSTANCE_HOST=example.com
    -EM_UPLOAD_PORT=4889
    -EM_UPLOAD_HTTPS_PORT=1159
    -EM_CONSOLE_PORT=7788
    -EM_CONSOLE_HTTPS_PORT=7799
    

    Example 20-2 Reponse File Format for Microsoft Windows

    -AS_HOST=example.com
    -AS_USERNAME=weblogic
    -AS_HTTPS_PORT=7101
    -MSPORT=7201
    -MS_HTTPS_PORT=7301
    -EM_INSTANCE_HOME=C\:\\Oracle\\Middleware\\gc_inst
    -EM_NODEMGR_PORT=7401
    -WEBTIER_ORACLE_HOME=C\:\\Oracle\\Middleware\\Oracle_WT
    -REP_USER=SYSMAN
    -REP_CONN_STR=(DESCRIPTION\=(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=example.com)(PORT\=1521)))(CONNECT_DATA\=(SID\=dbview)))
    -NM_USER=nodemanager
    -EM_DOMAIN_NAME=GCDomain
    -EM_INSTANCE_HOST=example.com
    -EM_UPLOAD_PORT=4889
    -EM_UPLOAD_HTTPS_PORT=1159
    -EM_CONSOLE_PORT=7788
    -EM_CONSOLE_HTTPS_PORT=7799
    
  13. Configure the plug-ins:

    $ORACLE_HOME/bin/pluginca -oracleHome $ORACLE_HOME -middlewareHome $MW_HOME -action deploy -plugins <pluginlist> -oldOracleHome <old_oms_home> -installMode gcupgrade


    Note:

    The plug-ins to be mentioned for the <pluginslist> argument can be found in the following file:

    $ORACLE_HOME/sysman/install/plugins_installed.txt



    Note:

    On Microsoft Windows, run the following command:

    %ORACLE_HOME%\bin\pluginca -oracleHome %ORACLE_HOME% -middlewareHome %MW_HOME% -action deploy -plugins "<pluginlist>" -oldOracleHome <old_oms_home> -installMode gcupgrade


    For example,

    $ORACLE_HOME/bin/pluginca -oracleHome $ORACLE_HOME -middlewareHome $MW_HOME -action deploy -plugins "oracle.sysman.db=12.1.0.1.0,oracle.sysman.xa=12.1.0.1.0,oracle.sysman.emas=12.1.0.1.0,oracle.sysman.mos=12.1.0.1.0,oracle.em.sat=12.1.0.1.0,oracle.em.sidb=12.1.0.1.0,oracle.em.smdn=12.1.0.1.0,oracle.em.smad=12.1.0.1.0,oracle.em.smss=12.1.0.1.0,oracle.sysman.emct=12.1.0.1.0,oracle.sysman.ssa=12.1.0.1.0,oracle.sysman.emfa=12.1.0.1.0,oracle.sysman.empa=12.1.0.1.0,oracle.sysman.vt=12.1.0.1.0,oracle.em.ssad=12.1.0.1.0" -oldOracleHome /u02/app/Oracle/Middleware/oms11g -installMode gcupgrade


    Note:

    Ensure that the old OMS home is accessible from the remote host where you are running this command.


    Note:

    Example for Microsoft Windows:

    %ORACLE_HOME%\bin\pluginca -oracleHome %ORACLE_HOME% -middlewareHome %MW_HOME% -action deploy -plugins "oracle.sysman.db=12.1.0.1.0,oracle.sysman.xa=12.1.0.1.0,oracle.sysman.emas=12.1.0.1.0,oracle.sysman.mos=12.1.0.1.0,oracle.em.sat=12.1.0.1.0,oracle.em.sidb=12.1.0.1.0,oracle.em.smdn=12.1.0.1.0,oracle.em.smad=12.1.0.1.0,oracle.em.smss=12.1.0.1.0,oracle.sysman.emct=12.1.0.1.0,oracle.sysman.ssa=12.1.0.1.0,oracle.sysman.emfa=12.1.0.1.0,oracle.sysman.empa=12.1.0.1.0,oracle.sysman.vt=12.1.0.1.0,oracle.em.ssad=12.1.0.1.0" -oldOracleHome \\comp1\c$\EM\oms10g -installMode gcupgrade


  14. Migrate the plug-in inventory from old tables to the new Plug-In Lifecycle Application (PLA) inventory table:

    1. Log in to the upgraded Management Repository as SYSMAN user:

      From the Old OMS

      Navigate to the $DB_HOME\bin directory.

      For example (UNIX), /scratch/aime/DB/db/bin. For example (Microsoft Windows), C:\DB\db\bin.

      Run the following, where HOST is where the Management Repository resides:

      sqlplus sysman/<password _for_sysman_user>@"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<REPOSITORY_HOST>)(PORT=<PORT>))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=<REPOSITORY_SID>)))

      For example,

      sqlplus sysman/mypwd@"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=example.com)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=dbview)))

      From the New OMS

      Navigate to the $MW_HOME\oms\bin directory.

      Run the following:

      sqlplus sysman/<password _for_sysman_user>@"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<REPOSITORY_HOST>)(PORT=<PORT>))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=<REPOSITORY_SID>)))"

      For example,

      sqlplus sysman/mypwd@"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=example.com)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=dbview)))"

    2. Run the following SQL query

      SET SERVEROUTPUT ON SIZE 100000
      DECLARE
      PLUGIN_BITS_TYPE     CONSTANT NUMBER := 1;
      DISCOVERY_BITS_TYPE    CONSTANT NUMBER := 2;
      AGENT_DEST_TYPE      CONSTANT NUMBER := 3;
      err_num NUMBER;
      err_msg VARCHAR2(100);
      
      BEGIN
             FOR rec in ( select plugin_id, plugin_version, target_guid, plugin_home,  plugin_type from PRE_UPGC_DEP_PLUGINS )
      LOOP
      
      BEGIN
      
      IF rec.plugin_type = 'discoveryplugin' THEN
      EM_PLUGIN_INVENTORY.add_to_plugin_inventory(rec.plugin_id, rec.plugin_version, DISCOVERY_BITS_TYPE, AGENT_DEST_TYPE, rec.target_guid, rec.plugin_home);
      ELSE
      EM_PLUGIN_INVENTORY.add_to_plugin_inventory(rec.plugin_id, rec.plugin_version, PLUGIN_BITS_TYPE, AGENT_DEST_TYPE, rec.target_guid, rec.plugin_home);
      END IF;
      
      EXCEPTION
      WHEN DUP_VAL_ON_INDEX THEN
      -- ALTER SESSION CLOSE DATABASE LINK PREUPGTO_NG_LINK;
      DBMS_OUTPUT.PUT_LINE('Records already exists.');
      WHEN OTHERS THEN
      -- ALTER SESSION CLOSE DATABASE LINK PREUPGTO_NG_LINK;
      err_num := SQLCODE;
      err_msg := SUBSTR(SQLERRM, 1, 100);
      DBMS_OUTPUT.PUT_LINE('Found exception Error Message :' || err_msg || ' Error Number ;' || err_num);
      
      END;
      
      END LOOP;
      commit;
      END;
      
      /
      
  15. Start the OMS:

    $ORACLE_HOME/bin/emctl start oms


    Note:

    On Microsoft Windows, run the following command:

    %ORACLE_HOME%\bin\emctl start oms


  16. While installing the software binaries in Step (1), if you had chosen to configure the security updates, then configure Oracle Configure Manager (OCM):

    $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/sysman/install/RunOMSOCMConfig.pl $ORACLE_HOME $ORACLE_HOME/perl/bin/perl


    Note:

    On Microsoft Windows, run the following command:

    %ORACLE_HOME%\perl\bin\perl %ORACLE_HOME%\sysman\install\RunOMSOCMConfig.pl %ORACLE_HOME% %ORACLE_HOME%\perl\bin\perl


  17. Configure the Management Agent. To do so, run the following command from the Management Agent home:

    $ORACLE_HOME/sysman/install/agentDeploy.sh AGENT_BASE_DIR=<absolute_path_to_agentbasedir> OMS_HOST=<oms_host> EM_UPLOAD_PORT=<secure_oms_upload_port> AGENT_REGISTRATION_PASSWORD=<agent_reg_password> -configOnly


    Note:

    On Microsoft Windows, run the following command:

    $ORACLE_HOME\sysman\install\agentDeploy.bat AGENT_BASE_DIR=<absolute_path_to_agentbasedir> OMS_HOST=<oms_host> EM_UPLOAD_PORT=<secure_oms_upload_port> AGENT_REGISTRATION_PASSWORD=<agent_reg_password> -configOnly


    For example,

    /u01/app/Oracle/Middleware/agent/core/12.1.0.1.0/sysman/install/agentDeploy.sh AGENT_BASE_DIR=/u01/app/Oracle/Middleware/agent OMS_HOST=example.com EM_UPLOAD_PORT=1159 AGENT_REGISTRATION_PASSWORD=2bornot2b -configOnly


    Note:

    Ensure that you enter the secure (HTTPS) upload port number for the argument EM_UPLOAD_PORT.


    Note:

    Example for Microsoft Windows:

    C:\Oracle\Middleware\agent\core\12.1.0.1.0\sysman\install\agentDeploy.bat AGENT_BASE_DIR=C:\Oracle\Middleware\agent OMS_HOST=example.com EM_UPLOAD_PORT=1159 AGENT_REGISTRATION_PASSWORD=2bornot2b -configOnly