Senthil Rajendran

Subscribe to Senthil Rajendran feed
The voice in my head may not be real , but they have some good ideas !!!Senthilkumar Rajendranhttps://plus.google.com/106215216686965173274noreply@blogger.comBlogger264125
Updated: 1 hour 48 min ago

Creating a New Single-Node Oracle E-Business Suite Installation on Oracle Cloud

Thu, 2016-06-02 00:36
(adsbygoogle = window.adsbygoogle || []).push({ google_ad_client: "ca-pub-6607084504466173", enable_page_level_ads: true });
Before you read : Please note the documentation and procedures for Lifting and Shifting On-Premise to Oracle Cloud is constantly evolving. Instruction here are high level and recommend to review the latest documentation.

Link : Provisioning a New Single-Node Oracle E-Business Suite Installation in the Oracle Compute Cloud Service

This procedure could be the quickest way of getting an e-business suite 12.2.5 instance in IaaS public cloud.

To the compute account pull either a EBS 12.2.5 Demo Install Vision Image or a Fresh Install Image using Get App method.

Here is the Demo Install EBS 12.2.5 Image



Here is the Fresh Install EBS 12.2.5 Image


Click the Get App and this action would copy the Image to the Compute Storage.


Now with the Image available in the Compute Storage we will be good to start with a new provisioning.

From the Compute Account , Click Create Instance


Search for the Fresh Install Image and Select it


Select the shape of the machine


Give a name to the Instance


Review the storage , at this point if you wish to add more space you can do it or it can be done later once the instance is provisioned.

Finally review and click the Create button


From there the backend operation will take care and the instance will get provisioned. Once the instance is provisioned view the instance from the compute page and log into the instance with the assigned IP and Key.  Validate the environment.

What happens at the back end 
  • fresh image has pre-cloned environment staged and ready
  • first database is prepared using config clone option
  • then the application is prepared using config clone
  • run and patch files system are setup
With this process a base 12.2.5 environment is available to you. From here you can customize to your need. 

Hope this helps ! Thanks for reading.



Oracle AppsUnlimited - Migrate from On-Premise to Oracle Cloud ( Lift and Shift )

Mon, 2016-05-30 04:26

Before you read : Please note the documentation and procedures for Lifting and Shifting On-Premise to Oracle Cloud is constantly evolving. Instruction here are high level and recommend to review the latest documentation.

Link : Migrating an Existing Oracle E-Business Suite Installation to the Oracle Compute Cloud Service

Migrate from On-Premise to Oracle Cloud ( Lift and Shift )

On-Premise Environment 12.1.3 or 12.2 can be moved to cloud , please review the "What Do You Need ?" section to understand the detailed requirement.

Here are the high level steps

  • Identify the EBS environment for lift and shift. Make sure that it meets the requirement for migration.
  • Create the compute infrastructure. Log into the compute service console and create the storage, virtual machines with the computing power required. Format the storage volumes and mount then to the requirement
  • Download the cloning utility Patch 22336899
  • Open the ports between the Source and the Target hosts
  • Update the cln.props which is available inside the patch , ensure that properties MODE and BACKUP_TYPE are commented out as they are used for EBS with DBaaS provisioning.
  • Run the EBS Cloud Clone Utility perl ./ebsclone.pl
  • Run post configuration steps as necessary.

What happens in the backend ?
  • Pre-Clone is run on the DB and MT
  • Necessary files are copied , tarred and compressed
  • Files are moved from On-Premise to Cloud 
  • Config clone is run on the Target Cloud IaaS VMs
Hope this helps.

Oracle AppsUnlimited - Building your Own Machine on IaaS

Sun, 2016-03-20 12:55
To enable Oracle EBS on cloud and to install a fresh EBS Instance of your own choice then you will have to create a image. This image can be build using Oracle Linux (x86, 64-bit) releases 6.4 and 6.6 with kernel 2.6.36 or later.

High Level Steps

  • Source the ISO from E-Delivery
  • Using Oracle Virtual Box create the VM
  • Install Oracle Linux in the VM
  • Add/Enable Sudo to OPC user and specify the keys
  • Change Network Settings
  • Convert VM Image into Cloud Machine Image
  • Upload/Associate the Machine Image to Oracle Cloud
  • Create a VM on Oracle Cloud

Detailed Steps

Source the ISO from E-Delivery and Using Oracle Virtual Box create the VM













