Making Oracle Applications Read only 11i.10 , R12

Most of the times requirement comes to clone the production application and make it read only.
Like during major 11i to R12 upgrade cutover plan, we need to clone old 11i to create the clone and put that in Read only mode.

In Oracle Database 11g , we can put tables in read only mode.

I have tested this in 11.5.10.2 and R12.1.3

Steps :
1) Stop the application.
2) Run the spool of the below script to put the tables in read only mode.
-----------------------table_read_only.sql--
 set echo off
set term off
set head off
spool read_only_table.txt
select 'alter table '|| OWNER ||'.'||TABLE_NAME|| ' read only;' from dba_tables where owner not in('APPLSYS','APPLSYSPUB','CTXSYS','OLAPSYS','SYS','OUTLN','SYSTEM','MDSYS','ORDSYS','PORTAL30','PORTAL30_SSO','APPS','DBSNMP','OWAPUB','ICX');
/
----------------------
It well spool read_only_table.txt, run the spool as sys user.

3) Start the application and test.

4) To revert back run the spool of below script after stopping the application and start the application.

---------- table_read_write.sql----------

set echo off
set term off
set head off
spool write_enable_table.txt
select 'alter table '|| OWNER ||'.'||TABLE_NAME|| ' read write;' from dba_tables where owner not in('APPLSYS','APPLSYSPUB','CTXSYS','OLAPSYS','SYS','OUTLN','SYSTEM','MDSYS','ORDSYS','PORTAL30','PORTAL30_SSO','APPS','DBSNMP','OWAPUB','ICX');
/
---------------------------------------------

Its not supported by Oracle, thus need to be done at your own risk.

If we have other ideas , please share with me.

R12.1.3 -JDK 7u51 and JRE 7u51 upgrade with iAS 10.1.3.5 , iAS 10.1.2.3 patches After 12.1.1 Installation and 12.1.3 MP Installation

This is applicable to 12.1.1 as there is a separate process if you are on 12.0.x.

I did this on OEL 6.4 and can be followed on any supported Linux version like OEL 5 and above.

Note : Upgrading to JDK 7.0 requires Oracle Application Server 10.1.3.5 or higher for the web tier and R12.1.1 comes with 10.1.3.4 patchset.
R12.1.1 default rapidwiz comes with JDK 6 on Apps Tier , JRE 6.0 on DB Tier and JDK 1.4.2 on 10.1.2 of Forms and Reports techstack.

After fresh Install of 12.1.1 , we upgrade it to 12.1.3 MP (Maintenance Pack) and then we need to update JDK to latest version like JRE 7u51 , before start using the application.

Referred the doc Using JDK 7.0 Latest Update with Oracle E-Business Suite Release 12.0 and 12.1 (Doc ID 1467892.1).
-----------------
Apply following three patches Step 2.1: Prerequisite Patches as per Doc -1467892.1

1) 16545472 1OFF:12.1.3:14487215: JAVA RUN-TIME ENVIRONMENT VERSION TEST FAILED AFTER JDK 7 UPGRADE (16545472:R12.OAM.B).

2) 16496713 This patch resolves the issue of showing inactive date getting populated for all supplier contact user (16496713:R12.POS.B).

3) 17309237 S_TXK_JDBC_ZIP IS TAKING DEFAULT VALUE OF JDBC14.ZIP FOR JDK 7 IN R12 INSTANCE (17309237:R12.TXK.B).
-----------------

As per the above note we need to follow the doc for 10.1.3.4 and 10.1.2.3
Document 454811.1: Upgrading to the Latest OracleAS 10g 10.1.3.x Patch Set in Oracle EBusiness Suite Release 12.

Here are the detailed steps on the same.

R12.1.1 rapidwiz will install default java 1.6.0_10 and we need to upgrade to latest JDK and JRE after 12.1.3 MP, in this case upgraded to JDK 7u51.

Before JDK Upgrade , need to upgrade 10.1.3.4 to 10.1.3.5 and apply latest patches for 10.1.2.3  as detailed below in Step1 and Step2, then follow JDK upgrade steps.

Few Important points to remember :

1) I have used generic terminologies , thus can be mapped to any environment.

2) # is OS default shell prompt.

Note : while downloading the patches make sure to select 32-bit os like Linux x86 and not Linux -x86-64.

Step 1 : Upgrade IAS_ORACLE_HOME 10.1.3.4 (default with 12.1.1 installation) to 10.1.3.5

              Doc ID 454811.1

         Note : To find out the current version of IAS_ORACLE_HOME (10.1.3) 
        $opatch lsinventory -detail -invPtrLoc /disk2/applr12/VISV/apps/tech_st/10.1.3/oraInst.loc > 10.1.3.5_oraInventory.txt


        ---> search PatchSet in the above txt file..
          Oracle Application Server PatchSet                               10.1.3.4.0
        --->
        ===>Need to upgrade it to 10.1.3.5

1. Verify the opatch version of IAS_ORACLE_HOME, first login using applmgr (application user)
1. Source the environment of 10.1.3 ORACLE_HOME by running  
2.  # . $INST_TOP/ora/10.1.3/<SID>_hostname.env
3. This will setup ORACLE_HOME variable to 10.1.3 ,verify by running                        #echo $ORACLE_HOME and should point to </BASEAPPL>/SID/apps/tech_st/10.1.3
4.  Run command $opatch -version (This will give 1.0.0.0.57 which comes default with 12.1.1 rapidwiz) , you can also use #opatch lsinventory -detail to get detailed report.  #opatch lsinventory -detail -invPtrLoc <1013_ORACLE_HOME>/oraInst.loc > 10.1.3.4_opatchInventory.txt
   Use the file 10.1.3.4_opatchInventory.txt to check the patches already there and need not to be applied
5. Apply latest opatch via Patch 6880880 and make sure to select release '10.1.0.0.0' while downloading and apply the patch using readme, follow below steps : follow doc - 1134259.1 and apply latest patch - 6880880 for Release 10.1.0.0.0 
6. #cd $ORACLE_HOME (10.1.3) 
7. #mv OPatch OPatch_org
8. #cp /tmp/p6880880_101000_LINUX.zip $ORACLE_HOME
9. #unzip -o p6880880_101000_LINUX.zip
10. This will create OPatch directory and use #opatch -version and would give 1.0.0.0.64

        Note : By default ORACLE_HOME is set to 10.1.2 ORACLE_HOME used for 10g Appliation Server forms and reports whereas 10.1.3 ORACLE_HOME is used for Apache and web services.

               11. As per DOC - Upgrading to the Latest OracleAS 10g 10.1.3.x Patch Set in Oracle E-Business Suite Release 12 (Doc ID 454811.1)

                     Download patches : Make sure you select correct platform - Linux x86

                     1) 10.1.3.5 patchset - 8626084 - PLACEHOLDER BUG TO UPLOAD AS10.1.3.5 PATCH-SET ON ARU  (Size 779M)

                     2)  8920270 -INSTALLING AS 10.1.3.5 REQUIRES OCM RESPONSE FILE WHEN OCM IS NOT CONFIGURED (Size 432K)

               12. Make patch directory where you would unzip the patchset like /r12patches/10135 and   copy the main patchset 8626084 to this directory and unzip it , It will create two Disk1 and Disk2 directories.

           

              13. Unzip the patch 8920270 into any temp directory like /tmp and follow the patch readme of 8920270 and apply step 1,2 and 3 only , this would replace the other.jar file of main patchset 10.1.3.5 - 8626084 with the other.jar file from patch 8920270.
             Steps:  unzip p8920270_101350_LINUX.zip under /disk2/10135 and follow the patch readme Steps 1,2 and 3 Only...
              cd /disk2/10135
              cd Disk1/stage/Patches/oracle.as.j2ee.top/10.1.3.5.0/1/DataFiles
               [applr12@oravdba DataFiles]$ mv other.jar other.jar_pre8920270
               cp /disk2/10135/other.jar .
            14. Take the backup of </BASEAPPL>/SID/apps/tech_st/10.1.3 (IAS_ORACLE_HOME)

                   #cd </BASEAPPL>/SID/apps/tech_st/

                   #cp -rp 10.1.3 10.1.3_4bkp

     

            15. Apply the patchset

                   # cd /r12patches/10135/Disk1

               

                   Imp Note : On OEL 6 or RHEL 6 use - ignoreSysPrereqs flag of runInstaller, no need to use this on OEL 5 or RHEL 5.

