Oracle E-Business Suite R12.2.5 Fresh Install – Part II

Oracle EBS R12.2.5 Installation

Navigate to ../startCD/Disk1/rapidwiz an launch rapidwiz

As you can see from below the installation is going to include Oracle 12cR1 RDBMS.

Welcome

Review and click ‘Next’

Wizard1

Select ‘Install Oracle E-Business Suite Release R12.2.0’, click ‘Next’

config_choice

Select ‘Create a new configuration’, click ‘Next’

global_settings

Update Port Pool if required, click ‘Next’

database_node

Update Database Node Configuration, click ‘Next’

primary_app_node

Update Application Node Configuration, click ‘Next’

App_user_info

Update Application User Information, click ‘Next’

node_info

Review node information, click ‘Next’

validation

Review ‘Validate System Configuration’, click ‘Next’

review

Review summary, click ‘Next’

Installing

Click ‘Next’ to start install

Missing Java library

rw-50004

The above failure is due to a missing java library file, this can be fixed with the below.

$ORACLE_HOME/javavm/jdk/jdk7/lib/libjavavm12.a lib to $ORACLE_HOME/lib/

If your quick you can copy it whilst rapidwiz is installing the Oracle Home, otherwise you will have to clean-up the oraInventory and star rapidwiz again.

RMAN failure

The installer will try to restore the data files using RMAN, previous releases just unzipped the files, the installer will continue for a while until.

RMAN-04014: startup failed: ORA-01127: database name ‘OLDDBNAME’ exceeds size limit of 8 characters

This can be fixed by updating the RMANinit.ora file and restarting rapidwiz e.g.

/u01/oracle/VIS/12.1.0/dbs/RMANinit.ora
db_name=OLDDBNAME
to
db_name=VIS

Perl Segmentation fault

Another, problem you may encounter with your Oracle EBS R12.2.5 install is a perl ‘Segmentation fault’

$ pwd
/u01/oracle/VIS/12.1.0/perl/bin
$ ./perl -v
Segmentation fault

$ cd $ORACLE_HOME
$ mv perl/ perl.old/
$ mkdir perl

Change directory back to your downloaded version and re-compile.

$ cd
$ cd perl/perl-5.14.1
$./Configure -des -Dprefix=$ORACLE_HOME/perl -Doptimize=-O3 -Dusethreads -Duseithreads -Duserelocatableinc ; make clean ; make ; make install

$ cd $ORACLE_HOME/perl
$ rm -rf lib/ man/
$ cp -r ../perl.old/lib/ .
$ cp -r ../perl.old/man/ .
$ cp ../perl.old/bin/dbilogstrip bin/
$ cp ../perl.old/bin/dbiprof bin/
$ cp ../perl.old/bin/dbiproxy bin/
$ cp ../perl.old/bin/ora_explain bin/

Rapidwiz Completion

Once the installed is complete you can now confirm your EBS and database versions using the following:

SQL> select release_name from apps.fnd_product_groups;
SQL> select * from v$version;

In part III of this BLOG series I will share the steps to upgrade from R12.2.0 to R12.2.5

A Quick look at Delphix Cross Platform Provisioning

Why Cross Platform Provisioning (XPP)

As a consultant I am fortunate to get the opportunity to work and speak with many customers across the whole of EMEA, a topic which is often discussed is the use of the Linux or the ‘Cloud’ for Development and Test teams. I will cover how you can migrate data to the Cloud in a future Blog post, but today I want to get you ready for the Cloud.

The migration of databases to Linux on commodity hardware on-premise or in the Cloud continues to grown year-on-year as IT departments look to reduce their infrastructure and operational costs and also provide greater Agility to the Business. However Unix is far from dead and not everyone is looking to migrate their Production systems to Linux quite yet. This a great example of where Delphix XPP can be used to provide Virtual Development and Test databases on Linux whilst retaining Production on Unix.

Validate Source

If you have a Unix dSource or VDB you may have noticed the ‘Transform to Linux’ option on your dashboard, this Service-lead feature provides an automated approach to the traditional labour intensive challenge of performing Endianness conversion, e.g. Unix (Big Endian) to Linux (Little Endian).

During the validation Delphix will spin-up a temporary VDB, therefore before you start you need to ensure that your Unix staging server has had the ‘Use as Staging’ enabled from within the Server Environment.

Validate dSource

To get started Open up the dSource or VDB card, and click on the ‘Linux’ tab, from here click on the Green Tick to validate the ‘Linux Transformation’. Delphix will then perform a series of checks against known Oracle restrictions including:

  • No encryption – Columns / Tablespaces
  • Locally managed tablespaces (not dictionary managed)
  • Tablespaces are self-contained
  • Restrictions surrounding XML Types, Spatial Indexes and Advanced Queries

