You can find related script by below

Enjoy!!

Yazının devamını oku »

You may need to move some objects to another tablespace or you may need to move all objects to one new tablespace under schema

I will share some sql statement to achieve this purpose. Here is the steps:

Yazının devamını oku »

These days, CDs and DVDs are not popular. However, you still may need to use CD drive to able to insert a disc and mount it on Linux for your needs.

In this post we will do it step by steps. Here are the our steps:

Yazının devamını oku »

This issue often occurs at Oracle database 12c installation process. But I faced with that error message during restore/recovery operation…

This error occurs whenever we want to mount the database but the multitenant container database was not set up properly. To fix this, follow below commands

Yazının devamını oku »

As you know Redo files are one of the most important file for Oracle databases. It have to be mirror and also have big enough for performance and contunity.

In Oracle formal documentation, redo switch should be between 6-8 in 1 hour. If you have a number than this( its also related what you are running) you need to change your redolog file size.

In this post, I try to explain how we can resize redolog files on RAC instance while we have ASM.

Yazının devamını oku »

In some case, you would need to move or rename your datafiles which is belong to your tablespaces in your database.

I try to explain step by step how you can move your data files on your system.

Yazının devamını oku »

RMAN List backup is a useful command to list the backup taken in the system. It shows all the details about the backup taken, what time it was taken, location of the backup.

Let us see our commands:

Yazının devamını oku »

I faced with that error on one of our 11.2.0.4 database.

We got ora-600 error on our alert.log. After investigate issue we have found our error is matches unpublished Bug 5368945 – ORA-00600: [KDSGRP1] ON XQUERY

A common situation hitting this bug is when using XDB/XML queries (XQUERY/SQLX) as IOT’s can be involved.

Yazının devamını oku »

We are not Unix admin but we have to know some basic commands as a dba. In this post i try to share some of most usefully command for Unix based system.

Here is the some usage and examples

Yazının devamını oku »

I wanted to share latest update&details for current database support&end of life.
Short information can be found below. For more details you can check this link

The bug fixing has been ended for Oracle 12.2.0.1 on Nov 20, 2020. For 12.2.0.1 is running on the limited Error Correction from Dec 1, 2020 through March 31, 2022. (PS: Limited Error Correction means you can open Sev 1 Sr and follow Security Updates only)

You need to 19c version which that gives you a long term support, as the full span of bug fixing support until 31-APR-2024. THis version have Extended Support until 31-Apr-2027. Premier Support (PS) ends April 30, 2024 and you need to pay Extended Support (ES) fees beginning May 01, 2024 through April 30, 2027.

For fully details available at
Release Schedule of Current Database Releases (Doc ID 742060.1)