Date

Avoiding Downtime with Oracle's Maximum Availability Architecture (Complimentary for IOUG Registrants Only)

This real world session with Oracle experts Joe Meeks and Larry Carpenter is loaded with practical knowledge for implementing a highly available Oracle Database environment. With a combined 60 years of experience, Joe and Larry appreciate that one size doesn't fit all, and will walk you through a progression of high availability and disaster recovery (HA/DR) architectures and Maximum Availability Architecture (MAA) best practices that address the complete range of data protection and availability service level requirements. Starting from a single instance database, we take the mystery out of building an HA system by showing how to incorporate all components of a complete MAA architecture with minimal disruption to your production environment. The session also demonstrates how to automatically failover application connections whether due to a Real Application Cluster node eviction or a Data Guard failover affecting the entire database. You will also learn how to uti!
lize the
same MAA infrastructure used to prevent unplanned outages to minimize or eliminate downtime for planned maintenance. Finally, because no organization can afford the luxury of idle systems you will also learn how to take the notion of 'standby' out of standby databases and gain insight into new HA capabilities available with the lastest release of Oracle Database. Joe and Larry's experiences working with Oracle customers will be shared at every step along the way to bring real-life context to the subjects covered, including customer's successes, failures, and insight that can only be learned by having done it.

Implementing Oracle E-Business Suite R12.1.2 on EXADATA

Velcro has recently implemented Oracle EXADATA at its worldwide locations. The presentation covers on best practices and shares experience on migrating Oracle E-Business Suite to Oracle Exadata Database Machine. It focuses on the tools and techniques that were used in this implementation, challenges and key issues faced, give guidance and set a framework that could be followed by implementers, project managers, and senior management team.

Oracle Cluster 11GR2 with Oracle Applications

Oracle Real Application cluster evolves with each release. There are some important features added in Oracle 11GR2. During this presentation the authors will share their practical experience on how to configure EBS to use SCAN Listeners, services and load balance different EBS components across cluster nodes. We will talk through different configuration strategies and how to choose the right one. Come to the presentation and take away practical hints on how to make EBS and RAC 11GR2 best friends.

Oracle Roadmap: Oracle's Engineered Systems Strategy for Optimizing Software Performance

Why should Oracle software users care about Oracle's new engineered systems? Why is Oracle Exadata Database Machine, the first Oracle engineered system, the fastest growing product in Oracle history with thousands of installations that span every industry and geography? This talk will explain how Oracle's engineered systems have evolved naturally from the company's strategy for optimizing software performance, reliability, and business value. It will explain the rapidly expanding family of Oracle engineered systems, their unique architectural and business advantages and why every Oracle customer needs to understand what engineered systems means to future of IT.

RAC Attack! (Complimentary for IOUG Attendees Only)

The IOUG and the RAC SIG are co-hosting a hands-on lab called IOUG RAC Attack! This hands-on lab, taking place on Monday and Tuesday, will focus on cluster installation prerequisites on Linux, installing Oracle clusterware, installing Oracle RDBMS, creating RAC databases (for beginners), failure testing and backup/recovery test.

Running E-Business Suite Database on Oracle Database Appliance

ODA is a pre-configured, simple setup, high performance engineered system running 11gR2 cluster. It is a great choice for small to medium sized DBs and if you wish it can be used for Oracle EBS DB too. This paper will show you how the standardized configuration of ODA can be adjusted to comply with the specific requirements of e-Business Suite without sacrificing ODA’s flexibility and supportability. The paper will also share author’s experience migrating, running and maintaining R12 database tier on ODA.

Migrate to Exadata - Our Detailed Journey and Lessons Learned

As a database machine, there's a lot of excitement surrounding Exadata. Rightfully so, Exadata leverages next-generation technologies to deliver significant improvements in response times with dramatic reduction in costs. Interested in successfully deploying Exadata, please join us in our session as we will share with you our journey in migrating Oracle databases from a non-Exadata environment to an Exadata platform. We will also share with you lessons learned including challenges that we had to overcome.

