Friday Feb 27, 2015

Oracle Private Database Cloud REST APIs

While we spend a lot of time developing GUI for our private cloud features – like the self service portal, setup screens, etc, a large percentage of our customers use these features via our APIs, both EMCLI and REST based.

Q: So why would anyone not use the out of the box cloud (self service) portal and use the APIs instead?

A: Well, there are many reasons:

  1. You already have a custom cloud portal that you use to deploy non-Oracle products and now you would like Oracle products to be part of it
  2. You want cloud related actions to be part of a larger orchestration flow. For example, prior to provisioning, you want to integrate an approval workflow, and then post-provision update your asset management system with the service details.
  3. You want to integrate the cloud actions with our IT service desk or ticketing systems
  4. Integrate actions like cloning of databases (Snap Clone), or provisioning of middleware and applications with your continuous integration or devops process.

Read More

Oracle Enterprise Manager at Collaborate15

April 12-16, 2015  •  Mandalay Bay Resort & Casino, Las Vegas  •  #C15LV

Since the release of Oracle Enterprise Manager 12c, the user community has responded to the significant increased adoption of this popular product by featuring deep-dive sessions and labs in various user conferences spread all over the globe. Nowhere is this more evident than at Collaborate, a very popular user conference being held this year in Las Vegas and comprised of the respected IOUG, OAUG and Quest User Groups.  Collaborate15 has almost 50 sessions devoted to Enterprise Manager topics ranging from Private Cloud Management, Oracle technology or “stack” management and Applications Management heavily sprinkled throughout all three groups. Although some of those sessions on new features and “inside baseball” capabilities are being delivered by Oracle folks, the majority are developed and presented by experienced Enterprise Manager customers and partners.

Word is starting to get out. In fact, Kellyn Pot’Vin-Gorman just published an excellent blog, “Everything I Needed to Know about Enterprise Manager I Learned at Collaborate15” which takes you on a highly-descriptive day-by-day journey of all the sessions, hands-on labs, demos and SIG meetings which feature Oracle Enterprise Manager. Oracle has also published a handy guide for Collaborate15 attendees to help build their schedules, called “FocusOn Enterprise Manager at Collaborate15” which is duplicated below for your convenience.

The Oracle Enterprise Manager product group will also have a solid contingent present through-out the conference so please stop by the Oracle Demogrounds area and check out the OEM demo kiosks. See you there!

Sunday April 12 - Pre-Conference Day

Title

Time

Room

ID

Primary Presenter

Hands-on Lab: Everything I Needed to Know About Enterprise Manager I Learned at COLLABORATE

Begins 9:00 AM

Click link for latest info on room

Kellyn Pot'Vin-Gorman, Oracle

Courtney Llamas, Oracle

Werner de Gruyter, Oracle

Expanding Use of Your Enterprise Manager System

3:30 PM – 4:30 PM

South Seas I

10188

Brent Sloterbeek, Gentex

Monday April 13 - Day One

Title

Time

Room

ID

Primary Presenter

Zero to Manageability in One Hour: Build a Solid Foundation for Oracle Enterprise Manager 12c

9:15 AM – 10:15 AM

Banyan B

0

Courtney Llamas, Oracle

Architecting your own DBaaS in a Private Cloud with EM12c

9:15 AM – 10:15 AM

Reef F

556

Gustavo Antunez , Pythian

The Best Oracle Database 12c Tuning Features

10:30 AM – 11:30 AM

Palm B

567

Rich Niemiec, ROLTA

Exadata Exachk and Oracle Enterprise Manager 12c: Keeping up with Exadata

12:00 PM – 12:30 PM

Banyan B

746

Bobby Curtis, Enkitec

Application Management Suite Deep Dive - Patching and Cloning

3:15 PM – 4:15 PM

South Seas I

10479

Ravi Madabhushanam, Apps Associates

The Power of the AWR Warehouse

3:15 PM – 4:15 PM

Banyan B

112

Kellyn Pot'Vin-Gorman, Oracle

Panel: Wait, Before We Get the Project Underway, What Do You Think Database as a Service Is...

3:15 PM – 4:15 PM

Reef F

598

Steve Lemme, Oracle

Erik Benner, Mythics

Seth Miller, Collier IT

Gustavo Antunez, Pythian

The New Tool- Automatic Diagnostic Repository (ADR): How Can It Help You Troubleshoot Your Databases?

3:15 PM – 4:15 PM

Palm C

241

Michael Nelson, Northrop-Grumman

Getting Started with Oracle Enterprise Manager Cloud Control 12c

4:30 PM – 5:30 PM

Banyan B

856

Leighton Nelson, World Wide Technology

Stabilize Your Plans with SQL Plan Management Including 12c

4:30 PM – 5:30 PM

Palm B

231

Alfredo Krieg, Sherwin Williams Company

Top Weblogic Administration Tasks You Can Automate Now

4:30 PM – 5:30 PM

Breakers H

10506

Mrityunjay Kant, AST Corporation

Welcome Reception

Enterprise Manager Demos:

  • Total Cloud Control with Oracle Enterprise Manager (Technology Area)
  • Applications Management with Oracle Enterprise Manager (Applications Area)

5:30 PM – 8:00 PM

Exhibit Hall - Oracle Demogrounds

Oracle Enterprise Manager Team

Tuesday April 14 - Day Two

Title

Time

Room

ID

Primary Presenter

Enterprise Manager Demos:

  • Total Cloud Control with Oracle Enterprise Manager (Technology Area)
  • Applications Management with Oracle Enterprise Manager (Applications Area)

