In this series of Blog posts I will detail how you can build an Oracle EBS 12.2.6 environment with VirtualBox for use on a laptop / PC.
Logon to the Oracle Software Delivery Cloud using you SSO credentials and search for ‘Oracle Virtual Appliance‘ , select the Product as below and click ‘Continue’ to download the Oracle VM Virtual Appliance for Oracle E-Business Suite.
Compatible with VirtualBox
As you can see from above, the Oracle VM Virtual Appliance for Oracle E-Business Suite supports both Oracle VM and Oracle VirtualBox. Once download the Virtual Appliance can be imported into VirtualBox for running on a laptop / PC.
The Oracle VM Virtual Appliances for Oracle E-Business Suite 188.8.131.52.0 for x86 64bit is packaged in 19 files requiring 69.4 GB, so may take some considerable time to download depending upon your network / internet connection.
You can download the 19 Oracle VM Virtual Appliances files individually by clicking on the file name or them all use wget, if you have never used wget you can read the following post on how to use wget for downloading.
The distribution includes the entire Oracle EBS Technology and Apps stack including the example Vision database.
Oracle EBS non-Production environments often have complex topologies, usually with separate database and application tiers, often with multiple Application servers. The recent Delphix v5.0 releases addressed this challenging requirement with the introduction of support for multiple Application Servers ‘Multi-Node’.
I thought it was a good time to revisit how Delphix virtualises a complete Oracle EBS environment including dbTech stack, Database and AppsTier and also provide a brief overview of Delphix EBS capabilities per release.
Delphix v4.0 was the first release to provide full stack Oracle EBS R12.1.x cloning, R12.1 was selected as it remains one of the most widely EBS deployed versions even though it’s getting quite long in the tooth now as you can see from below.
Amazing to think R12.1 was GA (Generally Available) May 2009.
Delphix v4.2 was another important release extending support to include the terminal release of 11i (184.108.40.206) and R12.2.x and it’s use of the WebLogic Application Server.
The latest version of Oracle EBS R12.2.5 went GA Oct 2015, this is also fully supported by Delphix.
Delphix v4.3 provided access to JetStream automation, with it’s Ordered Containers environment level management was now possible as you could specify the sequence of operations e.g.
Delphix v5.0 now provides Out-of-the-Box support for multiple Application servers ‘Multi-Node’, this has previously been possible but required some development effort outside of Delphix.
You can now add additional Application servers to a Delphix Managed Oracle EBS environment from with the Delphix UI with a few extra clicks during initial provisioning or later on during configuration changes.
Configure as normal then click on the green ‘+’
Provide Environment, OS User, Hostname, required Services and Display variable details, the Port Pool will be inherited from the primary Apps server
OS User must the same UID (User ID) and GID (Group ID) as the primary Apps server.
Click ‘Next and complete the Wizard to finish to your EBS Multi-Node deployment
Over the past 25 years I worked for various clients in the Defence, Aerospace and Finance industries, one business challenge which I frequently come across is ‘Data Masking’. During many engagements I frequently have to consider the management and use of many different security classifications and types of data, my experiences suggest that even though everyone agrees and acknowledges the need for ‘Data Masking’ it’s largely been parked or ignored, I believe this could be due to many factors including:
Required time to implement traditional Data Masking solutions
Experience of failed Data Masking projects
Unknown impact on existing process and productivity
Lack of application and data knowledge
No Data Masking tools and or skills
Undocumented database interdependencies, schemas and tables
Historically the approach taken by many of these organisations to mitigate the lack of Data Masking and the associated risk of data loss was to rely on Physical and Network security.
Organisations have and continue to invest heavily in physical and network security implementing physical and organisational access control system and ‘Hardening’ the outer shell of their corporate networks by deploying Firewalls, De-militarised (DMZ’s), Intrusion Detection Systems (IDS) and Anti Virus (AV) solutions. The Application and Data access layers have remained the poor relation.
As we can see from my Security Onion this approach has only addressed part of the problem, the biggest cause of data loss continues to be internal incidents, be that intentional or accidental. This problem has grown considerable over the last few years with a high number of very public data breaches and will only increase as organisations embrace the ‘Cloud’ and migrate more and more development and test activities to partners, 3rd parties and off-shore teams.
Remember we should need to consider all the layers of data access, do you know everyone who has access to your non-Production data, are you part of their HR on-boarding process ?
This is where Data Masking has a significant role to play in Risk mitigation for Data Loss
Delphix Agile Data Masking
During the summer Delphix announced the Delphix Compliance Engine so I thought I would get the top down and take it out for a Test Drive against an Oracle Vision R12.1 database to see how easy it is to get up and running.
Having worked on Defence ‘Black’ projects I have seen data security issues with Project descriptions, so I thought I would try masking Project descriptions for this posting.
A quick query of the PA_PROJECTS_ALL table before I applied any Masking rules.
After logging onto the Agile Data Masking UI I configuring my database connection, I uploaded some masked data (a text file with DESCRIPTION1 to DESCRIPTION600) I then selected the ‘PA’ schema and navigated to the ‘PA_PROJECTS_ALL’ table and selected the ‘DESCRIPTION’ column, provided Domain and Algorithm and was ready to create and run my Masking Job
Now a couple of clicks to create the Masking Job
A check of Job completion summary screen
Now lets validate that the Oracle EBS R12 form shows the Masked Project description.
Now lets re-run the PA_PROJECTS_ALL query to see the Data Masking results in SQL*Plus
The Delphix Agile Data Masking feature when combined with Database Virtualisation provides a solution that is able to address all the previous concerns and issues with rolling out an Enterprise Data Masking project.
With the Delphix Agile Masking, Delphix Replication and Amazon Web Services (AWS) support you now have all the tools you need to take your Oracle EBS R12 environment up into the Clouds allowing you to share your data with partners, 3rd parties and anyone else you need to collaborate with.
Check out the Delphix Agile Data Masking solution to see how Delphix can address your Data Governance, Data Protection and Security requirements.