2014 Winter General Meeting - Presentations - New York Oracle User Group

Contents

The New York Oracle Users Group Winter General Meeting

Thursday December 11, 2014
sponsored by Dell Software

KEYNOTE: Different ways to Upgrade, Migrate & Consolidate with Oracle Database 12c

You may be wondering just how you can move your current databases to pluggable databases in a multitenant architecture in Oracle Database 12c. Whether you are just starting to explore the world of pluggable databases or are planning a production upgrade in the near future to Oracle Database 12c, this session gives you all of the details: what methods are available; how they work; and which is the best for your particular upgrade, migration, or consolidation scenario.

Roy Swonger has over twenty years of experience in commercial software development. His seventeen-year career at Oracle has included work on software process and quality improvement as well as a progression of management roles in technical documentation, software development tools, and core database technologies. Roy is currently the Senior Director of Database Upgrade & Utilities in the Server Technologies division. He is responsible for the development of database features such as the Data Pump, SQL*Loader, External Tables, and Metadata API. In addition, Roy runs the global Upgrade Program for the database, coordinating worldwide efforts to make database upgrades faster, easier, and less risky for customers. Roy holds a Bachelor of Science in Computer Science from Rensselaer Polytechnic Institute, and a Master of Software Engineering from Carnegie Mellon University.

DBA TRACK: ACFS and Flex ASM: Advanced Filesystem Technology for All

The ASM Clustered File System (ACFS) is license-free since September 2014. This gives all sites (even those without a database at all) access to snapshot, encryption, and replication facilities that might otherwise cost a fortune. Flex ASM removes the last excuses for not using ASM for database storage. The ACFS now offers file system facilities including local and wide area replication, transparent encryption, and snapshot copies. It supports all file types, and to users looks like any other POSIX compliant file system. Based on 12c Flex ASM, it can replace all of your third party file system and file server products. Even without ACFS, the Flex ASM enhancements should motivate all sites to upgrade to 12c. This presentation will demonstrate how simple it can be to configure and use, and will cover Flex ASM as used for database storage.

Dave Anderson is SkillBuilders President and Founder. Dave is an Oracle DBA with 20 years of experience. John Watson is an Oracle Certified Master consultant, lecturer, and author with twenty years’ experience with the Oracle technology stack, including 11g Grid Infrastructure and RAC. John has authored 5 Oracle Press Exam Guides. He is SkillBuilders’ Director of Oracle Database Services.

DEVELOPER TRACK: JSON is not another YAML (Yet Another Markup Language – with SQL Developer and 12c)

With the introduction of Oracle 12c (cloud) comes more enhancements and incorporation of current industry standards. Oracle’s implementation of JSON or JavaScript Object Notation is no exception towards meeting current industry standards. As an alternative to XML, JSON or JavaScript Object Notation, is an open standard format that uses human-readable text to transmit data objects consisting of attribute–value pairs. It is used primarily to transmit data between a server and web application. Using Oracle 12c and SQLDeveloper, attendees will view several examples of using JSON as well as get an introduction to its syntax.

Coleman Leviter is an IT Software Systems Engineer at Arrow Electronics. He has presented at IOUG’s Collaborate and at Oracle Open World. He is on the IOUG Board of Directors (ioug.org). He is the NYOUG Web SIG Chairperson. His articles have been published in Select Journal and OTDUG Journal. He has worked in the financial and aerospace industries where he developed Navigation, Flight Control and Reconnaissance software for the F-14D Tomcat. Coleman has a BSEE from Rochester Institute of Technology, an MBA from C.W. Post and an MSCS from New York Institute of Technology. He may be contacted at cleviter@gmail.com

DBA TRACK: How Database Upgrade Works in a Multitenant Environment

With the first patch set of Oracle Database 12c, you will be able to choose between various methods of upgrading a multitenant container database and its pluggable databases. This presentation includes all the details of how a database upgrade works in a multitenant environment. You will learn what your options are, how parallelism works for database upgrades, and what is new for database upgrades in the first patch set of Oracle Database 12c.

DEVELOPER TRACK: Using AngularJS in APEX

Oracle Application Express (APEX) has established itself as one of the best ways to capitalize on SQL and PL/SQL skills to create web applications in a fraction of the time of traditional applications. AngularJS, on the other hand, has proven itself as a great framework to create web applications using JavaScript that are highly responsive and customizable. But must we choose between the two? It turns out that you don’t have to choose – at least once you figure out the best way to integrate them! This presentation will bring attendees up to date on the latest integration strategies involving these two fantastic frameworks.