9:30 AM – 3:30 PM

Exhibit Hall - Oracle Demogrounds

Oracle Enterprise Manager Team

Protect Your Identities: Managing User Access Using Oracle Identity and Access Management With Bonus Tuning Tips

9:45 AM – 10:45 AM

Banyan C

100

Ken Ramey, Centroid Systems

Upgrading to an OEM 12c High Availability Architecture for Monitoring and Job Execution - Keeping the NOC from Knocking

9:45 AM – 10:45 AM

Banyan B

741

Bill Petro, American Express

Enable Oracle GoldenGate Monitoring for the Masses with Oracle Enterprise Manager 12c

11:00 AM – 12:00 PM

Banyan B

219

Bobby Curtis, Enkitec

What is My EnterpriseOne Web Users Real Experience?

11:00 AM – 12:00 PM

Surf C

101760

Frank Jordan, ERP Suites

The Best Oracle Database 12c New Features

11:00 AM – 12:00 PM

Palm A

565

Rich Niemiec, ROLTA

Oracle WebLogic Performance Tuning

11:00 AM – 12:00 PM

Banyan C

239

Jon Gilmore, Zirous, Inc

Where did my day go?: Oracle Enterprise Manager 12c Administration

2:00 PM – 3:00 PM

Banyan B

230

Alfredo Krieg, Sherwin Williams Company

Automated Database Patching with Clould Control 12c: Lessons Learned and Best Practices

4:30 PM – 5:30 PM

Banyan B

182

Fernando de Souza, General Dynamics IT

Happy Hour

Enterprise Manager Demos:

  • Total Cloud Control with Oracle Enterprise Manager (Technology Area)
  • Applications Management with Oracle Enterprise Manager (Applications Area)

5:30 PM – 7:00 PM

Exhibit Hall - Oracle Demogrounds

Oracle Enterprise Manager Team

Wednesday April 15 - Day Three

Title

Time

Room

ID

Primary Presenter

Your Own Private Cloud

8:00 AM – 9:00 AM

Reef F

460

Gleb Otochkin, Pythian

Managing and Monitoring Fusion Middleware Using Oracle Enterprise Manager 12c

8:00 AM – 9:00 AM

Banyan C

336

Shawn Ruff, Mythics

You've Got It—Flaunt It: Oracle Enterprise Manager Extensibility

8:00 AM – 9:00 AM

Banyan B

281

Ray Smith, Portland General Electric

Exadata 101 - What You Need to Know

8:00 AM – 9:00 AM

Banyan D

569

Rich Niemiec, ROLTA

How to Comply With Audit and Make Your Life Easier

8:00 AM – 9:00 AM

South Pacific J

389

Frank Pound, Bank of Canada

Enterprise Manager Demos:

  • Total Cloud Control with Oracle Enterprise Manager (Technology Area)
  • Applications Management with Oracle Enterprise Manager (Applications Area)

9:30 AM – 3:30 PM

Exhibit Hall - Oracle Demogrounds

Oracle Enterprise Manager Team

Oracle 12c Multitenant Database Lifecycle Management with Enterprise Manager 12c Cloud Control

10:45 AM– 11:45 AM

Banyan B

108

Krishna Kapa, UBS

SIG: IOUG Oracle Enterprise Manager Special Interest Group Meeting

12:30PM – 1:00 PM

South Seas Ballroom B

949

Enterprise Manager Leadership Committee

Design and Implement your Own Self-Service Enabled Private Cloud with Oracle EM12c

2:45 PM – 3:45 PM

Reef F

464

Kai Yu, Dell

Migrate Your Cron Jobs to Oracle Enterprise Manager Cloud Control 12c

2:45 PM – 3:45 PM

Banyan B

335

Vladimir Lugo, Loyola Marymount University

PeopleSoft Application and System Monitoring Basics

2:45 PM – 3:45 PM

Mandalay Bay Ballroom C

100270

Raj Garrepally, Emory University

Migrate Your Cron Jobs to Oracle Enterprise Manager Cloud Control 12c

2:45 PM – 3:45 PM

Banyan B

335

Vladimir Lugo, Loyola Marymount University

Servers and Systems and Storage, Oh my! Infrastructure Management Using OEM 12c

4:00 PM – 5:00 PM

Banyan B

453

Erik Benner, Mythics

Recipe for Building a Private Database Cloud with Oracle RAC 12c

4:00 PM – 5:00 PM

Reef F

656

Leighton Nelson, World Wide Technology

Panel: Oracle Best Practices for Managing Oracle Applications

4:00 PM – 5:00 PM

Mandalay Bay Ballroom B

104800

Ken Baxter, Oracle

Thursday April 16 - Day Four (Final Day)

Title

Time

Room

ID

Primary Presenter

Pluggable database as a service: Combining Oracle 12c Database multitenant architecture and Oracle Enterprise Manager 12c

8:30 AM – 9:30 AM

Reef F

107

Krishna Kapa, UBS

Enterprise Manager 12c Cloud Control for Managing Oracle E-Business Suite 12.2

8:30 AM – 9:30 AM

South Seas H

10550

Angelo Rosado, Oracle

SIG: OAUG Oracle Enterprise Manager for Applications Special Interest Group

9:45 AM – 10:45 AM

South Seas H

10083

James Lui, Aramark

Future Now: Advanced Database Management for Today's DBA

9:45 AM – 10:45 AM

Banyan B

866