Before starting ,login to root user and do #xhost +
This would allow applmgr user to start the graphical xwindows.
                  On linux 64 bit
                  # . $INST_TOP/ora/10.1.3/<SID>_hostname.env
                  #linux32 bash
                  #echo $SHELL    (Should give /bin/bash)
                  # echo $ORACLE_HOME (verify ORACLE_HOME to be set to 10.1.3)
                  #cd /disk2/10135/Disk1

                  # ./runInstaller -ignoreSysPrereqs -invPtrLoc <1013_ORACLE_HOME>/oraInst.loc

                   It will start the Installer and in the first screen select Destination as something like

                       VISV_WEBOH_disk2_applr12_VISV_apps_tech_st_10_1_3

                   Make sure it has 10_1_3 in it.

                   Enter 'oafm' (without single quotes) as oc4jadmin password when prompted.

                   At the end it will fail at the OC4J configuration assistant as part of post install configuration steps , you just ignore and click Next and complete the installation.

                  While running runInstaller , from another unix windows can tail the log to see the progress.
                  #tail -f /home/applr12/VISV/inst/apps/VISV_oravdba/admin/oraInventory/logs/installActions2014-03-19_12-45-06AM.log

                   After successful installation , by default it starts the opmn processes, check it by running.

                   # $IAS_ORACLE_HOME/opmn/bin/opmnctl status -l

                  Stop the opmn services by running below command.

                   # $IAS_ORACLE_HOME/opmn/bin/opmnctl stopall

             16) Apply additional patches - Apply patches over 10.1.3.5 patchset

             IMP Note :While downloading make sure select the Release as - iAS 10.1.3.5.0  and not iAS 10.1.3.4.0

                 1) Patch 8999551: REQEUST TO EVALUATE TO REV UP THE JAVA MAILER APIS TO LATEST TO SUPPORT SSL

                   Patch file name should be p8999551_101350_Generic.zip

                 2) Patch 12965674: NULLPOINTEREXCEPTION WHEN DEPLOYING APPLICATIOINS AT OC4J

                  Patch file name should be p12965674_101350_Generic.zip

              Unzip patches and go to unzipped patches folder and use below command.

              Make sure 10.1.3.5 environment is set by  # . $INST_TOP/ora/10.1.3/<SID>_hostname.env

   

              1) #cd /r12patches/10135  and unzip patches p8999551_101350_Generic.zip and p12965674_101350_Generic.zip , this would create individual patch folders 8999551 and 12965674.   run below command to apply two patches from there unzipped folders one by one.

  

                  #opatch apply -invPtrLoc <1013_ORACLE_HOME>/oraInst.loc

         To verify the 10.1.3.5 patchset version.
      Use runInstaller from <1013_ORACLE_HOME>/oui/bin and Click on Installed Products.
      Select the 10.1.3 Oracle Home and expand the tree. You should see Oracle Application Server    Patchset 10.1.3.5 patch in the list.
                                              OR
 $opatch lsinventory -detail -invPtrLoc /disk2/applr12/VISV/apps/tech_st/10.1.3/oraInst.loc > 10.1.3.5_oraInventory.txt

        ---> search PatchSet in the above txt file..

          Oracle Application Server PatchSet                               10.1.3.5.0
                                               OR
          #cd $IAS_ORACLE_HOME (10.1.3)
          #cd config
          #cat ias.properties | grep Version   (V is capital and you would get as below)
          Version=10.1.3.5.0

               We will do post-install steps of re-generating appsborg.zip and appsborg2.zip10.1.3.5 at the end of this doc using adadmin - Generate product JAR file option.

             

Step 2 : Apply latest  10.1.2.3 (default with 12.1.1 installation) forms bundle and reports patches

              Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12 (Doc ID 437878.1)

1. R12.1.1 rapdiwiz delivers 10.1.2.3 as default application ORACLE_HOME, after 1213 MP, follow below steps to apply latest forms , reports etc.. patches as per doc - 437878.1
2. Few patches in the documents are already there in 12.1.1 installation, to get the list of patches already part of 10.1.2.3 which comes with 12.1.1 rapidwiz use below command