Engineered Systems Curriculum: A Pragmatic Approach to Integrating Exadata rapidly into your Enterprise

Viscosity North America

Time to value is an important consideration when purchasing an Exadata. So should it be when integrating it into your enterprise.

While the urge to intricately plan and prepare a warehouse ecosystem worthy of this dream platform, management's need to maintain its competitive edge and for fast return on investment required a more expedient and pragmatic approach to integration.

In this presentation we share the quick wins and low hanging fruit to making a successful Exadata integration with your enterprise. Shortening time to value for new integration development to just a couple of months.

Starting with flat files and data exports, direct connections to heterogeneous databases, moving to xml and integrations with the enterprise service bus, and integration strategies for Big Data, we discuss how we implemented a solid and performant multi-threaded ETL layer, management layer, and presentation layer for an Enterprise Data Warehouse using the tools available on the Exadata.

Finally, we close with our lessons learned, including the quick wins to help you integrate Exadata. With attendees we share hard won examples, configuration, and source code from our experience.

Engineered Systems Curriculum: Exadata vs Supercluster: which one to choose?

Verizon Wireless

This presentation emphasizes on key differences and characteristics of exadata and Supercluster. While both the products are very good option for reporting database there is lot confusion when it comes to choose among them. This presentation will not only help understand both the products but also aids in decision making process when it comes to buy one of them.

Engineered Systems Curriculum: Exadata Distinctives

This lecture introduces features of Exadata that help improve the performance of Oracle applications and aren't available in normal Oracle database servers. It describes the flow of data from the blocks on the disk to the end user in Exadata and non-Exadata systems. Also, it shows how to use the new Exadata features and how to turn them off. This is based on our experiences with Exadata supporting custom datawarehouse apps and Oracle Business Intelligence Analytics (OBIA).

Engineered Systems Curriculum: Business Case and Readiness Checklist for Exadata

With the emergence of various Engineered systems like Exadata, Exalogic, Exalytics and Big Data Appliance to name a few, how does a company evaluate the value proposition for their specific needs? This session will take a look at the check list for Exadata readiness, or a systematic evaluation process to determine the fit of Exadata and similar Engineered systems. The business value, ROI as well as technical factors will be used to create the blueprint of the business case for Engineered systems. Experiences from customer case studies will be used in this session.

RAC Attack! (Complimentary for IOUG Attendees Only)

The IOUG and the RAC SIG are co-hosting a hands-on lab called IOUG RAC Attack! This hands-on lab, taking place on Monday and Tuesday, will focus on cluster installation prerequisites on Linux, installing Oracle clusterware, installing Oracle RDBMS, creating RAC databases (for beginners), failure testing and backup/recovery test.

Engineered Systems Curriculum: An Exadata POC

Simplify and Virtualize your JD Edwards deployments with Exalogic and Exadata

Oracle Corporation

Oracle's product portfolio spans Oracle Database and enterprise applications, middleware, operating systems, virtualization, servers, and storage—a true applications-to-disk stack. Oracle's unique position enables it to engineer completely integrated and optimized solutions—an opportunity Oracle is capitalizing on to benefit its JD Edwards EnterpriseOne customers with Exalogic and Exadata engineered systems. Session will cover recently released Oracle VM templates for Exalogic to ease provisioning of dev, test and production JD Edwards environments. This session also includes performance measurements of running JD Edwards EnterpriseOne on a complete Oracle stack, Oracle Exadata, and Oracle Exalogic.

Engineered Systems Curriculum: Databases in a solid state world: how Exadata X3 and other database systems leverage the performance of flash

The drastic price drops in solid state storage have opened new avenues to maximize database performance. Even very large databases can put their entire active data sets on solid state storage, relegating rotating storage to archival roles. Exadata X3 demonstrates how terabytes of solid state storage can be obtained for the same cost as smaller predecessor systems.

