Thursday Jan 30, 2014

Oracle Enterprise Manager Helps Manage Systems for Gaia Mission

The Italian National Institute of Astrophysics (INAF) has selected Oracle to store, analyze and manage scientific data generated from the European Space Agency's Gaia mission. The mission sets out to provide in-depth 3-D mapping of the Milky Way galaxy over the course of the next 5 years. An estimated 1 petabyte of astronomical data (equivalent to 1 million gigabytes) will be collected and stored in Oracle Database with Oracle Enterprise Manager entrusted to manage the system.

The goal of the Gaia mission will give researchers a better understanding into how the Milky Way was formed and how it has evolved over time. According to Roberto Morbidelli, Scientific Operation Manager at INAF, "Our activity within the Gaia mission will provide a huge volume of information, a very precious heritage of astronomical data that will have to be stored for the whole 21st century and beyond. Oracle has demonstrated in other research contexts that it would be the ideal technological partner to manage scientific projects of this kind of size. Thus we are sure that it will be a successful choice for INAF too. Oracle has been selected for its technology’s reliability, scalability, availability and the appropriate technological evolution planned in the next years; also key was the competence showed by Oracle experts in the development of features useful to our research.”

Oracle Enterprise Manager will be deployed to help manage the multiple Oracle Database instances and Oracle Real Application Clusters. Oracle Enterprise Manager will be used to ensure reliable access to Gaia mission data, allowing for numerous third-party applications and systems that control and verify the correct functioning of satellites and astronomical instruments.

“We are proud to offer our technology to the Gaia mission, an international research project that is of both major importance and high ambition,” said Xavier Verhaeghe, Vice President, Technology & Big Data Oracle EMEA. “INAF’s choice is another confirmation of Oracle’s ability to easily manage the extreme challenges involved in processing petabytes of Big Data."

Follow the Gaia Mission on Facebook.
Read the press release.


Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app

Tuesday Jan 28, 2014

Oracle Enterprise Manager at Collaborate 14

Updated March 28, 2014

Below is a complete list of all Enterprise Manager related sessions and activities.  Detailed abstracts are available by going to the Collaborate14 Session Scheduler and providing Title or Session ID in the search box.

You may also be interested in these two related blogs: Focus on Oracle Applications Management at Collaborate and Oracle PartnerNetwork at Collaborate 14.

Monday April 7 - Pre-Conference Day
Title Time Room Session ID Speaker
Workshop: Cloud Odyssey

9:00 AM - 3:00 PM

Level 3 Lido 3003

931

Oracle Team
Workshop: Simplify, Automate, and Enhance Management of E-Business Suite (EBS) Applications

1:00 PM - 4:00 PM

Level 1 Sands 101

15526

Ken Baxter & Angelo Rosado - Oracle (with Apps Associates)

Workshop: Database Lifecycle Management

9:00 AM - Noon

Level 1 Murano 3203

936
Michael Smith & Hari Srinivasan - Oracle
Title Time Room Session ID Speaker

Tuesday April 8 - Day One
Oracle NoSQL Database 3.0 release feature review

10:15 AM - 11:15 AM

Level 3 Murano 3203

478

Robert Greene - Oracle

Expert Session: Making Sense of the Stereo Instructions. A Walk Through of Setting Up Metrics and Monitoring in Enterprise Manager

10:15 AM - 12:30 PM

Level 3 Lido 3105

980

David Start - Johnson Controls

Quicktip: Data Guard and Oracle Database Server 12c

12:45 PM - 1:15 PM

Level 3 Lido 3103

366

Edward Whalen - Performance Tuning

Quicktip: Fundamental Administration and Management Concepts for WebLogic Server

12:45 PM - 1:15 PM

Level 3 Murano 3206

245

Abhay Kumar - Application Software Technology

Quicktip: High Availability for Oracle Database as a Service (DBaaS) on VMware

12:45 PM - 1:15 PM

Level 3 Lido 3101b

735

Nathan Owen - Blue Medora

Quicktip: Use Cloud Control 12c Corrective Action to be Proactive

12:45 PM - 1:15 PM

Level 3 Lido 3105

127

Javier Ruiz - Database Administration Services

PeopleSoft Application and System Monitoring Basics

1:45 PM - 2:45 PM

Level 4 Marcello 4401A

101140

Raj Garrepally - Georgia Health Sciences Univ

Expert Session: The Best Oracle Database 12c New Features

1:45 PM - 4:00 PM

Level 3 Lido 3005

725

Rich Niemiec - ROLTA

Exadata 101 – What You Need to Know

4:15 PM - 5:15 PM

Level 3 San Polo 3403

733