Reboot the Linux Image


  • Add OPC user , create authorized_keys from  http://192.0.0.192/latest/meta-data/public-keys/{index}/openssh-key
  • Enable SUDO for OPC User
  • Disable SELinux
  • Stop the iptables service
  • Ensure that there are no hard-coded MAC addresses
  • Update /etc/sysconfig/network-scripts/ifcfg-eth0 with the below lines
    • DEVICE=eth0
    • BOOTPROTO=dhcp
    • ONBOOT=yes
  • Update /etc/sysconfig/network with the below lines
    • NETWORKING=yes
    • HOSTNAME=localhost.localdomain
    • IPV6_AUTOCONF=no
    • NOZEROCONF=yes
  • Shutdown the VM
  • Create the Cloud Image using the below VBox command
    • VBoxManage internalcommands converttoraw OEL6.vdi OEL6.img
    • cp --sparse=always OEL6.img OEL6sp.img
    • tar -czSf OEL6_Cloud_Image.tar.gz OEL6sp.img
  • Access Compute Account and upload OEL6_Cloud_Image.tar.gz



Create an Instance






Access the Instance using the Public IP and the Key. 

With the above procedure you can create your own image and upload it to IaaS.
In addition to the above linux setup , you can install any packages or application on to it and upload it. I will cover that as a separate post.

Happy Clouding !!!

Oracle AppsUnlimited - Oracle E-Business Suite Meets Oracle Cloud

Fri, 2016-03-18 03:45



Oracle Cloud Infrastructure as a Service (IaaS) is now powered to run Oracle E-Business Suite. Does that interest you ? I am exited to be part of the apps unlimited team and let me share what I have explored. 

Apps Unlimited offers two ways  of running EBS , start fresh or migrate. Depending on customer choice and business requirement either of the options can be chosen. Some of benefits of running EBS on Cloud are quick and easy automated way to provision EBS images on the cloud, lift and shift EBS instances on premise to cloud , easily develop and deploy customization , manage them in EM 13c using hybrid management options.


Cloud Marketplace has the various images to explore. These images are the latest updated images running EBS 12.2.5 with AD and TXK 12.2.7 with database Oracle 12c running on Oracle Linux 6 update 7 (x86-64).

Will be sharing more about EBS on Cloud in this space. Please watch out for more update. Happy Clouding.

Happy New Year 2016

Thu, 2015-12-31 20:28

EBS 12.2.7 AD & TXK Delta 7 Features Review

Tue, 2015-10-20 22:25
With 12.2.7 AD & TXK Delta 7 - EBS Customers on 12.2 should be seeing improvements and stability. It is time now to review them. Watch this blog for the detailed review.

Some of the key features of Delta 7 are
  • Enhanced adop Console Messages
  • New adop Monitoring Tool
  • New adop 'validate' Option
  • Support for Middle Tier EBS Technology Checker
  • Support for EBS Installation Central Inventory
  • Script to Automate Changing Oracle WebLogic Server Administration User Password
  • Simplified Procedure for Changing WLS Data Source
  • New 'dualfs' Option in Standard Cloning
  • Improved Delete Node and Delete Managed Server APIs
  • Mandatory Definitions of Context Variables
  • Automatic Execution of ETCC on Database Tier After Cloning
  • Various adop Enhancements and Fixes

Exadata Upgrade - Adding X5-2 Half Rack to X3-2 Existing Half Rack

Sat, 2015-10-10 23:26

Recently did an Exadata Expansion project on x3 half rack and making it a full rack by adding x5.
this setup is a full exadata rack with two different flavours of engineered system hardware four x3 compute nodes and four x5-2 compute nodes along with seven x3 cellnodes with seven x5 cell nodes.
This topology is supported but there were a lot of work behind.

  • First getting the x3 on the supported release 12c , this involved 4 node grid upgrade from 11g to 12c and x3 compute/cell node image to 12c from 11g.
  • Next physical racking of x5 hardware into x3 rack space
  • Then upgrade x5 to the latest software stack 12c same as x3
  • Interconnect both x3 and x5 to co-exisits
  • Precheck of the full exadata rack before making them into one cluster
  • Next add the four x5 node to the x3 rac cluster using addnode.sh
  • Now the storage - x3 had 3TB disk and x5 has 4TB disk , so grid disk has to be the same size.
    • following doc "How to Add Exadata Storage Servers Using 3TB/4TB Disks to an Existing Database Machine (Doc ID 1476336.1)" will help.
    • the additional 1TB space from x5 cell storage was created into RECO2 for future recovery storage space as the current setup is 80:20 (DATA:RECO)
  • Completed cluster verification and return the rack to service 


This whole exercises was so cool and went as documented.
For documentation the below was used (you may have to refer to the latest document for extending exadata)
Oracle® Exadata Database Machine Extending and Multi-Rack Cabling Guide
12c Release 1 (12.1)
E51952-10
https://docs.oracle.com/cd/E50790_01/doc/doc.121/e51952/hardware.htm#DBMMR21157

