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.


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