Thursday, September 26, 2013

R12 Online Patching ? ADOP AD Online Patching replaces adpatch in 12.2.

Online Patching ? ADOP AD Online Patching replaces adpatch in 12.2.


Online Patching is new feature which  is major change with R12 12.2 for DBA's , as downtime would be reduced for any patching activity from hours to few minutes.

Now it is possible to apply even upgrade patches in Online Patching mode minimizing downtime to very low, But please note upgrade to 12.2 is not possible via online patching from lower versions . 

On the technology part  of online patching, It is some what similar to Stage Appl TOP, But in online patching database objects also will maintain two copies to support this method. i.e run file system and run edition of DB, patch file system and patch edition of DB.

In applications  contains two setf of file systems patch and run file system, run is where actually applications is running from and patch is used for patching the applications when it is running. in database we have edition based concept, where we contain patch edition and run edition.

Actually the base for the online patching concept came into picture with 11GR2 database version , Where there is concept called "Edition Based Redefinition", Online patching database part is based on it.

Online Patching in 12.2. is done using adop utility (No Longer adpatch), But this utility calls internally the required patching(adpatch) or other  utilities.

and all the patches need to be applied using adop only, Other methods are not supported. But we can apply the patches in hot patch mode using adop, But in this method , The online patching concept will not come into picture , It is traditional way of applying patch directly on the run file system and run edition of the database when applications and DB is running.


Online Patching (adop) runs in different phases, The below are phases and syntax of adop.

prepare
apply
finalize
cutover
cleanup


1) prepare  Phase
--------------

patch edition and run editions are synchronized in incremental synchronizations of files changed in the run file system.

patch edition is created in th database

How to run this , Syntax: $ adop phase=prepare

2)apply phase 
-----------

patches are applied to patch patch edition in the database and patch file system in the applications.

adpatch is called internally by adop to apply the patches.

production application is un effected by these changes, and multiple patches can be applied.

How to run this , Syntax: $ adop phase=apply


3)finalize phase 
-------------

Performs all the activities which can be done when applications is up & running.

example: compile invalids,generate objects,pre-compile DDL

How to run this , Syntax: $ adop phase=finalize


This stage we can stay as long as we want, until once we have downtim to move the changed in the cutover stage , 


4)cutover phase
------------

This is a stage where where actual changes reflects and downtime is required for this stage. 

Users are logged off during this stage.

patch file system is promoted to be the run file system

patch database edition is promoted to the run database edition.

users are actually broght back on online on the patched system.

How to run this , Syntax: $ adop phase=cutover


5)cleanup phase
------------

Cleanup happens once users online on the system


There are no cleanup on the file system , Only it happens on the database where it deletes the code objects from old editions of the database where patching happened.

How to run this , Syntax: $ adop phase=cleanup


syntax of patch application in 12.2 using adop is : $ adop phase=apply patches=123456

Wednesday, September 25, 2013

R12 - 12.2. Installation step by step

R12 - 12.2. Installation step by step 

Have installed 12.2. on the Linux 64 bit machine successfully, For installing Vision demo with 12.2. you need around 350 GB and for Fresh install you need 120 GB.

For Installation screen shots for the 12.2 Please click here https://www.dropbox.com/s/m7uus85jgok84s4/1222_Installation_Screen_Shots_blog.pdf .

Latest version of 12.2. is 12.2.2 .But base release version is 12.2.0, and 12.2.2 is update pack on top of it.

Online patching is introduced from 12.2.0.


How to Stage R12 - 12.2 Software for Installation


How to Stage R12 - 12.2 Software for Installation


Now it is official that R12 - 12.2 is released. For installing , Download all the software 12.2  from edelivery.oracle.com.

Now let us see how to stage 12.2. software, this staging is required even if you are downloading from edelivery, and it is different from R12 12.1 version.


1) First unzip start CD parts in the staging directory example 1222_Stage in this example.


cd /downloads/oracle/1222/1222_Stage

unzip ../V35215-01_1of3.zip
unzip ../V35215-01_2of3.zip
unzip ../V35215-01_3of3.zip

2) Go to startCD/Disk1/rapidwiz/bin

# cd /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin

3) Launch buildStage.sh script which will stage the software. It prompts for the downloaded the zips locations , All the zip files need to be downloaded to the same location.

# ./buildStage.sh

                Build Stage Menu

------------------------------------------------------

1.     Create new stage area

2.     Copy new patches to current stage area.

3.     Display existing files in stage TechPatches.

4.     Exit menu


Enter your choice [4]: 1

         Rapid Install Platform Menu

------------------------------------------------------

1.    Oracle Solaris SPARC (64-bit)

2.    Linux x86-64

3.    IBM AIX on Power Systems (64-bit)

4.    HP-UX Itanium

5.    Exit Menu


Enter your choice [5]: 2

/downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../jre/Linux_x64/1.6.0/bin/java -classpath /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../jlib/emocmutl.jar:/downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../jlib/ewt-3_4_22.jar:/downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../jlib/share-1_1_18.jar:/downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../jlib/jnls.jar:/downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../jlib/ACC.JAR:/downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../jlib/netcfg.jar:/downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../jlib/ojdbc14.jar:/downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../jlib/OraInstaller.jar:/downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../jlib/java oracle.apps.ad.rapidwiz.util.StageBuilder /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin


