Tuesday, September 19, 2017

Idempotent and Nullipotent in Cloud

I was going through the documentation of Oracle Cloud IaaS, when I came across the vaguely familiar term Idempotent.

Monday, September 18, 2017

SRVCTL Status Doesn't Show RAC instances Running Unlike SQLPLUS

Yesterday, I converted a single instance 12.1.0.2.0 physical standby database to a cluster database with 2 nodes.

After converting that to RAC database, I brought both instances up in mount state on both nodes and they came up fine and I started managed recovery on one node and it started working perfectly fine and got in sync with the primary.

Tuesday, September 12, 2017

Attended Google Cloud Summit in Sydney

The day event at picturesque Pier One Autograph Collection just under the shadow of Sydney's iconic harbor bridge was very interesting to say the least.


Wednesday, August 16, 2017

SPX86-8002-VP - The /var/log filesystem has exceeded the filesystem capacity limit.

The following error message sounds ominous:

SPX86-8002-VP - The /var/log filesystem has exceeded the filesystem capacity limit.

and from Cloud control:


Sunday, July 30, 2017

Presented at CLOUG OTN Day 2017, Chile stop of the 2017 LAD OTN Tour

Amidst lots of Empanadas and Lomo Saltodos, I presented at CLOUG OTN Day 2017, Chile stop of the 2017 LAD OTN Tour last week and it was great to see a very passionate audience.

Friday, July 7, 2017

Oracle Cloud Machine ; Your Own Cloud Under Your Own Control

Yes, every company wants to be on cloud but not everyone wants that cloud to be out there in wild no matter how secure it is. Some want their cloud to be trapped within their own premise, under their own control.

Wednesday, June 28, 2017

Oracle GoldenGate Cloud Service

Even on Amazon AWS, for the migration of Oracle databases from on-prem to Cloud, my tool of choice is GoldenGate. The general steps I took for this migration was to create extract on source in on-prem, which sent data to replicat running in AWS Cloud in EC2 server, which in turn applied data to cloud database in RDS.

Sunday, June 18, 2017

Steps for Moving ASM Disk from FRA to DATA

Due to some unexpected data load, the space in DATA diskgroup became critically low on one of the production systems during middle of night on the weekend. There was no time to get a new disk and we needed the space to make room for new data load scheduled to be run after 3 hours.

Sunday, May 14, 2017

12c Patching Resume with Nonrolling Option While Analyze - JSON Magic

I was engaged in an interesting Oracle 12c patching today.  Patch applicability was checked by using:

"$GRID_HOME/OPatch/opatchauto apply /u01/app/oracle/software/24436306 -analyze"

and it failed because its a non-rolling patch:


Friday, April 21, 2017

Love Your Data Conference in NYC on 31st May

In this InfoEra, its all about data.Whether its in the cloud or on-premises everything is truly revolving around and is for data. Pythian understood that decades ago and loving the data of their customers since day one. They are showcasing this love on 31st May in NYC.

http://promo.pythian.com/love-your-data-conference/


To help you turn your organization into a truly data-driven business, this interactive 1-day event in New York City on May 31, 2017, combines presentations, practical interactive panel sessions and open discussions across business and technical tracks.

This event is for CIO’s and IT Business leaders interested in learning how to better empower their company to drive business outcomes with analytics. Pythian’s Love Your Data Conference will focus on practical ways to:
  • Transform your organization using data and self-service analytics
  • Align IT to the business by giving all users access to data
  • Add data intelligence and automation to business decisions
  • Get a 360-degree view of your customer and promote innovation 
If you want to attend only one event this year then this must be the one.