Certification
Become a certified expert with our various Certification modules available. Open up better job prospects for yourself. Get hired by the top MNCs in India.
Start Learning for FREE
Check out our blog for awesome articles on Database, Cloud and more. Get started with basic tips and tricks. It’s 100% free and it always will be!
Check Out Our YouTube Channel
Get free video lessons, walkthroughs, and demos on our YouTube channel. It’s totally free and meant for complete beginners.
Check Out Our Latest Posts
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...
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...
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”
Environment Operations Fail With “bash: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory”
Recently I faced this problem while trying to start MySQL Database Instance on a new Linux Environment : error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory In the below step, we can see ncurses 6.1...
Mount a File System in Linux
To mount a File System in RedHat Linux, please perform the below steps: 1. Identify the newly added Disk [root@localhost ~]# fdisk -l Disk /dev/sda: 85.9 GB, 85899345920 bytes, 167772160 sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical):...
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...
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. ...
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
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 =...
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...