•  Source the environment of 10.1.2 ORACLE_HOME by running
   # . $INST_TOP/ora/10.1.2/<SID>_hostname.env
• Verify by running #echo $ORACLE_HOME and should point to
  </BASEAPPL>/SID/apps/tech_st/10.1.2
   
• Run command $opatch -version (This will give 1.0.0.0.58 at top which comes default with 12.1.1 rapidwiz) , you can also use #opatch lsinventory -details to get detailed report.
• This is important step and need to be applied before applying latest OPatch patch. Apply Universal Installer patch.
  Patch 6640838 OUI CD PLACE HOLDER ON ARU FOR 10106 (Size 37M)  
Strictly follow the doc : How to patch OUI for installing overlay patches on top of Forms Bundle Patch - 9593176 (Doc ID 1301320.1)

 After unzipping the patch start ./runInstaller -ignoreSysPrereqs

                                                 invPtrlLoc <1012_ORACLE_HOME>/oraInst.loc >

          In Select  Installation Type , screen select Custom  mode. click Next.
          In next screen at the bottom of the window you would see this option and select it.

                            

And in OUI , check the Show all components and make sure to select -Installer SDK Component 11.1.0.6.0 and this will automatically select the other two instances of similar option as shown in below screen shot.

                        

 

 If you wont follow the Doc-1301320.1 , then Forms Overlay Patch 17303472 would fail with below error.

"OPATCH_JAVA_ERROR=CheckConflict: OPatch cannot process overlay patches because of no OUI support. Please take latest OUI 10.1 patchset from "My Oracle Support" and try again. 

• Apply latest opatch via Patch 6880880 and make sure to select release '10.1.0.0.0' and apply the patch using readme, follow below steps :
  #cd $ORACLE_HOME (10.1.2)
  #mv OPatch OPatch_org
  #cp /tmp/p6880880_101000_LINUX.zip $ORACLE_HOME
  #unzip -o p6880880_101000_LINUX.zip
   This will create OPatch directory and use #opatch -version and would give 1.0.0.0.64 
•  #cd $ORACLE_HOME and take the detailed opatch list by running below single command
• #opatch lsinventory -detail invPtrlLoc <1012_ORACLE_HOME>/oraInst.loc > 10.1.2.3_opatchInventory1211.txt
• Use the file 10.1.2.3_opatchInventory1211.txt to check the patches already there and need not to be applied. 

  3) Apply patches in following sequence after latest opatch and OUI patch.

              

1. Patch 14825718 - ORACLE FORMS BUNDLE PATCH 10.1.2.3.2  (Size 5.6 MB)
2. Forms Overlay Patch 17303472 - MERGE REQUEST ON TOP OF 10.1.2.3.2PSU FOR BUGS 16784403 6166808 13913713 (Size 4.6 MB)
3. Patch 8528194 - APPS6: SCRIPT CHANGES FROM 5456500 NOT INCLUDED IN 10.1.2.3 (Size 10K)
4. Patch 8551790 - N LINUX INS_PROCBUILDER.MK FILE NEEDS LIBDIR=LIB AND PASTA_LIBDIR=LIB (Size 18 K) - Mandatory Pre-Req of 8557019
5. Patch 8557019 - APPSPERF: ONE SQL USING ALL_OBJECTS HAS PERFORMANCE ISSUE UNDER 11G INSTANCE. (Size 89K)
6. Patch 10152652 - MERGE REQUEST ON TOP OF 10.1.2.3.0 FOR BUGS 6497684 9726201 (Size - 19K) , Follow post patch instructions after opatch
   

   sh ./patch.sh

7. Patch 11780669 - REP-56048:ENGINE RWENG-0 CRASHED AFTER INSTALLING PATCH 9774440 (Size 95K)
8. Patch 12379038 - APPS6: RDFS FAILING TO GENERATE USING RWCONVERTER- BAD WINDOW (Size - 12K)
9. Patch 12887068 -  APPS6: REPORT FAIL WITH REP-1510 FOR SUMMARY COLUMN AFTER SETTING CA_FILEIO_64=Y
10. Patch 12898423 - CA FUNCTION CADCMRFPBLB DOES NOT SUPPORT FILES LARGER THAN 2GB (Size - 13K)Follow post patch instructions after opatch
    

    sh ./patch.sh