Learn about solid state storage's unique attributes, and which applications can benefit most. Discover how solid state storage's low latency is changing physical database design. Compare Exadata X3 with competing technologies, and cut through the marketing hyperbole to see what the systems are truly capable of.

Engineered Systems Curriculum: Oracle Database Appliance - RAC in a box Some strings Attached

Walgreens Company

Oracle Database Appliance is an engineered system that is geared towards Small and Medium businesses but has all the bells and whistles for enterprise deployments. This talk will focus on Oracle Database Appliance deployment as a consolidation platform as well as as a development platform for rapidly deploying databases. We will talk about the Deployment process , the patching process and the best practices built into The Oracle Database Appliance. We will also talk about the DBA's role for managing the ODA as well as security considerations.

Oracle 11g R2 has revolutionized the way we think about database storage technology. Automatic Storage Management is no longer just an alternative for Real Application Clusters, but is now used for general database implementations. The next generation of ASM now gives system and database administrators alternatives to storage solutions that were unavailable until now. The newly introduced ASM cluster file system and a rich set of available tools make ASM an exciting alternative for database storage. This session will go over the new grid architecture and take the participant through several examples of how to set up and use ASM. The targeted audience is for any IT professional wanting more information about the next generation of ASM.
Abstract
The presentation will start with an overview of ASM and a review of previous versions. Oracle has made enhancements with each version including new tools and the introduction of the ASM cluster file system.
ASM has made several fundamental changes with the installation and architecture. These important changes will be covered including what is involved in the installation process.
A new set of tools has been introduced and enhanced to support ASM. The ASM configuration assistant or ASMCA is a new application used for creating and administering ASM instances. Oracle has added functionality to the command line ASMCMD and turned it into a powerful tool. Examples using both tools will be covered in detail including new options available in OEM.
The grid architecture will be covered to include Oracle Restart and Real Application Clustering.
The new acfs or ASM cluster file system will be covered in detail. The steps involved in setting up and maintaining acfs will be covered to include step by step examples.
The challenges of upgrading previous versions of ASM, migrating databases to ASM, and backup recovery scenarios will also be examined.
A new set of permission alternatives have been introduced including the new SYSASM role.
In conclusion, a philosophical look at the advantages to migrating to an ASM instance will be covered.

Oracle Database Appliance Customer Panel

RAC Attack! (Complimentary for IOUG Attendees Only)

The IOUG and the RAC SIG are co-hosting a hands-on lab called IOUG RAC Attack! This hands-on lab, taking place on Monday and Tuesday, will focus on cluster installation prerequisites on Linux, installing Oracle clusterware, installing Oracle RDBMS, creating RAC databases (for beginners), failure testing and backup/recovery test.

Efficiently Scaling Oracle E-Business Suite on Oracle Exadata and Oracle Exalogic

Oracle Exadata and Oracle Exalogic are designed from the ground up with optimizations in software and hardware to deliver fast performance for mission-critical applications such as Oracle E-Business Suite. Oracle E-Business Suite applications run three to eight times as fast on the Oracle Exadata/Oracle Exalogic platform in standard benchmark tests. Besides performance, customers benefit from simplified support, enhanced manageability, and the ability to consolidate multiple Oracle E-Business Suite instances.

Engineered Systems Curriculum: Case Study - Oracle Database Appliance

Solid State Disk (SSD) is rapidly becoming a mainstream technology and an almost indispensable ingredient in a high performance Oracle database. While SSD is often too expensive to replace all your database disk, judicial use of SSD in combination with magnetic disk can be a very cost effective way of accelerating Oracle database performance. This presentation will consider how best to use SSD in an Oracle 11g database to get the most bang for your SSD buck. You'll see examples of configuring SSD:
* as part of the database flash cache
* to improve IO for selected tables or partitions
* as part of a temporary tablespace to improve disk sort performance
* to accelerate redo log IO
* inside an Exadata system.

Interactive RAC & Exadata Rapid Fire Interview Q&A Competition

