Oracle EBS 12.2.6 on VirtualBox

Back in May, Oracle announced the general availability of Oracle VM Virtual Appliance for E-Business Suite 12.2.6 for download from the Oracle Software Delivery Cloud.

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.

Getting Started

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.

Filter

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 12.2.6.0.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.

DownloadQueue

The Download

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.

Virtual_Appliance_SWThe distribution includes the entire Oracle EBS Technology and Apps stack including the example Vision database.

COMPONENT VERSION
RDBMS Oracle Home 12.1.0.2
Application Code Level Oracle E-Business Suite 12.2.6 Release Update Pack (My Oracle Support Knowledge Document 2114016.1) + AD and TXK Delta 8 (My Oracle Support Knowledge Document 2159750.1)
Oracle Forms and Reports 10.1.2.3
WebLogic Server 10.3.6
Web Tier 11.1.1.9
JDK JDK 1.7 build 1.7.0_121-b15
Java Plugin J2SE 1.7
Critical Patch Update (CPU) October 2016

In my next post I will detail how build an Oracle E-BS 12.2.6 environment within VirtualBox.

How to Check Oracle EBS Clone Configuration

How to check Oracle EBS Configuration

An interesting question was raised during a recent discussion on Delphix 5.0 and it’s new Oracle EBS Multi-Node capability.

How can I check what my Oracle EBS Clone topology is?

The simplest way to check your R12 Clone configuration is to use Oracle Applications Manager (OAM).

OAM (Oracle Applications Manager)

Logon to your Oracle R12 clone environment with an account that has the ‘System Administrator Responsibility’

Navigate to ‘Oracle Application Manager’

Select ‘Dashboard’ from here you can easily see a list of Database and Application Servers as well as the status of the services on each server.

 

OAM Configuration

Use SQL

Alternatively logon as ‘APPS’ to SQLPlus and perform the following checks

select INSTANCE_NAME, HOST_NAME from V$INSTANCE;

After a successful running adcfgclone.pl dbTier or adcfgclone.pl database (if database already exists)

You should see your cloned database DB_NAME updated to it’s new value

select DB_NAME from FND_DATABASES;

Once you have completed the AppsTier cloning you can check the Database and Application servers using the following:

select NAME, SERVER_TYPE from FND_APP_SERVERS, FND_NODES
where FND_APP_SERVERS.NODE_ID = FND_NODES.NODE_ID

e.g.

dbCheck

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Oracle EBS Cloning with Delphix 5.0

History of Delphix and Oracle

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.

Below is a diagram I frequently use to describe the Delphix EBS Architecture, step-by-step virtualisation details can be found at one of my previous posts Virtualising Oracle EBS R12.1 using Delphix

Delphix EBS Virtulisation

 

Delphix v4.0

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.

Oracle EBS Releases

Delphix v4.2

Delphix v4.2 was another important release extending support to include the terminal release of 11i (11.5.10.2) 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

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.

1) dbTechStack
2) Database
3) AppsTier

Delphix v5.0

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 ‘+’

Adding Additional Node

 

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.

Adding additional Node

Click ‘Next and complete the Wizard to finish to your EBS Multi-Node deployment

Fast Backups and Restores

I recently came across an excellent post on Mike Swings’ Blog which does a great job is detailing the impact Delphix can have on Oracle EBS deployments, suggest you check it out – Fast Backups and Restores are Critical during EBS Upgrades, Testing and Development

Oracle EBS R12 and Delphix Agile Data Masking

The Business Challenge

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
Data at the centre
Security Onion

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.

PA_PROJECTS_ALL_Pre

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

PA Project All

Now a couple of clicks to create the Masking Job

Create Masking Job

 

A check of Job completion summary screen

Overview

 

Now lets validate that the Oracle EBS R12 form shows the Masked Project description.

Project_Search

Now lets re-run the PA_PROJECTS_ALL query to see the Data Masking results in SQL*Plus

PA_PROJECTS_ALL_Post

Conclusion

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.