GP Gongloor, Oracle

12 Things to Consider for Migrating EBS to Exadata

11:00 AM – 12:00 PM

Banyan D

660

Arun Kumar Anthireyan, BIAS Corporation

Anomaly Detection for Database Monitoring

11:00 AM – 12:00 PM

Palm B

701

Alex Gorbachev, Pythian

Data Clone and Refresh Made Easy with Enterprise Manager 12c Snap Clone

11:00 AM – 12:00 PM

Palm D

921

Pete Sharman, Oracle

Under The Hood of Enterprise Manager - A troubleshooting primer

11:00 AM – 12:00 PM

Banyan B

157

Courtney Llamas, Oracle

Werner de Gruyter, Oracle

Best Practices for Planning and Deploying Private Database Clouds with Oracle RAC 12c Technologies

11:00 AM – 12:00 PM

Reef F

729

Mark Scardina , Oracle

Smarter Monitoring with Adaptive Thresholds and Time Based Metrics

12:15 AM – 1:15 PM

Banyan B

144

Courtney Llamas, Oracle

Case Studies Moving ASM Files

12:15 AM – 1:15 PM

Palm D

211

Anthony Noriega, ADN

Wednesday Feb 25, 2015

Editing EM12c Jobs in Bulk

I recently received requests for suggestions on how to edit EM12c jobs in bulk. The two examples that were presented to me were:

  1. Change the start time of 70+ jobs
  2. Change the oracle home path in 80+ RMAN script jobs

So how do we do this?

Read More

Tuesday Feb 24, 2015

Q&A: The Cloud Journey with Enterprise Manager

On last week's Enterprise Manager webcast, we had a great opportunity to catch up on the latest product news and hear how Enterprise Manager is helping companies transition to the cloud. We specifically focused on new capabilities around Platform as a Service for databases and middleware. You can still view the webcast on demand.

As a speaker on the webcast, I really enjoyed seeing the high number of questions in the text chat window - that's maybe the most fun part! Here are some of the questions & answers we had. (They've been slightly edited for clarity.) As always, you're welcome to comment via the blog.

Q: Do you recommend a DBA onsite or do you provide DBA support?
A: Either way. You can have your own DBA managing your database private cloud, or hire a consultant from Oracle or an Oracle partner. The important thing is that a DBA can support many more databases once users have self-service.

Q: Please explain provisioning of a schema in the database.
A: Schema as a Service allows you to deploy a schema and use it as if it were a separate DB - but with the benefits of consolidated management at the DB layer. In Database 12c, this is achieved using multi-tenant, pluggable DBs.

Q: What is Showback?
A: Showback is like chargeback, except that no money actually changes hands. IT is just showing the users how many resources they used.

Q: In Database Replay, does the workload run on an actual production-like environment, or is it just a simulation?
A: Database Replay allows you to replay the captured workload on the actual proposed environment. This is often useful for upgrade exercises and testing new configurations.

Q: Yes, but if consolidation is in planning stage, then the actual proposed environment won't be there. Are you talking about proposed environment in the cloud only?
A: Using Consolidation Planner, you can simulate the workload and arrive at the target environment requirement for a specific set of workloads. Also, using Real Application Testing and SQL Performance Analyzer, you can test using captured workloads and replay them. 

Q: Can EM provision MS SQL Server, and can EM provision in the Azure or Amazon cloud?
A: EM has no out of box capabilities for provisioning non-Oracle DBs. Current capabilities are focused on private cloud. Provisioning for public cloud is on the roadmap.

Q: Can you buy plugins for MS SQL Server?
A: Yes, plugins are available for non-Oracle DBs, including SQL Server, Sybase, DB2. The Oracle Extensibility Exchange on OTN has a list of available plugins from Oracle and from third party sources.

Q: I have a customer that wants to use Azure Pack as their provisioning UI. Can EM talk to Azure Pack in order to do this?
A: Yes, your customer can use Oracle Cloud APIs and build the relevant application for provisioning.

Q: So would Oracle Cloud APIs be an integration layer to Azure Pack?
A: You need to write your own code to integrate the Oracle private cloud solution into any third party solution.

Q: What's difference between full and snap clone?
A: As the names suggest, a full clone is a copy of the source database - it will occupy the same amount of space as the source. Snap Clone is a sparse copy of the source database, where the copy will occupy very little space on the disk as it uses copy-on-write storage technology.

Q: So Snap Clone only stores the changes and reads most data from the source?
A: Snap Clone stores only changes made in the clone copy. 

Q: In Snap Clone, what is the continuous refresh from production?
A: When you clone a database (typically from production to either a test or dev environment), there may be a need to refresh the clone on a regular basis.

Q: What is drift tracking?
A: Using the new configuration management features, you can define a configuration standard for your databases. If there is a deviation, you can get a report (typically called) drift analysis.

Q: What are some of the critical security-related configurations that you recommend for DB12c?
A: EM12c can be used to track and enforce compliance, including industry standards such as PCI or customer policies created and monitored by EM itself. 

Q; With self-service DBaaS, can the end user can update or upgrade the database or DB home?
A: The end user (Self Service User) can upgrade the database service that he/she created earlier. Only Cloud Admin can upgrade Oracle Homes.

Q: Can you explain this with an example?
A: The Cloud Admin will upgrade all Oracle Homes in a Pool to the next patchset release. Now, SSA users can subscribe to upgrade the database services they created. If SSA users do not do so by a certain time, the Cloud Admin can force-upgrade their databases.