Expert Panelists/Judges::
Tariq Farooq - Oracle ACE Director - CEO, BrainSurface
Rich Niemiec - Oracle ACE Director - CEO, ROLTA TUSC
Sandesh Rao - Director RAC Assurance Team - Oracle
Mike Ault - Oracle ACE & Guru - IBM

An Expert Team of Judges/Panelists will interactively pose Oracle RAC & Exadata rapid fire Job-Interview style questions to see who is the technical guru in the audience! This will be a fast paced exchange of leading Best Practices within the RAC & Exadata realms. The best answers will be selected with points awarded. Our top three winners will be awarded the Oracle RAC & Exadata "Technical Guru" award in addition to prizes! Even if you don't want to compete but, want to rub elbows & learn from some of the best technical leaders within the Oracle RAC & Exadata domains, come join this action-packed fun-filled session!

Engineered Systems Curriculum: Exadata X3: What's New and Where Are We Going

The Oracle Exadata Database Machine is designed to be highly performant and available platform for running the Oracle Database. In this session we will discuss the new X3 Exadata product and other Exadata products enhancements. Topics will include: system and software architecture, deployment strategies, performance, administration, applications, and high availability.

Viscosity North America

When Automatic Storage Management (ASM) was introduced in 10gR1, it was simply marketed as the volume manager for the Oracle database. However, ASM has now grown into becoming an integral part of the enterprise stack. ASM is now not only a significant part of the Oracle Clusterware stack, but is also a core component of engineered systems such as Exadata and ODA. The next generation of the Oracle database was announced in 2012, and along with this release, came significant changes for ASM. This session will cover some of key management and high availability features introduced in the latest versio of ASM. Attendees will get a great glimpse of these advancements, the history behind the new features, and why these features are a necessary part of the future of ASM.

Engineered Systems Curriculum: Exadata 101 -- What You Need to Know

This presentation will teach you the basics of Exadata & other Engineered Systems from a beginner's perspective, with experiences and examples that are intermediate level. It will go over the advantages of using this hardware and how the hardware components provide the speed that you'll realize implementing it.

We will cover the following topics:

* Terminology & the Basics about Exadata (X2-2 & X2-8)
* Flash Cache
* Storage Index
* Smart Scans
* Hybrid Columnar Compression (HCC)
* Enterprise Manager & Grid Control
* Enterprise Manager Exadata Simulation
* I/O Resource Manager (IORM)
* Security
* Utilities
* Exalogic, ODA, Exalytics, SuperCluster, & other Hardware
* Best Practices
* Summary

Big data is a big deal these days. Every CTO read about it and believes that with the right technology it is possible to deliver meaningful business insights from massive amounts of information in real time. And they are correct. However, many IT shops also believe that you need cutting technologies like NoSQL and Hadoop to deliver big data capabilities. While in fact, in many cases these cutting edge technologies are a poor fit for business requirements and increase the risk of the project without delivering value. Why not deliver on big data promise using the familiar Oracle Database, using Exadata?

In this presentation, Oracle ACE Christo Kutrovsky will discuss common big data use cases and how they can be implemented efficiently with Exadata. We will see how Exadata actually delivers most of the benefits touted by newer big data technologies, and can often be the right platform for data scalability

Engineered Systems Curriculum: Database Consolidation on Exadata with Deep Dive into I/O Resource Management

Apps Associates

Why run PeopleSoft on Exalogic and Exadata? Super Fast, Risk Free and Cost Effective

Oracle Corporation

Oracle Exadata and Exalogic are designed from the ground up with optimizations in software and hardware to deliver superfast performance for mission critical PeopleSoft applications. PeopleSoft applications on Exalogic and Exadata outperform other platforms in standard benchmark tests. In addition to performance customers benefit from simplified support, enhanced manageability and ability to consolidate multiple PeopleSoft instances. Learn how Oracle VM templates speed up provisioning PeopelSoft for Exalogic. Session will include a customer's success story and provide insight on Exalogic and Exadata implementation.

Engineered Systems Curriculum: The Perfect Marriage: ZFS Storage Appliance with Exadata

