facebook twitter youtube facebook facebook facebook

E-Mail : info@askmlabs.com

Phone : +1.215.353.8306

Latest Post

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


 
Support :
Copyright © 2013. askMLabs - All Rights Reserved
Proudly powered by Blogger