Q: What is the difference between a hosting environment and a cloud?
A: Resource abstraction, metering, chargeback, self-service, and a few other things are industry-accepted characteristics of a cloud.

Q: Is dev/test in the public cloud, and production in the private cloud, the most common architecture?
A: It's definitely very common. Dev/test environments are often temporary in nature and that lends itself very well to public cloud.

Q: What's the difference between Exadata and Exalogic?
A: Both are Oracle hardware systems. Exadata is optimized for databases, whereas Exalogic is meant for Oracle middleware and applications.

Q: Thank you for answering all my questions. Great webcast!
A: Thanks so much! Glad we got the opportunity to share the news.

Monday Feb 23, 2015

Webcast: Database Provisioning in Minutes: Using Oracle Enterprise Manager 12c DBaaS Snap Clone and EMC Storage

Live Webcast
Wednesday February 25, 2015
8:00 a.m. PST | 11:00 a.m. EST

Oracle Enterprise Manager 12c Database as a Service Snap Clone allows administrators to create fully functional copies of databases using the capabilities of the underlying storage layer. Users can request databases from the self-service console and have them provisioned within minutes instead of hours while keeping storage needs to a minimum.

Attend this presentation to learn more about the features and benefits of Oracle Enterprise Manager 12c DBaaS Snap Clone using EMC storage and to view a live demo.

This webcast is specifically targeted for DBAs, storage administrators and cloud administrators interested in saving time and effort implementing enterprise grade DBaaS.

Register Now!

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

Wednesday Feb 18, 2015

Test Drive Oracle Enterprise Manager at a City Near You

Are you tired of watching product demos? Prefer to try products for yourself? Then this is for you.

Oracle is currently running a workshop series called Oracle Database as a Service Test Drives. You bring your laptop, connect to live Oracle Database 12c and Oracle Enterprise Manager 12c instances, and try our latest database cloud management solution for yourself.

The day begins with an overview of DBaaS benefits and the architectural choices for building your enterprise cloud (OK, the introduction is actually a PowerPoint presentation!) You then use a step-by-step workbook that guides you throughout the day through the steps of creating a database cloud environment. The event is perfect for DBAs, application developers, IT managers and anyone involved in private cloud deployments.

These are the workbooks we’ll go through:

  • Database as a Service using Snap Clone – self service
  • Database as a Service using pluggable databases (PDB) – self service
  • Database as a Service setup for cloud administrators
  • Cloud management – chargeback and metering
  • Database consolidation testing with Real Application Testing
  • Database lifecycle management with Enterprise Manager 

Looks interesting? Register for an event near you.

Wednesday Feb 11, 2015

Webcast: Accelerate Your Cloud Journey With Enterprise Manager (February 17)

Webcast: Accelerate Your Cloud Journey

On February 17, join us for a webcast about the journey to the cloud with Oracle Enterprise Manager 12c. (If you can't make it, you can watch the webcast later on demand.)

Last month, Oracle announced a new release of Enterprise Manager with many new cloud management capabilities, especially around Database as a Service and Middleware as a Service. This is a good opportunity to learn how the new capabilities fit into the overall cloud story.

On the agenda:

  • The Cloud Journey
  • Private Cloud Platform as a Service
  • Making the Journey with Enterprise Manager 12c
  • Customer Case Studies
  • Looking Ahead: The Hybrid Cloud

Register here

Monday Feb 09, 2015

Take the IOUG Database Manageability Survey

The Independent Oracle Users Group (IOUG), is conducting its annual database manageability survey. If you are a database professional responsible for managing and operating your organization's database applications and systems, then the IOUG wants to hear from you.

Take the next few minutes to answer simply questions around your common manageability practices and challenges. Share your experience and insight with the IOUG and Oracle communities and you'll be entered into a draw for a chance to win an Apple iPad from the IOUG. You will also receive a free copy of the final report.

Take the 2015 IOUG Database Manageability Survey


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

Monday Feb 02, 2015

Snap Clone using EMC SAN and ASM

Recently we announced the latest update to Enterprise Manager Cloud Control 12c Release 4.  One of the enhancements in that release is support for Snap Clone on Automatic Storage Management (ASM) and EMC Storage.  Before we examine the details of this specific enhancement, let's look at a quick refresher on what Snap Clone provides for you.

What is Snap Clone?

Snap Clone is a storage agnostic and self service approach to creating rapid and space efficient clones of large databases (and by large, we’re talking terabytes or more). Now that’s probably more buzz words in one sentence than anyone’s brain can deal with without exploding, so let’s explain some of those terms more:
  • Storage agnostic – by that I mean Snap Clone supports all storage vendors, both NAS and SAN. It can leverage storage layer APIs or layer a ZFS filesystem on top to provide copy on write.
  • Self service – in the XaaS world – where X can be any of I, MW, P and DB :) – one of the key features is empowering the end user to do the work, rather than waiting on some techie to find time in their otherwise busy schedules. So it’s the end user who makes the adhoc clones here, not the storage admin
  • Rapid – People simply don’t have the time to wait weeks for provisioning to happen any more, so you have to support the functionality to clone databases in minutes rather than the days or weeks things used to take.
  • Space efficient – When you’re working with terabyte or larger databases, you simply may not have the storage to create full-sized clones, so you have to significantly reduce the storage footprint to start with.
