A new pre-built VirtualBox image is available for download  from OTN (updated on March 27, 2017).

Once you download, import and configure the VM, you can pretty much do whatever you want. But Roy and Mike have put together a very good lab environment and exercise for you to practice Oracle database upgrade from 11gR2 to 12cR2. The lab includes

  • Manual upgrade of 11.2.0.4 database to 12.2.0.1
  • Attach 12c non-container database as a PDB to existing 12.2.0.1 CDB
  • Upgrade 11.2.0.4 database using Full Transportable Export/Import to 12.1.0.2 as a PDB
  • Upgrade 12.1.0.2 PDB to 12.2.0.1 using unplug / plug method

The pre-built VM comes with Oracle software already installed.

  • 11gR2 11.2.0.4 – /u01/app/oracle/product/11.2.0.4
  • 12cR1 12.1.0.2 – /u01/app/oracle/product/12.1.0.2
  • 12cR2 12.2.0.1 – /u01/app/oracle/product/12.2.0.1

Practice upgrades, new features, patches, PSU, migration using this VirtualBox image.

Thanks to Mike Dietrich and Roy Swonger!

VirtualBox Download

12c Database Image Download

 

otnlogoThanks Tim for coming up with this idea! Pretty neat… And THANK YOU OTN!!

There are quite a few features I like in the Oracle Database, but today I choose ORAchk (and EXAchk). Troubleshooting and diagnostics are my favorite area and I was amazed by the enhancements Oracle made in integrating the various diagnostics tools and preserving history. And ORA/EXAchk is a no-cost tool, provided by Oracle, enhanced every quarter with more and more health checks…

ORAchk and EXAchk tools started as just another configuration verification tool (used to be called RACcheck). ORAchk (for non-Engineered systems) and EXAchk (for engineered systems) grown into a “product” from a “tool”. This is evident in 12.2, as the documentation from a simple MOS note grown into a full document User Guide.

What’s cool is that ORAchk and EXAchk can be daemonized to run these checks periodically. The daemon can also purge old reports based on the retention policy you set. The most favorite enhancement I like is the ability to compare two reports. Oracle ORAchk and Oracle EXAchk automatically compare the two most recent HTML reports and generate a difference report, when run in an automated daemon mode.

To manually compare two reports, orachk (or exachk) can be invoked with the -diff option.

The comparison report’s sections are very appropriate.

  • Difference between report 1 and report 2 (status change of checks)
  • Unique findings in report 1 (issues that were fixed)
  • Unique findings in report 2 (new issues after report 1)
  • Common findings in report 1 and 2 (issues that were not fixed)

Oracle Health Check Collections Manager is another cool application that comes with these tools, where the ORAchk (and EXAchk) results can be uploaded to an Oracle database APEX workspace for analysis and reporting. ORAchk (and EXAchk) can be configured to automatically upload check results to the Oracle Health Check Collections Manager database. Specify the connection string and the password to connect to the database to upload collection results. Oracle Health Check Collections Manager stores the connection details in an encrypted wallet.

If you have not run ORAchk recently, it’s time to download and run the check today. And, don’t forget to schedule it! Forgot to mention, since 12.1.0.2.5 version you have the ability to Create User Defined Checks too!

Download ORAchk – My Oracle Support Note 1268927.2

While you are there, check out TFA (Trace File Analyzer: MOS 1513912.2) and CHM (Cluster Health Monitor: MOS 1328466.1) as well!

In the February 2016 issue of the NoCOUG Journal, for the Many Things Oracle column, I discuss some of the v$ views that are lesser known or not widely used. I also touch up on the MGMTDB cluster repository database in Oracle Clusterware 12c.

Read here…

This is a Collector’s Edition, and includes the several good articles from:

  • Shyam Varan Nath – The Internet of “Things”
  • Brian Hitchcock – “Oracle Database 12c New Features” book review
  • Iggy Fernandez – The rise and fall of the NoSQL Empire
  • Lothar Flatz – Raiders of the Data Dictionary III: The Quest for the Missing Index

This is sixth installment of Many Things Oracle column in NoCOUG journal. The past articles are:

NoCOUG Journal 2015 NOV: Oracle Database 12c New Processes and SQL Developer [Magazine]

NoCOUG Journal 2015 AUG: Trace File Analyzer [Magazine]

NoCOUG Journal 2015 MAY: Listener IFILE, LREG process [Magazine]

NoCOUG Journal 2015 FEB: Oracle Database 12c new parameters [Magazine]

NoCOUG Journal 2014 NOV: Miscellaneous 12c new features [Magazine]

Thank you NoCOUG for the opportunity…

%d bloggers like this: