Monday, December 11, 2017

ORA-00240: control file enqueue held for more than 120 seconds 12c

Occasionally, In Oracle 12c database, you may get ORA-00240: control file enqueue held for more than 120 seconds  error in the alert log file.

Thursday, November 30, 2017

Enters Amazon Aurora Serverless

More often than not, database administrators around the technologies have to fight out high load on their databases. It could be ad hoc queries, urgent reports, overflown jobs, or simply high frequency and volume of queries by the end users.

DBAs try their best to do a generous capacity planning to ensure optimal response time and throughput for the end users. There are various scenarios where it becomes very hard to predict the demand. Storage and processing needs in case of unpredictable load are hard to foretell in advance.


Tuesday, November 21, 2017

Query Flat Files in S3 with Amazon Athena

Amazon Athena enables you to access data present in flat files stored in S3 (Simple Storage Service) as if it were in a table in the database. That and you don't have to set up any server or any other software to accomplish that.

That's another glowing example of being 'Serverless.'

Wednesday, November 8, 2017

List of Networking Concepts to Pass AWS Cloud Architect Associate Exam

Networking is a pivotal concept in cloud computing. Knowing it is a must to be a successful Cloud Architect. Of course you won't be physically peeling the cables to put RJ45 connectors on but you must know various facets of logical networking.

Tuesday, November 7, 2017

Guaranteed Way to Pass AWS Cloud Architect Certification Exam

Today and for the sometime to come, one of the hottest IT certification to hold is AWS Cloud Architect Certification. There are various reasons for that:

Passed the AWS Certified Solutions Architect - Associate Exam

Well, it was quite an enriching experience to go through taking the AWS certification exam and I am humbled to say that I passed it. It was first time, I underwent any AWS exam and I must say that quality was high and it was challenging and interesting enough. 

I will be writing soon as how I prepared and what are my tips for passing this exam.

Good night for now.

Sunday, October 1, 2017

CIDR for Dummies DBA in Cloud

For DBAs of Cloud, its imperative to learn various networking concepts and CIDR is one of them. Without going into much detail, I will just post here quick note as what CIDR is and how to use it.

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.