facebook twitter youtube facebook facebook facebook

E-Mail : info@askmlabs.com

Phone : +1.215.353.8306

Latest Post
Showing posts with label oakcli. Show all posts
Showing posts with label oakcli. Show all posts
4:04 PM

Oracle Database Appliance - Create A New Oracle Home

Written By askMLabs on Friday, January 27, 2017 | 4:04 PM

Creating a new oracle rdbms home in ODAs is not the same process how we normally install rdbms binaries on any OS platform. This is an engineered system and Oracle made is very simple to create new oracle homes.

Our new ODAs ( X5-2 ) are with control version 12.1.2.9.0 and installed 12.1.0.2( Grid and RDBMS). To know your version , you need to execute the following commands ...

oakcli show version
oakcli show dbhomes

Now we have a requirement where we need 11.2.0.3 database binaries. These ODAs does not come with that package by default. So we need to get that package from MOS. Installing the db home is very simple in ODAs, but finding the right package for your version is the critical part of it. This is how we started analyzing to get the right package for right version.

We started checking if the latest version of ODAs (12.1.2.9.0) is supported to install 11.2.0.3. We executed the following command to see what versions it supports ....

oakcli create dbhome -version 11.2.0.3 

Then it gives you an error message saying ...

ERROR: 2017-01-27 12:07:39: 11.2.0.3 is not a supported version

It also gives you the version supported....

INFO: 2017-01-27 12:07:39: Supported versions are
11.2.0.3.15
11.2.0.4.0
11.2.0.4.1
11.2.0.4.2
11.2.0.4.3
11.2.0.4.4
11.2.0.4.5
11.2.0.4.6
11.2.0.4.7
11.2.0.4.8
11.2.0.4.160119
11.2.0.4.160419
11.2.0.4.160719
11.2.0.4.161018
12.1.0.2.0
12.1.0.2.1
12.1.0.2.2
12.1.0.2.3
12.1.0.2.4
12.1.0.2.5
12.1.0.2.160119
12.1.0.2.160419
12.1.0.2.160719
12.1.0.2.161018


Now we confirmed that the present version support the 11.2.0.3 version.  For information about supported releases, refer to My Oracle Support note 888888.1

At this point we know that 11.2.0.3 version is supported and we need to get the correct package for this version. Open the MOS 888888.1 and search for "RDBMS Clone files", under this section, you will find the patch number and its corresponding package to download.  You can directly download the package from this location or search for that patch in MOS and get the correct package by following the instructions carefully. In our case, we need to search for this patch for 12.1.2.4.0 release as instructed by this MOS  888888.1. 

Now we have the package. Upload this package to the one of the ODA server and execute the following commands. We uploaded to /var/tmp location which is a default package location on ODAs.


# oakcli unpack -package /var/tmp/p14777276_121240_Linux-x86-64.zip
Unpacking will take some time,  Please wait...
WARNING: 2017-01-27 13:52:41: You are trying to unpack older clone file
INFO: 2017-01-27 13:52:41: Current system is at 12.1.2.9.0 version
WARNING: 2017-01-27 13:52:41: Unpacking this bundle may overwrite some files which may cause patching/deployment failures
Press Yes to continue or No to quit.... :
No


If you see these messages, you probably thinking something might be going wrong by unpacking the zip file we just uploaded to server. It is not. We are actually on version 12.1.2.9.0 and the package we downloaded for version 12.1.2.4.0. So It warns you with those messages. It is nothing wrong. You can continue pressing "Yes". You can refer the MOS 888888.1 in the know issues section to get confirmation on this.


# oakcli unpack -package /var/tmp/p14777276_121240_Linux-x86-64.zip
# oakcli create dbhome -version 11.2.0.3.15
# oakcli show dbhomes

 Monitor the progress of this installation from the log file : /opt/oracle/oak/log/<hostname>/tools/12.1.2.9.0/createdbhome_25754.log




Hope This Helps
SRI


Labels: , ,
10:01 PM

Migrating Level-4 OEM to New Datacenter With Zero Downtime

Written By askMLabs on Thursday, December 15, 2016 | 10:01 PM

I am working on a project to migrate a level-4 OEM(Oracle Enterprise Manager) running on Oracle Database Appliances(ODA) from one Datacenter to another Datacenter. I am also planning to write a white paper on this and will  submit to Oracle.

I proposed the following action plan to migrate these ODAs to new datacenter with zero downtime. 

I am going to explain the outlined procedure to perform this activity in the present article, but will also write some more articles on the same topic with detailed step by step procedure.

In order to understand this article, Please note the following keywords.
  • OEM - Oracle Enterprise Manager
  • ODA - Oracle Database Appliance
  • OMR - Oracle Management Repository ( Oracle Database )
  • OMS - Oracle Management Service
  • OMA - Oracle Management Agent
  • PDC - Primary Datacenter
  • SDC - Second Datacenter or Standby Datacenter
  • TDC - Third Datacenter
  • DNS - Domain Name Service

