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”

read more

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

read more

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

read more

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

read more

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

read more

Learn Oracle

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

read more

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

read more

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

read more

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",...

read more

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

read more

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

read more

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

read more

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

read more

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

read more

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

read more

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

read more

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

read more

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

read more

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

read more

Learn MySQL

 

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

read more

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

read more

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

read more

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

read more

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

read more

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

read more

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

read more

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

read more

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

read more

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

read more

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

read more

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

read more

Learn Ansible

 

Learn Terraform

 

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

read more

Learn Ansible

 

Learn AWS

Learn AWS

Learn AWS