Upgrade oracle 11.2.0.1 to 11.2.0.4

Software information
Patch 13390677: 11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER
Product                Oracle Database - Enterprise Edition
Oracle Server - Standard Edition
Hide Release      Oracle 11.2.0.4.0
Platform IBM AIX on POWER Systems (64-bit)
Size        7.3 GB

Download software  from oracle support

1.       Oracle 11.2.0.4 Database Software Installation
2.       Navigate to directory where database software was unzipped
3.       As root user, run rootpre.sh
4.       As Oracle user, ensure all ORCALE* and TNS* variables are unset
5.       Create required install directory
6.       Ensure Xwindows settings are correct
7.       Run the OUI, ./runInstaller
8.       Leave blank and click next. This will cause a new error dialogue box to appear, click yes to continue
9.       Select skip software updates and click next.
10.   Select install database software only and click next. (Upgrade to database will be a manual process covered in the next section)
11.   Ensure English is selected and click next
12.   Select Enterprise edition and click next
13.   Specify Install location for new database OHOME and click next
14.   Click next. The installer will now perform some pre requisite checks.  If server has been configured correctly there should be no failures/warnings reported
15.   Check summary screen and click install
16.   Once the software has installed ok, you will be asked to run a script as the root user, 11g-OHOME/root.sh.
17.   Oracle 11.2.0.4 Database Software Installation completed

check the last night backup of the database and archive logs

Run dbupgdiag.sql script and follow and recomendations e.g. Pre process audit records via  Audit_Pre_Process.sql

SQL> EXECUTE dbms_stats.gather_dictionary_stats
SQL> PURGE DBA_RECYCLEBIN
SQL> @$11g_ORACLE_HOME/rdbms/admin/utlrp
Login to sqlplus as sys and create a spool file
SQL> @$11g_ORACLE_HOME/rdbms/admin/utlu112i.sql
Spool off and check output file for any issues, fix issues and run suggest routines
"startup database in mount mode, Create restore point:
SQL> create restore point BEFORE_UPGRADE guarantee flashback database;
"
Start db upgrade assistant @$11g_ORACLE_HOME/bin/dbua
Confirm no warning are displayed from pre-check script, act on any warnings
select database to be upgraded
select degree of parallelism for recompile
select upgrade Timezone version and Timestamp with Time Zone data
Accept and proceed with upgrade
Monitor upgrade process for any run time errors, validate completion report
UPGRADE COMPLETE
SQL> drop restore point BEFORE_UPGRADE

set compatible parameter to 11.2.0.4
Analyze all schemas - Objects analyzed with 100% Sample set and system stats removed

You need to perform an out of place upgrade.

1. Install 11.2.0.4 on a different home
2. run the pre-upgrade tool on the existing 11.2.0.1 database
3. peform the pre-requisities mentioned
4. Bring down the database from 11.2.0.1 and start the database in upgrade mode from 11.2.0.4 home by copying the pfile/spfile of 11.2.0.1 database to $11.2.0.4_HOME/dbs path
5. startup upgrade and run the catupgrd.sql

Make sure you look out for the invalid objects.

Refer *Complete checklist for out-of-place manual upgrade from previous 11.2.0.N version to the latest 11.2.0.N patchset. [ID 1276368.1]

and

Database Upgrade Path Reference List(Doc ID 730365.1)

. Install 11.2.0.4.0 rdbms software
11.2.0.4 patch set is a full release. There is no need to install 11.2.0.1 software
See Note 1189783.1 Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2

Beginning with the release 11.2.0.2 patch set, you have two ways to apply a patch set :
- Out-of-place upgrade (Recommended)
- In-place upgrade

See Note 1276368.1 : Complete checklist for out-of-place manual upgrade from previous 11.2.0.N version to the latest 11.2.0.N patchset

The software can be downloaded from My Oracle support: Patch:13390677

Please select your platform before downloading (Click on "Platform or Language" drop down menu)

if the platform name contains (32-bit) then it's 32-bit 11.2.0.4 client version

To install 11.2.0.4, you must download both p13390677_112040_<platform>_1of7.zip
and p13390677_112040_<platform>_2of7.zip

<platform> = your platform( ie for linux x86, download p13390677_112040_LINUX_1of7.zip and
p13390677_112040_LINUX_2of7.zip )