Please enter the directory containing the zipped installation media:
/downloads/oracle/1222/
Unzipping V35805-01_1of2.zip
Unzipping V35803-01_2of3.zip
Unzipping V35231-01_3of5.zip
Unzipping V35806-01_3of3.zip
Unzipping V35812-01.zip
Unzipping V35215-01_3of3.zip
Unzipping V35215-01_1of3.zip
Unzipping V35231-01_5of5.zip
Unzipping V35810-01.zip
Unzipping V35809-01.zip
Unzipping V35803-01_3of3.zip
Unzipping V35813-01.zip
Unzipping V35811-01.zip
Unzipping V35806-01_2of3.zip
Unzipping V35231-01_4of5.zip
Unzipping V35802-01.zip
Unzipping V35806-01_1of3.zip
Unzipping V35231-01_1of5.zip
Unzipping V37515-01_3of6.zip
Unzipping V37515-01_6of6.zip
Unzipping V37515-01_1of6.zip
Unzipping V35805-01_2of2.zip
Unzipping V35804-01_2of2.zip
Unzipping V35230-01_1of2.zip
Unzipping V35231-01_2of5.zip
Unzipping V37515-01_5of6.zip
Unzipping V37515-01_4of6.zip
Unzipping V35803-01_1of3.zip
Unzipping V35804-01_1of2.zip
Unzipping V35230-01_2of2.zip
Unzipping V35807-01.zip
Unzipping V35215-01_2of3.zip
Unzipping V37515-01_2of6.zip
Unzipping V35808-01.zip
Applying one-off patches
All files have been unzipped.

Done Unzipping shiphome ...


StageBuilder will now stage the tech patches for Linux_x64...


Copying one-off patches to shiphome

/downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../unzip/Linux_x64/unzip -o /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../Xpatches/Linux_x64.zip -d /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches


Archive:  /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../Xpatches/Linux_x64.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16303726/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16303726/p16303726_112030_Linux-x86-64.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14123213/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14123213/p14123213_112030_Linux-x86-64.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/13923995/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/13923995/p13923995_112030_Linux-x86-64.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14751895/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14751895/p14751895_112030_Linux-x86-64.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16163946/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16163946/p16163946_112030_Linux-x86-64.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14207902/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14207902/p14207902_112030_Linux-x86-64.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/15967134/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/15967134/p15967134_112030_Linux-x86-64.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16438289/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16438289/p16438289_112030_Linux-x86-64.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/13931044/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/13931044/p13931044_112030_Linux-x86-64.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16342486/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16342486/p16342486_112030_Linux-x86-64.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14398795/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14398795/p14398795_112030_Linux-x86-64.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/12951696/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/12951696/p12951696_112030_Generic.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/12942119/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/12942119/p12942119_112030_Linux-x86-64.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14698700/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14698700/p14698700_112030_Generic.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16587934/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16587934/p16587934_112030_Linux-x86-64.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16105745/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16105745/p16105745_112030_Generic.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16040940/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16040940/p16040940_112030_Linux-x86-64.zip
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/13583235/p13583235_1036_Generic.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14825718/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14825718/p14825718_10123_LINUX.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14353879/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14353879/p14353879_10123_LINUX.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14614795/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14614795/p14614795_101231_LINUX.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16209520/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16209520/p16209520_10123_GENERIC.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16275529/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16275529/p16275529_10105_LINUX.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14597598/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14597598/p14597598_1036_Generic.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14577216/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14577216/p14577216_101231_Generic.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16784403/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16784403/p16784403_101232_LINUX.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14386347/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14386347/p14386347_111160_Generic.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16199894/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16199894/p16199894_111160_Generic.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14374587/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14374587/p14374587_10123_GENERIC.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/10152652/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/10152652/p10152652_10123_LINUX.zip
   creating: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/11669923/
 extracting: /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/11669923/p11669923_10123_GENERIC.zip

Done Copying additional patches

Verifying stage area...

Directory /downloads/oracle/1222/1222_Stage/TechInstallMedia is valid
Directory /downloads/oracle/1222/1222_Stage/TechPatches/DB is valid
Directory /downloads/oracle/1222/1222_Stage/TechPatches/MiddleTier is valid
Directory /downloads/oracle/1222/1222_Stage/EBSInstallMedia/AppDB is valid
Directory /downloads/oracle/1222/1222_Stage/EBSInstallMedia/Apps is valid
Directory /downloads/oracle/1222/1222_Stage/EBSInstallMedia/AS10.1.2 is valid
Directory /downloads/oracle/1222/1222_Stage/TechInstallMedia/database is valid
Directory /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin is valid
Directory /downloads/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz/bin is valid


Stage area verified.

Press enter to continue...


Now staging completed,After staging the directory structure looks like below.

EBSInstallMedia  startCD  TechInstallMedia  TechPatches