Wednesday, December 4, 2013

Upgrade to E-Business Suite 12.1.3 or 12.2?

Which Oracle E-Business Suite Release Should You Target: 12.1 or 12.2?


12.2 is latest release of Oracle E-Business Suite, Customer who are in 11i (11.5.10.2) can directly upgrade to 12.2 instead of 12.1

But there is a general query on to upgrade to 12.1.3 now or directly upgrade to 12.2 which is latest of Oracle eBiz.

Consider targeting 12.1 if any of the following circumstances applies to your organization:

 You prefer to target a release on which Oracle has thousands of live customers.
 You would like to stay on 12.1 for 3-5 years before upgrading to 12.2.
 You need to move from a release below 11.5.10 with no direct upgrade to 12.2.

Consider targeting 12.2 if any of the following circumstances applies to your organization:

 You need the high availability provided by Online Patching.
 You want the functional enhancements that are in 12.2.
 You prefer to invest in a single project to upgrade directly to 12.2.

The above information is from Steven Chan Oracle blog (https://blogs.oracle.com/stevenChan/)



Thursday, November 28, 2013

R12 12.2 Installation Error - Fatal Error: TXK Install Service

It was observed many facing this error during the installation of R12.2 "Fatal Error: TXK Install Service"

This issue is majorly related to the staging of the software, When the staging was not done properly, or you have downloaded the installation parts which are not required or missed to download which are required.

Please note that you should NOT download the following files while creating the  R12.2 Rapid install Stage:

These files DO NOT belong to the R12.2 shiphome.

 1. Oracle Database Lite 10g Release 3 (10.3.0.3.0) for Linux x86 V20223-01.zip

2. Oracle SOA Suite 11g Patch Set 5 (11.1.1.6.0) for Price Protection   
V29672-01_1of2.zip
V29672-01_2of2.zip
 

3. Oracle Data Integrator 11g (11.1.1.6.0) for Generic
V29762-01_1of2.zip
V29762-01_2of2.zip

4. Oracle Portal, Forms, Reports and Discoverer 11g (11.1.1.2.0) for Linux x86-64
V18772-01_1of4.zip
V18772-01_2of4.zip
V18772-01_3of4.zip
V18772-01_4of4.zip

5. Oracle Portal, Forms, Reports and Discoverer 11g Patch Set 5 (11.1.1.6.0) for  Linux x86-64 
V29883-01.zip

These files DO NOT belong to the R12.2 shiphome.

They should be downloaded to a different location than the R12.2 Rapid install stage.

Also IMPORTANTLY, note that these two components that at one stage were marked as  optional are ' Mandatory  ' and should be downloaded into the Rapid Install stage .

1. Oracle Fusion Middleware Web Tier Utilities 11g Patch Set 5 (11.1.1.6.0) for Linux x86-64 , V29764-01.zip
2. Oracle WebLogic Server 11gR1 (10.3.6) Generic and Coherence , V29856-01.zip

Once you have downloaded all the right zip files, rebuild the stage directory by running ' buildStage.sh'..

Cleanup the current install  (oraInventory, temp also) and re-install again.


Monday, November 18, 2013

libmawt.so: libXtst.so.6: cannot open shared object file

While launching R12 installer in RHEL6 encountered below issue.


# Exception in thread "main" java.lang.UnsatisfiedLinkError: 

/d01/EBS_Software/R12Stage/startCD/Disk1/rapidwiz/jre/Linux_x64/1.6.0/lib/i386/xawt/libmawt.so: libXtst.so.6: cannot open shared object file: No such 

file or directory

FIX:
---
Install below missing two rpms in the same order.

# rpm -ivh libXi-1.3-3.el6.i686.rpm
warning: libXi-1.3-3.el6.i686.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEY
Preparing...                ########################################### [100%]
   1:libXi                  ########################################### [100%]

# rpm -ivh libXtst-1.0.99.2-3.el6.i686.rpm
warning: libXtst-1.0.99.2-3.el6.i686.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEY
Preparing...                ########################################### [100%]
   1:libXtst                ########################################### [100%]





Tuesday, October 8, 2013

R12 - 12.2 Upgrade Step By Step

Upgrading from from 12.2.0 to 12.2.2 Step by Step

1) Reset FND_SQLNET_ACCESS to ALLOW_RESTRICTED