Over the various EM releases,  more and more functionality has been added to Snap Clone:
  • EM12cR2 provided Snap Clone for NAS storage (NetApp and Sun ZFSSA).  It provided RMAN backup based clones, and included the Snap Clone Analyzer to show you the storage savings you could make using Snap Clone
  • EM12cR3 added in support for Snap Clone using the Solaris File System (ZFS) and admin flows for Snap Clone for PDB’s (pluggable databases)
  • EM12cR4 added a lot more:
    • Snap Clone using CloneDB – this is the biggie, as it means Snap Clone can now be used with ANY Oracle database release that supports CloneDB, regardless of what storage it’s on
    • Data Guard standby as a test master – allows offloading the impact of creating the test master from your Production environment
    • NetApp Ontap 8.x cluster mode support
    • Certification for engineered systems, with I/O over Infiniband
    • Support for NFSv4
  • And in the latest plugin update that's just been shipped, we added:
    • Integrated data lifecycle management
    • Snap Clone using EMC SAN and ASM
    • Admin flows for test master creation
    • Integration with masking, patching, upgrades etc.

Snap Clone using EMC SAN and ASM

Most NAS technologies offer storage efficient clones in the form of Snapshots. The snapshots make use of underlying volumes, knows as flexvols (Netapp) or shares (ZFS). Unfortunately, SAN storage does not provide native snapshotting capability unless a file is created on it by leveraging TCP/IP over iSCSI over Ethernet. However this defeats the purpose of having high speed fiber channel fabric, not to mention that it makes little sense to overlay SAN with a filesystem. Another complaint we heard from our customers is that cloning is a data intensive operation that could flood the corporate IT backbone if Ethernet is used. Consequently, lot of our customers want native support for SAN for cloning purposes, especially, the ones who run ASM on SAN. And they are quite a lot in number.

Using Snap Clone on ASM and EMC storage provides the ability to create ‘live’ thin clones of databases that are on ASM. A live clone is NOT snapshot based but rather a live copy of the database, residing on copy-on-write storage technology, that can be within the same cluster or indeed another one. Both single instance and RAC are supported – supported versions are 10.2.0.5 or higher of the database, 11.2 and higher of the Grid Infrastructure code. This functionality works on both EMC VMAX (with Time Finder VPSnap) and VNX storage appliances.

Diagrammatically, the configuration looks like this:



Why Use Snap Clone with EMC SAN and ASM

There are a number of major challenges that Snap Clone can be used to address:
  1. Lack of automation - Manual tasks such as provisioning and cloning of new databases (for example, for test or development systems) is one area that many DBA’s complain is too time consuming. It can take days to weeks, often because of the need to coordinate the involvement of different groups, as shown in the image below:

  2. When an end user, be it a developer or a QA engineer, needs a database he or she typically has to go through an approval process like this, which then translates into a series of tasks for the DBA, the sysadmin and storage admin. The sysadmin has to provide the compute capacity while the storage admin has to provide the space on a filer. Finally, the DBA would install the bits, create the database (optionally on Real Application Clusters), and deliver that to the user. Clearly, this is a cumbersome and time-consuming process that needs to be improved on.

  3. Database unfriendly solutions – Obviously, when there is a need looking for a solution, different people take different approaches to solving that need. There are a variety of point solutions and storage solutions out there, but the vast bulk of them are not database aware. They tend to clone storage volumes rather than databases and have no visibility into the database stack, which of course makes it hard to triage performance issues as a DBA. They also lack the ability to track configuration, compliance and data security issues, as well as having limited or no lifecycle capabilities. As mentioned before, DBAs would like to leverage the native FDDI protocol of SAN for cloning.  This will make cloning fast and efficient without disrupting regular network traffic.

  4. Storage issues and archaic processes – Of course, one of the main issues is storage. Data volumes are ever increasing, particularly in these Big Data days, and the growth can often outpace your storage capacity. You can throw more disks at the problem, but it never seems to be enough, and you can end up with degraded performance if you take the route of sharing clones between users. There can also be different processes and different priorities between the storage team and the DBA team, and you may still have fixed refresh cycles, making it difficult to clone on an adhoc basis.
So the end result of all of this is that far too often, there are competing priorities at odds. Users want flexibility – simplified self service access, rapid cloning, and the ability to revert data changes. IT, on the other hand, want standardization and control, which allows a reduction in storage use, reduction in administrative overhead, visibility into the complete database stack and lineage tracking.  

Snap Clone on EMC storage helps you to address all these competing priorities, using hardware you may already own.  Indeed, EMC is well established as an Oracle database storage vendor over many years, and that integration has become tighter and tighter over the past few years.  In addition to that, the actual setup and configuration can be simpler than is the case when using other hardware, as you do not need to create Database Profiles in this configuration.  Service Templates are created directly on either a single instance or RAC database that resides on ASM.  Because you're using this combination of ASM and EMC SAN storage, the database is already Snap Clone enabled as it resides on copy-on-write storage technology.

In my next post, I'll discuss more details of what else is new in the Snap Clone product in this latest release, so stay tuned for more details on that soon!

For More Information

You can see more details on how you actually set Snap Clone up on EMC storage by viewing the following screenwatches:

For more details on using Enterprise Manager Cloud Control 12c to provide Database as a Service functionality, visit the OTN page located here.

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

Tuesday Jan 27, 2015

Top Oracle Enterprise Manager 12c Questions

Guest contributors: Courtney Llamas and David Wolf

