CONVERTING SOCKET MODE TO SERVLET MODE OF ORACLE APPS

PRE-REQUISITES :

 We had to apply latest AD.I.6 Patch.
Patch number : 6502082
 We need to apply forms Patch set—18
Patch number : 4948577
 We need to apply Interoperatibility Patch
Patch number : 4888294

APPLYING AD.I.6 PATCH :

 Pre-Requisites :

 Unzip the apps.zip file.
Location : $JAVA_TOP
[app@linux6 ~] $ unzip  apps.zip

 Apply the Patch using ADPATCH. Go to Patch Location and apply the required Driver.

 Post Steps :

 Copy adgrants.sql from $APPL_TOP/ADMIN to <RDBMS_ORACLE_HOME>/appsutil/admin.
Create admin directory under <RDBMS_ORACLE_HOME>/appsutil.
[app@linux6 ~] $ cd <RDBMS_ORACLE_HOME>/appsutil
[app@linux6 ~] $ mkdir admin
[app@linux6 ~] $ cd $APPL_TOP/admin
[app@linux6 ~] $ cp adgrants.sql RDBMS_ORACLE_HOME>/appsutil/admin.
 Now connect to SQLPLUS as  SYSDBA and run adgrants.sql.
[app@linux6 ~] $ sqlplus  ‘/ as sysdba’
SQL > @adgrants.sql  applsys
 Unzip apps.zip under $JAVA_TOP
 Run Autoconfig


APPLYING FORMS PATCHSET 18 :

 Check the forms Server Version. It must be 6.0.8.17.0. To check the  Forms Server Version. Issue the below command.
[app@linux6 ~] $ f60gen

Forms 6.0 (Form Compiler) Version 6.0.8.25.2 (Production)
Forms 6.0 (Form Compiler): Release  - Production
(c) Copyright 1999 Oracle Corporation.  All rights reserved.
PL/SQL Version 8.0.6.3.0 (Production)
Oracle Procedure Builder V6.0.8.21.0 Build #0 - Production
Oracle Virtual Graphics System Version 6.0.5.39.0 (Production)
Oracle Multimedia Version 6.0.8.25.0 (Production)
Oracle Tools Integration Version 6.0.8.17.0 (Production)
Oracle Tools Common Area Version 6.0.5.32.0
 Copy the Patch to 8.0.6 Home location and unzip the patch. It creates the below Directory.
[app@linux6 ~] $ cd <8.0.6 HOME>
[app@linux6 ~] $ unzip p4948577_600_LINUX.zip

 Directory Name : developer6i_patch18

 Set the Oracle Home
 Now go to developer6i_patch18 location and fire the below command.
[app@linux6 ~] $ ./patch_install.sh
 Check whether it is applied by firing f60gen.
[app@linux6 ~] $ f60gen

Forms 6.0 (Form Compiler) Version 6.0.8.27.0 (Production)

Forms 6.0 (Form Compiler): Release  - Production

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

PL/SQL Version 8.0.6.3.0 (Production)
Oracle Procedure Builder V6.0.8.21.0 Build #0 - Production
Oracle Virtual Graphics System Version 6.0.5.39.0 (Production)
Oracle Multimedia Version 6.0.8.25.0 (Production)
Oracle Tools Integration Version 6.0.8.17.0 (Production)
Oracle Tools Common Area Version 6.0.5.32.0
Oracle CORE Version 4.0.6.0.0 – Production
 Relink Procedure Builder, Forms, Graphics and Reports
o [app@linux6 ~] $ cd $ORACLE_HOME/procbuilder60/lib
[app@linux6 ~] $ make -f ins_procbuilder.mk install
o [app@linux6 ~] $ cd $ORACLE_HOME/forms60/lib
[app@linux6 ~] $ make -f ins_forms60w.mk install
o [app@linux6 ~] $ cd $ORACLE_HOME/graphics60/lib
[app@linux6 ~] $ make -f ins_graphics60w.mk install
o [app@linux6 ~] $ cd $ORACLE_HOME/reports60/lib
[app@linux6 ~] $ make -f ins_reports60w.mk install

APPLYING THE INTEROP PATCH

 Unzip the Patch.
 Apply the patch using adpatch and apply the required driver.

CONVERT FROM SOCKET TO SERVLET MODE :

We need to run the below perl script which located in  FND_TOP/bin

[app@linux6  ~] $ cd $FND_TOP/bin
[app@linux6  ~] $ perl txkrun.pl -script=SetAdvCfg -appsuser=apps -appspass=apps –
   enable=FormsLsnrServlet

Run Autoconfig.