Tag: Oracle

How to extend the /u01 filesystem on an Exadata

Marketers are very good at selling everyone on the fact that resources (CPU, disks, memory) are now infinite, which is mainly true on a slide but it’s less true in real life. You may one day face this situation with…

Read More >

Weighing the pros and cons of Oracle Autonomous Database

The next generation of managed database services is upon us, offering organizations of all sizes the ability to scale database workloads quickly without forking out huge investments in either hardware or specialized expertise. One of these services is Oracle Autonomous…

Read More >

Testing the 19c Grid Infrastructure by Performing a Dry-Run Upgrade

In reviewing Grid Infrastructure Installation and Upgrade Guide for Linux, I discovered the dry-run upgrade mode to test upgrades. With dry-run being a new feature, I tested it first using GUI. From the response file above grid_2019-08-06_00-20-31AM.rsp, create dryRunForUpgradegrid.rsp: Create…

Read More >

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 >
Page 1 of 15812345...10...Last Page »