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
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
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
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
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