-
Step By Step Resize Redolog Files in Oracle
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… Continue reading
-
Step by Step Rename or Move Datafiles
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. Continue reading
-
Select Fails With ORA-600 [kdsgrp1] on 11gR2
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. Continue reading
-
UNIX Basics for the DBA
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 Continue reading
-
Latest info for Oracle Database version supports&end life
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.… Continue reading
-
Oracle DBA Daily/Weekly/Monthly or Quarterly Checklist/Tasks
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 Continue reading
-
Install 19c Grid Infrastructure on Standalone Server
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: Continue reading
-
How To Use your ISO image as YUM repo?
If your linux server do not have internet access it could be very hard to install some rpms on your operating system. If you have cdrom and iso image than you can create your own Repo by using your linux iso. Here is the steps: Continue reading
-
ORA-65093: multitenant container database not set up properly on Oracle Database
This issue often occurs in a Oracle database 12c&onward installation or restore operation. The error stated that multitenant container database not set up properly, which means we have to set the enable_pluggable_database to True while on restore steps. To fix this, connect to your Oracle Database using the sysdba user: sqlplus / as sysdba startup… Continue reading
AWARDED TOP 60 ORACLE BLOGS SINCE 2018
Recent Posts
- Oracle CDB vs Non-CDB: A Future-Ready Database Architecture
- Hot Cloning of a PDB in Oracle Database
- Oracle + Artificial Intelligence = Smarter Database Management
- Understanding UNDO Tablespace in Oracle Database: Importance and Best Practices
- Fortifying Your Cloud: Understanding the OCI Zero Trust Landing Zone
CATEGORIES
- Cloud Computing Tutorials
- My Presentations
- Oracle Cloud Journey
- Oracle Database&EBS General
- Oracle E-Business Suite Release 11
- Oracle E-Business Suite Release 12
- Scripts for Oracle E-Business Suite
- Some other Oracle Products Installation
- Step by Step Oracle E-Business Suite Installation
- Video Tutorials
HELIOS BLOG 