You are currently browsing the category archive for the ‘Oracle Database&EBS General’ category.

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 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 on Nov 20, 2020. For 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)

This is the most common question for beginners or all of us. Database is living system, every second it has doing something. As a dba we need to check some informations to keep our db up and work 7×24 without any problems.

Here is the simple task lists

Yazının devamını oku »

I faced this issue on 19c grid installation on linux 7. Our first steps is complete grid installation by using software only option.

That steps do not give any errors. But Grid background process such as ora.evmd,ora.cssd do not work.

Also srvctl command is not running.

So what we need? Here is the steps:

Yazının devamını oku »