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 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 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 MoreCloning Tables Between Databases in SQL Server Using Export and Import Functions
Overview: Cloning tables between databases in SQL Server can be efficiently achieved through the use of the built-in export and import functions. This process involves exporting data from the source…
Read MoreINSTALLATION OF OEM 13.5 USING SILENT METHOD IN ORACLE DATABASE 19.3 ON LINUX.
OEM OVERVIEW: Oracle Enterprise Manager is management tool, which is used for integrated solution for managing your heterogeneous environment. It Includes, Graphical console, Agents, Common Services and Tools to provide…
Read MoreUpgrading Oracle database from 12.1.0.2 to 19.20 using AutoUpgrade tool
This blog aims to support DBAs upgrading databases from 12.1.0.2 to 19.20 using the new AutoUpgrade tool. Oracle Database AutoUpgrade is the supported and recommended method for upgrading Oracle database.…
Read MoreConverting a Non-CDB to PDB using remote cloning method
This blog aims to support DBAs in converting a Non-CDB database to a PDB using remote cloning method. Note: Non-CDB and target CDB are on different hosts (both on-premises) Create…
Read MoreExploring the significance and utility of responsive number counters in Oracle APEX applications
Overview A responsive number counter is not only capable of displaying numeric values but also adjusts its appearance. It provides a means to present data or perform calculations based on…
Read More