What are the steps involved for upgrading from Oracle Enterprise Manager 12c Release 3 to Release 4? Is it an upgrade in place or a new install/migration
Answer: Yes, Oracle Enterprise Manager 12c R3 to R4 is an out-of-place upgrade, which means the installer will install in a new Oracle Home and migrate the application over. You will need the additional space for a new Oracle Home. You can reduce downtime of the upgrade by performing a “Software Only Install”, and then upgrade later. See the upgrade documentation here.

Do the patch and upgrade functionality work on Oracle Database 11g targets or only on Oracle Database 12c targets?
A: Yes, patching and upgrading can be performed on any certified target version. For more details on database patching and lifecycle management visit this page.

Where can I find a full list of new enhancements compared to Release 3?
A: The new features are listed in Oracle Enterprise Manager Cloud Control Introduction Guide.

Is there a list available of new features by management pack?
A: The new features are listed in Oracle Enterprise Manager Cloud Control Introduction Guide. They are listed by plug-in, not management pack. For the license information read this page.

What are the best hardware configuration and setup in order to provide high availability capabilities for database as a service (i.e. Oracle RAC, Oracle Exadata)?
A: The more you rely on Oracle Enterprise Manager, the more you need to think about high availability. The best recommendation is to have a multi-OMS system with a standby for disaster recovery. You can scale up to this as the environment grows, but starting with a multi-OMS system will give you the availability and scalability you need. A standby database with Oracle Data Guard and a software replicated standby OMS would be the next step. Please read this whitepaper Deploying a Highly Available Oracle Enterprise Manager 12c Cloud Control for more information.

Can Snap Clone be used with EMC storage or is Oracle ZFS storage required?
A: Yes. Snap Clone can be used with either EMC VMAX and/or VNX Block Storage, both are supported. More details can be found on this page under the section: Database Cloning and Dynamic Data Refresh.

Does Oracle Enterprise Manager support monitoring of hypervisors?
A: Oracle Enterprise Manager supports monitoring of Oracle VM natively and VMWare via a Blue Medora third party plug in. More details on managing physical and virtual host can be found here.

Is the metering and chargeback functionality part of the base product or does it requires an additional management pack?
A: Metering and Chargeback for Oracle Database is part of the Oracle Cloud Management Pack for Oracle Database. Metering and Charge back for guest virtual machines (VMs) and hosts are included with the base product and does not require a separate license. Read this whitepaper for more on Metering and Chargeback with Oracle Enterprise Manager.

Does Enterprise Data Governance require additional licensing?
A: Use of the Enterprise Data Governance capabilities within Oracle Enterprise Manager requires an Oracle Database Lifecycle Management Pack license.

How is the new AWR Warehouse feature different from the existing AWR report in Oracle Enterprise Manager 12c Release 3?
A: The existing AWR report in Oracle Enterprise Manager pulls AWR data from the source database and relies on the AWR retention setting of that database. This is typically only saved for 8 days. There’s been a big demand for saving this data for 30-60 days and even longer. AWR Warehouse, automates the extract of the source AWR data and loading to a warehouse database so that data can be retained without affecting the performance and storage of the source database. The reports are the same, it just allows you to dig back further in time. Read this article for more details.

Does this new release require more disk space for the AWR Warehouse? More CPU and memory?
A: Not for the OMS. The recommendation is to setup the AWR Repository in a separate database, outside of the Oracle Enterprise Manager repository database. Hosting on the same server would be fine, so long as there is sufficient memory and CPU for both instances. Read this article on AWR Warehouse for more details.

Does AWR Warehouse also support Oracle Database 10g and/or 11g AWR?
A: AWR Warehouse must be installed on Oracle Database 12.1.0.2 or higher or version 11.2.0.4 with the appropriate patch. It also must be an equal or higher database version of the source databases it accommodates. Check out this demo to understand AWR Warehouse. Read the AWR Warehouse documentation.

Is there a list of 3rd party technologies that can be managed by Oracle Enterprise Manager 12c?
A: Check out the Oracle Enterprise Manager Extensibility Exchange for a list of the available 3rd party plug-ins and connectors.

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

Monday Jan 26, 2015

Register Now for the Cloud Platform Online Forum

January 28th, 2015 10:00 a.m. PST/1:00 p.m. EST
Register Today

Modern Business. Modern Cloud.
Is Your PaaS Delivering the Agility Your Users Demand?

Don't miss the opportunity to join Oracle and IDC in a series of deep discussions on Cloud Platform as a Service. This online event kicks off on Wednesday January 28th at 10:00 a.m. PST. Take advantage of 20+ sessions, 10+ demos and 100+ tips and techniques to plan your PaaS adoption effectively. Topics encompass private, public and hybrid cloud. You will also learn how to plan your transition from traditional IT delivery to cloud delivery using Oracle technologies you use every day. Register at bit.ly/PaaSForum

Oracle Enterprise Manager discussions during this event include tips and techniques on workload consolidation using database as a service and application platform as a service; transforming traditional IT delivery using self-service; effectively collaborating with business users with showback/chargeback, and more. Our speaker Sudip Datta, Vice President of Product Management will also provide a glimpse into the future of PaaS management.

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

Sunday Jan 18, 2015

Enterprise Manager Ops Center - Ops Center EC/PC sizing

Counting Access Points Vs Assets

When designing a customer's Ops Center environment, one of the first questions I get asked is how many servers can an Enterprise Controller (EC) or a Proxy Controller (PC) support.  Customers think of sizing, as being the number of servers,  LDOMs, etc. and these are lumped together into a total number of assets. In the real world, the answer to the "How many assets can my Enterprise Controller /Proxy Controller support?" question is, "It Depends".  How you place your Proxy Controllers in your network and what you manage from each Proxy Controller can impact the total number of assets that can be supported from an Enterprise Controller.

