Deploying JRE 7 (Native Plug-in) for Windows Clients in EBS 12

Deploying JRE 7 (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12

Tested on EBS 12.1.3

The JRE 7 Plug-in is certified for Oracle E-Business Suite R12 with the following minimum patch requirements:

Oracle forms 10.1.2.3 or higher with Patch 14614795 

• Download latest certified OracleAS patchset and Oracle E-Business Suite Interoperability Patch : 14837539
  • Enable Maintenance Mode and apply the patch

• Forms - Bundle Patch 10.1.2.3.2 (Linux and Linux x86-64) : 14825718
  • Stop the application services
    
  • Set the oracle home to 10.1.2 home
  • go to patch directory
  • opatch apply

• Rebuild Forms and Reports executable:

cd $ORACLE_HOME/forms/lib32
Note: if this directory does not exist:
cd $ORACLE_HOME/forms/lib
$ make -f ins_forms.mk install

Note: During reports/forms rebuild you might get below error during relinking

/usr/lib/libXtst.so.6: undefined reference to `__stack_chk_fail@GLIBC_2.4'
/usr/lib/libXtst.so.6: undefined reference to `__fprintf_chk@GLIBC_2.3.4'
/usr/lib/libXtst.so.6: undefined reference to `__sprintf_chk@GLIBC_2.3.4'

Solution :
unlink /usr/lib/libXtst.so.6
ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6

• Regenerate the JAR Files

Run the AD Administration Utility to regenerate the JAR files:

1. Run the AD Administration Utility (adadmin)
2. Select Generate Applications Files
3. Generate Product JAR Files
4. Verify that the fndforms.jar and fndewt.jar JAR files have been rebuilt by checking the timestamp for both files in the $OA_JAVA/oracle/apps/fnd/jar directory.

Download the latest JRE 7 update from the Java SE Downloads page.

• Click the JRE Download button for the appropriate Java version

• Click the Accept License Agreement button

• Download the Windows x86 Offline (32-bit) or Windows x64 (64-bit) version as required

• Rename the JRE Plug-in and Place it on Web Application Tier

E.g. : jre-7u25-windows-i586.exe or jre-7u25-windows-x64.exe would be renamed j2se17025.exe

• Move the renamed j2se<version>.exe file to the web application tier and place it in $[COMMON_TOP]/webapps/oacore/util/jinitiator

Apply the JRE Interoperability Patch

If not applied previously apply the JRE Plug-in interoperability Patch 4377566

• enable the maintenance mode and apply the patch

Run the txkSetPlugin.sh Script

• Run the $FND_TOP/bin/txkSetPlugin.sh script against the web node of the application tier.
• txkSetPlugin.sh jversion e.g. txkSetPlugin.sh 17025

Disable maintenance mode if enabled and start the services

Retest the forms issue with jre 1.7

Reference Metalink Doc ID:

Deploying JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12 (Doc ID 393931.1)
Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12 (Doc ID 437878.1)

Installing Micro Focus Server Software and licensing on UNIX

Micro Focus Server (UNIX). This is the runtime and licensing engine that allows the product's COBOL programs to run in a production environment.

Installing Micro Focus Server Software on UNIX Server

Caution: This software MUST be installed into /opt/SPLcobAS51 on UNIX systems.

Installed this using root

i- Create a directory to contain the COBOL executables:

mkdir /opt/SPLcobAS51

ii- Extract the tar file into /opt/SPLcobAS51:

cd /opt/SPLcobAS51; tar -xvf /u01/softwares/MF_SERVER/sx51_ws7_redhat_x86_64_server.tar

iii-

Start the installation program:

COBDIR=/opt/SPLcobAS51; export COBDIR

cd $COBDIR; ./install

iv-

Enter the following responses to the installation questions:

• Do you want to make use of COBOL and Java working together? (y/n): y

• Which of these versions of Java do you want to be the default?: 1.6.0 64-bit

• Please enter either 32 or 64 to set the system default mode: 64

• Do you wish to configure Enterprise Server now? (y/n): n

To Install License:

COBDIR=/opt/SPLcobAS51; export COBDIR

cp auto* splwg* $COBDIR

Then you need to run the autoinstall script

    cd $COBDIR

    sh ./autoinstall2

   

If you wish to check your installed licenses

    $COBDIR/aslmf/apptrack

The apptrack program will ask you to think of a new password if you haven't

run it before.  You can then select the options for 'license list' and

'License summary'.

import utility progress in oracle database

Started import of huge dump files (more than 20 gb each) in database, definitely it would take long time but wants to check progress of import utility in database. So I found below query explains fair enough details about the progress of import running.


set lines 180
col table_name for a50

select substr(sql_text,instr(sql_text,'INTO "'),30) table_name,
rows_processed,
round((sysdate-to_date(first_load_time,'yyyy-mm-dd hh24:mi:ss'))*24*60,1) minutes,
trunc(rows_processed/((sysdate-to_date(first_load_time,'yyyy-mm-dd hh24:mi:ss'))*24*60)) rows_per_min
from sys.v_$sqlarea
where sql_text like 'INSERT %INTO "%'
and command_type = 2
and open_versions > 0

EBS Cloning Techniques: Rapid Clone

EBS Cloning Techniques: Rapid Clone

Information of some scripts: When we run cloning scripts lots of things happens at backend

1-   Prepares Source System

On Database Tier

adpreclone.pl dbTier

·         Creates OH/appsutil/clone directory

·         Obtains Database Information

·         Creates adcrdbclone.sql

What it does?

adpreclone.pl dbTier à adclone.pl à StageDBTier.java à 1- StageDatabase.java

                                                                                   2- StageDBTechStack.java

On Application Tier

adpreclone.pl appsTier

·         Creates $COMMON_TOP/clone directory

What it does?

adpreclone.pl appsTier à adclone.pl à StageAppsTier.java à 1 - StageApplTop.java

                                                                                   2 - StageAppsTechStack.java

2-   Copy Bits

Source System To Target System

3-   Configure Target System

On Database Tier

adcfgclone.pl dbTier

·         Create Context File

·         Register Oracle Home

·         Relink Oracle Home

·         Configure Oracle Home

·         Recreate Control File

·         Configure Database

·         Start SQL*Net Listener

What it does?

adcfgclone.pl dbTier à adclone.pl à ApplyDBTier.java à  1- ApplyDatabase.java

                                                                                   2- ApplyDBTechStack.java

     On Application Tier

adcfgclone.pl appsTier

·         Create Context File

·         Register Oracle Homes

·         Relink Oracle Homes

·         Configure Oracle Homes

·         Create INST_TOP

·         Configure APPL_TOP

·         Start Apps Processes

What it does?

adcfgclone.pl dbTier à adclone.pl à ApplyAppsTier.java à  1- ApplyApplTop.java

                                                                                      2- ApplyAppsTechStack.java

4-   Other Configuration Commands

On Database Tier

adcfgclone.pl dbTechStack

·         Create Context File

·         Register Oracle Home

·         Relink Oracle Home

·         Configure Oracle Home

·         Start SQL*Net Listener

adcfgclone.pl dbconfig

·         Configure Database

adcfgclone.pl database

·         Recreate Control File

·         Configure Database

·         Start SQL*Net Listener

On Applications Tier

adcfgclone.pl atTechStack

·         Create Context File

·         Register Oracle Homes

·         Relink Oracle Homes

·         Configure Oracle Homes

·         Create INST_TOP

adcfgclone.pl appltop

·         Configure APPL_TOP

·         Create INST_TOP

·         Start SQL*Net Listener

adclonectx.pl

·         Clone Context File

·         Allows Automation

What it does?

adclonectx.pl à CloneContext.java