11. Patch 8339196 - DESFORMAT=XML FAILS WITH REP-271504897 WITH LONG COLUMN AND LONG DATA (Size 7.1K)
12. Patch 16778382 -  APPS6 REPORT SERVER PRODUCES AN OUTPUT PDF 1.4 NOT COMPLIANT TO ITS SPECS  (Size 23.0 K)
13. Patch 7140392 - APPS1012: MLR 6116405,6764875 FOR LINUX ON TOP OF 10.1.2.3 (Size 30K) , unzip of this patch will create directory - 7140405 and not 7140392
14. Patch 14374587 - APPS6:REP-57054 REP-50159 REP-54002 ERROR WHEN RUNNING REPORT IN BATCH (Size - 39K)

    4)  Apply 10.1.0.5 RSF (Required Support Files) Fixes.
        Following patches need to be applied for 12.1.1 install. While downloading the patches make sure Product Release selected is - Oracle 10.1.0.5 while downloading the patches and select 32-bit os like Linux x86 and not Linux -x86-64.

Verify these patches in opatch lsinventory file above 10.1.2.3_opatchInventory1211.txt

1.  Patch 5261796 - BUNDLED PATCH FOR RDBMS AND CORE FIXES FOR 10.1.4IM (Size 79.0 KB)
2. Patch 5651245 - ATG120XB14FUNC CP SQL*LOADER REGRESSION TEST WITH ORA-01801 IN ARABIC SESSION (Size 21K)
3. Patch 4047619 - SVRMAN TUNE - TUNING DBA_IND_COLUMNS CRASHES ORACLE SHADOW - TMANDTSD.DIF (Size 8.8 K)
4. Patch 5604120 - SIGNIFICANT PERFORMANCE PROBLEMS AFTER APPLYING CALENDAR DEVIATION (Size -25K)- Select Platform Linux x86
5. Patch 16275529 - MERGE REQUEST ON TOP OF 10.1.0.5.0 FOR BUGS 13514925 10427365 (Size 1.2 M) - Select Platform Linux x86

  Note: E-Business Suite uses the legacy locale definitions in 10.1.2 ORACLE_HOME and its resource files must be regenerated. After applying patch 16275529 perform this task in 10.1.2 ORACLE_HOME using below step:

cd $ORACLE_HOME/nls/data/old

perl cr9idata.pl

Step-3 Post Installation Tasks


Step3 : JDK Upgrade steps

===Next steps - Apply E-Business R12 Interoperability patch

This Oracle Apps Patch 14837539 enables Applications Release 12 Forms to consume class files available in the 10.1.2.3 Patchset. Specifically this patch contains Oracle Applications
Java *.dep and driver files used for building JAR files.

1) Enable Maintenance Mode
2) Apply interoperability patch - p14837539_R12.TXK.B_R12_GENERIC.zip
cd /disk2/10135/10123/14837539
3) Disable Maintenance Mode

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

Before this JDK 7u51 upgrade
-->See the existing version
cd /disk2/applr12/VISV/apps/tech_st/10.1.3/appsutil/jdk/bin
[applr12@oravdba bin]$ file java
java: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.2.5, not stripped

[applr12@oravdba bin]$ ./java -version
java version "1.6.0_10"
Java(TM) SE Runtime Environment (build 1.6.0_10-b33)

-------
cd /media/PENDRIVE/jdk1213_upgrade
gunzip jdk-7u51-linux-i586.tar.gz
This will create tar file..
jdk-7u51-linux-i586.tar
cp jdk-7u51-linux-i586.tar $IAS_ORACLE_HOME/appsutil
chown applr12:dba /disk2/applr12/VISV/apps/tech_st/10.1.3/appsutil/jdk-7u51-linux-i586.tar
cd /disk2/applr12/VISV/apps/tech_st/10.1.3/appsutil
[applr12@oravdba appsutil]$
[applr12@oravdba appsutil]$ tar -xvf jdk-7u51-linux-i586.tar

This will create jdk1.7.0_51 folder..

