Tag: Oracle

Starting with 12c, running datapatch may be required after creating a database, depending on the database version and method for creating the database. Instead of having to remember all the variations, it’s much simpler just to run datapatch -prereq after creating…

I was recently working on a Proof Of Concept to migrate RAC non-CDB to CDB. I faced multiple issues and wanted to start fresh. In order to do this, I needed to delete the newly RAC CDB database. Review database…

Linux 7 introduced multiple changes and enhancements to the kernel. Among them was automated housekeeping for temporary files. In version 6, tmpwatch is available to manage unused files in temp directories. It can be scheduled via cron to automatically keep…

DBA typically checks cluster resources as part of patching efforts. However, when checking cluster resources returns 200+ results, it’s not feasible to verify the results and it’s too time-consuming. A better solution is to find a cluster resource where the…

There may be many reasons as to why Oracle ACFS volume would need to be resized. Current Filesystem for ACFS is 299G. Free_MB is 872 which causes paging due to insufficient FREE space from ASM Disk Group ACFS_DATA. Option 1…

I am currently working on project to migrate GoldenGate trail from Oracle Database File System (DBFS) to Oracle Automatic Storage Management Cluster File System (ACFS). The migration is performed in two phases. This is the first phase, in which I create…

Problem: MGMTDB and MGMTLSNR are running on only one host at a time and when relocated, will be paged unnecessarily. One team member`s suggestion is to relocate MGMTDB and MGMTLSNR back to its original host. It does not make sense having…

Now that Oracle Grid Infrastructure (GI) 19c has been released, it is time to upgrade your GI to 18c! I am presenting here a well-tested procedure to upgrade your Grid Infrastructure to 18c. It has been designed and applied on…

I wanted to compare Oracle Recovery Manager (RMAN) backup to an existing NFS versus a NEW backup appliance. I performed a Proof Of Concept (POC) to compare and contrast NFS and NEW, backed up both, then mined the logs to…

Problem Having decided to move our Oracle databases to the cloud, we now want to build equivalent VMs as database servers.  This is simple enough when we have only one or a very small number of databases. But this can…