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...

There are lot of new features introduced by Oracle in 12c Release 2 version when compared to 12c Release 1. Here are some of the...

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...

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...