2) Apply mandatory fs_clone fix - Patch 17064510:R12.TXK.C

cd 17064510
adop phase=apply hotpatch=yes


3) Run Database Patch Checker to identify the patches required on the DB node.

From startCD/Disk1/rapidwiz/bin run the below as oracle user

$ ./addbptchk.sh

Enter the full path of rapidwiz location: /media/oracle/1222/1222_Stage

Enter $ORACLE_HOME value : /u01/TEST/oracle/11.2.0

Setting ORACLE_HOME to : /u01/TEST/oracle/11.2.0
Please confirm this is the correct value [y/n] :y

Enter database SID : TEST

Setting database SID to: TEST
Please confirm this is the correct SID [y/n] :y

Setting database context to: TEST_test.oracle.com
Please confirm this is the correct context [y/n] :n

Enter the correct db context : TEST_test

Setting database context to: TEST_test
Please confirm this is the correct context [y/n] :y

Looking for database context file /u01/TEST/oracle/11.2.0/appsutil/TEST_test.xml
Please confirm this is the correct file [y/n] :y

Found /u01/TEST/oracle/11.2.0/appsutil/TEST_test.xml...

The DB version is assumed to be 11.2.0.3.

 Pre-req Patch Testing Start Phase : Tue Sep 24 15:29:52 IST 2013
runProcess_1

Rapidwiz location from DB context file is /media/oracle/1222/1222_Stage/startCD/Disk1/rapidwiz

Copying templates to temp area

Executing Perl command:

perl -pi -e 's/txkTopology_R1220_DB11gR2_11202_Patches.xml/txkTopology_R1220_DB11gR2_11203.xml/g' 

Copying one-off patches to temp area

---------
----
---
---
Opatch is at the required version

All the required one-offs are present in Oracle Database Home

FINISHED Pre-req Patch Testing :  Tue Sep 24 15:32:07 IST 2013


4)Apply Database Patches from the above report , If there are any.


5)Apply below addtional Database Patches 

16702016 - ORA-7445 [KGLOBCL()+487]
16924879 - CLEAN UP OBSOLETE ORACLE/QSMA SYNONYMS FROM DB 11.2
17047617 - MERGE REQUEST ON TOP OF 11.2.0.3.0 FOR BUGS 15967134 12657924
17184721 - CLEAN UP OBSOLETE ORACLE/QSMA SYNONYMS POST INSTALL SCRIPT


6) Apply Application Tier Patches

i) Apply Consolidated Seed Table Upgrade Patch 16605855:12.2.0 (required for both VISION and PROD)

adop phase=apply hotpatch=yes


7) Applying the 12.2.2 AD and TXK Release Update Pack 


i) Download and unzip Oracle Applications DBA 12.2.2 Product Release Update Pack (R12.AD.C.Delta.2) , Patch 15955263.


Usage:

  1. Create $ORACLE_HOME/appsutil/admin on the database server.

  2. Copy the higher version of adgrants.sql (UNIX) to $ORACLE_HOME/appsutil/admin.
     
  4. Set the environment to point to ORACLE_HOME on the database server.

  5. Use SQL*Plus to run the script:

     UNIX:
     $ sqlplus /nolog
     SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql APPLSYS

cd 15955263   

$ adop phase=prepare

$ adop phase=apply 



ii)  Download and apply phase for R12.TXK.C.DELTA.2 Patch 15946788.

cd 15946788

$ adop phase=apply 

Note: R12.AD.C.DELTA.2 and R12.TXK.C.DELTA.2 must be applied in the same online patching cycle, without merging.

iii) Complete the online patching cycle by running the following commands in the order shown.

$ adop phase=finalize

-- Downtime Required Here

$ adop phase=cutover
$ adop phase=cleanup



8) Apply the 12.2.2 Suite-Wide Release Update Pack


i)Start an online patching cycle.

adop phase=prepare

ii) Apply Oracle E-Business Suite Release 12.2.2 Patch 16207672 and Oracle E-Business Suite Release 12.2.2 Online Help Patch 16207673.

$ cd 16207672
adop phase=apply 

