Subscribe to Blog via Email
Follow me on TwitterMy Tweets
It’s finally time to upgrade our Linux Target! OK, so we’re not going to upgrade the way a DBA would normally upgrade a database server when we’re working with virtualization.
So far, we’ve completed:
Now we’re done with our Linux Source and onto our Linux Target.
We’ll run through and install and configure the VNC Viewer requirements just like we did in Part I and Part II. We’ll also install Oracle, but only this time, we’ve performed a software installation only.
We’ll install the Enterprise Edition and we’ll make sure to install it in the same path as we did on our Linux Source, (/u01/app/oracle/product/12.1/db_1) We’re not installing the multi-tenant, as we didn’t configure this on our source, either.
Once that is complete, it’s time to get our VDB’s upgraded.
The first thing you need to remember is that the VDBs are simply virtual images of our Dsource that is already UPGRADED.
Log into Delphix Admin Console and click on Environments.
click on the Linux Target and then click on the refresh button:
Click on the Databases tab and you’ll now see the DB12c Oracle home is now present in the list:
Copy your environments profile from 11g.env to 12c.env. Update the Oracle home to point to the new 12c home and save the file.
Now I have three VDBs on this target:
[delphix@linuxtarget ~]$ ps -ef | grep pmon delphix 7501 1 0 Jul12 ? 00:01:17 ora_pmon_devdb delphix 8301 1 0 Jul06 ? 00:01:49 ora_pmon_VEmp6 delphix 16875 1 0 Jul05 ? 00:01:57 ora_pmon_qadb
Log into the Linux Target and from the command line, set the environment and log into each database via SQL Plus and shut it down.
export ORACLE_SID=VEmp6f sqlplus / as sysdba shutdown immediate; exit;
and so on and so forth…. 🙂
Copy all the init files from the 11g Oracle Home/dbs for the VDBs over to the 12c Oracle Home/dbs/.
And this is where it all went wrong for two of the VDBs…
Back on the Delphix Admin Console, click on Manage –> Datasets
Click on each of the VDBs involved. Click on Configuration –> Upgrade, (up arrow icon) and say yes to upgrading. Update the Oracle home from the 11g in the drop down to the new 12c Oracle home and click the gold check mark to confirm.
OK, so this is what I WOULD have done for all three VDBs if I’d been working with JUST VDBs, but this is where it gets a bit interesting and I had to go off the beaten path for a solution. I’m unsure if this is documented anywhere inside Delphix, (Delphix Support is awesome, so I’m sure they already know this, but for my own sanity) here’s the situation and the answer. The environment I am working on is built off of AWS AMIs that consist of Delphix containers. Containers are very powerful, allowing you to “package” up a database, application and other tiers of virtualized environments, offering the ability to manage it all as one piece. This was the situation for the qadb and the devdb instances.
Due to this, I couldn’t run the upgrade inside the Delphix Admin console since these two VDBs were part of Delphix “data pods.” The following are the steps to then address this change.
5. Delete the two containers that are controlling the administration of these two VDBs still pointing to the 11g home.
Now, log into the Delphix Admin console.
In Jet Stream
This will take just a moment to finish creating and that’s all there is to it. You now have two DB12c environments that are completely containerized and upgraded from their previous 11g state.
Our source shows we’re using our DB12c upgraded database:
It may have taken a little longer for me to upgrade with the complexity of the containers introduced, but the power of data pods is exceptional when we’re managing our data, the database and the application as one piece anyway. Shouldn’t we treat it as one?