How to Make a Local Yum Repository
Sometimes, the Linux servers does not have any internet connection in the environment, thus yum command has no way to resolve dependencies among being installed… Read More »How to Make a Local Yum Repository
How to Resolve ORA-12012: error on auto execute of job
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, How and Why
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
DB_CREATE_FILE_DEST, How and Why
DB_CREATE_FILE_DEST is a server parameter which specifies the default destination where new Oracle-managed data files (OMF) should be placed. In this post, we'll talk about… Read More »DB_CREATE_FILE_DEST, 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.
How to Shrink Empty Tablespace
Shrink Empty Tablespaces Dropping empty tablespaces for reclaiming unused space is not a reversible operation, any mistake may cost you a lot in a production… Read More »How to Shrink Empty Tablespace
How to Resolve ORA-14086: a partitioned index may not be rebuilt as a whole
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
Alter Index Rebuild Partition to Another Tablespace
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
Improve Query on Dictionary and Dynamic Views
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
How to Drop Empty Tablespace
In previous post, we have talked about how to identify empty tablespaces for dropping. In that post, we cautiously check the status of the tablespace… Read More »How to Drop Empty Tablespace