$ cd 16207673
adop phase=apply 


iii)Instantiate the Oracle HTTP Server configuration files ssl.conf and mod_wl_ohs.conf.

 Source the patch edition environment file:

. $PATCH_BASE/EBSapps/appl/APPS$CONTEXT_NAME.env


$ . $PATCH_BASE/EBSapps/appl/APPS$CONTEXT_NAME.env
$ $ADJVAPRG oracle.apps.ad.autoconfig.InstantiateFile -e $CONTEXT_FILE -d $FND_TOP/admin/driver/ohstmpl.drv -tmpl 

$FND_TOP/admin/template/ssl_conf_FMW.tmp
Enter the APPS password : 
$ $ADJVAPRG oracle.apps.ad.autoconfig.InstantiateFile -e $CONTEXT_FILE -d $FND_TOP/admin/driver/ohstmpl.drv -tmpl 

$FND_TOP/admin/template/mod_wl_ohs_conf_FMW.tmp
Enter the APPS password : 


4.  Complete the online patching cycle by running the following commands in the order shown

. $RUN_BASE/EBSapps/appl/APPS$CONTEXT_NAME.env
adop phase=finalize

--Downtime Required Here

adop phase=cutover
adop phase=cleanup

4)  Post-Update Steps

Synchronize file systems

adop phase=fs_clone

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



Friday, September 20, 2013

UnsatisfiedLinkError exception loading native library: njni11

UnsatisfiedLinkError exception loading native library: njni11 while running Autoconfig on DB Node

After upgrading database to 11GR2, This issue can occur.

While running autoconfig on the DB node this error occured.

java.lang.UnsatisfiedLinkError: /u01/CRP1/db/tech_st/11.2.0/lib/libnjni11.so: /u01/2CRP1/db/tech_st/11.2.0/lib/libnjni11.so: wrong ELF class: ELFCLASS64 (Possible cause: architecture word width mismatch)


FiX
---

To fix this issue, Edit the database node xml as below and re-run the autoconfig.

From
----
<          <JDK_TOP oa_var="s_jdktop">/u01/CRP1/db/tech_st/11.2.0/appsutil/jre</JDK_TOP>
<          <JRE_TOP oa_var="s_jretop">/u01/R12CRP1/db/tech_st/11.2.0/appsutil/jre</JRE_TOP>

To
---
>          <JDK_TOP oa_var="s_jdktop">/u01/CRP1/db/tech_st/11.2.0/jdk/jre</JDK_TOP>
>          <JRE_TOP oa_var="s_jretop">/u01/CRP1/db/tech_st/11.2.0/jdk/jre</JRE_TOP>



Note:
----
From 11gR2 DB version onwards AutoConfig on DB node uses the JRE from <Oracle_Home>/jdk/jre where as earlier versions of DB uses JRE from $ORACLE_HOME/appsutil/jre  Ref Note 1467892.1

Wednesday, September 18, 2013

Oracle HTTP Server 11G 32 bit Installation Issue on 64 bit OS Linux

Oracle HTTP Server 11G 32 bit Installation Issue 64 bit

Installing Oracle HTTP server 11g 32 bit on 64bit OS is not supported, But With a work around we can install it , But this is not certified method.

Perform the below on Linux 64bit OS:

           Create gcc file to install 32bit HTTP server on 64bit OS.

                mv /usr/bin/gcc /usr/bin/gcc.orig
                vi /usr/bin/gcc41

                #!/bin/sh
                exec /usr/bin/gcc.orig  -m32 -static-libgcc -B /usr/lib/gcc/i686-redhat-linux/4.4.4/ $*

                chmod 755 /usr/bin/gcc41
                ln -s -f /usr/bin/gcc41 /usr/bin/gcc


Note: Replace  /usr/lib/gcc/i686-redhat-linux/4.4.4 with exact 32bit gcc path in your server.

Fusion Application Installation - Part 1

Fusion Applications 11.1.6 Installation Hardware Sizing:

Fusion applications has below modules:

1)SCM
2)CRM
3)Financial
4)Procurement
5)Incentive
6)HCM
7)BI
8)Projects

You can install on single node or Multinode, But the memory requirement should match.

