Oracle EBS R12.2.6 on Virtual Box Pt2

If you followed my previous post Oracle E-Business Suite R12.2.6 on Virtual Box you will have already downloaded the 19 required zip files, and be ready to go.

Ok, change directory to the location of the downloaded files, unzip and concatenate them into a single OVA file using the following:

$ unzip ‘V*.zip’

$ cat Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.* > Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova

Getting started – Virtual Box

Start Virtual Box and navigate to File -> Import Appliance

Click on ‘Expert Mode’ and edit the ‘Virtual Disk Image’ path to a location with adequate space (~500GB), in this example I am using my Samsung Portable SSD T1 1TB dive mounted at ‘/Volumes/Samsung_T1’

OVA_import

Click ‘Import’, go to lunch or grab a coffee and watch the progress bar if you prefer, the remaining time will re-calulate periodically.

Importing

Once complete, start up your new Oracle EBS R12.2.6 VM from within Oracle VirtualBox

Oracle E-Business Suite R12.2.6

inital_boot

The initial boot will prompt you to change the ‘root’, ‘oracle’ and ‘applmgr’ passwords, the process will continue to start and configure an Oracle 12.1.0.2 database called ‘EBSDB’.

VISION

Use ifconfig -a’ to determine your VM’s IP address from you VirtualBox console before using SSH from your host to connect using your preferred client.

Add the IP address to your local ‘/etc/host’ file so your browser can resolve your Oracle EBS VISION sandbox environment. e.g.

#
192.168.0.23 apps.example.com apps
#

Change directory to ‘/u01/install/APPS/scripts’ to access the database and application stop / start scripts and run ‘startdb.sh’ and ‘startapps.sh’

  • startdb.sh
  • stopdb.sh
  • startapps.sh
  • stopapps.sh

Shell

[oracle@apps scripts]$ ./startdb.sh
Logfile: /u01/install/APPS/12.1.0/appsutil/log/EBSDB_apps/addlnctl.txt

You are running addlnctl.sh version 120.4

Starting listener process EBSDB …

LSNRCTL for Linux: Version 12.1.0.2.0 – Production on 15-AUG-2017 07:42:19

Copyright (c) 1991, 2014, Oracle. All rights reserved.

Starting /u01/install/APPS/12.1.0/bin/tnslsnr: please wait…

TNSLSNR for Linux: Version 12.1.0.2.0 – Production
System parameter file is /u01/install/APPS/12.1.0/network/admin/EBSDB_apps/listener.ora
Log messages written to /u01/install/APPS/12.1.0/admin/EBSDB_apps/diag/tnslsnr/apps/ebsdb/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=apps.example.com)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=apps.example.com)(PORT=1521)))
STATUS of the LISTENER
————————
Alias EBSDB
Version TNSLSNR for Linux: Version 12.1.0.2.0 – Production
Start Date 15-AUG-2017 07:42:19
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/install/APPS/12.1.0/network/admin/EBSDB_apps/listener.ora
Listener Log File /u01/install/APPS/12.1.0/admin/EBSDB_apps/diag/tnslsnr/apps/ebsdb/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=apps.example.com)(PORT=1521)))
Services Summary…
Service “EBSDB” has 1 instance(s).
Instance “EBSDB”, status UNKNOWN, has 1 handler(s) for this service…
The command completed successfully

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /u01/install/APPS/12.1.0/appsutil/log/EBSDB_apps/addlnctl.txt for more information …

You are running addbctl.sh version 120.1

Starting the database EBSDB …

SQL*Plus: Release 12.1.0.2.0 Production on Tue Aug 15 07:42:19 2017

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to an idle instance.
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size 2926472 bytes
Variable Size 1308625016 bytes
Database Buffers 822083584 bytes
Redo Buffers 13848576 bytes
Database mounted.
Database opened.
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

addbctl.sh: exiting with status 0

[oracle@apps scripts]$ ./startapps.sh 
Starting the Oracle E-Business Suite Application Tier Services
You are running adstrtal.sh version 120.24.12020000.11

All enabled services for this node are started.

adstrtal.sh: Exiting with status 0

adstrtal.sh: check the logfile /u01/install/APPS/fs1/inst/apps/EBSDB_apps/logs/appl/admin/log/adstrtal.log for more information …

Before you can logon you will need to enable SYSADMIN and the Demo accounts, Oracle have provided scripts to do this  e.g.

[oracle@apps scripts]$ ./enableSYSADMIN.sh

This script will let you set a new password for the SYSADMIN EBS Applications User, the default password most likely was “sysadmin”, so pick a different one now.

Enter new password for SYSADMIN:
Re-enter password for SYSADMIN:
Changing password for SYSADMIN
Log filename : L7583909.log
Report filename : O7583909.out
[oracle@apps scripts]$