Viscosity North America

Storage requirements are exploding across the Oracle industry, often beyond your control. If you own an Exadata, space is a premium and you want to squeeze every ounce you can. This session will demonstrate how you can couple the ZFS Storage Appliance (ZFSSA) with the Exadata to maximize your space utilization by tiering storage on the Exadata and ZFSSA. In addition, this session will demonstrate how to archive data to the ZFSSA.

Attendees will get an in-depth insight into optimal RMAN backup strategies, direct NFS settings, and scripts used to drive throughput on the ZFSSA across all the compute nodes. Come hear the power of implementing snapshots and clones to provision databases on the fly, and replication to achieve another level of protection.

Other industry use cases for the ZFSSA will be revealed.

Build a RAC Database for Free with VirtualBox - A Step by Step Guide

This presentation will walk attendees step by step through the process of building a RAC environment for free.

Oracle's Real Application Clusters (RAC) and Grid Infrastructure are technologies that provide organizations with high availability for their Oracle database environments. For many Oracle professionals however, it can be challenging to learn RAC - while proactive DBAs can easily download and use any of Oracle's products for learning purposes, having access to or creating a RAC environment can be a serious limitation for many. In this presentation, I'll show you, step-by-step, how I created a RAC environment using nothing but tools freely available via the Internet.

Real-World Exalytics/Exadata Benchmarking -- A Northeast Utilities Case Study

In 2010, Northeast Utilities (a Connecticut-based Electric and Gas utility with over 2 million customers) embarked on an ambitious BIDW initiative to integrate data across its Meter Operations business unit. The resulting Oracle data warehouse combined with a 50+ dashboard OBIEE application proved successful and is heavily-used today.

But with large data volumes (and more coming every day) and heavy user load, performance of the application is a primary concern. While tuning can and has mitigated some of these issues, NU realized that a long-term solution might be necessary.

In this session, we will present the results of a real-world migration of a complex 10g OBIEE/11g database application into Oracle Exalytics and Exadata as well as combinations of the two technologies. Presenting both the highlights of the migration process as well as the before/after benchmarks, this session will highlight the performance benefits of Oracle's newest BI and database machines.

Database Administration, Inc.

Large RAC Clusters are complex to design and install. But once they are setup, ongoing management of large RAC Clusters can be an even more daunting task. This presentation will focus on managing large RAC clusters with tips and techniques used in the real world. A combination of Oracle Enterprise Manager, custom OS scripts and other third-party tools will be discussed as potential solutions.

What's New in the Latest Generation of Oracle Real Application Clusters (Oracle RAC)

Are you getting the best out of your systems based on Oracle Real Application Clusters (Oracle RAC) and Oracle Database's Grid Infrastructure feature? Wait until you've seen the latest generation of Oracle RAC and Oracle Database technology. Using Grid Infrastructure as a sound foundation, the latest generation of Oracle RAC extends beyond the boundaries of a traditional cluster and database environment. Enhancements not only on the storage and database level but also in application-facing layers make the new Oracle RAC a never-seen-before end-to-end solution as well as the ideal foundation for your database cloud. Learn more in this session.

How to minimize the brownout, due to RAC reconfiguration.

Engineered Systems Curriculum: 500+ Million Records Per Day Replicated to Exadata using GoldenGate.

In this Case Study, the over design of using GoldenGate (GG) to consolidate several databases (Oracle and SqlServer) into a single database running on Exadata X2-2 is dicussed. Beacuse of the large volume of transactions being replicated, significant GG tuning, Database configuration and system configuration were required. For added, sensitive data in the database require encryption, use of database compression, Oracle RAC on source and target adds to the complexity of the configuration.

Virtualized Oracle Stretched RAC Cluster using VMware vSphere and EMC VPLEX

This presentation will present a solution for creating a virtualized stretched RAC cluster. This cluster will provide much lower latency, improved availability, automated failover, simplified administration, and many other benefits over creating a stretched RAC cluster using conventional means (ASM).