Ideally, suggested to install minimum on two nodes, where IDM and IDM database on one node and Fusion Applications and Database on another Node.

Note: The below is NOT official Oracle documentation - this is a rough  calculation for a Fusion Applications installation, For actual customer implementation contact Oracle support to get the sizing info.

Hard Disk:
-----------
Harddisk size can be of 500GB for initial installation, Later based on the transactions volume need to add as required.


Memory/RAM:
-----------
Fusion Applications is memory intensive applications as there will be many managed and Admin servers for each Module.

Each module requires specific amount memory to be able to successfully install and run the FA.


The below outlines the memory requirement for each module. 
---------------------------------------------------------

If you are planning to Install:

only SCM   - 80GB of RAM required
only HCM   - 70GB of RAM required
HCM+IC     - 80GB of RAM required
CRM     - 80GB of RAM required
CRM+IC     - 90GB of RAM required
Finance+SCM+HCM - 125 GB of RAM required

Note: FA DB,IDM and IDM DB is not included in the above. Additional memory required for them

If you are planning to Install Complete Fusion Applications Modules:
***********************************************************

For All the Modules of Fusion Applications - 150 GB RAM is Required

Below are commonly required RAM sizes irrespective of the modules installed.

Fusion Applications DB  - 15 GB RAM is Required
IDM Applications           - 20 GB RAM is Required
IDM Database                - 10 GB RAM is Required


Watch this space for installation Pre-requisites to Install on Linux and procedure of Fusion Applications.

Thursday, August 15, 2013

Internet Explorer crashing on launching the forms for Oracle Applications 11i (11.5.10)


Internet Explorer crashing on launching while launching the forms for Oracle Applications 11i (11.5.10)

We see many a times IE crashes when you try to launch the Jinitiator Forms using IE.

Now IE is not supported, We can not use  Jinitiator to launch forms for 11i, Only JRE is supported.

But we can fix this issue by tweaking the jvm.dll file in the jinitiator directory.


Copy the jvm.dll to c:\Program FilesOracle\JInitiator <Version of Jinit>\bin\hotspot

Click here to download the jvm.dll file  https://docs.google.com/file/d/0BwQ_NVbOr4hwb0ZkTGdlbndZWjg/edit?usp=sharing


Restart IE, and check the issue.

Wednesday, April 3, 2013

Enable DDL auditing in 11GR2 Database:

Found intresting audit parameter in 11Gr2, enable_ddl_logging will allow the tracking of all ddl's in the alert log using the following:

Enable it by using the below command.

ALTER SYSTEM SET enable_ddl_logging=TRUE

All the DDL commands executed against the database will be recorded in the alert<SID>.log

More details of the DDL of the command executed can be found in the XML file in the alert directory

Friday, March 8, 2013

RMAN DUPLICATE DATABASE WITHOUT CONNECTING TO TARGET DATABASE

Have come across a requirement to clone a database using RMAN from from PROD to TEST in the same server

The only way you can clone a database from PROD to TEST (Different SID) in the same server is using RMAN duplicate command.

Usually RMAN duplicate command uses auxilary database and connect to target(PROD) database while creating the TEST.

We have a new feature in 11GR2, Which allows to clone using RMAN duplicate command without connecting to source PROD database.

It will only access the backup piecies and clones database.

This method works in cloning the database in the same server or different server

Source : PROD
Target : TEST


Steps:

1) Copy the Oracle home from source PROD to target TEST and create the parameter file for TEST database

2) Copy the backupsets to TEST server (If the clone is in the same server, This step is not required)

3)If you are cloning the database in the same server as PROD,Modify the below two parameters in the TEST (target instance),

This step is very importent step to mention the different directory structure for TEST datafiles if you are restoring on the same server as PROD.

db_file_name_convert=('/oradata/PROD' '/oradata/TEST')
log_file_name_convert=('/oradata/PROD' '/oradata/TEST')


4) Start the TEST Instance (This is called as auxilarary database)
$ sqlplus "/ as sysdba"
SQL> startup nomount;

5) Run the RMAN duplicate command from
rman auxiliary /
RMAN> DUPLICATE DATABASE TO NEWDB BACKUP LOCATION '/RMAN_Backup_Location/';