Senthil Rajendran

Subscribe to Senthil Rajendran feed
The voice in my head may not be real , but they have some good ideas !!!Senthil Rajendran
Updated: 10 hours 9 min ago

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

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

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

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

EBS 12.2 Blocking a Concurrent Program while Online Patching

Sat, 2015-01-10 22:36
Will there be a need to Blocking a Concurrent Program while Online Patching in EBS 12.2 , if so then here are the steps.

  • Use the Concurrent Program window or page to edit your concurrent program definition.
  • Select the Incompatibilities button to open the Incompatible Programs window.
  • Add a new global incompatibility rule for your program with the following program:
    • Application Name: Applications DBA
    • Program Name: Online Patching In Progress (internal name: ADZDPATCH) concurrent program

    EBS 12.2 Validation Scripts for Prepare, Cutover and FS_Clone Phases

    Sun, 2015-01-04 22:45
    Are you going to run Prepare, Cutover or FS_CLONE , then before you start the phases using ADOP tool if you would like to validate the instance if it is ready for those phases then here is a simple script.

    export RUN_CONTEXT_FILE=/testi/inst/fs1/inst/apps/testi_host1/appl/admin/testi_host1.xml
    export PATCH_CONTEXT_FILE=/testi/inst/fs2/inst/apps/testi_host1/appl/admin/testi_host1.xml

    perl $AD_TOP/patch/115/bin/  -contextfile=$RUN_CONTEXT_FILE -patchctxfile=$PATCH_CONTEXT_FILE -phase=fs_clone -logloc=/tmp
    perl $AD_TOP/patch/115/bin/  -contextfile=$RUN_CONTEXT_FILE -patchctxfile=$PATCH_CONTEXT_FILE -phase=prepare -logloc=/tmp
    perl $AD_TOP/patch/115/bin/  -contextfile=$RUN_CONTEXT_FILE -patchctxfile=$PATCH_CONTEXT_FILE -phase=cutover -logloc=/tmp

    Review the logfile that gets created under /tmp

    You can run the scripts for the phase you are interested and it takes not more than 10 mins.

    ORA-06508 in an EBS 12.2 environment ?

    Fri, 2015-01-02 07:20

    Custom.pll template are sometimes used wrong. In case of 12.2 make sure you use the seeded 12.2 template to put in you customizations. In case if you are migrating from a older release make sure it is created from the latest versions. You can check the version using adident package. ORA-06508 are known to be a problem with older custom.pll template.

    $APPLTMP directory in R12.2 Multi Node

    Fri, 2015-01-02 07:15

    $APPLTMP directory in R12.2 if placed in a shared location in a multi node environment the there are know complications in multi node cutover. So best to leave it under INST top for each node.