Tuesday May 26, 2015

Data to collect when logging a Service Request on Enterprise Manager Ops Center

If you ever have to log a Service Request (SR) on your Enterprise Manager Ops Center instance, the question often arises as to what data you should include with the SR. Including the right information when you log the SR will greatly reduce your Time To Resolution (TTR).

So, what data should you add to the SR? That will depend on what type of issue you are experiencing.

Basic Information for All SR's

While the My Oracle Support (MOS) portal will help by asking you relevent questions, here is a list of things to think about while answering them:

  1. A clear problem description - Tell us about what you were attempting to do when you encountered the issue, what host(s) were involved and what error message you saw. You would be surprised how many SR's get logged with "It didn't work" or just the error message as the problem description without telling us what you were actually trying to do. 
  2. Time and date - Tell us the time and date you saw the issue. The log files are time stamped, so knowing the time the issue occurred (at least approximately) will reduce the extent of searching of the log files that will need to be done.
  3. Software Version - Always tell us what version of Enterprise Manager Ops Center you are using. To find out your version, look on your Ops Center BUI under [Administration] ==> [Enterprise Controller] and at the top of the middle panel (Summary Tab) will be listed the Enterprise Controller Version. Don't forget to include if there are any IDR's (Patches) that have been applied to your Enterprise Manager Ops Center instance.


Additional Data to include with your SR