The amount of load placed on an Enterprise Controller or Proxy Controller is not directly determined by the number of assets it manages, but by the number of Access Points (AP) it is supporting. A simple view of Access Points is that they are a connection. But it is a little more complex in that they are also a reflection of the way Ops Center internally models its data structures. The actual load on any given Enterprise Controller or Proxy Controller closely links to the number of Access Points it is managing. The number of Access Points seen by the Enterprise Controller can differ depending on whether an asset is connected via a single or multiple Proxy Controllers. Therefore, the Access Point count on the Enterprise Controller will be higher than the actual number of managed assets, if assets are managed by multiple Proxy Controllers. When the documentation is referring to Enterprise Controller /Proxy Controller capacity and uses the term "Asset", it is actually counting "Access Points".

Let's look at a couple examples of this to make it clearer:

Physical Server ILOM

In this example, a single physical server has multiple data collection methods. A Proxy Controller can gather LOM data by accessing the service processor and by using the agent running inside the operating system.


If the same Proxy Controller is used to access a single asset, the two data feeds are consolidated into a single Access Point. The Enterprise Controllers total load will be a single Access Point.


If different Proxy Controllers are used to access a single asset,  each Proxy Controller will record it as a separate Access Point. The Enterprise Controllers total load will be the sum of both Proxy Controllers and will be a total of 2 Access Points.

LDOMs

Another example would be an LDOM guest where we obtain data from the Control Domain agent and the agent running inside the LDOM guest OS.

Once again, if  both data feeds are via a single Proxy Controller they only count as 1 Access Point on both the Proxy Controller and the Enterprise Controller.

Where as, if each data feed is via a separate Proxy Controller they each count as 1 Access Point on each Proxy Controller and the total Access Point count on the Enterprise Controller will be 2.