Move old jdk folder to jdk_old
#mv jdk jdk_old
[applr12@oravdba appsutil]$ mv jdk1.7.0_51 jdk
cd /disk2/applr12/VISV/apps/tech_st/10.1.3/appsutil/jdk/bin
[applr12@oravdba bin]$ ./java -version
java version "1.7.0_51"
Java(TM) SE Runtime Environment (build 1.7.0_51-b13)
Java HotSpot(TM) Server VM (build 24.51-b03, mixed mode)
[applr12@oravdba bin]$ file ./java
./java: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.6.9, not stripped
[applr12@oravdba bin]$

[applr12@oravdba ~]$ which java
/disk2/applr12/VISV/apps/tech_st/10.1.3/appsutil/jdk/jre/bin/java

[applr12@oravdba ~]$ java -version
java version "1.7.0_51"
Java(TM) SE Runtime Environment (build 1.7.0_51-b13)
Java HotSpot(TM) Server VM (build 24.51-b03, mixed mode)

==>Rename Existing JRE Directories 1.4.2 , not needed any more..

cd /disk2/applr12/VISV/apps/tech_st/10.1.3/jre
[applr12@oravdba jre]$ mv 1.4.2 1.4.2_old

==>Install Albany (Display) Font

cd /disk2/applr12/VISV/apps/tech_st/10.1.3/appsutil/jdk/jre/lib/fonts
[applr12@oravdba fonts]$ ls -ltr
total 2044
-rw-r--r--. 1 applr12 dba 242700 Dec 19 08:21 LucidaTypewriterRegular.ttf
-rw-r--r--. 1 applr12 dba 234068 Dec 19 08:21 LucidaTypewriterBold.ttf
-rw-r--r--. 1 applr12 dba 698236 Dec 19 08:21 LucidaSansRegular.ttf
-rw-r--r--. 1 applr12 dba 317896 Dec 19 08:21 LucidaSansDemiBold.ttf
-rw-r--r--. 1 applr12 dba 344908 Dec 19 08:21 LucidaBrightRegular.ttf
-rw-r--r--. 1 applr12 dba  80856 Dec 19 08:21 LucidaBrightItalic.ttf
-rw-r--r--. 1 applr12 dba  75124 Dec 19 08:21 LucidaBrightDemiItalic.ttf
-rw-r--r--. 1 applr12 dba  75144 Dec 19 08:21 LucidaBrightDemiBold.ttf
-rw-r--r--. 1 applr12 dba   4041 Dec 19 08:21 fonts.dir

[applr12@oravdba fonts]$ cp /disk2/applr12/VISV/apps/apps_st/appl/fnd/12.0.0/resource/ALBAN* .


==>Apply patche to 10.1.2.3 Oracle Home using opatch
[root@oravdba jdk1213_upgrade]# ls *1284822*
p12848228_10123_GENERIC.zip
[root@oravdba jdk1213_upgrade]# ls *565959*
p5659594_10123_GENERIC.zip
cd /media/PENDRIVE/jdk1213_upgrade
root@oravdba jdk1213_upgrade]# cp p12848228_10123_GENERIC.zip /disk2/10135/10123/
[root@oravdba jdk1213_upgrade]# cp p5659594_10123_GENERIC.zip /disk2/10135/10123/

==>) Apply patch p12848228_10123_GENERIC.zip
cd /disk2/10135/10123/12848228
opatch apply -invPtrLoc /disk2/applr12/VISV/apps/tech_st/10.1.2/oraInst.loc

==>) Apply patch p5659594_10123_GENERIC.zip
cd /disk2/10135/10123/5659594
opatch apply -invPtrLoc /disk2/applr12/VISV/apps/tech_st/10.1.2/oraInst.loc

---->Copy latest JDK home used with R12 10.1.2 forms and reports ORACLE_HOME
cd /disk2/applr12/VISV/apps/tech_st/10.1.2
cp /disk2/applr12/VISV/apps/tech_st/10.1.3/appsutil/jdk-7u51-linux-i586.tar .
tar -xvf jdk-7u51-linux-i586.tar
It will create jdk1.7.0_51

mv jdk1.7.0_51 jdk

Rename old jre

cd /disk2/applr12/VISV/apps/tech_st/10.1.2/jre
mv 1.4.2 1.4.2_old

===>Apply 10.1.2.3 opatch for Linux86

