Sunday, May 27, 2018

How to find the UUID of a device in Linux for Oracle ASM

UUID stands for Universally Unique Identifier. I use UUID for my disk device, when I need to create and add disks for Oracle ASM, as UUID is independet of device name or mountpoint. So its always a good idea to include UUID of device in the fstab file in Linux.

So here is how to find the UUID of a device in Linux for Oracle ASM:

Friday, April 20, 2018

Relocate Goldengate Processes to Other Node with agctl

Oracle Grid Infrastructure Agents can be used to manage Oracle Goldengate through Oracle GI. agctl is the utility to add, modify and relocate the goldengate. These Oracle GI agents can also be used with other products like weblogic, mysql etc. 

Tuesday, April 17, 2018

Oracle DBAs and GDPR

The General Data Protection Regulation (GDPR) (Regulation (EU) 2016/679) is a regulation by which the European Parliament, the Council of the European Union and the European Commission intend to strengthen and unify data protection for all individuals within the European Union (EU).

AWS Pricing Made Easy By Simple Monthly Calculator

With ever changing pricing model and services, its hard to keep track of AWS costing.


Friday, April 13, 2018

AWS CLI is Boon for DBAs

For most of production RDS databases , we normally have a related EC2 server to access that RDS database through tools like datapump, sqlplus etc.

Thursday, March 29, 2018

Tuesday, February 13, 2018

Move a Datafile from one ASM Diskgroup to Another Diskgroup

Following are steps to move a datafile from one ASM diskgroup to another diskgroup in the same ASM instance:

Thursday, January 4, 2018

Its Cloud Service, Not Oracle 18c RDBMS which is Self-Driving and Autonomous

Look at the following picture displayed at Oracle's official website here, and you would forgive anyone who would naively believe that the Oracle 18c is a self-driving, autonomous database.

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.