ORA-12012 ORA-20001 ORA-06512 Saw an error stack containing ORA-12012, ORA-20001 and ORA-06512 in the alert log. Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL2/trace/ORCL2_j001_3231.trc: ORA-12012: error on auto execute… Read More »How to Resolve ORA-12012: error on auto execute of job
DB_CREATE_ONLINE_LOG_DEST_n is a set of server parameters which specify the default destination where new Oracle-managed redo log files (OMF) should be placed. More precisely, DB_CREATE_ONLINE_LOG_DEST_n… Read More »DB_CREATE_ONLINE_LOG_DEST_n, How and Why
How to Resolve PRKZ-1125 : Oracle Grid Infrastructure Management Repository (GIMR) client is not configured.
PRKZ-1125 Tried to list the configuration of MGMTDB, but it failed with PRKZ-1125. [grid@primary01 ~]$ srvctl config mgmtdb PRKZ-1125 : Oracle Grid Infrastructure Management Repository… Read More »How to Resolve PRKZ-1125 : Oracle Grid Infrastructure Management Repository (GIMR) client is not configured.
ORA-14086 Saw an error when we were trying to rebuild the index to another tablespace. SQL> alter index sh.sales_cust_bix rebuild tablespace users online; alter index… Read More »How to Resolve ORA-14086: a partitioned index may not be rebuilt as a whole
Rebuild Index Partition Yes, index can be partitioned. Since a partitioned index has many segments, we cannot rebuild the partitioned index as a whole. That… Read More »Alter Index Rebuild Partition to Another Tablespace
Query on Views At times, I found that the query to check tablespace usage was running slowly. In the query, we retrieve some data from… Read More »Improve Query on Dictionary and Dynamic Views