Oracle Database&EBS General
-
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
-
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
-
Operations on Scan listener
There arethe some example of stop/start/add/relocate SCAN Listener command. Here is example: Continue reading
-
How to increase apply rate on Standby Database
If your primary has huge load or if there are huge gap on your standby, you may need to increase your apply rate on your standby database.Do not forget your standby server’s CPU and Disk should be strong enough for this actions. Here is the steps Continue reading
-
12.2 space advisor job fails with ORA-12012 and ORA-00060:
Hi friends… One of our 12.2 db we got below errors from alertlog: ORA-00060: deadlock resolved; details in file /u01/app/oracle/diag/rdbms/db_name/DB_NAME/trace/DB_NAME_j001_10041.trcORA-12012: error on auto execute of job “SYS”.”ORA$AT_SA_SPC_SY_56337″ORA-00060: deadlock detected while waiting for resourceORA-06512: at “SYS.DBMS_SPACE”, line 2741ORA-06512: at “SYS.DBMS_HEAT_MAP_INTERNAL”, line 716ORA-06512: at “SYS.DBMS_HEAT_MAP_INTERNAL”, line 1164ORA-06512: at “SYS.DBMS_HEAT_MAP”, line 228ORA-06512: at “SYS.DBMS_SPACE”, line 2747 Continue reading
HELIOS BLOG 