Dear Readers, In this article, we will see the following Installation of MySQL 8.0.21 On RHEL Using Generic Binaries in AWS Cloud . Steps to Follow : Logging to AWS Account Launch MySQL EC2 Instance Connect to Linux EC2 Instance by Using Putty Switch to… Read More
Dear Readers, In this article, we will see the following Installation of Oracle Database 19c On Windows. Step-1: 👉 Download the Oracle Database Software Download the Oracle Database 19c software (Windows Version) by the below link. https://www.oracle.com/database/technologies/oracle-database-software-downloads.html#19c Oracle software will be downloaded in zip format … Read More
Dear Readers, In this article, we will see the following MySQL Upgrade from 5.6 to 5.7 to 8.0 1. Logging to AWS Account First, we need to AWS Console page by using below link. https://aws.amazon.com/console/ Click on sign in to Console button. Logging to aws… Read More
Dear Readers, In this article, we will see the following MySQL Upgrade from 5.7 to 8.0 1. Logging to AWS Account First, we need to AWS Console page by using below link. https://aws.amazon.com/console/ Click on sign in to Console button. Logging to aws account Login… Read More
Dear Readers, In this article, we will see the following MySQL Upgrade from 5.6 to 5.7. 1. Logging to AWS Account First, we need to AWS Console page by using below link. https://aws.amazon.com/console/ Click on sign in to Console button. Logging to aws account Login… Read More
Dear Readers, In this article, we will see the following Install MySQL 5.7 On RHEL 8 . Steps to Follow : Logging to AWS Account Launch MySQL Server Connect to Linux EC2 Instance by Using Putty Switch to root user Install Server Updates Install wget… Read More
Dear Readers, In this article, we will see the following Install MySQL 5.7 On RHEL 8. Steps to Follow : Logging to AWS Account Launch MySQL Server Connect to Linux EC2 Instance by Using Putty Switch to root user Install Server Updates Install wget package… Read More
Dear Readers, In this article, we will see Auditing using Percona XDB plugin. Database auditing is the monitoring of selected actions of database users. It doesn’t protect the database in case privileges are set incorrectly, but it can help the administrator detect mistakes Audits are… Read More
Dear Readers, In this article, we will see the following Install MySQL 5.6 On RHEL . Steps to Follow : Logging to AWS Account Launch MySQL Server Connect to Linux EC2 Instance by Using Putty Switch to root user Install Server Updates Install wget package… Read More
Dear Readers, In this article, we will see the following Free Buffer Wait . Buffer Cache Management : 👉 Locating free blocks (Data to write) 👉 Finding data blocks (Data to read) 👉 Managing LRU lists (Flushing least recently used blocks) 👉 Cleaning dirty buffers… Read More
Dear Readers, In this article, we will see the following Transfer Files from One Server to Another Server Using SFTP. Login as root and install sshpass package : [oracle@db2 u01]$ su – root [root@db2 ~]# yum install sshpass Create text file and Create .sh file… Read More
Dear Readers, In this article, we will see the following Internal mechanism of Buffer Cache. Buffer cache management : 👉 Locating free blocks (Data to write) 👉 Finding data blocks (Data to read) 👉 Managing LRU lists (Flushing least recently used blocks) 👉 Cleaning dirty… Read More
Dear Readers, In this article, we will see the following Check Partition Summary More than N Days (60 Days). Script : cat parti_last_60days.sh #!/bin/bash #Script to Check Partition In last 60 Days #./Partition Report.sh DEMO ## Environment variables TODAY=`date +%d-%b-%Y-%H:%M:%S` rm /tmp/part1.log /tmp/part.log touch /tmp/part1.log… Read More
Dear Readers, In this article, we will see the Daily Tips for Exadata. Tip-2 : Date: 12-Dec-20 Provided By (Linkedin): Ankush Chawla 👉 Exadata patches following components 👉 DB Home 👉 Grid Home 👉 DB Server (patchmgr)… Read More
Dear Readers, In this article, we will see the Daily Tips for GoldenGate. Tip-1 : Date: 12-Dec-20 Provided By (Linkedin): Ankush Chawla LogDump is a popular utility to troubleshoot GoldenGate issues: It allows to : 👉 Read… Read More
Dear Readers, In this article, we will see TableSpace Menu Bar in SecureCRT . TBS_FREE : set linesize 130 set pagesize 1000 col tablespace format a30 select tablespace_name tablespace, round(sum(a.total1)/1048576, 0) Total, round(sum(a.total1)/1048576, 0)-round(sum(a.sum1)/1048576, 0) used, round(sum(a.sum1)/1048576, 0) free, round(((sum(a.sum1)/1048576)/(sum(a.total1)/1048576))*100, 0) pct_free, round(sum(a.maxb)/1048576, 0) largest,… Read More
Dear Readers, In this article, we will see the Daily Tips for PostgreSQL. Tip-1 : Date: 07-Dec-20 Provided By (Linkedin): Ankush Chawla Public Role and Schema: 👉 This very interesting feature of PostgreSQL. 👉 When a new… Read More
Dear Readers, In this article, we will see the following Daily Tips for AWS. Tip-1 : Date: 07-Dec-20 Provided By (Linkedin): Bhagyasri History of AWS: 👉 AWS was first to market with a modern cloud infrastructure service… Read More
Dear Readers, In this article, we will see the following Daily Tips for DevOps. Tip-1 : Date: 09-Dec-20 Provided By (Linkedin): BhagyasriHistory of DevOps: 👉 The word “DevOps” was coined in 2009 by Patrick Debois, who became… Read More
Dear Readers, In this article, we will see the following Daily Tips for Data Science. Tip-1 : Date: 07-Dec-20 Provided By (Linkedin): Arjun Reddy 👉Data Science is doing reseach on past data to genereate the fact-based reports… Read More