An inspiration to an entire generation, Dr APJ Abdul Kalam - Rest in Peace. The real hero behind Indian Space Research Organisation (ISRO)

Mon, 2015-07-27 11:10
An inspiration to an entire generation,  Dr APJ Abdul Kalam - Rest in Peace. The real hero behind Indian Space Research Organisation (ISRO) 




GoldenGate Initial Load by Senthil Rajendran

Sun, 2015-06-21 03:42
Welcome to the world of replication. Recently have been deep into GoldenGate and here are the series of presentation that can help you to start with GoldenGate



Index
GoldenGate Fundamentals Session
GoldenGate Implementations Essential
GoldenGate Monitoring, Troubleshooting and Tuning
GoldenGate Use Cases
GoldenGate Initial Load

GoldenGate Use Cases by Senthil Rajendran

Sun, 2015-06-21 03:41
Welcome to the world of replication. Recently have been deep into GoldenGate and here are the series of presentation that can help you to start with GoldenGate



Index
GoldenGate Fundamentals Session
GoldenGate Implementations Essential
GoldenGate Monitoring, Troubleshooting and Tuning
GoldenGate Use Cases
GoldenGate Initial Load

GoldenGate Monitoring, Troubleshooting and Tuning by Senthil Rajendran

Sun, 2015-06-21 03:41
Welcome to the world of replication. Recently have been deep into GoldenGate and here are the series of presentation that can help you to start with GoldenGate



Index
GoldenGate Fundamentals Session
GoldenGate Implementations Essential
GoldenGate Monitoring, Troubleshooting and Tuning
GoldenGate Use Cases
GoldenGate Initial Load

GoldenGate Implementations Essential by Senthil Rajendran

Sun, 2015-06-21 03:38
Welcome to the world of replication. Recently have been deep into GoldenGate and here are the series of presentation that can help you to start with GoldenGate



Index
GoldenGate Fundamentals Session
GoldenGate Implementations Essential
GoldenGate Monitoring, Troubleshooting and Tuning
GoldenGate Use Cases
GoldenGate Initial Load

GoldenGate Fundamentals Session by Senthil Rajendran

Sun, 2015-06-21 03:36
Welcome to the world of replication. Recently have been deep into GoldenGate and here are the series of presentation that can help you to start with GoldenGate




Index
GoldenGate Fundamentals Session
GoldenGate Implementations Essential
GoldenGate Monitoring, Troubleshooting and Tuning
GoldenGate Use Cases
GoldenGate Initial Load

Supporting a Day Against DRM with PacktPub

Wed, 2015-05-06 08:47
What is DRM?
DRM stands for “digital rights management,” a bit of technology that hardware and software manufacturers, publishers, and copyright holders use to control the way we use the devices and media that we own. The idea is to limit users’ ability to copy the content without permission, but DRM does much more: it shapes how people tinker with and share devices, software, music, movies, etc. they legally paid for. Have you ever unsuccessfully tried to copy music you “bought” from your computer to your iPhone? Attempted to download an ebook from Amazon only to discover it isn't “compatible” with your device? That’s DRM at work.
To celebrate all eBooks and Videos are available in a lesser price with PacktPub. Please read here http://bit.ly/1KgYlv6

EBS R12.2 Delta 6 Feature Review : Enhancement of adop console messages

Tue, 2015-04-28 01:02
ADOP console messages was always something that administrators needed changes. Delta 6 new features talks that there has been more enhancements done and running SQLs are displayed. Yes & True , it does but comparing to Delta 5 there are not much improvements. If you are from a older Delta version 2 or 3 , then Delta 6 upgrade might be interesting.

Instead of displaying the complete update statements , I can see messages like "[STATEMENT] Updating cutover_status=0 for session_id : 67" which are quite meaning full.

Still see a lot of technical names used like "[STATEMENT] Inside createPatchCtxFile()..."


EBS R12.2 Delta 6 Feature Review : EBS Technology Consistency Checker (ETCC)

Tue, 2015-04-28 00:19
With EBS R12.2 Delta 6 will not display a warning message when using the ADOP utility. An additional check is made every time ADOP tool is invoked which checks for the  recommended patches that are missing in the instance. This feature is ETCC and you will see something like this on the ADOP logs.

    [PROCEDURE] [START 2015/04/27 14:27:57] Performing database sanity checks
    [WARNING]   ETCC: The following database fixes are not applied in node vmohstest001
                  14046443
                  14255128
                  16299727
                  16359751
                  17250794
                  17401353
                  18260550
                  18282562
                  18331812
                  18331850
                  18440047
                  18689530
                  18730542
                  19472320
                  19487147
                  19896336
                Refer to My Oracle Support Knowledge Document 1594274.1 for instructions.
    [PROCEDURE] [END   2015/04/27 14:27:57] Finished performing database sanity checks


