INDEX
Linux Blogs
1. Mount a File System in Linux 2. Environment Operations Fail With “bash: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory”
Terraform Blogs
1. Create an EC2 Instance with hard coded AMI ID 2. Create a Static Webserver using EC2 Instance in Terraform 3. Create an EC2 Instance with 2 Security Groups and Output values 4. Create Multi AZ RDS using Terraform 5. Restore RDS from existing snapshot using Terraform
MySQL Blogs
1. MySQL Theoretical Explanation 2. MySQL Binaries installation 3. MySQL Generic Commands 4. MySQL Backup and Restore Commands 5. MySQL Replication Theory 6. Steps to implement Master-Slave MySQL Replication 7. MySQL upgrade from MySQL 5.7 to MySQL 8.0.21 8. MySQL...
AWS RDS Blogs
1. Daily Tasks in AWS RDS Oracle 2. RMAN Tasks in AWS RDS Oracle 3. Steps to integrate S3 with Amazon Oracle RDS 4. Full Load Migration of On-premise Oracle Database to AWS RDS Oracle 5. Migration and Replication (Full Load + CDC) of On-Premise Oracle 11G database to...
ORACLE Blogs
Commands in Oracle : 1. Daily Commands in Oracle 2. Tablespace Commands 3. Basic RMAN Commands 4. Export Import Datapump Basic Commands Interview Questions : 1. Oracle interview questions part 1 2. Oracle Interview Questions Part 2 3. Oracle Interview Questions Part 3...
Learn Oracle
Fixing up pre-upgrade issues related to DST update operation in Oracle 19c Upgrade
During Oracle 19c upgrade you may have to resolve the below required actions before upgrading the database Complete any pending DST update operation before starting the database upgrade. There is an unfinished DST update operation in the database. It's current state...
Oracle ASM Interview Questions
1. What init.ora parameters does a user need to configure for ASM instances? Oracle ASM offers these initialization parameters. The main parameters for ASM include asm_diskgroups, asm_diskstring, asm_power_limit and asm_preferred_read_failure_groups. ...
Export Import Datapump Basic Commands
For more exciting blogs on Oracle, please click the LINK 1. EXCLUDING TABLE PARTITIONS JOB_NAME=INFRA_EXPORT DIRECTORY=DUMP_DIR DUMPFILE=Schema_%U.dmp LOGFILE=Schema.log SCHEMAS=INFRA EXCLUDE=table_data:"IN ('INFRA_KEY_2005Q1','INFRA_KEY_2005Q2')" FILESIZE=100G...
RMAN Basic Commands
For more exciting blogs on Oracle, please click the LINK 1. Crosscheck and delete expired archive logs RMAN>list expired archivelog all; RMAN>crosscheck archivelog all; RMAN>delete noprompt expired archivelog all; 2. Delete archive logs keeping just a days...
Tablespace Commands
For more exciting blogs on Oracle, please click the LINK 1. Checking tablespace size col "Tablespace" for a22 col "Used MB" for 99,999,999 col "Free MB" for 99,999,999 col "Total MB" for 99,999,999 select df.tablespace_name "Tablespace", totalusedspace "Used MB",...
Daily Commands in Oracle
For more exciting blogs on Oracle, please click the LINK 1. Kill Multiple Inactive sessions in Oracle BEGIN FOR r IN (select sid,serial# from v$session where username='user' and status'INACTIVE') LOOP EXECUTE IMMEDIATE 'alter system kill session ''' || r.sid || ',' ||...
Oracle RAC Interview Questions
For more exciting blogs on Oracle, please click the LINK 1. Where are the Clusterware files stored on a RAC environment? The Clusterware is installed on each node (on an Oracle Home) and on the shared disks (the voting disks and the CSR file) 2. Where are the...
Modify SCAN Listener port number
In this post we will see how to change the SCAN Listener port from 1521 to 1585 For more exciting blogs on Oracle, please click the LINK STEPS : 1. Check the current configuration of your SCAN Listener [oracle@INFRA oracle]$ srvctl config scan_listener SCAN...
Steps to switchover from Primary Database to Standby Database in Oracle Dataguard
In this blog we will see how to switchover your Primary database to a Standby database and vice versa in a Oracle Dataguard Environment For more exciting blogs on Oracle, please click the LINK Let us take the Primary and Standby Databases as follows : Primary DB :...
Oracle DBA Interview Questions – Part 3
For more exciting blogs on Oracle, please click the LINK 1. How to determine redo log size is not optimal As a general rule of thumb, Oracle recommends that you size your online redo logs not to switch more then 5 times per hour during peak DML times. If you are ever...
Learn AWS
Amazon RDS Custom for Oracle
In this post we will see step by step details of creating an Amazon RDS Custom for Oracle Before proceeding with the Practical setup, let us have a brief overview on Oracle Custom RDS For more posts on AWS RDS please check the INDEX page or visit our YouTube channel...
Lift and Shift Migration to AWS using Cloud Endure
Before jumping into the Practical session, we should know the basics. So, Lets start with the basics of Cloud Endure What is Cloud Endure? Cloud endure provides a unified, simple process to migrate/protect any application or database from any source into AWS This can...
Migrate on-premise Oracle database to AWS RDS using Datapump and S3 integration
In this post we will see how we can migrate an On-premise Oracle database to AWS RDS using Oracle Datapump utility and integration with S3. For more posts on AWS RDS please check the INDEX page or visit our YouTube channel There are various methods to migrate your...
Steps to upgrade AWS Oracle RDS
In this post, we will see in details the steps to upgrade your AWS Oracle RDS. Here we are upgrading our Oracle database from 12c to 19c. For more posts on AWS RDS please check the INDEX page or visit our YouTube channel Upgrades are majorly of 2 types : Major Version...
Heterogeneous Database Migration using AWS SCT
In this post we will see how we can migrate an On-premise Oracle database to Mysql RDS using AWS SCT and AWS DMS Before we proceed with the migration, we need to know what is AWS SCT For more posts on AWS RDS please check the INDEX page or visit our YouTube channel...
Migration and Replication (Full Load + CDC) of On-Premise Oracle 11G database to AWS RDS Oracle 19c
In this post we will see how we can migrate and replicate ongoing changes from an On-Premise Oracle Database to AWS RDS, before which we need to be well aware of the below constraints which you might face while migrating your databases. For more posts on AWS RDS...
Full Load Migration of On-premise Oracle Database to AWS RDS Oracle
In this post we will see how we can migrate an On-Premise Oracle Database to AWS RDS, before which we need to be well aware of the below constraints which you might face while migrating your databases For more posts on AWS RDS please check the INDEX page or visit...
RMAN Tasks in AWS RDS Oracle
Since AWS RDS is a PaaS, we donot have login to the Database host, rather we can connect to the database and there are some built-in queries which can help make our life easier to perform the Backup Operations in AWS RDS For more posts on AWS RDS please check...
Daily Tasks in AWS RDS Oracle
This blog is meant to have a deep understanding on the daily tasks you can perform in Oracle Database hosted in AWS RDS. For more posts on AWS RDS please check the INDEX page or visit our YouTube channel How does RDS work? To deliver a managed service experience,...
Steps to integrate S3 with Amazon Oracle RDS
You can transfer files between an Amazon RDS for Oracle DB instance and an Amazon S3 bucket. You can use Amazon S3 integration with Oracle features such as Data Pump. For example, you can download Data Pump files from Amazon S3 to the DB instance host. For more posts...
Learn MySQL
MySQL Master Master Replication – Step By Step
Here we will be implementing Master Master Replication in MySQL 5.7 For more interesting posts on MySQL, please click on INDEX Below are the server details which will be used : Server 1 : Hostname : Master1 IP Address : 172.168.190.1 Server 2 : Hostname : Master2 IP...
MySQL Upgrade from 5.6 to 5.7
In this post we will see how to upgrade MySQL Database Instance from MySQL 5.6 to MySQL 5.7 NOTE : If you are planning to upgrade in a Master-Slave Environment, please upgrade all Slave Environments first before upgrading Master Server database. Please stop the Slave...
MySQL upgrade from 5.7 to 8.0.21
In this post, we will see how to upgrade your MySQL database from 5.7 to 8.0.21 version NOTE : If you are planning to upgrade in a Master-Slave Environment, please upgrade all Slave Environments first before upgrading Master Server database. Please stop the Slave...
Steps to implement Master-Slave MySQL Replication
Master Server IP : 172.168.190.15 Slave Server IP : 172.168.190.35 For more interesting posts on MySQL, please click on INDEX 1. Take dump on master and restore on slave bin/mysqldump --defaults-file=/mysqldatabase/TEST/admin/my.cnf -uroot -pmysql --master-data=2...
MySQL Replication
To make MySQL a totally reliable and available in cases of high load, database replication and clustering are a possible solution to achieve this For more interesting posts on MySQL, please click on INDEX As MySQL is one of the first open source databases, its...
MySQL Database
What is MySQL Database? MySQL is an open-source relational database management system based on SQL – Structured Query Language. The application is used for a wide range of purposes, including data warehousing, e-commerce, and logging applications. Open Source means...
MySQL Backup and Restore Commands
In this post,I am going to explain the native methods that are used to generate the backup of the database. Mysqldump is a command-line utility that is used to generate the logical backup of the MySQL database. It produces the SQL Statements that can be used to...
MySQL Generic commands
1. Install MySQL instance cd /mysqldatabase/product/binary/5.7.35 bin/mysqld --defaults-file=/mysqldatabase/TEST/admin/my.cnf --initialize --user=mysql For more interesting posts on MySQL, please click on INDEX 2. Start MySQL instance cd...
MySQL 5.7.35 Binaries Installation on Linux
In this post we will see how to install Mysql Database 5.7.35 in Linux Operating System. For more interesting posts on MySQL, please click on INDEX Steps : 1. Create the below directories : mkdir -p /mysqldatabase/TEST/admin/ mkdir -p /mysqldatabase/TEST/logs/ mkdir...
Learn Shell Scripting
Shell Scripting Tutorial – Part 6
FUNCTIONS & SIGNALS 6.1. Signals Finding the signal man page Your system contains a man page listing all the available signals, but depending on your operating system, it might be opened in a different way. On most Linux systems, this will be man 7 signal. When in...
Shell Scripting Tutorial – Part 5
REPETITIVE TASKS & VARIABLES 5.1. FOR loop How does it work? The for loop is the first of the three shell looping constructs. This loop allows for specification of a list of values. A list of commands is executed for each value in the list. The syntax for this...
Shell Scripting Tutorial – Part 4
CONDITIONS & INTERACTIVE SCRIPTS 4.1. IF clause General At times you need to specify different courses of action to be taken in a shell script, depending on the success or failure of a command. The if construction allows you to specify such conditions. The most...
Shell Scripting Tutorial – Part 3
GNU 3.1. Interactive editing What is sed? A Stream Editor (sed) is used to perform basic transformations on text read from a file or a pipe. The result is sent to standard output. The syntax for the sed command has no output file specification, but results can be...
Shell Scripting Tutorial – Part 2
BASH ENVIRONMENT 2.1. Initialization System-wide configuration files /etc/profile When invoked interactively with the --login option or when invoked as sh, Bash reads the /etc/profile instructions. These usually set the shell variables PATH, USER, MAIL, HOSTNAME and...
Shell Scripting Tutorial – Part 1
BASH SCRIPT BASICS 1.1. Shell programs General shell functions - The UNIX shell program interprets user commands, which are either directly entered by the user, or which can be read from a file called the shell script or shell program. Shell scripts are interpreted,...
Learn Ansible
Protected: Deploying Custom Files with Jinja2 Template
Password Protected
To view this protected post, enter the password below:
Protected: Automating Linux Administration Tasks with Ansible
Password Protected
To view this protected post, enter the password below:
Protected: Ansible Roles
Password Protected
To view this protected post, enter the password below:
Protected: Implementing Handlers and handling Task failures in Ansible
Password Protected
To view this protected post, enter the password below:
Protected: Ansible Tutorial Part 7 – Implementing Task Control
Password Protected
To view this protected post, enter the password below:
Protected: Ansible Tutorial Part 6 – Ansible Import & Include with Parallelism
Password Protected
To view this protected post, enter the password below:
Protected: Ansible Tutorial Part 5 – Ansible Vault
Password Protected
To view this protected post, enter the password below:
Protected: Ansible Tutorial Part 4 – Ansible Facts
Password Protected
To view this protected post, enter the password below:
Protected: Ansible Tutorial Part 3 – Introduction to Ansible Variables
Password Protected
To view this protected post, enter the password below:
Protected: Ansible Tutorial Part 2 – Implementing Playbooks
Password Protected
To view this protected post, enter the password below:
Learn Terraform
Restore RDS from existing snapshot using Terraform
In this post, we will see how to restore a RDS using the latest snapshot in AWS We will use 3 configuration files in here. 1. Generic-varibles.tf #Input Variables #AWS Region variable "aws_region" { description = "Region in which AWS Resources will be created" type =...
Create Multi AZ RDS using Terraform
In this post, we will create Multi AZ RDS using Terraform RDS Engine/Version : MySQL 5.7 We will also see how to provide an existing VPC security group using Terraform while creating the RDS. We will just post the configuration files over here. For more details,...
Create an EC2 Instance with 2 Security Groups and Output values
Here we are going to implement how to dynamically get the latest AMI ID from AWS using Terraform Datasource concept and then create the EC2 Instance. We will also create 2 resources which is nothing but VPC-SSH and VPC-Web security group resources so that those can be...
Create a Static Webserver using EC2 Instance in Terraform
Terraform Provider Block # Terraform Block terraform { required_version = "~> 1.0.11" required_providers { aws = { source = "hashicorp/aws" version = "~> 3.0" } } } #Provider Block provider "aws" { region = "us-east-1" } Terraform Resource Block resource...
Create an EC2 Instance with hard coded AMI ID
Terraform Settings block terraform { #required Terraform Version required_version = "~> 1.0.11" #Required Providers and their versions required_providers { aws = { source = "hashicorp/aws" version = "~> 3.21" } } #Remote Backend for storing Terraform state in S3...