Daniel McGhan is Senior Technical Consultant at Enkitec and an Oracle ACE. He suffers from Compulsive Programming Disorder, which is believed to be linked to his balding. Having started his development career in the land of MySQL and PHP, he was only too happy to have stumbled upon APEX. Since then, he’s dedicated his programming efforts to learning more about Oracle and web based technologies in general.

DBA TRACK: Building Oracle on LXC Linux Containers

Linux Containers are the solution for achieving all the benefits of virtualization that also promise to deliver resources at bare-metal speeds, avoiding the “virtualization penalty” incurred by conventional hypervisor-based solutions. Linux Containers can deliver IO, CPU and network very quickly, while at the same time offering all the benefits of efficient resource usage. This presentation shows how an actual Oracle Real Application Cluster was built on Linux using two Oracle Enterprise Linux 6.5 containers running on a generic Linux platform. The presentation will also cover use of so-called advanced-format storage (4K sector size storage) when building such Oracle systems in Linux Containers.

Gilbert Standen is the East Coast Region Solution Architect, Oracle practice, for Violin Memory, a technology market leader, manufacturer, and designer of all-NAND-flash storage arrays. Gil has worked on numerous low latency Oracle projects in the NYC area, including building the Oracle back-end Oracle RAC database for highspeed trading systems in New York, as well as projects for gas and oil market makers, fixed-income securities, and other financial industry projects.

DEVELOPER TRACK: Oracle Database Table Access for Hadoop Compute Engines (Hive, Impala, Spark)

Hadoop 2 led to a bloom of several Hadoop compute engines including MapReduce v2, Apache Spark, Apache Tez, Apache Storm, Apache Giraph, Cloudera Impala, GraphLab, Splunk Hunk, Microsoft Dryad, SAS HPA/LASR and Oracle Big Data SQL. However, some Hadoop applications (e.g., MDM) need direct access to data in Oracle Database. Oracle Table Access for Hadoop (OT4H) exposes Oracle Database tables as Hadoop data sources. This presentation will describe and demonstrate OT4H and discuss use cases.

Kuassi Mensah is director of product management for Java products and Hadoop products for the Oracle Database. Kuassi holds an MS CS and post-graduate from the Programming Institute of the University of Paris. He is a frequent speaker at Oracle and IT events and maintains a blog at http://db360.blogspot.com, as well as Facebook, LinkedIn, and Twitter (@kmensah)

DBA TRACK: Conflict Detection and Resolution (CDR) with Oracle GoldenGate 12c

Replication of data has become a very tricky area for most system and database administrators in recent years. Starting with Oracle GoldenGate 11g and Oracle’s continued improvement in Oracle GoldenGate 12c, the Conflict Detection and Resolution (CDR) features have simplified the process of handling conflicts. CDR is especially critical when dealing with high transactional replication in an active/active or multi-master environment. This presentation will examine CDR and how this feature not only simplifies the detection and resolution of transaction, but also ensures that replication continues and your business succeeds. The presentation includes a case study grounded in an active/active
setup and a demonstration of what can be done with CDR.

Bobby Curtis is an Oracle ACE, Senior Technical Consultant at Accenture Enkitec Group and member of various Oracle User Groups. He specializes in creating, maintaining and tuning enterprise databases including engineer system platforms (Exadata and Oracle Database Appliance), data integration using Oracle GoldenGate and monitoring with Oracle Enterprise Manager 12c. He is has been a lead author and co-author on various technical books from Apress, published a technical articles in user group publications, and presented at national conferences including Oracle Open World, Collaborate and KSCOPE.

DEVELOPER TRACK: Using Oracle VDBench to Implement IDC AFA Testing Guidelines

Often it is very difficult to find a method to compare multiple all-flash-arrays for use in cloud or other storage initiatives. IDC has provided a detailed set of guidelines for testing AFAs. Utilizing Oracle’s VDBench a set of tests can be created to provide repeatable, easily compared AFA test suites. Utilizing the IDC AFA testing Guidelines and Oracle’s VDBench, a set of easily repeatable and comparable tests can be performed against multiple AFAs to allow for easy comparison for performance, features and utilization. This presentation provides scripts and shows the
methodology to compete a set of IDC guidelines.

Mike Ault has been working with Oracle since 1990. He has published over 24 books, numerous articles, and given dozens of national, international and regional Oracle event presentations. Mike currently works as an Oracle expert for IBM’s STG group.

2014 Winter General Meeting – Presentations