Transform to Linux

If the Validation process fails, use the download the ‘Transformation’ text file to assist in identification and correction of the errors reports. Perform required updates and recommended changes to the Transformation script and Upload and repeat Validation step until successful validation.

Successful Validation

Now that you have Validated dSource / VDB the previously greyed out ‘Transform to Linux’ will be available allowing the Provision of Linux VDB’s

Validated dSource

Click on ‘Transform to Linux’ and follow the Delphix Provisioning wizard providing Database name and Mount Point as normal.

Provision Linux VDB

Delphix and DB2 ‘Air Gapped’

Delphix v5.0

Delphix v5.0 introduced many new feature including Secure Replication, SDD (Selective Data Distribution) and Oracle E-Business Suite Multi-Node, but in this Blog I am going to give the new DB2 functionality a test drive.

Delphix and DB2

The Delphix DB2 solution uses DB2 High Availability Disaster Recovery (HADR) capability to synchronise data from a Production DB2 database into a Delphix managed DB2 ‘Standby’ server. Delphix is able to automatically ingest data and keep the standby server in sync with only a minimal impact on the Production system. DB2 HADR is configured to be Super-Asynchronous (SUPERASYNC) so that log writes are considered successfully transmitted when the log records are sent from the primary database and therefore does not cause any Production delay.

DB2 HADR Standby
DB2 HADR Standby

 

 

 

 

 

 

 

 

 

 

 

Delphix strongly recommends the use of DB2 a High Availability Disaster Recovery (HADR) Standby as this provides an far superior RPO (Recovery Point Objective) and provides Delphix a fully automated sync with Production.

Getting Started

Being an Oracle guy with little DB2 experience I thought I was the perfect person to see how easy it is to get going with Delphix and DB2. After checking out the Delphix DB2 Docs, Rahul Nair’s excellent YouTube DB2 video I felt pretty confident to use Delphix and DB2.

DB2 Air Gapped

Whilst working with an existing Delphix customer and providing an update on the exciting support of DB2 within Delphix v5.0 I was given an edge case challenge.

The customer shared that they were unable to implement HADR and we needed to treat Production as ‘Air Gapped’, they were able to take backups and arrange for the transport of these but Delphix would not be able to interact with Production or a Standby server.

To demonstrate the process I performed the below on my Linux DB2 10.5.5 SAMPLE database.

Performed an On-Line backup using the following:

db2 connect to SAMPLE
db2 backup database SAMPLE online compress include logs

I then manually transferred the SAMPLE database backup file using scp with SHH Password less configuration.

Updated my Delphix Engine environment details, and then added a dSource using the Delphix UI.

Adding a DB2 dSource

As we are not planning to use HADR as this solution is ‘Air Gapped’ I have unchecked the HADR box.

I then clicked the ‘+’ to add the additional database information – Database Name and Backup Path

Adding DB2 dSource
Adding DB2 dSource

 

 

 

 

 

 

 

 

 

 

 

 

Click’ next and at the next screen provide a dSource name and click next again.

On the following screen specify the Staging server and Staging Mount Path

Adding Staging details
Adding Staging details

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

We can now ‘Click’ next and finally ‘Finish’ after reviewing the summary.

Delphix will now ingest the backup and create the initial dSource

Provisioning a Virtual Instance

To Provision a new Virtual Instance select either a dSource or existing virtual instance and click on the ‘+’ provision icon.

Select DB2 installation path and environment user, then click next.

Provide vFiles name and select folder, then click next until you get to the summary screen and click ‘Finish’

Provision DB2 Virtual Instance
Provision DB2 Virtual Instance

 

 

 

 

 

 

 

 

 

 

 

 

 

Performing Manual SnapShots

As we are not using HADR, we can’t use Delphix’s in-built policies to schedule and Snapshots so these need to be initiated manually.

This can be triggered via the Delphix CLI or automated using the Delphix SSH password less authentication.

e.g.
Grant access for the target user if not same as source user
db2 grant dbadm on database to user ${TARGETUSR}

Take a Full on-line backup
db2 backup database ${DATABASE} online compress include logs

Initiate backup file transfer
scp ${NEWBACKUP} ${STANDBYUSR}@${STANDBYSVR}:/home/${STANDBYUSR}/

Perform SnapShot
ssh delphix_admin${DELPHIX_ENGINE}”
${SSH_CMD} “version 1.7.0; cd database; select STANDBY; sync; set resync=true; commit; exit;”

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.