Yearly Archives: 2017

Home »  2017

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…

Create a new Pluggable Database using DBCA !!!

On April 13, 2017, Posted by , In 12c, By , , With No Comments

In this article, we will create a new Pluggable database using DBCA. Here we have one Container database already created. ======================================================================================================   Follow below steps to create a new multitenant PDB using DBCA. Login as oracle user and run dbca $ dbca – Database Operation Select “Manage Pluggable Databases” and…

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…