Upgrade timezone version to 14 from version 4 after upgrading to 11.2.0.4
Please check this post Database upgrade from 10.2.0.5.0 to 11.2.0.4
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…
Oracle database migration from Windows to Linux
I just wanted to make a post for this: I had a task to migrate an oracle database (11.2.0.1) from Windows to Linux. On linux I have 11.2.0.3 software version. First I did some checks: First I checked the endian: On Windows I get this: SQL> SELECT A.platform_id, A.platform_name, B.endian_format 2 FROM v$database A, v$transportable_platform…
Shutdown hangs due to E000 processes
I had this several times and these are the possible solutions: Shutdown hangs while EMON slaves are spawned for notification (Doc ID 1394945.1) In short, you either apply the patch described on the document or just kill the e000 process. In my case is this: oracle 10371 1 0 Jan28 ? 00:00:03 ora_e000_TESTDB
How to get the encrypted passwords in 11g
This is what I use to get the encrypted passwords in 11g: col name format a10 col DEFAULT_PASSWORD format a17 col status format a17 select u.name,m.status,u.password PASSWORD from sys.user$ u, sys.user_astatus_map m where u.astatus = m.status# order by 1;
How to rename a database instance on the same host
Something that I was working on and it turned to be very easy. Below you’ll find what I did: MAIN3 = the name of the main database CL3= the name of the clone database Prepare the new database locations: # Create the necessary folders: mkdir -p /u01/app/oracle/admin/CL3/adump mkdir -p /u02/oradata/CL3 mkdir -p /u03/oradata/CL3 mkdir -p…
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# –,…
Check default temp tablespace
col PROPERTY_NAME format a50 col PROPERTY_VALUE format a50 col DESCRIPTION format a50 set lin 300 SELECT PROPERTY_NAME,PROPERTY_VALUE,DESCRIPTION FROM DATABASE_PROPERTIES where PROPERTY_NAME=’DEFAULT_TEMP_TABLESPACE’;