Rich Niemiec - ROLTA

Oracle Enterprise Manager Cloud Control 12c - Top 10 Features for DBAs

4:15 PM - 5:15 PM

Level 3 Lido 3105

582

Leighton Nelson - Mercy

Deep Dive into ASH and AWR

5:30 PM - 6:30 PM

Level 3 Lido 3003

434

Kellyn Pot'Vin - Oracle

Managing Database Cloud with Oracle Enterprise Manager 12c Snap Clone and Oracle ZFS Storage Appliance

5:30 PM - 6:30 PM

Level 3 Lido 3105

497

Wendy Chen - Oracle

Delivering Self-service Cloud Application Services Based Using Enterprise Manager 12c

5:30 PM - 6:30 PM

Level 3 Lido 3101B

393

Kai Yu - Dell

Welcome Reception

Enterprise Manager Demos:

  • Total Control for Private Cloud (Technology Area)
  • Total Control for Oracle Applications (Applications Area)

6:30 PM - 8:30 PM

Exhibit Hall - Oracle Demogrounds


Oracle Enterprise Manager Team

Title Time Room Session ID Speaker

Wednesday April 9 - Day Two
DBA 101 : Calling all New Database Administrators

8:30 AM - 9:30 AM

Level 3 Lido 3005

574

Gustavo Antunez - Pythian

Oracle Enterprise Manager 12c High Availability – Lessons Learned

8:30 AM - 9:30 AM

Level 3 Lido 3105

438

Eric Siglin - Smartdog

Enterprise Manager Demos:

  • Total Control for Private Cloud (Technology Area)
  • Total Control for Oracle Applications (Applications Area)

10:45 AM - 4:00 PM

Exhibit Hall - Oracle Demogrounds


Oracle Enterprise Manager Team

Automatic Diagnostic Repository -- Best Practices

11:00 AM - Noon

Level 3 Lido 3005

2266

Michael Nelson - Northrup Grumman

Oracle Enterprise Manager 12c: Design, Install, Configure and Manage

11:00 AM - Noon

Level 3 Lido 3105

884

Tom Reddy - Database Administration, Inc.

Oracle EM FeatureTalk #1

12:15 PM - 12:45 PM

Level 3 Lido 3105

914

IOUG EM SIG

Mastering Enterprise Manager 12c

2:00 PM - 3:00 PM

Level 3 Lido 3105

408

Kellyn Pot'Vin - Oracle

Ensure HA in Database Cloud with Oracle Database 12c:What to do and how to do it

2:00 PM - 3:00 PM

Level 3 Lido 3101B

398

Kai Yu - Dell

Enterprise Manager Extensibility

4:30 PM - 5:30 PM

Level 3 Lido 3105

112

Ray Smith - Portland General Electric (PGE)

DBaaS- Database as a Service in a DBAs World

4:30 PM - 5:30 PM

Level 3 Lido 3101B

428

Kellyn Pot'Vin - Oracle

Validate extended distance DR workloads for RAC and DataGuard using Real Application Testing and virtualization at little to no cost

4:30 PM - 5:30 PM

Level 3 Lido 3001A

883

Marlin McNeil - Yucca Group

Happy Hour

Enterprise Manager Demos:

  • Total Control for Private Cloud (Technology Area)
  • Total Control for Oracle Applications (Applications Area)

5:30 PM - 7:00 PM

Exhibit Hall - Oracle Demogrounds


Oracle Enterprise Manager Team

Title Time Room Session ID Speaker

Thursday April 10 - Day Three
Performance visualizations – One picture worth 1000 words

8:30 AM - 9:30 AM

Level 3 Lido 3003

2159

Amihay Gonen - Dell

Oracle12c New Features for DBA's

8:30 AM - 9:30 AM

Level 3 Lido 3103

150

Dan Hotka - Independent

Diagnosing and Tuning Enterprise Manager

8:30 AM - 9:30 AM

Level 3 Lido 3105

293

Courtney Llamas - Oracle

Tuning Oracle Using 12c Cloud Control

8:30 AM - 9:30 AM

Level 3 Lido 3101B

756

Rich Niemiec - ROLTA

Automatic Diagnostic Repository (ADR) - The new tool; how can it help you troubleshoot your databases

8:30 AM - 9:30 AM

Level 3 Lido 3001A

485

Michael Nelson - Northrup Grumman

Migrating From Applications Unlimited (E-Business Suite, PeopleSoft, Siebel) to Fusion Applications

8:30 AM - 9:30 AM

Level 1 Casanova 605

15254

Anish Desai - Oracle

Taming the AWR Tsunami

9:45 AM - 10:45 AM