[oracle@apps scripts]$ ./enableDEMOusers.sh

Enter a new password for the EBS Applications Users, the default password
most likely was “welcome”, so pick a different one now…

Enter new password for DEMO users:
Re-enter password for DEMO users:
Setting password for DEMO users…
Log filename : L7583911.log

[oracle@apps scripts]$

Oracle EBS R12 Dashboard

You should now be able to logon as ‘SYSADMIN’ or explore your Oracle EBS R12.2.6 VISION sandbox environment using the Demo users (see below) and the password defined above at: http://apps.example.com:8000/

“AFENG”, “AMARLIN”, “AMILLER”, “APOTTER”, “BPALMER”, “BWEBB”
“CBROWN”, “CONMGR”, “CONTMGR”, “CSADM”, “DBAKER”, “EBUSINESS”
“FBRAMER”, “HRMS”, “ILANG”, “ISUPPORTADMIN”, “JFROST”
“KJONES”, “LJONES”, “MFG”, “MGRMKT”, “MNT”, “OPERATIONS”
“PHENRY”, “PIMMGR”, “PLMMGR”, “PROCESS_OPS”, “PROJMFG”
“PSTOCK”, “RBATES”, “SCRIPTUSER”, “SERVICES”, “SFM”
“SPAIN”, “SVYADMIN”, “TRADEMGR”

Sales_Dashboard
Sales Dashboard – LJONES
Advertisements

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.

Downloading Oracle E-Business Suite R12.2.6 using wget

When it’s time for you to next download the Oracle E-Business Suite media you better plan ahead as it’s getting big, really big, R12.2.6 is now over 83GB and could take a considerable amount of time if your downloading it interactively.

Fortunately Oracle’s e-delivery website can help out.

Select your Options

Firstly, uncheck all the ‘Oracle E-Business Suite Languages (12.2.0.0.0)’ and ‘Oracle E-Business Suite Languages (12.2.6.0.0)’ not required.

Now, if you are only performing a ‘VISION’ installation you can uncheck the all files labeled ‘Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD – Disk X’.

Alternatively, if you don’t want the ‘VISION’ database uncheck all the files labeled ‘Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION – Disk X’.

WGET Options

Now we have selected our files, look for ‘WGET Options’ in the bottom left corner and click the link.

edelivery

This opens up a new window allowing you to download a wget script, hit ‘Download.sh’ to download the script to your desktop.

wget_options

Great, you now have a script you can run on your Linux/Unix server to ‘pull’ back all the files, you now need to copy the wget script to your server using scp for example.

Once copied over, open the script in your editor of choice, and find the references to ‘SSO_USERNAME’ and ‘SSO_PASSWORD’.

Update these to your Oracle SSO (Single Sign-On) credentials, save the file and then change the permissions to 755 to make it executable and your now good to go.

# SSO username and password
#read -p ‘SSO User Name:’ SSO_USERNAME
#read -sp ‘SSO Password:’ SSO_PASSWORD
SSO_USERNAME=john.smith@oracle.com
SSO_PASSWORD=maryjane

Note: The WGET download script does not provide any feedback about whether or not the script was successful. Therefore you need to view the log file to verify the download was a successful or to troubleshoot any issues. The log file by default will be called wgetlog-.log, however you can change the name and location in the wget script file by setting the following:

# Log directory and file
LOGDIR=.
LOGFILE=$LOGDIR/wgetlog-`date +%m-%d-%y-%H:%M`.log

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 E-Business Suite Clone Log Parser utility

Oracle EBS Log Parser

As anyone who has ever performed an Oracle E-Business suite clone knows it can be a complex time consuming task,  any error during the cloning process may result in a considerable amount of time been spent reviewing multiple clone log files in various directories on the Apps & Database tiers. To assist with this challenge the Oracle Proactive Support Team developed the ‘Log Parser’, this utility is able to consolidates error information from the 12 seperate clone log files into a easy to read HTML report. The ‘Log Parser’ also perform some basic configuration checks and reports this along with useful recommendations and the Oracle support pages links.

The Log parser analyses the following logs:

  • StageDBTier.log
  • StageAppsTier_.log
  • ApplyDBTier.log
  • ApplyDatabase.log
  • ApplyDBTechStack.log
  • ApplyAppsTechStack.log
  • ApplyAppsTier.log
  • CloneContext.log
  • make_.log, make.log
  • adconfig.log
  • ohclone.log
  • adcrdb_.txt
  • NetServiceHandler.log
  • setup_stubs.log
  • Central/Global oraInventory/logs directory and all sub-directories, for any files with a .err, .log or .txt extension

Installation

