Senthil Rajendran

Subscribe to Senthil Rajendran feed
The voice in my head may not be real , but they have some good ideas !!!Unknownnoreply@blogger.comBlogger276125
Updated: 5 days 11 hours ago

Create Databases from Automatic Daily Backups - New Feature - Jan 2019 - Oracle Cloud Infrastructure

Wed, 2019-02-06 03:03
New Feature - Create Databases from Automatic Daily Backups
Services : Block Volume
Release Month : Jan 2019

Automatic Daily Backup feature lets you to create automated backups of OCI DB System Databases on a daily basis. With this feature you can now create a new system out of the automated daily backups.

Here is a DB System in OCI that is created and you can see there is a Automated Backup Running

Once the backup is completed you will see that it is ready for the refresh

From the backup section select Create Backup and fill in the required details

Once you start the database creation process you will see the restore process beginning immediately.

The DB System will have your database in provisioning stage

Once restore is done you will be having your new Database up and running.

This is indeed a cool feature. I bet your DBA will love to see this , he can now start looking into other useful stuffs.

In-transit encryption for boot and block volumes - New Feature - Jan 2019 - Oracle Cloud Infrastructure

Tue, 2019-02-05 01:15
New Feature : In-transit encryption for boot and block volumes
Services : Block Volume
Release Month : Jan 2019

Data is often considered less secured when in movement. It could be across two servers , two data center , between two services, between cloud and on-premise or between two cloud providers. Wherever data is  moving , data protection methods should be implemented for in transit data that are critical. While organization care more about data at rest , protecting sensitive data in-transit should also be given high importance as attackers find new methods to steal data.

Encryption is the best way to protect data in-transit. This is done by encrypting the data before sending it , authenticating the end points and decryption once the data is received. 

OCI block volume service encrypts all block volumes at rest and their backups as well using AES Advanced Encryption Standard algorithms with 256-bit encryption. Data moving between the instance and the block volume is transferred over an internal and highly secure network. This transfer could be encrypted with this feature announcement for paravirtualized volume attachments on virtual machines.

Optionally you can use the encryption keys managed by the key management service for volume encryption. if there is no service used oracle provided encryption key is used and this is for both data at rest and in-transit.

Here above when you specify the key for the block while creating then the same will be used for in-transit as well.

Consistent device paths for block volumes - New Feature - Jan 2019 - Oracle Cloud Infrastructure

Mon, 2019-02-04 04:53
New Feature : Consistent device paths for block volumes
Services : Block Volume
Release Date : Jan 2019

With this feature you can now select a device path that will remain consistent between instance reboots. though this is an optional feature it is recommended to use the device path as you can refer to the volumes when create partitions , creating file systems , mounting file system , you can also specify this option in /etc/fstab file for automatically mounting volumes on the instance boot.

Operating System Linux Images that are released by Oracle prior to November 2018 would not be able to use this feature. Windows based , Custom images and Partner images are not supported.

To verify if consistent device path support is available on your instance , login into your environment and do a "ll /dev/oracleoci/oraclevd*" , if you see a list of devices then it is supported else if you get a message "no such file or directory" then it is not supported.

Screenshot showing output for listing attached devices on instance using consistent device paths

Attaching a device path in the console is done simply by selecting a device path for the block volume.  Once attached you can verify the block volume from the summary page

Device Path : /dev/oracleoci/oraclevdb

After attaching the device then from the operating system you can create a partition using the device path.

fdisk  /dev/oracleoci/oraclevdb 
mkfs.ext3 /dev/oracleoci/oraclevdb1
update : /etc/fstab --- /dev/oracleoci/oraclevdb1   /oradata    ext3    defaults,_netdev,noatime  0  2
mkdir /oradata
mount /dev/oracleoci/oraclevdb1 /oradata

Steal Percentage on the Virtual Machine

Mon, 2018-10-22 04:26
Recently have been working with a customer who was running high workload on virtual machine. After a complete review , DBAs have identified the database is running non optimized codes/sql/programs. During high peak load we observed very high Steal %

Image result for Steal Percentage Top

In a virtual environment, CPU cycles are shared across virtual machines on the server. If your virtual machine displays a high %st in top (steal time), this means CPU cycles are being taken away from your virtual machine to serve other purposes. You may be using more than your share of CPU resources or the physical server may be over-sold. Move the virtual machine to another physical server. If steal time remains high, try giving the virtual machine more CPU resources.

In this case this database was not having any noisy neighbor and it was the same machine fighting against itself. The reason was over-provisioning. The underlying hardware had 48 CPU but virtual machine was over provisioned for 64 CPU.

