Upgrade 11.2.0.1 to 11.2.0.3 For RAC ON AIX

Upgrade 11.2.0.1 to 11.2.0.3 For rac on aix [plain] recently upgraded two systems For a bank. Here we will sort out the upgrade steps and precautions. [Plain] Preparation [plain] $ create pfile from spfile; $ select file_id, file_name from dba_data_files; $ alter database backup controlfile to trace as 'xxxx '; <the preceding content may be used for rollback. We recommend that you back up the data after the rollback. 1. Check 1> oracle user 1> @ utlu112i_5. SQL <Note: download the latest script. This script is especially important for manual upgrade. If you do not execute the subsequent upgrade script, an error is reported. 2> truncate table SYS. aud $; 3> Database contains INVALID objects prior to upgrade. @ utlrp. SQL 4> Your recycle bin contains 983 object (s ). PURGE DBA_RECYCLEBIN 5-> To gather dictionary statistics execute the following command while connected as SYSDBA: EXECUTE commands; 6-> To view existing hidden parameters execute the following command while connected as sysdba: SQL> SEL ECT name, description from SYS. V $ parameter where name LIKE '\ _ % 'escape' \ '; _ gc_policy_time 7-> To view existing non-default events execute the following commands while connected as sysdba: Events: SELECT (translate (value, chr (13) | chr (10), '') FROM sys. v $ parameter2 where upper (name) = 'event' AND isdefault = 'false'; Trace Events: SELECT (translate (value, chr (13) | chr (10 ), '') from sys. v $ parameter2 Where upper (name) = '_ TRACE_EVENTS' AND isdefault = 'false' 2. use RMAN to back up the database. 3. check inventory under the oraInventory directory of the inventory parameter configuration. xml grid @ QAZWS0200:/home/db/grid/oraInventory/ContentsXML $ more inventory. xml <? Xml version = "1.0" standalone = "yes"?> <! -- Copyright (c) 1999,200 9, Oracle. All rights reserved. --> <! -- Do not modify the contents of this file by hand. --> <INVENTORY> <VERSION_INFO> <SAVED_WITH> 11.2.0.1.0 </SAVED_WITH> <MINIMUM_VER> 2.1.0.6.0 </MINIMUM_VER> </VERSION_INFO> <HOME_LIST>