The installation couldn’t be much simpler – download, extract, run

You can download the ‘Log Parser’ directly from ‘My Oracle Support’  – E-Business Suite Clone Log Parser Utility (Rapid Clone 11i,12.0, 12.1) (Doc ID 1447553.1)

1447553

Database Tier

Download the ‘Log Parser’ zip file into /tmp and unzip the file into $ORACLE_HOME/appsutil/clone

Screen Shot 2015-01-07 at 10.49.10

Once you have unzipped the Log Parser your a ready to navigate to the LogParser directory and run the LogParser perl script.

Screen Shot 2015-01-07 at 11.27.34

On completion you will have a new HTML report available for your review

Screen Shot 2015-01-07 at 11.30.59

Transfer this back to your desktop an open in your preferred browser, click on the ‘Show Details’ links in the various sections to expand the report.

Screen Shot 2015-01-07 at 11.35.28

Applications Tier

Download the ‘Log Parser’ zip file into /tmp and unzip the file into <COMMON_TOP>/clone

Screen Shot 2015-01-07 at 18.55.48

Once you have unzipped the Log Parser your a ready to navigate to the LogParser directory and run the LogParser perl script.

Screen Shot 2015-01-07 at 19.01.48

On completion you will have a new HTML report available for your review, as before click on the ‘Show Details’ to expand the report.

Screen Shot 2015-01-07 at 18.56.22

Transfer this back to your desktop an open in your preferred browser.

Screen Shot 2015-01-07 at 19.06.07

In a future post I will walk through the Log Parser report and review the output.

Oracle EBS and Delphix

The Delphix EBS solution provides AppsDBA’s, functional consultants, test teams and business users the ability to perform Self Service on-demand EBS environment (Database, Database Tier & AppsTier) clones. This dramatically reduced the end-to-end provision time coming down from multiple weeks to a mater of minutes.

In a couple of previous posts I have provided a walkthrough of how to Virtualise your EBS environment and also how to create a new Virtual EBS environment.

 

 

 

Taking Oracle EBS R12 up into the Clouds with Delphix

Getting ‘Cloud Ready’

In my previous Oracle E-Business Suite (EBS) Virtualisation postings I have shown how Delphix can be used to Virtualise your EBS environment, and then how it can be used to to provision new virtual EBS environments.

Part 1: Virtualising Oracle EBS R12.1 using Delphix

Part 2: Creating a Virtual Oracle EBS Environment using Delphix

Now that we are ‘Cloud Ready’ I will show how we can use Delphix Replication to migrate your Oracle EBS environments into the Cloud.

Delphix supports the Amazon Elastic Cloud Compute (EC2) platform, and has also recently announced support for VMware vCloud Air.

i2Family
Amazon i2 Family

Note: When using choosing your Amazon Cloud instance for Delphix select a storage optimised instance type from the I2 family. The larger instances provide greater CPU and memory, the more memory you can give your Delphix Engine the better as this will be used as a cache improving read performance.

 

The I2 This family includes the High Storage Instances that provide very fast SSD-backed instance storage optimized for very high random I/O performance, and provide high IOPS at a low cost. 

Delphix requires that the all the storage attached be Amazon Elastic Block Store (EBS), Delphix does not support the use of instance store volumes

Using the Cloud

EBS Replication
Oracle EBS Replication with Delphix

In the example above the On-Premise Oracle R12 environment (Database, dbTech Stack & Apps Tier) are all replicated to a Delphix E2C instance.

This provides an extremely Agile deployment model where Production, Prod Support, Development, Test, Integration, Acceptance Testing and Training can all be hosted where makes best sense for the business.

It is becoming increasling common to see Production On-Prem and non-Prod in the Cloud, this could be as part of a longer strategic journey to the Cloud, with quick wins being delivered by using ‘Compute On-Demand’ or the final architecture.

When customers look at ‘SaaS’ based solutions a requirement which is frequently overlooked and can be challenging for non-Virtualised solutions is business reporting and integration. Very few organisations rely on a single business solution and often struggle to get their data out of the hosted solution. This is example where a Cloud Delphix Engine could be used to replicate back to On-Prem Delphix Engine, providing the business access to the required data.

Configuring Delphix for the Cloud

To get started logon to your Source Delphix Engine as a Delphix Administrator

EBS_Source

 

Navigate to System -> Replication

 

 

 

 

 

Provide Replication Target IP Address, Username and Password, configure Schedule and Network Options.

Source_Rep1

 

Hit OK

Source_Rep2

 

Click on ‘Run Now’ to start the Replication process

 

Target_Rep1

You can now Logon to the empty Target Server and from the pulldown select the Source Server and check the ‘Active Jobs’ to see the Replication process.

Target_Post

 