==>)Apply patch p16271876_10123_LINUX.zip
cd /disk2/10135/10123/16271876
opatch apply -invPtrLoc /disk2/applr12/VISV/apps/tech_st/10.1.2/oraInst.loc
[applr12@oravdba disk2]$ cd $ORACLE_HOME
[applr12@oravdba 10.1.2]$ pwd
/disk2/applr12/VISV/apps/tech_st/10.1.2
[applr12@oravdba 10.1.2]$ cd lib/stubs
[applr12@oravdba stubs]$ ls -ltr libjv*
-rw-r--r--. 1 applr12 dba 38148 Apr 23 04:47 libjvm-1.7-stub.so
[applr12@oravdba stubs]$ ln -s libjvm-1.7-stub.so libjvm.so

==>) Apply patch p14703419_10123_LINUX.zip
cd /disk2/10135/10123/14703419
opatch apply -invPtrLoc /disk2/applr12/VISV/apps/tech_st/10.1.2/oraInst.loc

This will rollback Rolling back patch 6995251...

==>) Apply patch p16207165_10123_LINUX.zip
cd /disk2/10135/10123/16207165
opatch apply -invPtrLoc /disk2/applr12/VISV/apps/tech_st/10.1.2/oraInst.loc

==>) Apply patch p16241466_10123_LINUX.zip
cd /disk2/10135/10123/16241466
 opatch apply -invPtrLoc /disk2/applr12/VISV/apps/tech_st/10.1.2/oraInst.loc

Subset patches:  8551790,

The fixes for Patch 8551790,  are included in the patch currently
being installed (16241466).  OPatch will roll back the subset patch(es) and
install the new patch (16241466).

--->Done above 4 patches

===>Rebuild Forms and Reports executables...

cd /disk2/applr12/VISV/apps/tech_st/10.1.2/forms/lib
[applr12@oravdba lib]$ make -f ins_forms.mk sharedlib install

cd /disk2/applr12/VISV/apps/tech_st/10.1.2/reports/lib
[applr12@oravdba lib]$ make -f ins_reports.mk install

===> Regenerate Forms and Report using adadmin
            AD Administration Main Menu
   --------------------------------------------------

   1.    Generate Applications Files menu

         Generate Applications Files
   ----------------------------------------

   1.    Generate message files

   2.    Generate form files

   3.    Generate report files

   4.    Generate product JAR files

   5.    Return to Main Menu


There are now 5981 jobs remaining (current phase=admin):
    0 running, 2004 ready to run and 3977 waiting.
------
The following Oracle Forms objects did not generate successfully:

bom    forms/US    CSTFVTLC.fmx

Try compiling the form...

frmcmp_batch userid=apps/apps module=CSTFVTLC.fmb output_file=/disk2/applr12/VISV/apps/apps_st/appl/bom/12.0.0/forms/US/CSTFVTLC.fmx module_type=form batch=no compile_all=yes

----Error-----
Compiling ON-POPULATE-DETAILS trigger on MTL_MATERIAL_TXNS_VAL_V data block...
   No compilation errors.

Compiling ON-CHECK-DELETE-MASTER trigger on MTL_MATERIAL_TXNS_VAL_V data block...
Compilation error on ON-CHECK-DELETE-MASTER trigger on MTL_MATERIAL_TXNS_VAL_V data block:
PL/SQL ERROR 905 at line 10, column 19
object APPS.CST_LAYER_ACTUAL_COST_DTLS_V is invalid
PL/SQL ERROR 0 at line 10, column 5
SQL Statement ignored

---------
Refer Doc - 1610857.1 - Customer cannot compile CSTFVTLC.fmx

SOl: apply patch 9868229:R12.BOM.C
cd /disk2/10135/9868229

apply using adpatch and compile again as below and got compiled.

frmcmp_batch userid=apps/apps module=CSTFVTLC.fmb output_file=/disk2/applr12/VISV/apps/apps_st/appl/bom/12.0.0/forms/US/CSTFVTLC.fmx module_type=form batch=no compile_all=yes

------
Reports generation also Done..

Done copying files to destination.


Gathered additional statistics on 'TASK_TIMING' tables.

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


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


Post-Installation Steps for 10.1.3.5

Regenerate appsborg.zip and appsborg2.zip
Use adadmin and chose - Generate product JAR files (with no force option)
Enter your choice [5] : 4