To resolve the issue , virtual machine was migrated from 48 CPU bare metal to 82 CPU bare metal.

The Steal is gone.

it is highly recommended to have a metric collection on the monitoring tool to have Steal monitored on high workload virtual machines. This will help take action and move environment to have better performance.

ADOPValidations EBS 12.2

Thu, 2018-10-11 05:21
ADOPValidations_detailed.log reported a warning message for one of the critical error "Cross Reference"

        [WARNING]: Found invalid cross references in FS config files.

cross reference is nothing but having incorrect values in the context file of EBS 12.2

for example : run file system context file having path of patch file system 


$ grep -i fs2 /prod/inst/fs1/inst/apps/PROD_node1/appl/admin/PROD_node1.xml

$ grep -i fs1 /prod/inst/fs2/inst/apps/PROD_node1/appl/admin/PROD_node1.xml /prod/applmgr/fs1

here on the patch file system there is a cross reference which can be very costly mistake if you ignore it. so consider having all validations reviewed.

how to fix it then ....

just update the context file and upload it to the database

$ADJVAPRG action=upload contextfile= logfile=/tmp/patchctxupload.log

then run ADOP operations...

Golden Gate moving from Classic to Integrated

Thu, 2018-10-11 05:07
Golden Gate moving from Classic to Integrated was an option taken in one of our project to have better performance. A lot of effort was put to convert all the extract and replicate to Integrated mode and some optimization parameters were used but still there were not a significant performance improvement.

Then I took a different route to examine the AWR and ASH for the replicate processes. Wow our friend INDEXES. Since we were dealing with build load , some of the unwanted indexes were dropped and Golgen Gate was super fast. Both Integrated and Classic was having better performance. Post the build load we rebuild the indexes.

Better consult a Dr.DBA always.

Yamaha's PSR-E463 - A truly awesome Keyboard to have

Wed, 2018-08-08 01:33
Though I am a beginner in this instrument, still I would like to recommend others to go with this keyboard.

Yamaha's PSR-E463 makes a perfect first keyboard for students, a solid educational tool for classrooms, and a fun, lightweight travel instrument and composition tool for professionals. Each of the E463's 61 full-sized, organ-style keys provides good resistance with a quick response that's suited for playing dynamic string pads to quick brass lines and synth leads. And speaking of instruments: the E463 comes loaded with 758 rich stereo voices, which means students and recording artists will never be short on inspiration. And for purists, a one-touch Live Grand Piano function bypasses all advanced features to provide a lush, distraction-free grand piano sound with 48-note polyphony. Its intelligent backing tracks, a USB port for thumb drives and MIDI connectivity, and the included 9-lesson Yamaha Education Suite round out the PSR-E463's value-packed features.

Read the Readme

Mon, 2018-06-25 11:28

Read the readme.

When applying PSU or OJVM do instructions as documented in the readme in the specificed sequence. Run post patch instructions as specified in the readme.

E Business Suite will stop authenticating users if post ojvm instructions are missed.

Happy New Year 2018

Sun, 2017-12-31 21:46

Happy New Year 2018

Mon, 2017-12-04 23:02

Oracle Developers

Aggregation of articles from Oracle engineers, Developer Champions, partners, and developer community on all things Oracle Cloud and its technologies.

Oracle Cloud Conference @Bangalore

Mon, 2017-12-04 21:21

Attending Oracle Cloud Conference @Bangalore 2017

Happy New Year

Sat, 2016-12-31 22:55

Wish every one a Happy New Year.

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 ./
  • 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 with EBS

Mon, 2016-03-21 04:11
Oracle Public Cloud gives multiple options to create a base image. There are options available from the market place which I will cover later. Here I will cover building your own machine image on IaaS with your own EBS Installation. If you are a customer running 12.1.3 this should interest you. This procedure can be used to build multiple development single node EBS images of your choice.

I will make the document generic to 12.2 and 12.1.3, so lets get started. Here are the high level steps

  • Build a local Oracle Linux image supported on Cloud , follow doc here and stop after rebooting the linux image.
  • Install EBS 12.2 or 12.1.3 with all the latest PSU,CPU, AD and TXK 
  • Run Pre-Clone on the Database Tier followed by Application Tier
  • Shutdown the Services
  • Follow doc here and complete the rest of the preparatory task for OPC
  • Upload the image
  • Spin-off a machine with the uploaded Image
  • Configure the Target system following Cloning documentation.
  • Finish post installation task if any
With the uploaded image , you can spin-off as many as EBS instances needed.

Reference Note for Cloning : Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone (Doc ID 1383621.1)

Though this procedure has a lot of work on customer end , I would recommend to try out Market Place Images.

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{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
  • 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)