Oracle EBS R12.1 Virtualisation

Since v4.0 Delphix has had the ability to Virtualise Oracle E-Business Suite (EBS) environments – (Database, Database Tech Stack & Apps Tier), in this post I will provide a quick walkthrough on how you can configure Delphix to Virtualise your EBS environment.

For this walkthrough I have built an R12.1.1 VIS environment running on a non-RAC Database server and single Application server with the directory structure below.

Before you can begin Virtualising your EBS environment you need to register the Source & Target EBS Database and Application Server and Operating System user accounts within Delphix, you can do this by using the Delphix UI thus:

Manage -> Environments -> Add Environments providing your Oracle EBS database (oracle) and Application owner (applmgr) accounts details for the Source and Target Servers.

Virtualising Oracle EBS Database Tech Stack

We are now ready to start Virtualising the Oracle EBS environment, in this example I am going to start with the EBS dbTech Stack.

As you can see below I have set the Data Type to ‘builtin:ebs-db’, this lets Delphix know that you are planning to manage an EBS Oracle Home,  the ‘Environment User’ is set to my Oracle EBS database owner and ‘Data Path’ to the top level directory.

Delphix provides the ability to exclude directories from the dSource, as I have my Oracle database files located under my top level directory I have excluded db/apps_st/data (relative path) as my datafiles will be managed by the database dSource and do not want to import them twice.

I have also excluded ‘bump’, ‘cdump’, ‘udump’ and the ‘diag’ directories as I do not want the log files in my Virtual clones

 

 

 

 

 

 

 

 

 

 

 

Check your entries and if OK click ‘Next’

It’s good practice to give your dSource a meaningful name, I have included the environment name and type in the dSource name to help with the description

 

 

 

 

 

 

 

 

 

 

 

 

 

Select your ‘Target Group’ and then click ‘Next’

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Review the summary screen and if OK click ‘Finish’

Delphix will now kick off a Job to ingest the Oracle Tech Stack, the time taken will be dependent upon your network and infrastructre. My 9.28GB Oracle Tech Stack compressed down to 5.57GB (1.6:1 ratio)

Virtualising Oracle EBS Database

If you have used Delphix to Virtualise a Database before you will be familar with the next steps but I have included them here for completeness.

Click on ‘Add dSource’ select your source EBS Database, and enter the Delphix database username and password.

 

 

 

 

 

 

 

Verify the credentials and if all OK click ‘Next’

 

 

 

 

 

 

Select ‘Target Group’ and click ‘Next’

 

 

 

 

 

 

Take defaults to perform an immediate Load

 

 

 

 

 

Review the settings and click ‘Finish’, Delphix will now kick of a Job to ingest the Oracle Database, the time taken will be dependent upon database size, network and infrastructure.

Virtualising Oracle EBS Apps Tier

It’s now time to Virtualise the Oracle EBS apps Tier.

Here I have set the Data Type to ‘builtin:ebs-app’, this lets Delphix know that you are planning to manage an EBS Oracle Apps Tier the ‘Environment User’ is set to my Oracle EBS Application owner and ‘Data Path’ to the top level directory.

As the Oracle post clone process will recreate the $INST_TOP we can exclude that from the Apps Tier dSource, provide the relative path to $INST_TOP if located under your top level directory.

 

 

 

 

 

 

 

 

 

 

 

 

Check you ‘Environment User’, ‘Data Path’ and ‘Paths to exlude’ and click ‘Next’

Enter a meaningful dSource Name and select Group as before

 

 

 

 

 

 

 

 

 

 

 

 

Review and click ‘Next’

 

 

 

 

 

 

 

 

 

 

 

 

Click ‘Next’ to take the defaults

 

 

 

 

 

 

 

 

 

 

 

Review the summary screen and if all OK click ‘Finish’

Delphix will now kick of a Job to ingest the Oracle Apps Tier, the time taken will be dependent upon your network and infrastructre.

We have now Virtualised our entire Oracle EBS environment (DB Tech Stack, Database and Apps Tier) within Delphix, in my next post I will walkthrough how can use it to create multiple Virtual Oracle EBS environments on premises or in the Cloud.