Month: July 2019

Greater Cincinnati Oracle User Group – August 2019

Viscosity will be collaborating a Technology Day Greater with the Cincinnati Oracle User Group on August 15th.

www.gcoug.org

 

Date: August 15th

Start Time: 9AM

Finish Time: 3PM

Lunch will be served at: 12:00 from Larosa’s

Social Networking Time:  4:30

Viscosity Happy Hour will be held at  Firehouse Grill (4785 Lake Forest Dr, Blue Ash Ohio 45242) after the Viscosity Technology Day.

 

There is generally a $25 admission cost for non-members but Viscosity will waive this fee for new guests of Viscosity to attend the Technology Day.

  

Technology Day Agenda:

 

Overview of Oracle’s Engineered Systems – Oracle ACEs 

Oracle Database 12c Release 2 (Oracle 12.2/18c/19c) is the fastest state-of-the-art revolutionary database in the world.  Companies can significantly see immediate ROI by upgrading to Oracle Database 12.2/18c/19c.  Oracle customers need to upgrade to Oracle Database 12.2/18c/19c and unlock the full potential of the new database features and transform their IT infrastructure. 


Everything You Know is Wrong:  DBA Intuition, Meet Hard-Core Metrics – Jim Czuprynski, Oracle ACE Director

Handling application performance degradation – especially when an RDBMS as complex as Oracle Database 12c Release 2 (12.2, 18c, 19c)  underlies the application – can be a complex, time-consuming, frustrating task. Via actual use cases, stories of painful discoveries, and of course some hard-core metrics, this session will take a look at some of the simplest mistakes even an Oracle DBA can make when probing application performance issues and how to overcome one’s own blind spots when searching for the true root causes of that degradation.

This session will:

– Look at some typical use cases that we’ve encountered in the past two decades as an Oracle DBA

– Discuss what Oracle DBAs need to know to successfully analyze and recover from unexpected application performance degradation

– Lay out some particularly useful tools built into Oracle 12.2/18c/19c for overcoming one’s own intuition when problem-solving under pressure

This session will look at some typical use cases that we’ve encountered in the past two decades as an Oracle DBA; as well as:

  • Discuss what Oracle DBAs need to know to successfully analyze and recover from unexpected application performance degradation
  • Lay out some particularly useful tools built into Oracle 12.2/18c/19c for overcoming one’s own intuition when problem-solving under pressure

Agenda

  • Evaluating Your Career: Applying Metrics to Your Future
  • Horror Story #1: “What’s Wrong With the Database?”
  • When Intuition Fails, There’s Always Metrics
  • Understanding the Underlying Genius of Quadruple-A
  • Horror Story #2: “But VMSTAT Says …”
  • Horror Story #3: “Your SAN’s Performance S*cks!”
  • Conclusions

Bulletproof your Data Guard Configuration – Charles Kim Oracle ACE Director

Learn the pitfalls to common Data Guard configuration issues. Not only will we review the common Data Guard configuration issues that most of the customers face, we will provide tips and tricks to avoid the situation. More importantly, we will share our industry expertise to show you how to  resolve the issues.  We will also demonstrate how you can proactively monitor and maintain your Data Guard configuration so avoid disasters, tune the transport layer, and minimize out-of-sync conditions.


We will disseminate Data Guard best practices and reference architectures that DBAs and architects need to know to protect their Oracle ecosystem. Pertinent Oracle Database 12.2/18c/19c new features will be shared.  The session concentrates on:

  • Building the physical standby
  • Monitoring and maintaining the physical standby
  • Configuring Data Guard Broker
  • Performing backup and recovery with RMAN
  • Setting archive retention
  • Performing switchovers and failovers
  • Integrating Data Guard with OEM 13c
  • What’s new in Oracle Data Guard 12.2/18c/19c

 

Oracle Enterprise Manager in Action – Alfredo Krieg Oracle ACE