Level 3 Lido 3003

667

Roger Cornejo - GlaxoSmithKline

Learn what it takes to manage the Oracle 12c Database in the Cloud

9:45 AM - 10:45 AM

Level 3 Lido 3101B

881

Natik Ameen - VitalSoftTech

Python and EMCLI; The Enterprise Management Super Tools

9:45 AM - 10:45 AM

Level 3 Lido 3105

227

Seth Miller - Collier IT

Enterprise Manager Demos:

  • Total Control for Private Cloud (Technology Area)
  • Total Control for Oracle Applications (Applications Area)

10:45 AM - 3:00 PM

Exhibit Hall - Oracle Demogrounds


Oracle Enterprise Manager Team

What changed the SQL Performance? A Structured Approach to Understanding and Identifying the Root Cause

11:00 AM - Noon

Level 3 Lido 3005

945

Tony Jambu - Wizard Consulting

Cloud SIG: Understanding Cloud and DBaaS Strategies, Best Practices, Skill Sets

11:00 AM - Noon

Level 3 Lido 3101B

713

George Trujillo, Kai Yu, Charles Kim, Ron Batra

Quicktip: Calculating OS CPU Utilization From V$ Views, AWR, and Statspack

12:15 PM - 12:45 PM

Level 3 Lido 3003

982

Craig Shallahamer - OraPub

Quicktip: How many ways can I monitor Oracle Golden Gate?

12:15 PM - 12:45 PM

Level 3 Lido 3001A

203

Bobby Curtis - Enkitec

Oracle EM FeatureTalk #2

12:15 PM - 12:45 PM

Level 3 Lido 3105

699

IOUG EM SIG

Extending Oracle Enterprise Manager 12c Features/Functionality: Oracle Application Express

1:00 PM - 2:00 PM

Level 3 Lido 3105

877

Todd Bellaver - Secure-24

SIG Meeting: OAUG Enterprise Manager Informational Session/SIG Formation

3:00 PM - 4:00 PM

Level 1 Marco Polo 703

15368

James Lui - Aramark

Mining the AWR Repository to Find Unreported Performance Problems

4:15 PM - 5:15 PM

Level 3 Lido 3005

373

Wayne Sharp - Union Gas

Oracle E-Business Suite Plug-In for Enterprise Manager – Features and Roadmap

4:15 PM - 5:15 PM

Level 1 Sands 309

15260

Angelo Rosado - Oracle

IOUG Enterprise Manager SIG "Birds of a Feather" Happy Hour Reception

5:00 PM - 6:00 PM

Level 3 Toscana 3701


612


IOUG EM SIG


Title Time Room Session ID Speaker

Friday April 11 - Day Four (Final Day)
Capacity Planning: How to Leverage OEM12c for Engineered Systems

8:30 AM - 9:30 AM

Level 3 Lido 3105

102

Maaz Anjum - BIAS

Oracle Enterprise Manager 12c, Oracle Database 12c, and You!

9:45 AM - 10:45 AM

Level 3 Lido 3103

200

Bobby Curtis - Enkitec

Using the Oracle Database Diagnostic and Tuning Packs through OEM 12c

9:45 AM - 10:45 AM

Level 3 Lido 3105

440

Eric Siglin - Smartdog

Saving Time and Improving Agility Using OEM to Build, Manage and Report on Your Private Cloud

9:45 AM - 10:45 AM

Level 3 Lido 3101B

563

Erik Benner - BIAS

Oracle Exadata Management Deep Dive with Oracle Enterprise Manager 12c

11:00 AM - Noon

Level 3 Lido 3105

833

Ashish Agrawal - Oracle

Database Provisioning in OEM12c: Provision me a Database Now!

12:15 PM - 1:15 PM

Level 3 Lido 3105

602

Maaz Anjum - BIAS

Monday Jan 27, 2014

IOUG Oracle EM SIG Techcast: Managing Oracle Enterprise Manager 12c with Oracle Clusterware


The Oracle Enterprise Manager Special Interest Group (SIG) is a growing body of IOUG members who manage or are interested in all aspects of Oracle Enterprise Manager. This IOUG SIG is managed by volunteers and supported by Oracle Enterprise Manager product managers and developers. The purpose of the SIG is to bring relevant information and education through webcasts, discussions and networking to users interested in learning more about the product, and to share user experiences.

On January 28th at 10 AM pacific time, Oracle Enterprise Manager SIG is hosting a webcast on "Managing Oracle Enterprise Manager Cloud Control 12c with Oracle Clusterware". In this webcast, Leighton Nelson, Associate Principal Database Administrator/Oracle ACE will discusss the steps required to configure virtual host names and create an Oracle Clusterware resource for Oracle Enterprise Manager to provide seamless failover and improved high availability levels.