There are three basic layers to this solution and the presentation will be split up accordingly. First, there is the Oracle side, which will be presented by Charles Kim (one of the foremost experts on Oracle). Then will come the virtualization layer, presented by George Trujillo. Finally, will come the storage layer (including the EMC VPLEX, which is the heart of stretched RAC), presented by EMC's Jeff Browning.

In-Database MapReduce: When Hadoop Meets Exadata

Oracle Corporation

There is a growing need to apply MapReduce analytics techniques to business data stored in RDBMS however, shipping data from RDBMS to a Hadoop cluster is generally a bad idea with lot of issues.
How about bringing MapReduce/Hadoop to the RDBMS instead?
There are many initiatives and projects in this area. The next release of Oracle database plans to furnish In-Database MapReduce. This session describes the implementation of a database resident "Hadoop container", built-in the Oracle database RDBMS engine, which lets you drop-in and run Hadoop Mappers and Reducers directly against RDBMS tables. The major benefits of this implementation are: source compatibility with Hadoop, minimal dependency on Hadoop infrastructure, Java and SQL interfaces.
The seamless integration of Hadoop MapReduce steps in SQL statements and OLTP, ease of development,
deployment and administration (any DBA can deploy MapReduce/Hadop jobs).
Furthermore MapReduce and Hadoop jobs running in the database get all the quality of services of the Oracle RDBMS and Exadata such as enterprise class security, data compression, and many more.

Near Zero Downtime Oracle RAC Migration with Oracle Automatic Storage Management and Oracle Enterprise Manager 12c

Performing a seamless migration to move Oracle Database to new hardware platforms and new operating systems can be challenging. This session shares Dell's experience in a recent Oracle Database migration project to move Oracle Real Application Clusters (RAC) databases to new storage systems, new servers, and new operating systems running on the database servers. It provides best-practice migration methodologies for moving Oracle RAC databases into a new infrastructure with near zero downtime impact on the database availability. Key technologies involved in the migration included Oracle Automatic Storage Management disk rebalance and Oracle Enterprise Manager 12c.

Engineered Systems Curriculum: Oracle Advanced Compression - An Insight into Space Realization on Exadata and ODA

BIAS Corporation

The goal of any IT shop is to maximize their current investments and with sound tuning methodologies for Oracle Advanced Compression, customers can make their storage solution more efficient. During a customer proof of concept supporting the compression of a 7TB database and an Oracle Database Appliance (ODA), the observations include intriguing results. These results include differing compression ratios based on the composition of the Oracle tables. These ratios support different approaches to advanced compression for sizing and performance considerations. In this session, you will view comparative analysis between different compression settings and table structures within an Oracle 11gR2 on an ODA as well as an Exadata Database Machine and ZFS.

From Big Data to Exadata: The Best of Both Worlds for Business Analytics

Viscosity North America

A case study to provide quick wins in rolling out Big Data and Exadata for Analytics in your Enterprise.

As organizations embrace Big Data for analytics, it is very clear that Hadoop and Relational Database are the requiring technology for solving most deep analytic problems and enterprise reporting requirements. This presentation will present a detail overview and perspective of implementing Hadoop with Exadata by starting with collecting the key business requirements and problems, indentifying Hadoop's business capabilities and technical infrastructure requirements, evaluating Exadata's performance and Relational Database analytics, evaluating the NoSQL analytical use cases, and ends with the implementation experience of the technology. In addition, this presentation will discuss the architecture of the analytic models and data integration process to best leverage Hadoop and Relational Databases ecosystem.

An Exploration of the Next Generation of the Oracle Database

Zero Defect Computing, Inc.

Join Jim Czuprynski as he gives his take on the 13 most important new features that the next generation of the Oracle database presents for Oracle Database Administrators and Exadata Database Machine Administrators. In these two 1-hour sessions, he'll focus on the latest features that make complex database and DBM administration tasks simpler, increase database response time and throughput, and offer laser-like precision to identify opportunities for overall performance tuning opportunities.