Oracle Enterprise Manager 13c provides the single pane of glass that allows Architects and DBA’s monitor and manage the Oracle ecosystem.. In this session, learn how Oracle Enterprise Manager simplifies management of the databases and including the Oracle’s Engineered Systems. This presentation covers the monitoring aspects of the Oracle’s engineered systems, techniques in order to find performance problems affecting the databases, and will cover the latest new features in OEM.

Oracle Enterprise Manger, provides comprehensive and centralized monitoring capabilities for the Oracle Engineered Systems, including the Oracle Database Appliance and  Exadata Database Machine. 

  • Performance monitoring 
  • Identify wait events
  • Create custom metrics to send alerts 
  • Learn the latest features in OEM 13c

 

 

SPARC to ODA Migration

Viscosity has expertise in migrating SPARC workloads to the Linux environments.  Viscosity has partnered up with the Oracle Database Appliance (ODA) teams to provide an simplified solution around migrating customers from the legacy SPARC platform to the ODAs.  

Look at our data sheet on migrating SPARC customers to the ODA.  While we migrate customers to the ODAs, Viscosity can modernize your Oracle workloads to Oracle Database 18c or 19c depending your requirements and application compatibility to the version of Oracle. Viscosity can also help with your application migration to the Linux platform from Solaris (Or even AIX). We have deep expertise in Java and emerging technologies.  

Solaris to Linux on ODA.pdf

The re-platform tasks for the database tier will involve changing the endianness for the database files.  Viscosity has a semi-automated solution to change data endianness from Sparc to Intel format. Viscosity’s solution integrates years of migration experience of migrating Solaris and AIX customers to Linux.  Viscosity will document the upgrade the process and any workarounds; more importantly, Viscosity will script out a majority of the migration process to improve migration efficiency, as well as document the processes to reduce potential errors that can be encountered during the migration process. 

Near Zero Downtime Migration/Upgrade Option:

Optionally by leveraging Oracle GoldenGate or Quest SharePlex, the latest data replication technologies, Viscosity can perform a near zero-downtime database migration as a cost-effective solution.  If you want the additional insurance policy, Viscosity can reverse the data replication back to Solaris before the go-live from ODA to achieve a zero-risk exposure value proposition.


  • Both Oracle GoldenGate or Quest SharePlex can be purchased for term licensing for the migration/upgrade duration.  In full transparency, leveraging the Quest SharePlex product for the upgrade will be more cost effective.
  • Customers can upgrade their database along the way to Oracle 18c, Viscosity can re-platform and upgrade as a single solution. If you are running older versions of Oracle Databases version 11.2 which is already out of error correction as of December 31, 2018.  Oracle Database version 12.1 will be out of error correction at the end of July 2019.  Customers should upgrade to Oracle Database 18c or 19c for all custom application databases. 

Eliminate risk with a failback option, keeping the original platform in sync with the new data until all tests have been performed on ODA. 

GG ODAThe tool of choice for near zero downtime migrations to ODA is Oracle GoldenGate or Quest SharePlex. Leveraging either of these data replication tools, Viscosity can copy, replicate and synchronize databases from Sparc platforms to ODA.

 

Viscosity encourages dry-runs of the proposed zero downtime database migration and re-platform to ODA with their customers to capture and record potential issues with the real-time data synchronization to the ODA.   Depending on the customer’s schema, Viscosity may need to perform manual data migrations for select tables that has datatype discrepancies and conflicts with Oracle GoldenGate or SharePlex. 

 

Viscosity has tooling to compare potential discrepancies for the dictionary between the source and target database environments. Viscosity’s tools can perform data validations and compare delta data records between the databases on the Sparc platform and the migrated/upgraded databases on the ODA. Viscosity has certified experts in Oracle and Red Hat Linux and regularly participates on the panel of experts at Oracle and VMware conferences to:

  • share best practices for scalable Linux infrastructure
  • methods to achieve near zero downtime database migrations and upgrades

 

Viscosity will setup/configure the databases on Linux to migrate heavy Oracle workloads from Solaris to Linux with our custom scripts.