Posts by Ajay Kumar

Installation of DbFetchX application in Oracle database

Introduction: DbFetchX is a robust application designed to streamline data extraction, transformation, and retrieval from Oracle Databases. Its installation involves integrating the application’s schema, objects, and configurations into an Oracle…

Read More

OS upgrade from version Linux 7 to 8 in OCI console

  Introduction: Upgrading from Linux 7 to Linux 8 in the Oracle Cloud Infrastructure (OCI) environment is a crucial step to ensure the operating system is up-to-date, secure, and capable…

Read More

Backup and Restore validation for Oracle database in OCI console

Introduction: Oracle Cloud Infrastructure (OCI) offers robust tools and features that allow database administrators to manage backups and restores efficiently. Ensuring that data is securely backed up and easily restorable…

Read More

Steps to apply and rollback patch in OCI console

Introduction : Maintaining the security and performance of your Oracle Database is crucial, and applying patches is a key aspect of this maintenance. Oracle Cloud Infrastructure (OCI) simplifies the process…

Read More

SETUPAWS CERTIFICATE TO SEND E-MAIL

SETUPAWS CERTIFICATE TO SEND E-MAIL    Download the certificates from the link provided by Amazon. Click on PEM Copy the text. Create five certificate file using notepad with extension .crt. Move…

Read More

Enabling Database management and Operation insights in OCI console

Enabling Database management and Operation insights in OCI console   Enabling Database Management: Navigate to the Observability & Management. In the Observability & Management, under Database Management section select the…

Read More

Steps to create ACFS file system

Step 1: List the disks using the below command. #oracleasm listdisks Step 2: Create the oracleasm disk using the below command. #oracleasm createdisk ARCH03  /dev/mapper/DISK014_ARCH_4T1 Step 3: Scan the disks…

Read More

HOW TO ACCESS ORATOP UTILITY

Description : Oratop is an interface that takes data from top and oracle databases on a host. The utility combines the data to OS data and session data. It allows…

Read More

MICROSOFT WINDOWS 19C DATABASE CREATION

                                        STEPS TO CREATE 19C DATABASE IN MICROSOFT WINDOWS    STEP…

Read More

MICROSOFT SQL DATABASE CREATION

STEPS TO CREATE THE MS-SQL DATABASE     STEP 1:  Download the .NET Framework version 3.5 and above, if not installed already.      STEP 2:  Download the SQL server –…

Read More