Note 1194734.1 : Where do I find that on My Oracle Support (MOS) [Video]
Note 549617.1 : How To Verify The Integrity Of A Patch/Software Download? [Video]
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix


2. Finish the post installation steps as per the patchset README (readme.html).


REFERENCE:
  11.2.0.4 Patch Set - Availability and Known Issues Note:1562139.1
  11.2.0.4 Patch Set - List of Bug Fixes by Problem TypeNote 1562142.1
Actions For DST Updates When Upgrading To Or Applying The 11.2.0.4 Patchset Note 1579838.1




Comments

  1. UnknownJune 15, 2022 at 6:34 AM

    hello friend, could you do me the great kindness, if you have share me a link to download patch 11.2.0.4 for windows 32-bit and 64-bit.


    oracle won't let me download

    thanks

    ReplyDelete

Post a Comment

Popular posts from this blog

QUERY DATAGUARD AND STANDBY STATUS

-- Find which logs were applied in the last day  SELECT SEQUENCE#, to_char(FIRST_TIME,'hh24:mi:ss dd/mm/yyyy'), to_char(NEXT_TIME,'hh24:mi:ss dd/mm/yyyy'),APPLIED FROM V$ARCHIVED_LOG where next_time>sysdate-1 ORDER BY SEQUENCE# ; -- Find last applied log   select to_char(max(FIRST_TIME),'hh24:mi:ss dd/mm/yyyy') FROM V$ARCHIVED_LOG where applied='YES';   -- What are the managed standby processes doing?   SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;   -- Are we on production or standby?  SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE;   -- Check for errors  SELECT MESSAGE FROM V$DATAGUARD_STATUS;   -- Check that the DB was openned correctly   SELECT RECOVERY_MODE FROM V$ARCHIVE_DEST_STATUS; -- important lag statistics  select * from v$dataguard_stats;  -- co...
Read more

Blocking session on RAC database

Blocking session on RAC database Blocking session of the databases Generate the report for Blocking session The SQL will provide Blocking sessions with SID, node information SELECT DISTINCT S1.USERNAME || '@' || S1.MACHINE || ' ( INST=' || S1.INST_ID || ' SID=' || S1.SID || ' ) IS BLOCKING ' || S2.USERNAME || '@' || S2.MACHINE || ' ( INST=' || S1.INST_ID || ' SID=' || S2.SID || ' ) ' AS BLOCKING_STATUS FROM GV$LOCK L1, GV$SESSION S1, GV$LOCK L2, GV$SESSION S2 WHERE S1.SID=L1.SID AND S2.SID=L2.SID AND S1.INST_ID=L1.INST_ID AND S2.INST_ID=L2.INST_ID AND L1.BLOCK > 0 AND L2.REQUEST > 0 AND L1.ID1 = L2.ID1 AND L1.ID2 = L2.ID2; Blockers information select s1.username || '@' || s1.machine  || ' ( SID=' || s1.sid || ' ) is blocking '  || s2.username || '@' || s2.machine || ' ( SID=' || s2.sid || ' ) ' AS blocking_status from gv$lock l1, gv$session s...
Read more

Finding object size in Oracle database

Ref: http://www.runningoracle.com/product_info.php?cPath=2_44&products_id=153 Finding object size in Oracle database is very important and common. Is it very useful to know the exact size occupied by the object at the tablespace. The object size in the following scripts is in Mbytes. The scripts have been formatted to work very easily with TOAD SQL Editor. For example you can filter with tablespace_name, or owner, or size (for example more than 1GByte)  SELECT owner, segment_name, segment_type, partition_name, ROUND(bytes/(1024*1024),2) SIZE_MB, tablespace_name  FROM DBA_SEGMENTS  WHERE SEGMENT_TYPE IN ('TABLE', 'TABLE PARTITION', 'TABLE SUBPARTITION',  'INDEX', 'INDEX PARTITION', 'INDEX SUBPARTITION', 'TEMPORARY')  --AND TABLESPACE_NAME LIKE 'COSTE%'  --AND SEGMENT_NAME LIKE 'P2010201%'  --AND partition_name LIKE 'P20100201%' --AND segment_type = 'TABLE' --AND OWNER = 'TARG...
Read more