Tag: Oracle

Why it’s Good Practice To Run datapatch -prereq After Creating Database

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…

Read More >

How to delete an RAC Database Using DBCA silent mode

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…

Read More >

How to Prevent Linux 7 Housekeeping from Breaking Oracle

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…

Read More >

How to Find Cluster Resources Where Target!=State

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…

Read More >

How To Resize Oracle ACFS Volume

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…

Read More >

Using rsync to Copy GoldenGate Trails from DBFS to ACFS

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…

Read More >

How To Delete MGMTDB and MGMTLSNR Using emcli

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…

Read More >

How to Upgrade Grid Infrastructure to 18c

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…

Read More >

How to mine an RMAN Log

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…

Read More >

Three Easy Steps For Consolidating Oracle Databases into Cloud Virtual Machines

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…

Read More >
Page 2 of 15812345...10...Last Page »