Monthly Archives: January 2024

Inventory load failed in Oracle APPS R12

Inventory load failed in Oracle APPS R12   Inventory load failed… OPatch cannot load inventory for the given Oracle Home in Oracle APPS R12.   Possible causes are:   oradev@oracle…

Read More

Terraform Orchestration: Scaling Infrastructure Deployment with Modules and Workspaces

The Challenge:As infrastructures grow in complexity, maintaining and deploying resources across multiple environments can become a daunting task. Code duplication, consistency challenges, and scaling bottlenecks are common hurdles. The Terraform…

Read More

Rotate any logs with logrotated.services

                                                           …

Read More

Backup and Restore MySQL Database

Introduction: In this article, we are here to know different ways to generate the backup in the MySQL database server. It is essential to make regular backups of all data…

Read More

MYSQL DB SWITCHOVER

INTRODUCTION: This doc will guide you through the process of performing a MySQL replication switchover, ensuring a smooth transition without any data loss. Let’s dive into the step-by-step instructions. Step…

Read More

CREATING MAINTENANCE PLAN FOR BACKUP

A maintenance plan is a set of measures (workflows) taken to ensure that a database is properly maintained and routine backups are scheduled and handled.  Login to the server Go…

Read More

Identify and remove unused indexes in SQL Server

Identify and remove unused indexes in SQL                         Server   Introduction: Indexes means order information about data, with indexes we can retrieve data from the database more quickly than otherwise. Index…

Read More

Controlling visibility of databases and server level setting by Contained Database

Controlling visibility of databases and server level setting by Contained Database Introduction: Contained Database is a new feature of SQL Server 2012. A contained database is a database that is…

Read More

Database Migration from Non-ASM to ASM

We are going to convert our oracle Database to be migrated from Non ASM to ASM storage using RMAN commands  Check the ASM instance is up and running If not…

Read More

How to install POSTGRESQL and PGADMIN on linux 7 (REDHAT,CENTOS,ORACLE LINUX)

  INTRODUCTION:  This doc will guide you through the process of installing Postgresql14, Pgadmin4 and also Creating users, databases, schemas VERSION: PostgreSQL14 PGAdmin-4 Verify Platform compatibility  using below link https://www.enterprisedb.com/resources/platform-compatibility…

Read More