Recommendation is to review the below note and get all recommended patches applied.
Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1)

Note : please refer to the recent product documentation to know the latest changes.

EBS R12.2 Delta 6 Feature Review : Single File System Instance

Mon, 2015-04-27 05:40
With one of the main feature in 12.2 dual file system, there was always a need about having a single file system in 12.2 like 12.1.x and get away with the ADOP patching cycle. With Delta 6 AD and TXK you can. It is important to understand the feature and know its limitations.

There are two advantages of this single file system feature in 12.2

  • no more synchronization of run and patch file system
  • save storage
Still it operates with same ADOP engine and it is NOT CERTIFIED for PRODUCTION.
This feature will be interesting for development team where they need an EBS 12.2 instance where they can test their custom code.

Here is how to setup 
  • Install R12.2 Instance with dual file system or Clone an existing environment with dual file system. No option available in the Rapid Installer to select single file system instance.
  • Remove the PATCH_BASE using operating system remove command rm -rf $PATCH_BASE
  • Apply the patch using in ADOP downtime mode and run cleanup phase as required
So what is not possible ?
  • You cannot clone the single file system to build another environment.
  • You cannot enable the dual file system back and start a patching cycle
Note : please refer to the recent product documentation to know the latest changes.

EBS 12.2 do not ignore the database patches on top of AD Delta 5 and TXK Delta 5

Sun, 2015-04-05 09:13

Make sure all the recommended patches are in place as a part of the bundle patch. Your EBS 12.2 ADOP cycle could go unstable with out the database patches.

EBS 12.2 Essential Bundle Fixes for AD Delta 5 and TXK Delta 5 (Doc ID 1934471.1)

Thu, 2015-01-22 07:38
EBS 12.2 Essential Bundle Fixes for AD Delta 5 and TXK Delta 5 (Doc ID 1934471.1)

if any of the below features are interesting to your deployment then please review the doc and apply the essential bundle patches on 12.2.5 environment. Hope this helps to stabilize your environment.

Section 4: Features and Fixes in the Current Code level
The bundle fixes include implementation of the following AD and TXK features and fixes.

4.1: AD Features and Fixes

  • The database connection module has been enhanced such that the former multiple connections during adop execution have been reduced to only two connections for all embedded SQL actions.
  • Concurrency issues during multi-node configuration have been fixed.
  • Redundancy issues have been addressed:
    • When calling validation on all nodes.
    • Unnecessary calls to the TXK API, have been removed from the cleanup phase.
    • Time-consuming database actions have been centralized, instead of being performed on all nodes.
  • Multinode logic has been changed to depend on a new table, adop_valid_nodes, instead of fnd_nodes.
  • An issue where AD Admin and AD Splice actions were not synchronized on shared slave nodes has been fixed.
  • Reporting capabilities have been improved for:
    • Abandon nodes and failed nodes.
    • Uncovered objects not being displayed after actualize_all in adopreports.
    • Out of sync nodes during fs_clone and abort.
  • Cutover improvements:
    • Restartability of cutover.
    • An obsoleted materialized view has been removed from processing during cutover.
  • xdfgen.pl has been enhanced to support execution against Oracle RAC databases where ipscan is enabled.
  • Support for valid comma-separated adop phases has been provided.
  • Several database-related performance issues have been fixed.
  • Improvements have been made in supporting hybrid, DMZ, non-shared, and shared configurations.
  • The adop utility has been enhanced to support host name containing the domain name.

4.2: TXK New Features and Fixes

  • Enhancements have been made to the provisioning tools used in multi-tier environments to perform operations such as adding or deleting nodes and adding or deleting managed servers.
  • An enhancement has been made to allow customization of the s_webport and s_http_listen_parameter context variables when adding a new node.
  • Performance improvements have been made for cloning application tier nodes, particularly in the pre-clone and post-clone phases.
  • Fixes related to cloning support for Oracle 12c Database have been provided.
  • Performance improvements have been made for managing application tier services, including implementation of the Managed Server Independence Mode feature (-msimode parameter to adstrtal.sh) to allow application tier services to be started or stopped without the WebLogic Administration Server running.
  • On a multi-node application tier system configuration, remote connectivity is no longer required for packaging the Oracle E-Business Suite WebLogic Server domain.
  • JVM heap size (-Xms and -Xmx) has been increased to 1 GB for the WebLogic Administration Server and all managed servers.


Pages