Do you wish to force regeneration of all jar files? [No] ?
  Calling /disk2/applr12/VISV/apps/tech_st/10.1.3/appsutil/jdk/jre/bin/java ...

  Removed appsborg2.cmd.

    Successfully created new appsborg2.zip.

    Copied appsborg2.zip from AU_TOP to  AF_JLIB

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

After starting the applications

500 Internal Server Error

Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in this response. Please consult the application log for details.

In the log
/home/applr12/VISV/inst/apps/VISV_oravdba/logs/ora/10.1.3/j2ee/oacore/oacore_default_group_1/application.log

--------------
14/05/15 04:13:13.702 html: Servlet error
java.lang.NoClassDefFoundError: Could not initialize class oracle.apps.fnd.profiles.Profiles
        at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:239)
        at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:287)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpApplication.loadServlet(HttpApplication.java:2528)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpApplication.findServlet(HttpApplication.java:5006)ppsLoginRedirect.java:239
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpApplication.findServlet(HttpApplication.java:4930)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpApplication.getRequestDispatcher(HttpApplication.java:3139)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:775)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
        at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
        at java.lang.Thread.run(Thread.java:744)
-------------

               

Run autoconfig and test the upgrade.

Try running autoconfig and stop, start the db and application and try...

[applr12@oravdba scripts]$ ./adautocfg.sh
Enter the APPS user password:

The log file for this session is located at: /home/applr12/VISV/inst/apps/VISV_oravdba/admin/log/06042251/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
    Using CONFIG_HOME location     : /home/applr12/VISV/inst/apps/VISV_oravdba
    Classpath                   : /disk2/applr12/VISV/apps/apps_st/comn/java/lib/appsborg2.zip:/disk2/applr12/VISV/apps/apps_st/comn/java/classes

    Using Context file          : /home/applr12/VISV/inst/apps/VISV_oravdba/appl/admin/VISV_oravdba.xml

Context Value Management will now update the Context file

    Updating Context file...COMPLETED

    Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
    Configuring AD_TOP........COMPLETED
    Configuring FND_TOP.......COMPLETED
    Configuring ICX_TOP.......COMPLETED
    Configuring MSC_TOP.......COMPLETED
    Configuring IEO_TOP.......COMPLETED
    Configuring BIS_TOP.......COMPLETED
    Configuring AMS_TOP.......COMPLETED
    Configuring CCT_TOP.......COMPLETED
    Configuring WSH_TOP.......COMPLETED
    Configuring CLN_TOP.......COMPLETED
    Configuring OKE_TOP.......COMPLETED
    Configuring OKL_TOP.......COMPLETED
    Configuring OKS_TOP.......COMPLETED
    Configuring CSF_TOP.......COMPLETED
    Configuring IGS_TOP.......COMPLETED
    Configuring IBY_TOP.......COMPLETED
    Configuring JTF_TOP.......COMPLETED
    Configuring MWA_TOP.......COMPLETED
    Configuring CN_TOP........COMPLETED
    Configuring CSI_TOP.......COMPLETED
    Configuring WIP_TOP.......COMPLETED
    Configuring CSE_TOP.......COMPLETED
    Configuring EAM_TOP.......COMPLETED
    Configuring FTE_TOP.......COMPLETED
    Configuring ONT_TOP.......COMPLETED
    Configuring AR_TOP........COMPLETED
    Configuring AHL_TOP.......COMPLETED
    Configuring OZF_TOP.......COMPLETED
    Configuring IES_TOP.......COMPLETED
    Configuring CSD_TOP.......COMPLETED
    Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.
[applr12@oravdba scripts]$
--------------
Completed normally..

After autoconfig , application started working...

Cheers :)
------------------------

Step-4 Post Installation Tasks - JRE Plugin update.

Deploying JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12 [ID 393931.1]

JRE plugin is used for forms based application.

Oracle E-Business Suite 12.0.x and 12.1.x or Users
Step 1.1. Download the Interoperability Patch

If not applied previously, download the JRE Plug-in Oracle E-Business Suite interoperability Patch 4377566.

This patch is required for all JRE releases and contains the required versions of the txkSetPlugin JRE upgrade scripts to ensure that the context file is updated both seamlessly and correctly:

Unix: $FND_TOP/bin/txkSetPlugin.sh v120.10