Home > Blogs > VMware vFabric Blog


VMware IT Case Study: Refresh Oracle EBS in Hours not Days

In the past, several teams would work to provision an Oracle ERP environment, and it took weeks.

Now, it takes hours.

Whether a new environment is being created or an existing one is refreshed, it literally takes one person a few mouse clicks to initiate an entire environment, and it takes about 10 hours for the complex installation, configuration, and data-restore to run by itself.

Like many companies, one of the most important systems inside VMware is our Oracle ERP system.  It has 7 terabytes of data in the transactional database and records all transactions related to order management, service contracts, install base, customers, accounts receivable, accounts payable, general ledger, and more.  When our IT team set out to start using vFabric Application Director, we decided that this ERP application would be one of the critical places to automate deployments. At the end of the day, our main goal was to have a repeatable, fully automated process for provisioning and configuring an EBS instance.  For those who are interested, we are running:

  • Oracle Database 10gR2 (10.2.0.5.0) on the database tier
  • Oracle EBS 11i (11.5.10.2) on the application tiers (one Concurrent Manager node and one web/forms server node – uses the shared application tier feature)

You can get additional background from this post, and, if you are at VMworld, our sessions on Wednesday and Thursday go into even more detail on the topic of how VMware IT uses vFabric Application Director.

How a Refresh Worked before vFabric Application Director

Learn More

Register for VMworld!
Click Here

Register for Session OPS-CIM2852 – Automated Provisioning for Business Critical Applications (Microsoft/Java) in private or public cloud:
Click Here

Follow all vFabric updates at VMworld on Twitter:
Click Here

Follow us @vmwareappmgmt:
Click Here

Before we explain some of the detail, let us provide more context for the situation:

  • This ERP application impacts a significant number of upstream and downstream systems across multiple Dev, Test, UAT, and Load Test environments.  For all of these systems and environments, people need a snapshot of the Production database and code so that we are working from the current code base and have a clean way to test all use cases.
  • The application supports virtually every department.  Even if a department isn’t a direct user, they are an indirect user in some way.  The main users are from the order management, renewals, support, and finance departments.
  • Since the application supports internal corporate users, we have identity and access management to integrate with.  There are also externally facing customer portals.  And, we have middleware and master data management integrations.
  • Before we implemented this solution, a project manager would head the process and members from several different teams would participate.  Usually, system admins, DBAs, application admins, networking, and storage teams would be involved along with QA and development team members to smoke test.
  • The process was mainly a manual one for the teams. Some steps would include restoring the data from a production back-up, provisioning VMs, obtaining IP addresses, load balancing, installing the database, restoring the data, apps, etc.  This would be managed with tickets and approvals – it was a tedious, error-prone process, and took a lot of time. While steps cloning and application configuration were lengthy efforts, the biggest time waster was hand-offs, approvals, and just waiting for other people. In project management terms, the duration was probably greater than the actual effort.

Fully Automated with the vFabric Application Director Blueprint

Below, we outline the steps of the blueprint in vFabric Application Director and explain what it does to fully automate the entire process.  For various environments, the blueprint stays the same, and the deployment execution plan changes (i.e. logical separation of environment definition from underlying infrastructure). When the blueprint runs, it:

1. Provisions three VMs (Oracle Linux) – one each for Database, Concurrent Manager, and Web/Forms with below OS configuration

  • OEL_EBS_DB: OEL 5.6, 64 bit, 8 vCPU,16 GB memory
  • OEL_EBS_CCM:  OEL 5.6, 64 bit, 4 vCPU, 4 GB memory
  • OEL_EBS_APP:  OEL 5.6, 64 bit, 4 vCPU, 4 GB memory

2. Executes scripts to restore 7 TB Oracle Database and EBS Application Binaries from the gold copy.
3. Executes scripts to create oracle E-business suite database and start DB listeners in DB node.
4. Executes scripts to Configure EBS Concurrent Manager Tier to communicate with EBS database in CCM node.
5. Executes scripts to Configure EBS Web/Forms Tier to communicate with EBS database in App node.
6. Executes scripts to run post-clone steps like scrambling HR data, trunk-ing custom  tables, updating email addresses in workflow tables, make password changes, and more.
7. Executes scripts to start Application Services (CCM, forms, apache) for end user consumption.

The blueprint described above is shown below in the vFabric Application Director UI.

  • At the top left, there is a panel listing application blueprints like the one shown in the middle panel.
  • The bottom left panel shows a list of logical templates (VMs).
  • The top right panel lists application components (JARs, SQL, etc.).
  • The bottom right panel lists services (i.e. middleware and other applications).
  • The middle panel shows blueprint with the three OS configurations mentioned above, the steps to automatically create each, and the dependencies between them.
Please let us know what questions or thoughts you might have in the comments below.  You can certainly find out more on this blog, by reading documentation, or download a trial.

We would also love to see you on Wednesday or Thursday at VMworld for a deeper dive.

  About the Author: Thirumalesh Reddy is Director of Technology Labs and Architecture. He has been with VMware IT for 7+ years. He led the transformation of VMware IT Applications and Technology as VMware grew from $300 Million to $4 Billion dollars. His experience includes Virtualization, Cloud Computing, Private Cloud Automation, vFabric, End User Computing, and Mobile solutions. He has delivered solution across the business including custom enterprise portals, Oracle ERP, Salesforce, Middleware, IAM, and more.

6 thoughts on “VMware IT Case Study: Refresh Oracle EBS in Hours not Days

  1. Ashsih

    Hi Thirumalesh,

    Can i get more information about this product vfabric Application Director , which can reduce the refresh time from 4 days to 4 hours for similar type of environemtn as you have mentioned for R11 and R12.

    Ashish Tiwari
    9818640523

    Reply
  2. کوچینگ

    Bill Gates: Everyone needs a coach (coach). We all need people to give us feedback so that we can improve our performance. One of the founders of large corporations in the world in his memoir about Kuching says: “When I was building my first company, I realized that the biggest limitation in the growth of my company was my personal growth as the founder and CEO. So I hired a coach. Over the course of the months, my ten strategies for strategic development programs, the life of corporate values, helped me through interpersonal situations, and I became much more determined and determined that its worth is unfeasible for me. “

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

*