With the release of Enterprise Manager Ops Center - 12.2.2, we have updated and renamed the Enterprise Manager Ops Center Sizing and Performance Guide (https://docs.oracle.com/cd/E40871_01/doc.122/e57052/toc.htm). This revised document is easier to understand and has been updated to reflect current releases of Ops Center. Note: Since the term "Access Point" was not considered to be commonly understood, the term "Asset" has been used in the documentation. 

To make the counting of Access Points easier, we have added a program to the OCDoctor toolbox. This program "AssetCount.sh" is new in OCDoctor version 4.45 and can be found on any EC/PC or system that has an agent deployed. The path to the OCDoctor toolbox is /var/opt/sun/xvm/OCDoctor/toolbox.

# /var/opt/sun/xvm/OCDoctor/toolbox/AssetCount.sh

        AssetCount.sh [-v] { standard | machine | agent | all }

        standard - show Asset count
        machine - show machine output with Assets names
        agent - show information about agents, agentless Assets, Service Processors
        all - show all the information together

        -v : verbose output, present additional notes around the counting algorithm

        (Version 1.0 2015/01/08) 
  #

Let's just look at the standard output (we are running this on the Enterprise Controller). The output shows:

  • The total Access Point count for the EC (72)
  • The number of Access Points for each type of asset, for each Proxy Controller ( Note: the total Access Point count for each Proxy Controller is labeled as Assets )
root@ec1:~# /var/opt/sun/xvm/OCDoctor/toolbox/AssetCount.sh standard

EC 72

Proxy Assets Zones Ldoms OVMGuests Servers Storages Switches ExadataCells MSeriesChassis MSeriesDomain
------------------------------------------------------------------------------------------------------
pc4   32     5     25    0         2       0        0        0            0              0
pc1   28     0     26    0         2       0        0        0            0              0
pc0   12     2     4     0         6       0        0        0            0              0

Use option '-v' to see additional notes on the counting algorithm.

#

You can also use the "machine" option to list out which asset is attached to which proxy.

# /var/opt/sun/xvm/OCDoctor/toolbox/AssetCount.sh machine

EC 72

Proxy 32 pc4
Zones 5 S11zone101 S11zone102 S11zone100 S11zone103 S11zone104
Ldoms 25 stdldom21 stdldom34 stdldom36 stdldom22 stdldom45 stdldom47 stdldom25 stdldom43 stdldom49 stdldom30 stdldom23 stdldom29 stdldom42 stdldom20 stdldom32 stdldom46 stdldom44 stdldom26 stdldom31 stdldom27 stdldom48 stdldom40 stdldom35 stdldom41 stdldom28
OVMGuests 0
Servers 2 10.187.70.169 pc4
...
Proxy 28 pc1
Zones 0
Ldoms 26 stdldom21 stdldom34 stdldom36 stdldom22 stdldom45 stdldom47 stdldom25 stdldom43 stdldom49 stdldom30 stdldom23 stdldom29 stdldom42 stdldom33 stdldom20 stdldom32 stdldom46 stdldom44 stdldom26 stdldom31 stdldom27 stdldom48 stdldom40 stdldom35 stdldom41 stdldom28
OVMGuests 0
Servers 2 10.187.70.171 pc1
...
# 

You can see this would be incredibly verbose on a large environment ( I have truncated it here). You can clearly see that the LDOMs (stdldomXX) are being reported by both "pc1" (via Control Domain) and "pc4" (via OS agent). Note: the differing LDOM count on "pc1" and "pc4"  as "stdldom33" has no OS or agent on it, so it only reports against "pc1".

You can also use the "agent" option to display agent/agentless/LOM totals for each Proxy Controller.

# /var/opt/sun/xvm/OCDoctor/toolbox/AssetCount.sh agent

EC 72

Proxy Agents Agentless SPs
--------------------------
pc4   25     2         0
pc1   1      1         0
pc0   5      5         5

Use option '-v' to see additional notes on the counting algorithm.

#

In addition, OCDoctor.sh --troubleshoot will also be checking for the number of configured Access Points and comparing this number against the recommend Access Point count. It will print a warning at approximately 90% of the recommended capacity and a warning if you exceed the recommended capacity.

Armed with the information above, you should be able to better design your Ops Center deployments and to monitor the growing load on the Enterprise Controller/Proxy Controllers as you add more assets.

Regards,

Rodney

Friday Jan 16, 2015

Webcast: Zero to Manageability in One Hour—Build a Solid Foundation for Oracle Enterprise Manager 12c

Wednesday, January 21, 2015
1:00 p.m. EST | 10:00 a.m. PST

The goal in every Oracle Enterprise Manager 12c rollout is to take it from zero to manageability in the shortest possible time. This presentation will show you how to accomplish this feat. Oracle experts will demonstrate how to properly architect and deploy Oracle Enterprise Manager 12c, including designing a highly available and scalable environment. Through this demonstration a list of essential techniques and tips compiled from Oracle Enterprise Manager Development’s Strategic Customer Programs team will also be shared. Topics such as; users, roles, groups, templates, and incidents will be discussed, plus key architectural decisions.

By attending this webinar, you will learn how to:

  • Organize targets, notifications and users properly
  • Configure for best practices after the install is complete
  • Properly plan and architect an Oracle Enterprise Manager 12c environment

Featured Speaker: Courtney Llamas, Principal Member of Technical Staff, Oracle

Registered Now

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

Thursday Jan 15, 2015

IOUG eBrief: News for the Oracle Enterprise Manager User Community

IOUG eBrief: January Edition Now Available

Check out January's issue of the IOUG eBrief featuring all the latest news and highlights from IOUG and the Oracle Enterprise Manager 12c Special Interest Group (SIG).

Read the newsletter

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

Tuesday Jan 13, 2015

New Enterprise Manager Release Delivers Adaptive Private PaaS

We are pleased to announce an update to Oracle Enterprise Manager Cloud Control 12c Release 4. The update is now available on OTN.

So what exactly is adaptive private PaaS?

Recent releases of Enterprise Manager have expanded capabilities around Platform as a Service (PaaS) delivery in your private cloud. In particular, the EM Cloud Management Packs have focused on two critical areas for Oracle customers: Database as a Service (DBaaS) and Middleware as a Service (MWaaS).

In this release, these PaaS capabilities have become more adaptive to complex, rapidly growing environments. Let's look at 3 areas where database and middleware users and managers will benefit.

Controlling Expanding Database as a Service Environments

Rapid adoption of database as a service can lead to even faster growth in the number of database instances and the number of database versions and configurations. This can severely impact your management costs and could even cripple your database as a service initiative. The new release enhances our solution to this problem:
  • Configuration standardization with integrated advisory, to detect differences across databases and eliminate configuration drift
  • Database fleet patching using minimum downtime techniques, to bring database configurations back into compliance
  • Rules for custom placement, to intelligently find a suitable target for database placement, based on current load, current population and placement constraints

A database as a service approach can improve service to database users while simultaneously reducing database management costs. 

Developing More Rapidly, with Increased Security

Agile application development and testing requires convenient access to up-to-date test data. The Enterprise Manager Snap Clone feature gives DBAs, developers and QA engineers direct access to self-service cloning, so they can create fully functional copies of production databases within minutes. This release introduces several exciting new Snap Clone capabilities:
  • Continuous data refresh from the source database. As your production system gets updated, you can continuously refresh your test data.
  • Integrated data masking, subsetting and patching. Use the Enterprise Manager Data Masking and Subsetting Pack together with Snap Clone to keep your test databases lean and free of sensitive information, and keep them up to date with the latest PSUs and patch sets.
  • Restore a database to a previous point in time with a convenient calendar view.
  • Snap Clone support on EMC VMAX and VNX Block Storage. This adds to Snap Clone's native support for Oracle ZFS Storage Appliance and NetApp Storage Appliance in addition to generic support of other storage systems.
Software developers can also take advantage of new test-to-production (and reverse) cloning of SOA, OSB and WebCenter environments with application artifacts automation.

Flexible APaaS Service Catalogs

If you're providing middleware (e.g. an application platform) as a service to application developers, you now have additional ways to adapt these services to developers' needs.
  • More APaaS catalog options. In addition to Java apps and WebLogic Server, you can offer SOA, OSB and WebCenter in your self-service portal for easy, template-based provisioning.
  • Updated REST API support for new service catalog options, for easy integration with 3rd party orchestration tools and service desks.
  • Sharing of service instances among self-service users, for an efficient, consolidated platform on which to provision middleware services.
For a more comprehensive list of updates, please visit Database as a Service and Middleware as a Service on OTN. In addition, we will post several articles about the new DBaaS and MWaaS capabilities on this blog over the next few weeks.
About

Latest information and perspectives on Oracle Enterprise Manager.

Related Blogs




Search

Archives
« February 2015
SunMonTueWedThuFriSat
1
3
4
5
6
7
8
10
12
13
14
15
16
17
19
20
21
22
26
27
28
       
       
Today