The most common thing to include with your SR is an OCDoctor --collectlogs output (# /var/opt/sun/xvm/OCDoctor/OCDoctor.sh --collectlogs), but it will often depend on which part of the process Ops Center was at when the issue occurred. If your issue falls under multiple sections below, please supply the data from all relevant sections.

It should be noted that all of the Ops Center logs will rollover over time and on a busy environment that may not be a long time. So, it is important to collect any log files as soon as possible after you have seen your issue or you should reproduce the issue just before collecting the logs.

Browser User Interface (BUI) issues

  • Collect screen shots of what you are seeing in the browser
  • Run # /var/opt/sun/xvm/OCDoctor/OCDoctor.sh --collectlogs on your Enterprise Controller and collect the output file

Job related issues (Job fails)

  • Provide the job number
  • Provide the full job logs
    • In the BUI, click through to the failed task on the job and then export the logs
    • Select the radio button for "Full Job Log" and save the job log
  • Run # /var/opt/sun/xvm/OCDoctor/OCDoctor.sh --collectlogs on your Enterprise Controller and collect the output file

OS provisioning issues

  • Capture the full job log (as described above)
  • Run # /var/opt/sun/xvm/OCDoctor/OCDoctor.sh --collectlogs on the relevant Proxy Controller and collect the output file
  • Capture any console logs of either the physical server or, if deploying to LDOMs, capture /var/log/vtnds/[LDOM name]/console.log
  • If deploying to an LDOM, run # /var/opt/sun/xvm/OCDoctor/OCDoctor.sh --collectlogs on the relevant CDOM and collect the output file

Patching issues

  • Capture the full job log (as described above)
  • Run # /var/opt/sun/xvm/OCDoctor/OCDoctor.sh --collectlogs on the system being patched and collect the output file
  • Run # /var/opt/sun/xvm/OCDoctor/OCDoctor.sh --collectlogs on your Enterprise Controller and collect the output file

Discovery issues

  • Capture the full job log (as described above)
  • Run # /var/opt/sun/xvm/OCDoctor/OCDoctor.sh --collectlogs on your Enterprise Controller and collect the output file
  • Run # /var/opt/sun/xvm/OCDoctor/OCDoctor.sh --collectlogs on the relevant Proxy Controller and collect the output file

Agent deployment issues

  • Capture the agent install output and logfile (/var/tmp/agent_install, /var/scn/install/log)
  • Capture the agent configuration output and logfile (/var/tmp/agentadm.log)
  • If the agent has actually been installed, run # /var/opt/sun/xvm/OCDoctor/OCDoctor.sh --collectlogs on the system you are installing the agent on and collect the output file
  • Run # /var/opt/sun/xvm/OCDoctor/OCDoctor.sh --collectlogs on the relevant Proxy Controller and collect the output file

Domain Model issues

  • Run # /var/opt/sun/xvm/OCDoctor/OCDoctor.sh --collectlogs -u [EC Master Admin User] on your Enterprise Controller and collect the output file
    • This will collect the domain model information as well as the normal output from OCDoctor log collect. Note:  this can take a long time to run
    • The [EC Master Admin User] is the user that you specified as part of the initial install. On some customer systems, this will be root but it does not have to be.

Collecting the right information and providing it as part of the initial logging of the SR will make it easier for the engineer to analyze your issue and avoid a lot of unnecessary back and forth. Overall, it will get your issue resolved quicker. I hope this information will help you if you ever have to log a SR on Enterprise Manager Ops Center.

Regards,

Rodney Lindner






Tuesday May 12, 2015

Data Clone and Refresh (part 1)

In mid January we released the latest version of Enterprise Manager Cloud Control 12c, the 12cR4 Plugin Update.  This release included many enhancements in the cloud management space, making it the complete DBaaS automation solution.  The main areas of enhancement are:

  • Self Service Portal and Service Catalog, including add and remove standby capabilities, externalized database size and improved customization
  • Cloud Framework, with an improved self service portal, role and service type based access across all pages, and improved administration capabilities
  • Data Clone and Refresh, including an improved self service experience, admin flows for non-cloud cloning and refreshes, and additional storage certification
  • Fleet Maintenance, such as the ability to subscribe to database and grid infrastructure images, deploying them automatically to servers

In this posting, I'll be focusing on the data clone enhancements.  My next post will focus on the refresh enhancements.

Improved Self Service Experience

Enterprise Manager ships with an out-of-box self-service portal that allows developers, testers, DBA's, and other self service users to log on and request various services. It also provides an administrative interface for DBA's to deliver one-off or special requests for services. These services include:

  • New single instance (SI) and Real Application Clusters (RAC) databases using pre-defined golden standards. This is ideal for developers asking for standard databases with or without data.
  • New SI and RAC databases along with Data Guard standby databases either within the same data-center or across different geographical regions. This is ideal for production and semi-production workloads that have high availability requirements. 
  • Schemas hosted in one or more databases, and provided as Schema-as-a-Service.
  • Pluggable databases that are hosted in one or more Oracle Database 12c Multitenant container databases provided as Pluggable Database as a Service. 
  • Database thin clones, using the Enterprise Manager 12c Snap Clone feature that leverages storage Copy-on-Write (CoW) technology on Oracle and non-Oracle storage. Snap Clone lets users, such as functional quality assurance testers, to create multiple copies of the database in minutes without consuming additional space, take private backups, and refresh data from the original source. Snap Clone supports cloning of databases on file and on Oracle Automatic Storage Management with block storage. 
  • Database full clones using RMAN backups or RMAN duplicates. This could be ideal for intense testing, such as database upgrades and performance testing on Exadata. 
  • All cloning services come integrated with masking, and ability to change configuration and software versions. 
  • Fleet maintenance allows administrators to patch and upgrade database software, with near zero or zero downtime. The subscription based model enables updates at scale, and across the entire cloud ecosystem thus significantly reducing the time required for maintenance activities. 
Additionally, self service users can perform lifecycle operations like starting and stopping, checking the status, health monitoring, etc. on the requested databases and schemas. Provisioning can be done on both physical infrastructure using Deployment Procedures and on an Oracle VM virtualized server infrastructure using Virtual Assemblies and Virtual Templates. The portal provides access to a Service Catalog which lists various published service templates for standardized database configuration and versions. Users can review their past and outstanding requests, resource quotas, and current utilization as well as chargeback information for the databases and services they own. The portal also allows users to automatically backup their databases on a scheduled basis or take on demand backups. Users can restore the database to any of these backups. The self-service portal is the user's view into the cloud, thus it is designed to be easy to use and yet useful. The portal is also backed by both a command line interface and an API that can be used to request and manage cloud resources via scripts in lieu of the user interface.

Admin Flows for Non-Cloud Cloning and Refreshes

Often, people think of cloning as only important as a cloud operation, but  that’s not the only place that cloning can be important.  It’s ideal, for example, as a way to build environments for proofs of concept, test master creation, or indeed anywhere that you may need a one-off clone. With the Clone and Refresh functionality, you can clone from an existing snapshot of a database, or you can choose to clone to a particular point in time or SCN.  Not only that, you can integrate both masking and patching (for PSU’s) in this flow as well.  Once you have created a clone, you can then refresh it from the source later with a few clicks. And finally, once you’ve done cloning through the user interface, you might then decide to clone and refresh in a scripted manner, using the EM CLI verbs or REST API's that are provided for this.  You can even schedule the cloning through EM CLI to occur at a time that suits you.

Now let’s look at the details of what can happen as part of this clone and refresh flow, based on the environment you can see in the image below:



On the left hand side you can see our Production database.  In this example, this is an 11.2.0.4 database running in a 3 node RAC environment, with some RMAN backups already taken.  So what can I do with this database when I clone it?

Firstly, I can mask sensitive data.  Generally, when you take a copy of your Production database to another environment, you want to mask some of the data in that database, such as credit card numbers, salary details and so on.  The admin flow allows you to apply a pre-defined masking format to your data as it is cloned, or indeed execute your own custom SQL scripts to change the data as you need to.

Secondly, I can actually test patching as part of the flow.  In the example I’m showing here, I’m cloning my 11.2.0.4 Production database to an 11.2.0.4.2 test environment.

Thirdly, I can change the configuration as part of the admin flow as well.  Again, in the example shown here we're moving from a 3 node RAC environment in Production to a single instance test environment.

Finally, if my underlying storage supports copy on write technology, I can also take advantage of that and take a snap or thin clone of my Production environment, where blocks are only written to my test environment as they are changed in Production.  That means I can build a lot more snap clones and still require only a very small percentage of the storage of my Production environment.

Additional Storage Certifications

Earlier releases of the Enterprise Manager Snap Clone functionality provided two different solutions from a storage perspective.  If you already had either Oracle's Sun ZFS Storage Appliance or NetApp, you could create a vendor specific hardware solution.  If not, you could use either the Solaris ZFS File System or the CloneDB functionality provided sine Oracle Database 11g release 11.2.0.3.   More details on the EM12cR4 Snap Clone functionality is provided here.

In the January plugin release, we added additional storage certification, so you can now also use an EMC SAN with ASM to create snap clones.  If you want more details on the Snap Clone and EMC solution, you can find details about it here.

Further Information

You can find more information on the material I've just covered in Part VII of the Cloud Administration Guide in the online documentation here.  You can also watch the screenwatch we recorded to show you the cloning process in action here.

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

Friday May 08, 2015

Vote for Oracle Enterprise Manager 12c

Voting for the 2015 Database Trends and Applications (DBTA) Readers' Choice Awards is now open.

In last year's DBTA Readers’ Choice Awards, Oracle Enterprise Manager 12c won two awards for "Best Database Administration Solution" and "Best Database Performance Solution."

This year Oracle Enterprise Manager 12c has been nominated again in the same two categories; Best Database Administration Solution and Best Database Performance Solution.

Be sure to cast a vote for your favorite management tool, Oracle Enterprise Manager 12c.

The voting will close on May 22nd.

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

Tuesday Apr 28, 2015

EM Compliance ‘Required Data Available’ flag – Understanding and Troubleshooting

Overview

Starting in release 12.1.0.3 of Enterprise Manager a new column was added to the top level Compliance Standard Results page named ‘Required Data Available’. This column is meant to convey whether the data required for proper compliance evaluation of all of the rules within the Compliance Standard for each associated target is available in the repository. If the value for a given target is ‘No’ then the compliance results for that target should not be considered valid. A value of ‘Yes’ indicates the required configuration data is being collected and results valid; at least from a data availability perspective.

One challenge facing customers is the lack of understanding of the column and how to correct the cause of the ‘No’ status. The goal of this guide is to explain how this column’s value is derived and provide some tools to correct the situation.

Read More


Wednesday Apr 22, 2015

Test Drive Oracle’s Application Platform as a Service Solution

We've just launched a new set of workshops in several U.S. cities: Oracle Platform as a Service for Application Development.

This follows the success of the Database as a Service workshop series (see previous blog entry). It’s another opportunity to test drive new Oracle Enterprise Manager capabilities, but it goes far beyond Enterprise Manager. This time we focus on Java development and testing in the private and public cloud, and the cloud operations needed to support them.

So bring your laptop, connect to our live environment and try it for yourself!

The day begins with an overview of APaaS benefits and the architectural choices for building your enterprise private or public cloud (or both). You then use step-by-step workbooks that guide you through creating an application platform / middleware cloud environment. The event is perfect for application developers, IT managers and anyone developing, testing and deploying Java applications.

The time is evenly split between private and public cloud labs. These are the workbooks we’ll go through:

  • Middleware as a Service
  • SOA as a Service
  • Fusion Middleware Provisioning
  • Creating and Exploring Java Cloud Service
  • Building and Deploying an Application with Java Cloud Service
  • Managing Java Cloud Service Operations

Looks interesting? Register for an event near you.

Monday Apr 13, 2015

New Enterprise Manager STIG Compliance Standards for Oracle Database 11gR2 Now Available

Last Friday, Oracle released new Enterprise Manager compliance standards based on DISA’s Security Technical Information Guide ( STIG ) for Oracle Database 11.2g Version 1 Release 2. These standards are specifically for use with Oracle Database 11g Release 2, both single instance and RAC.

This is actually the second compliance content update since February. The previous one included an update to the Oracle Database 11g STIG standard bringing support from Release 8 to 11.

Read More

Wednesday Apr 01, 2015

New TimesTen Plug-in for Oracle Enterprise Manager

Co-contributor:  Simon Law, TimesTen Product Manager 

Last Friday, Oracle released a new version 12.1.0.3 of TimesTen Plug-in for Oracle Enterprise Manager 12c Cloud Control. This is a landmark release with many new features for database administrators in the enterprise.

Besides database performance and availability monitoring; the new plug-in offers administrators the ability to manage and administer their TimesTen instances and databases, such as starting and stopping TimesTen services, loading and unloading databases to and from memory, and scheduling backups and restoring databases. Additionally, users can monitor database and replication activities, memory and disk usages, workload performance statistics, and identify longest running and most executed SQL statements.

International users will be pleased to know that the new TimesTen plug-in was globalized with its user interface translated to nine different languages, the same languages as available in Oracle Enterprise Manager.

TimesTen plug-in 12.1.0.3.0 can be down-loaded through Enterprise Manager Self-Update.

For more information, visit the Enterprise Manager Extensibility Exchange or the Oracle TechnologyNetork (OTN) TimesTen product page.



Monday Mar 16, 2015

Oracle Private Database Cloud: Defining Database Sizes in the Service Catalog

Latest release of cloud plug-in (part of EM12c R4 Plug-in Update 1) brings the ability to define sizes for database cloud services (Schema and PDB services already support definition of size). Prior to this ability, customers were required to define a new template for each size – small, medium, large, etc. This will help in significantly reducing the number of templates required.

So lets see how to use them.

Read More

Discover and Promote Oracle Homes as EM Targets

Typically, Oracle Homes are discovered and promoted as targets automatically along with guided flows for addition of primary targets like databases, weblogic domains, etc, but there might be instances (not very often) where you need to discover the Homes standalone.

There are two ways to do this – from the GUI and using EMCLI verbs.

Read More

Friday Mar 06, 2015

Oracle Database In-Memory Advisor

Recently, Oracle announced the general availability of the Oracle Database In-Memory Advisor—a new capability built into Oracle Enterprise Manager 12c Tuning Pack. With this release, Oracle introduces new and extensive capabilities for managing Oracle Database In-Memory, an Oracle Database 12c Enterprise Edition option.

Oracle Database In-Memory can be used to improve queries on a variety of OLTP and/or data warehouse operations. The In-Memory Advisor helps to optimize performance with recommendations to run analytics processing faster. It gives customers insight into the sizing of the workload and offers actionable recommendations for running workloads at peak performance. The Advisor analyzes workloads and related objects making specific recommendations to which objects would give you the greatest benefit and performance if they were placed In-Memory.

Key Capabilities:

  • Assists with In-Memory size selection
  • Recommendations for tables, partitions and sub-partitions for a given In-Memory size
  • Uses workload and performance data to prioritize objects
  • Takes into account differences in disk and memory footprint, as well as compression ratios

Actionable Recommendations

  • Workload based cost/benefit analysis
    • Cost: Offers estimated memory size with various compression options
    • Benefit: Offers estimated database time reduction metrics for workload processing
  • In-memory area population plan

Reporting

  • Ability to vary In-Memory size to receive specific loading plan
  • Generates DDL scripts with all the tables/partitions/sub-partitions recommended
  • Top SQL benefits from any given configuration

For more information, visit the Oracle Database In-Memory Advisor page on the Oracle Technology Network. You can download the In-Memory Advisor, via MOS note 1965343.1.


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

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

9:00 AM start


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

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

9:15 AM – 10:15 AM

South Seas H

10550

Angelo Rosado, Oracle

SIG: OAUG Oracle Enterprise Manager for Applications Special Interest Group

10:45 AM – 11:45 AM

South Seas H

10083

James Lui, Aramark

Erik Benner, Mythics

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

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

 Updated March 10, 2015

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
About

Latest information and perspectives on Oracle Enterprise Manager.

Related Blogs




Search

Archives
« May 2015
SunMonTueWedThuFriSat
     
1
2
3
4
5
6
7
9
10
11
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
      
Today