Present Setup : 
  • Two primary ODAs with 12.1.0.4 OEM 12c installed - At PDC
  • Two secondary ODAs with 12.1.0.4 OEM 12c (Standby with ASM replication from primary for OMS binaries) - At SDC
  • Database and Grid are on 11.2.0.3
  • Oracle Database is two instance RAC both on primary and secondary
  • ODAs are with old control version (oakcli)
Targetted Setup : 
  • Two primary ODAs with 12.1.0.4 OEM 12c - At PDC 
  • Two secondary ODAs with 12.1.0.4 OEM 12c (Standby with ASM replication from primary for OMS binaries) - At TDC
  • Database with 12.1.0.2 and 11.2.0.3
  • Grid with 12.1.0.2 ( without flex ) 
  • Oracle Database is two instance RAC both on primary and secondary
  • ODAs with the latest control version ( oakcli )

Slide-1

  • Primary ODAs at PDC are hosting OEM12c with 12.1.0.4 version. The database is RAC and it has two OMS services  running.
  • Secondary ODAs at SDC are standby for Primary and it hosts the same versions as primary.
  • The primary to secondary OMS replication is setup using ASM file system. So it is ASM replication from primary to secondary. ( Note that it is not standby weblogic setup ) . Please read my other article on how to convert Standby weblogic Server setup to ASM replicaiton.

Slide-2

  • The secondary datacenter SDC will be replaced with a third datacenter TDC. So we got new ODAs and they are stacked and installed at new datacenter. These ODAs are called toda01 and toda02. The next step is to create a new standby database at TDC with primary database at PDC.
  • Grid software will be 12.1.0.2.
  • Database software will be 11.2.0.3 and 12.1.0.2 ( Need to install both the binaries, so that the latest version can be used for database upgrade)
Slide-3
  • In this step, we are going to create a new standby database TOEMDB for the primary database POEMDB. At this point of time, we have  two standby databases up and running. We need to make sure that the archive logs are shipped to both the standby locations. Once the second standby database is created, we need to prepare the toda's for the OMS creation.
Slide-4
  • We need to prepare the ODAs at TDC for ASM replication. The procedure and detailed steps will be posted in a different article. 
  • Disable the ASM replication from PDC to SDC.
  • Enable the ASM replication from PDC to TDC.
  • Note that, at this point, we still have two standby databases, but only one ASM replication from PDC to TDC. The DNS is still pointing to SDC.
Slide-5
  • Now the standby setup for database at SDC can be disabled. Need to remove all the configurations for SDC standby database at primary database running at PDC.
  • Now primary database is at PDC and One Standby Database is at TDC. Primary OMS is at PDC and Standby OMS is at TDC.
  • DNS ( loadbalancer ) updates need to be done to reflect the new ODAs at TDC. All the references for ODAs at SDC should be removed from DNS and loadbalancer.
Slide-6
  • We can now switch off or decommission the ODAs at SDC as per your enterprise standards.
  • At this point, we have PDC as primary OEM and TDC with the standby OEM setup.
  • Database at PDC is with 11.2.0.3 and at TDC with 11.2.0.3. Note that we still have binaries 12.1.0.2 created for future database upgrade.
  • Grid at PDC is 11.2.0.3 and Grid at TDC is 12.1.0.2.
  • ODA control software oakcli is with old version at PDC and at latest version at TDC.

Slide-7
  • The OEM setup looks as shown above after completely replacing the SDC datacenter ODAs with TDC ODAs.

Now we are going to repeat the same steps for replacing the ODAs at PDC. For this replacement, we are using the same datacenter PDC. So in the same datacenter PDC, we will replace the old ODAs with the new ODAs. For this to perform ,we need to switch the roles of the present OEM.

Slide-8
  • Rack and stack the ODAs at FDC.
  • Database with version 11.2.0.3 and 12.1.0.2
  • Grid wit h12.1.0.2 version.
Slide-9
  • Swith the roles of the OEMs at PDC and TDC.
  • Once the OEM at PDC is standby, we can repeat the same steps from 1-7.
Slide-10
Slide-11

Slide-12

Slide-13


Slide-14
  • When the ODAs at PDC are replaced completely with new ODAs, we can switch back the roles. So that, ODAs at PDC will run the primary OEM and PDAs at TDC will run the standby OEM.



The Complete procedure is shown in the following flow diagram for easy reference to understand what we are doing at each stage.




Hope this information helps you to understand the migration of  Level-4 OEM with zero downtime.

Please comment or reply to me if you have any questions or doubts.

Thanks
SRI
Labels: , , , , , , , , , , ,
 
Support :
Copyright © 2013. askMLabs - All Rights Reserved
Proudly powered by Blogger