Forum Stats

  • 3,838,210 Users
  • 2,262,341 Discussions
  • 7,900,543 Comments

Discussions

Upgrading OEM Cloud Control repository 11.2 to 12.1 database

Paul_______A.
Paul_______A. Member Posts: 62 Blue Ribbon
edited Dec 16, 2014 10:34AM in Enterprise Manager

Hi,

I'd like to upgrade my 11.2.0.3 database for EMREP to 12.1 (latest) . Also, it will be moving from hostA to hostB.

Simply upgrading is trivial for me, migration too.

But how to tell OMS that the database has moved to another host?

Most likely I have to

$OMS_HOME/bin/emctl stop oms -all

(upgrade-migrate database)

and then....??

Any hints (experience) is welcome.

Note: I'm on OEL6.4 64bit linux and the target platform is the same.

Note: Already got 12.1 running on target platform

Thanks,

Paul


Answers

  • Courtney Llamas-Oracle
    Courtney Llamas-Oracle Member Posts: 782 Employee

    Yes, it's a simple change with emctl. 

    http://docs.oracle.com/cd/E24628_01/install.121/e24089/ha_backup_recover.htm#sthref872

    However I'd advise you to review this note before upgrading the repository to 12.1: Temporary Suspension of 12c Database as EM 12cR4 Repository (Doc ID 1920632.1)

  • Monowar Mukul
    Monowar Mukul Member Posts: 310 Blue Ribbon

    Hi Paul,

    You can try below which I did long back  for reconfiguring existing OMS for upgraded repository database (MONDB) and new host (oraintdev), it worked after trying 3/4 times.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    1. Stop Agent, OMS, repository database, listener

    2. Upgrade repository database

    3. Configure Repository database again [A parameter for HOST]:

    cd /BPELAIT2/middleware0/oms/bin

    Where /BPELAIT2/middleware0/oms is OMS home.

    Then,

    oracle$ $OMS_HOME/bin/emctl config oms -store_repos_details -repos_conndesc "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oraintdev)(PORT=1521)))(CONNECT_DATA=(SID=MONDB)))" -repos_user sysman

    Oracle Enterprise Manager Cloud Control 12c Release 3 

    Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.

    Enter Repository User's Password :

    Successfully updated datasources and stored repository details in Credential Store.

    If there are multiple OMSs in this environment, run this store_repos_details command on all of them.

    And finally, restart all the OMSs using 'emctl stop oms -all' and 'emctl start oms'.

    It is also necessary to restart the BI Publisher Managed Server.Stop, then restart the OMS.

    [email protected]:/BPELAIT2/middleware1/oms/bin$  ./emctl config oms -list_repos_details

    Oracle Enterprise Manager Cloud Control 12c Release 3

    Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.

    Repository Connect Descriptor : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oraintdev.<domain>)(PORT=1521)))(CONNECT_DATA=(SID=MONITOR)))

    Repository User : SYSMAN

    oracle$ $OMS_HOME/bin/emctl stop oms -all ; sleep 5 ; $OMS_HOME/bin/emctl start oms

    Oracle Enterprise Manager Cloud Control 12c Release 3 

    Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.

    Stopping WebTier...

    WebTier Successfully Stopped

    Stopping Oracle Management Server...

    Oracle Management Server Successfully Stopped

    AdminServer Successfully Stopped

    Oracle Management Server is Down

    Oracle Enterprise Manager Cloud Control 12c Release 3 

    Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.

    Starting Oracle Management Server...

    Starting WebTier...

    WebTier Successfully Started

    Oracle Management Server Successfully Started

    Oracle Management Server is UpLogin to OEM and confirm proper operation of the system.

    [email protected]:/BPELAIT2/middleware1/oms/bin$ ./emctl status oms -details

    Oracle Enterprise Manager Cloud Control 12c Release 3

    Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.

    Enter Enterprise Manager Root (SYSMAN) Password :

    Console Server Host        : oraintdev.<domainname>

    HTTP Console Port          : 7789

    HTTPS Console Port         : 7800

    HTTP Upload Port           : 4890

    HTTPS Upload Port          : 4899

    EM Instance Home           : /BPELAIT2/gc_inst/em/EMGC_OMS1

    OMS Log Directory Location : /BPELAIT2/gc_inst/em/EMGC_OMS1/sysman/log

    OMS is not configured with SLB or virtual hostname

    Agent Upload is locked.

    OMS Console is locked.

    Active CA ID: 1

    Console URL: https://oraintdev.<domain>.au:7800/em

    Upload URL: https://oraintdev.<domain>.au:4899/empbs/upload

    WLS Domain Information

    Domain Name            : GCDomain

    Admin Server Host      : oraintdev.<domain>

    Admin Server HTTPS Port: 7102

    Admin Server is RUNNING

    Managed Server Information

    Managed Server Instance Name: EMGC_OMS1

    Managed Server Instance Host: oraintdev.<domain>

    WebTier is Up

    Oracle Management Server is Up

    Then start agent. Hope this help for you.

    Thanks

    Monowar

  • K B Sumesh -Oracle
    K B Sumesh -Oracle Member Posts: 201 Employee

    Hi,

    After you move/migrate you database, you need to update Weblogic Data source with new connection, so that OMS knows about the migrated database and makes a connection. On the OMS side, you need to run 'store repos details command to store the new connect descriptor to OMS using the below command

    $OMS_HOME/bin/emctl config oms -store_repos_details -repos_conndesc <complete connect descriptor> -repos_user sysman


    Refer to HA doc for details: http://docs.oracle.com/cd/E24628_01/install.121/e24089/ha_backup_recover.htm#sthref872


    NOTE: Support for 12c Database for EM12cR4 is temporarily suspended.


    Regards.

This discussion has been closed.