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 MoreTerraform 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 MoreBackup 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 MoreMYSQL 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 MoreCREATING 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 MoreIdentify 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 MoreControlling 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 MoreDatabase 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 MoreHow 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