Miscellaneous

DBCA Does Not Display ASM Disk Groups In 12cR2

I was installing Oracle 12c R2 with ASM but somehow the DBCA did not list ASM diskgroups. After struggling for hours, I could find a...

Oracle Cold Database backup is rarely used these days. DBAs hardly take cold database backup but sometimes it is important to take one...

When you try to add data files or resize existing data files, you cannot go with any number in your mind. Oracle database has limitations...

A rolling upgrade allows you to perform database upgrade without having any noticeable downtime to the end users. There are multiple ways...

Control file and Redolog file contains crucial database information and loss of these files will lead to loss of important data about...

This article describes how to remove oracle software from a Linux server. There are different methods with which you can remove the...

It’s always a good ideas to create Oracle database using DBCA. This method of creating Oracle database is outdated but you must also know...

Daily DB Health Checks Below are daily checks which are to be performed by a DBA: Check all instance, listener are up and running SELECT...

In this article we will creating a table cluster inside Oracle. We will also be creating couple of tables inside the cluster table....

The below script will drop all the objects owned by a schema. This will not delete the user but only deletes the objects SET SERVEROUTPUT...

In this article, we will learn about the traditional Oracle Export and Import utility Oracle Export Oracle Import Oracle Export To know...

Hot and cold database cloning methods are outdated and these methods of cloning are only for good to know purpose. Currently all cloning...