Database upgrade from 10.2.0.5.0 to 11.2.0.4

The following document is the best one you can start documenting yourself from: 11gr2-upgrade-bp-apr2012-1610082.pdf From the above document, I followed: Note 251.1: Database Upgrades from 10.2 to 11.2 On that note, on the PLAN tab, I followed: Complete Checklist for Manual Upgrades to 11gR2 (Doc ID 837570.1) In this document you’ll find a bunch of…

Time to upgrade the OPatch

As the title suggest, it’s time to upgrade the OPatch. This is what I got when I wanted to apply a patch (namely 20760982) to a 11.2.0.4 database (linux): [[email protected] 20760982]$ $ORACLE_HOME/OPatch/opatch apply Oracle Interim Patch Installer version 11.2.0.3.4 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0.4 Central Inventory : /u01/app/oracle/oraInv from…

ORA-00354: corrupt redo log block header

Recently I got a problem with one of the ORLs; like the title is suggesting, one of the ORL got corrupted (don’t ask how!) and below is what I did: ORA-00354: corrupt redo log block header ORA-00353: log corruption near block 8741986 change 136264748341 time 09/06/2016 12:47:59 ORA-00312: online log 4 thread 1: ‘/u2000/oradata/DB/redo4a.log’ What…

Where is the TEMP space used?

The following statements should give us more indication about the TEMP usage and what is using it: col username format a10 col osuser format a8 col SID_SERIAL format a8 col PROCESS format 9999999 col tablespace format a7 col status format a9 col size_mb format 9999999999999 set lin 300 SELECT   b.TABLESPACE        –, b.segfile#        –,…