Now that you have Virtualised your Oracle EBS environment, configured Delphix Replication and Replicated the dSource and VDB’s to your Target server you are free to ‘Cloud Burst’, expanding and shrinking the number of EBS environments in-line with business demand.

For further information on how Delphix can be used to support your Data Migration projects visit the Delphix web site

 

Creating a Virtual Oracle EBS Environment using Delphix v4.1

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 2nd post I will provide a detailed walkthrough on how you can use Delphix to provision a Virtualised 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.

EBS R12.1
Oracle EBS R12.1 directory structure

In my previous post Virtualising Oracle EBS with Delphix  I showed how to injest an Oracle R12.1 EBS environment into Delphix, I will now walkthrough the steps to provision a full Oracle EBS R12.1 environment (Database, Database Tech Stack & Apps Tier onto a non-RAC database server and single Application server.

Provision Database Tech Stack

From the Delphix console select your Environment dbTech Stack we created in part 1 of the Blog and select your Target Oracle EBS Database server and update the fields as required, if like me you prefer to have each EBS environment running as a different OS user select the ‘Environment User’ from the pick list.

dbTech Stack - Target Environment
dbTech Stack – Target Environment

 

 

 

 

 

 

 

 

 

 

 

 

Select your Target ‘Group’ and ‘Snapshot Policy’

dbTech Stack - vFiles Configuration
dbTech Stack – vFiles Configuration

 

 

 

 

 

 

 

 

 

 

 

 

 

Click ‘Next’

dbTech Stack - Hooks
dbTech Stack – Hooks

 

 

 

 

 

 

 

 

 

 

 

 

Review and Click ‘Finish’

dbTech Stack - Summary
dbTech Stack – Summary

 

 

 

 

 

 

 

 

 

 

 

  Provision EBS Virtual Database (VDB)

During the previous step we provision an EBS Oracle Home on the Target Database server, we can now use our new Virtual Oracle Home to provision our Virtual EBS Database (VDB). Enter database name and set the ‘Environment User’ to the same value as the previous step.

Provision VDB - Target Environment
Provision VDB – Target Environment

 

 

 

 

 

 

 

 

 

 

 

 

Provide VDB name and Group, Click Next

Provision VDB - VDB Configuration
Provision VDB – VDB Configuration

 

 

 

 

 

 

 

 

 

 

 

 

 

Click ‘Next’ on the Hooks screen.

Review Summary and Click ‘Finish’ to start the VDB provision process.

Provision Apps Tier

We should now have our EBS Virtual database running on our Target Database Server out of it’s own Virtual Oracle Home, the next step is to provision the Apps Tier.

Select the Target EBS Apps Server and complete the ‘Target Environment’ form providing the ‘applmg’ account name the other details which will be used by the Oracle EBS adcfgclone process

Provision Apps Tier - Target Environment
Provision Apps Tier – Target Environment

 

 

 

 

 

 

 

 

 

 

 

 

 

Click ‘Next’

Provide Name and Group and Click ‘Next’

Provision Apps Tier - vFiles Configuration
Provision Apps Tier- vFiles Configuration

 

 

 

 

 

 

 

 

 

 

 

 

 

Click ‘Next’ on the Hooks screen

Review the Summary and click ‘Finish’ to launch the provision of the AppsTier

Provision Apps Tier - Hooks
Provision Apps Tier – Hooks

We have a now a provisioned a full Virtual EBS environment from our Delphix server running on our Target Database & Apps Server

In the final part of this Trilogy I will show how you can use Delphix to provision an EBS environment in the Cloud

Virtualising Oracle EBS R12.1 using Delphix v.4.1

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.

EBS R12.1
Oracle EBS R12.1 Directory Structure

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

Add dSource - Source
Add dSource – Source





 

 

 

 

 

 

 

 

 

 

 

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

Add dSource - dSource Configuration
Add dSource – dSource Configuration

 

 

 

 

 

 

 

 

 

 

 

 

 

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

Add dSource - Summary
Add dSource – Summary

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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.

db1

 

 

 

 

 

 

 

Verify the credentials and if all OK click ‘Next’

db2

 

 

 

 

 

 

Select ‘Target Group’ and click ‘Next’

db3

 

 

 

 

 

 

Take defaults to perform an immediate Load

db4

 

 

 

 

 

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.

ap1

 

 

 

 

 

 

 

 

 

 

 

 

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

Enter a meaningful dSource Name and select Group as before

ap2

 

 

 

 

 

 

 

 

 

 

 

 

Review and click ‘Next’

ap3

 

 

 

 

 

 

 

 

 

 

 

 

Click ‘Next’ to take the defaults

ap4

 

 

 

 

 

 

 

 

 

 

 

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.