Register Now !

Stay Connected:

Twitter |  Face book |  You Tube |  Linked in |  Google+ Newsletter

Wednesday Jan 15, 2014

Oracle Enterprise Manager Snap Clone Webcast Replay and Slides

Thank you to all who attended our webcast on Enterprise Manager 12c Snap Clone last month. In this webcast, we talked about how EM12c Snap Clone can help:

  • Leverage storage copy-on-write technologies for rapid provisioning
  • Integrate cloning with other Oracle Enterprise Manager 12c Lifecycle Management features, such as data masking and sub-setting
  • “Time travel” across multiple database snapshots to restore and access past data
  • Reduced administrative overhead from integrated lifecycle management

 For those who missed this webcast, the replay is available here and the slides have been uploaded to slideshare.

Feel free to reach out to us if you have any questions on Snap Clone or Database as a Service.

- Adeesh Fulay (@adeeshf)


Tuesday Jan 07, 2014

Create a Database Instance without DB Control Schema

When using Database Configuration Assistant (DBCA) to create a database instance to house the repository of Enterprise Manager Cloud Control, people often end up with an instance containing DB Control schema, and they have to remove the schema from the instance before installing EM12c. To create an instance without DB Control or SYSMAN schema in the first place, make the following selections in the DBCA database creation process.


1. In the Database Template step, select the Custom Database option.



2. In the Management Options step, uncheck the Configure Enterprise Manager option.



Note: If DBCA locates an agent installation on the host, it will provide an option to register the database instance that you are creating with the corresponding Management Service. If you choose that option, DBCA will add the database instance to the Enterprise Manager site as a managed target upon completion of instance creation. This option, however, does not create SYSMAN schema in the database instance.



3. In the Database Content step, uncheck the Enterprise Manager Repository option.


Remember to make the above-mentioned selections, and you will have an instance without DB Control, which is fit for housing an EM repository.



Note: From EM12c Release 2, there is an option to create an 11.2.0.3 database instance with a pre-configured EM repository. For instructions see:

Creating a Database Instance with Preconfigured Repository Using Database Templates

Installing Oracle Database and Creating a Database


Thursday Jan 02, 2014

What is EM 12c DBaaS Snap Clone?

Happy New Year to all! Being the first blog post of the new year, lets look at a relatively new feature in EM that has gained significant popularity over the last year - EM 12c DBaaS Snap Clone.

The ‘Oracle Cloud Management Pack for Oracle Database’ a.k.a the Database as a Service (DBaaS) feature in EM 12c has grown tremendously since its release two years ago.  It started with basic single instance and RAC database provisioning, a technical service catalog, an out of box self service portal, metering and chargeback, etc. But since then we have added provisioning of schemas and pluggable databases, full clones using RMAN backups, and Snap Clone. This video showcases the various EM12c DBaaS features.

This blog will cover one of the most exciting and popular features – Snap Clone. In one line, Snap Clone is a self service way of creating rapid and space efficient clones of large (~TB) databases.

Self Service - empowers the end users (developers, testers, data analysts, etc) to get access to database clones whenever they need it.
Rapid - implies the time it takes to clone the database. This is in minutes and not hours, days, or weeks.
Space Efficient - represents the significant reduction in storage (>90%) required for cloning databases

Customer Scenario

To best explain the benefits of Snap Clone, let’s look at a Banking customer scenario:

  • 5 production databases total 30 TB of storage
  • All 5 production databases have a standby
  • Clones of the production database are required for data analysis and reporting
  • 6 total clones across different teams every quarter
  • For security reasons, sensitive data has to be masked prior to cloning

Based on the above scenario, the storage required, if using traditional cloning techniques, can be calculated as follows:

5 Prod DB                  = 30 TB
5 Standby DB            = 30 TB
5 Masked DB             = 30 TB (These will be used for creating clones)
6 Clones (6 * 30 TB) = 180 TB
                               ------------------
Total                           = 270 TB
Time = days to weeks

As the numbers indicate, this is quite horrible. Not only 30 TB turn into 270 TB, creating 6 clones of all production databases would take forever. In addition to this, there are other issues with data cloning like:

  • Lack of automation. Scripts are good but often not a long term solution.
  • Traditional cloning techniques are slow while, existing storage vendor solutions are DBA unfriendly
  • Data explosion often outpaces storage capacity and hurts ITs ability to provide clones for dev and testing
  • Archaic processes that require multiple users to share a single clone, or only supports fixed refresh cycles
  • Different priorities between DBAs and Storage admins

