Category Archives: ORACLE

Home »  ORACLE

Reinstall XDB database component !!!

On July 3, 2017, Posted by , In ORACLE, By ,, , With 2 Comments

In this article, we will see the steps to reinstall XDB database component. Reference taken from: Master Note for Oracle XML Database (XDB) Install / Deinstall (Doc ID 1292089.1) ======================================================================================================   Follow below steps to reinstall XDB component – Take full database backup Before proceeding with resinstallation of XDB, it…

Rename DiskGroup containing OCR and Voting Disks !!!

Recently encountered a issue where we had to rename a diskgroup for 11gR2 RAC containing OCR and Voting Disk. Luckily we had not created any database yet, only installed Oracle Database binaries. In this blog, we will see the steps to Rename DiskGroup containing OCR and Voting Disks. Below are…

Drop default TEMP tablespace and recreate !!!

On March 13, 2017, Posted by , In ORACLE, By , , With No Comments

There may be scenarios when you want to resize your default temporary tablespace because of multiple reasons. In this article, we would be dropping the default TEMP tablespace since we want to resize it. You can perform below steps to drop default TEMP tablespace and recreate. ======================================================================================================   – Create…

12c Dataguard Broker Configuration !!!

On December 6, 2016, Posted by , In Dataguard,ORACLE, By ,, , With No Comments

This article is a continuation to our previous article i.e. 12c RAC to RAC Dataguard configuration. In this post, we will see the 12c Dataguard Broker configuration steps. To configure a dataguard broker, we need to use the dgmgrl command which is a command line interface. ======================================================================================================   Perform the…

Migrate database from 32 bit to 64 bit !!!

On October 9, 2016, Posted by , In ORACLE,RMAN, By ,, , With No Comments

In this article, we will see the steps to migrate database from 32 bit to 64 bit OS using RMAN. Operating System (OS) will be same for both source and target servers, except that the source server is 32-bit whereas the target server is a 64-bit architecture. Below is information…

UNNAMED datafile issue on Standby Database !!!

On October 3, 2016, Posted by , In ORACLE, By ,, , With No Comments

In this article, we will see the steps to resolve UNNAMED datafile issue on Standby Database. Primarily there are 2 reasons for UNNAMED file getting created on Standby database. 1. Insufficient available space on filesystem/disk group for the datafile to be created on standby database. 2. If “standby_file_management” parameter is…

Install Oracle Multimedia component in 12c database !!!

In this article, we will see the steps to manually install Oracle Multimedia component in 12c database. You can also install the component using DBCA GUI mode. ======================================================================================================   Perform below steps to install Oracle Multimedia component • Pre-requisites for Oracle Multimedia Verify whether the below components are installed or…

Silent Database creation using DBCA !!!

In this article, we will see silent database creation using DBCA. We will see the commands for creating RAC database, RACOneNode database and Single database. Here I assume that you have already installed Oracle binaries. We will be using storage as ASM for all the examples. ======================================================================================================   Follow the…

Convert the upgraded 12c database to PDB !!!

On January 22, 2016, Posted by , In 12c,ORACLE, By , , With No Comments

This article is a continuation to our previous article where we have upgraded 11gR2 database to 12c database. In this article, we will see the steps to convert the upgraded 12c database to PDB. ======================================================================================================   Follow the below steps to convert to PDB. • Create a container database If…

Change RMAN Retention Policy of a Standby Database !!!

On November 9, 2015, Posted by , In ORACLE, By , , With 2 Comments

Once a standby database is created, it is not possible to change the backup retention policy on the fly. In this article, we will see how to change RMAN retention policy of a standby database. ======================================================================================================   There may be situation where you might need to change RMAN retention policy…