Search

Top 60 Oracle Blogs

Recent comments

Upgrading an Amazon EC2 Delphix Target, Part IV

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:

  • 1.  Updating our instances so that we’ll have a GUI interface if we’ll need one.
  • 2.  Installed Oracle on the Linux Source and upgraded our Dsource database to 12c

 

Now we’re done with our Linux Source and onto our Linux Target.

Install and Configure VNC and Oracle

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.

https://i1.wp.com/dbakevlar.com/wp-content/uploads/2017/07/target_12c_in... 300w, https://i1.wp.com/dbakevlar.com/wp-content/uploads/2017/07/target_12c_in... 768w, https://i1.wp.com/dbakevlar.com/wp-content/uploads/2017/07/target_12c_in... 1312w, https://i1.wp.com/dbakevlar.com/wp-content/uploads/2017/07/target_12c_in... 1968w" sizes="(max-width: 600px) 100vw, 600px" data-recalc-dims="1" />

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.

Add the New Oracle Home to the Linux Target

Log into Delphix Admin Console and click on Environments.

click on the Linux Target and then click on the refresh button:

https://i1.wp.com/dbakevlar.com/wp-content/uploads/2017/07/Screen-Shot-2... 300w" sizes="(max-width: 242px) 100vw, 242px" data-recalc-dims="1" />

Click on the Databases tab and you’ll now see the DB12c Oracle home is now present in the list:

https://i1.wp.com/dbakevlar.com/wp-content/uploads/2017/07/Screen-Shot-2... 300w, https://i1.wp.com/dbakevlar.com/wp-content/uploads/2017/07/Screen-Shot-2... 768w, https://i1.wp.com/dbakevlar.com/wp-content/uploads/2017/07/Screen-Shot-2... 1312w, https://i1.wp.com/dbakevlar.com/wp-content/uploads/2017/07/Screen-Shot-2... 1968w" sizes="(max-width: 600px) 100vw, 600px" data-recalc-dims="1" />

Prep VDBs for switch to new home

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.

#00ffff; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 13px;">. 11g.env

export ORACLE_SID=VEmp6f
sqlplus / as sysdba
shutdown immediate;
exit;

and so on and so forth…. </p />
</p></div></div>

    	  	<div class=