Automatically Add EC2 Instances to Active Directory Domain – Part 1

Windows Servers are in AWS will show some glitches in sometimes. My previous article explains how Windows Server 2016 had some issues with DNS Suffix and Forwarders. This time I got a chance to play around with PowerShell automations. The requirement is automatically add EC2 instances to Active directory domain during the instance launch. It might be an On Demand purpose ec2 or launched by an Auto scaling group.

Read More

How To Migrate PostgreSQL Users To AWS RDS PostgreSQL

How To Migrate PostgreSQL Users To AWS RDS PostgreSQL

According to PostgreSQL migration, we can migrate the databases and tables. I was migrating a Postgresql environment from EC2 to RDS Postgresql. I have completed the data migration. In many blogs, they have mentioned the steps to migrate PostgreSQL users to another server. But in RDS I couldn’t able to do that. I got the below error.

  Read More

Why Windows Server 2016 In AWS Unable To Resolve Public And Local DNS

Windows Server 2016 In AWS Unable To Resolve Public And Local DNS

Before reading further about this DNS issue, I want to clarify few things.

  • This issue happened only in AWS.
  • Windows Server 2016 has this issue.
  • On Domain Controller, I was Able to access the internet before configuring the AD/DNS.
  • On Member Server, I was able to access the internet before joining the domain.
  • Standalone Windows servers are working fine. Only the Domain Controller and the members of the domain having this problem.

Read More

Automatically Enable CDC In RDS SQL Server

Automatically Enable CDC In RDS SQL Server

AWS recently announced a new feature which will help to enable CDC in RDS SQL server on user databases. Here this the detailed blog post that explains how to enable this CDC for DMS service. CDC is an enterprise edition feature. But RDS SQL Server Standard editions are supporting CDC. The most important thing is we can use this feature to achieve the below things.

Read More

Don’t Use AWS AMI To Backup Your EC2 Database Server

Don't Use AWS AMI To Backup Your EC2 Database Server

I have started my career to handle the databases which all are in the Cloud. Most of the database servers are in AWS EC2. AMI is one the simplest and great feature to take a VM level backup and restore it when a disaster happens. But DBAs never depend on the VM or SAN backups, so I have configured native backups for all of my database servers. But I used to choose to restore the AMI whenever we need a Dev/Test server. Because restoring a huge database will take more time and its pretty expensive operation. So I just drop the existing Dev DB server and launch it from the AMI.

Read More

How To Install Oracle 12C on Amazon Linux In Silent Mode

How To Install Oracle 12C on Amazon Linux In Silent Mode

Install Oracle12c in Amazon Linux

Before start my story, I need to tell this, I’m not an Oracle guy. But as a DBA I had few situation to install Oracle on Amazon Linux. In many blogs, we can get the steps to install in CentOS and RedHat, but my bad I couldn’t find any blogs for Amazon Linux. After read many blogs I got the procedure to install it, and the more important thing is we can use the same step to Amazon Linux, CentOS and RedHat without any changes. But while follow this process some files are not available to edit in Amazon Linux, so please ignore them.

Read More