Snap Clone to the Rescue

All of the above issues lead to slow turnaround times, and users have to wait for days and weeks to get access to their databases. Basically, we end up with competing priorities and requirements, where the user demands self service access, rapid cloning, and the ability to revert data changes, while IT demands standardization, better control, reduction in storage and administrative overhead, better visibility into the database stack, etc.

EM 12c DBaaS Snap Clone tries to address all these issues. It provides:

  • Rapid and space efficient cloning of databases by leveraging storage copy-on-write (or similar) technology
  • Supports all database versions from 10g to 12c
  • Supports various storage vendors and configurations NAS and SAN
  • Lineage and association tracking between clone master and its various clones and snapshots
  • 'Time Travel' capability to restore and access past data
  • Deep visibility into storage, OS, and database layer for easy triage of performance and configuration issues
  • Simplified access for end user via out-of-the-box self service portal
  • RESTful APIs to integrate with custom portals and third party products
  • Ability to meter and charge back on the clone databases

So how does Snap Clone work?

The secret sauce lies in the Storage Management Framework (SMF) plug-in. This plug-in sits between the storage system and the DBA, and provides the much needed layer of abstraction required to shield DBAs and users from the nuances of the different storage systems. At the storage level, Snap Clone makes use of storage copy-on-write (or similar) technology. There are two options in terms of using and interacting with storage:

1. Direct connection to storage: Here storage admins can register NetApp and ZFS storage appliance with EM, and then EM directly connects to the storage appliance and performs all required snapshot and clone operations. This approach requires you to license the relevant options on the storage appliance, but is the easiest and the most efficient and fault tolerant approach.

2. Connection to storage via ZFS file system: This is a storage vendor agnostic solution and can be used by any customer. Here instead of connecting to storage, the storage admin mounts the volumes to a Solaris server and format it with ZFS file system. Now all snapshot and clone operations required on the storage are conducted via ZFS file system,. The good thing about this approach is that it does not require thin cloning options to be licensed on the storage since ZFS file system provides these capabilities.

For more details on how to setup and use Snap Clone, refer to a previous blog post.

Now, lets go back to our Banking customer scenario and see how Snap Clone helped then reduce their storage cost and time to clone.

5 Prod DB                      = 30 TB
5 Standby DB                 = 30 TB
5 Masked DB                 = 30 TB
6 Clones (6 * 30 TB)      = 180 TB
6 Clones (6 * 5 * 2 GB) = 60 GB
                                   ------------------
Total                               = 270 TB 90 TB
Time = days to weeks minutes

Assuming the clone databases will have minimal writes, we allocate about 2GB of write space per clone. For 5 production databases and 6 clones, this totals to just 60GB in required storage space. This is a whopping 99.97% savings in storage. Plus, these clones are created in matter of minutes and not the usual days or weeks. The product has out-of-the-box charts that show the storage savings across all storage devices and cloned databases. See the screenshot below.

Snap Clone Savings

Where can you use Snap Clone databases?

As i said earlier, Snap Clone is most effective when cloning large databases  (~TBs). Common scenarios we see our customers best use Snap Clone are:

  • Application upgrade testing. For example, EBusiness suite upgrade to R12.
  • Functional testing. For example, testing using production datasets.
  • Agile development. For example, run parallel development sprints by giving each sprint its own cloned database.
  • Data Analysis and Reporting. For example, stock market analysis at the close of market everyday.

Its obvious that Snap Clone has a strong affinity to applications, since its application data that you want to clone and use. Hence it is important to add that the Snap Clone feature when combined with EM12c middleware-as-a-service (MWaaS) can provide a complete end-to-end self service application deployment experience. If you have existing portals or need to integrate Snap Clone with existing processes, then use our RESTful APIs for easy integration with third party systems.

In summary, Snap Clone is a new and exciting way of dealing with data cloning challenges. It shields DBAs from the nuances of different storage systems, while allowing end users to request and use clones in a rapid and self service fashion. All of this while saving storage costs. So try this feature out today, and your development and test teams will thank you forever.

In subsequent blog posts, we will look at some popular deployment models used with Snap Clone.

-- Adeesh Fulay (@adeeshf)

Additional References

Cloud Management Page on OTN

Cloud Administration Guide (Documentation)

Enterprise Manager 12c Database-as-a-Service Snap Clone Overview (Presentation)

About

Latest information and perspectives on Oracle Enterprise Manager.

Related Blogs




Search

Archives
« January 2014 »
SunMonTueWedThuFriSat
   
1
3
4
5
6
8
9
10
11
12
13
14
16
17
18
19
20
21
22
23
24
25
26
29
31
 
       
Today