Search Blog Post

Friday, February 6, 2015

FRM-92050. Failed to connect to the Server: /forms/lservlet-1


After recent upgrade JDK upgrade on our EBS R12 environment, most of the users reported that they encounter below error while trying to launch forms thru EBS front end.
FRM-92050. Failed to connect to the Server: /forms/lservlet-1 

To fix the issue, oracle recommend to set the oracle EBS application to run throught the trusted sites zones, with a medium security settings.
1.     Open IE
2.     Select Tools -> Internet Options -> Security tab -> Trusted Sites icon -> Sites button from the Internet Explorer Menu Bar.
3.     Set the 'Security Level for this Zone' to 'Medium' if it is not set already.In the 'Add this Web site to the zone:' field, enter the 'hostname and domain' of the environment you are running the Oracle E-Business Suite from; i.e. https://., then click the 'Add' button
or
4.     Alternatively you can simply add the domain name preceded by '*', so that all sites under that domain go through this zone. i.e. *.

Also, I would suggest to uncheck IE to upgrade to latest version 11.














HTH
Thanks for reading..!! 

Upgrade to latest JRE 7.0 on Database Tier Node



Step : 1 Download Latest JRE 7.0 Update

Download the 32-bit JRE only, not the Java SE Development Kit (JDK).


Step : 2 Replace JRE Home Used With Oracle E-Business Suite Release 12

The Oracle E-Business Suite database tier uses the JRE 7.0 from a fixed installation location, $ORACLE_HOME/appsutil/jre. This can be replaced by copying the install from a separate default location or working directory, or by installing the new version following the procedure below, which replaces the old JRE installation used by AutoConfig with a new one for each database tier node.
o    $ cd [ORACLE_HOME]/appsutil
o    $ mv jre jre_old
/** Install the latest JRE 7.0 Update here. In the example, the directory name is jre1.7.0_5 .**/
o    $ mv jre1.7.0_5 jre


Verify JRE Installation on Database Tier Node

·         cd [ORACLE_HOME]/appsutil/jre/bin
·         $ java –version
 

Upgrade to JDK 7.0 on EBS R12 Application Tier


Upgrade the JDK in 10.1.3 Oracle Home from JDK 1.5/1.6 to JDK 7.0

Step 1: Apply following Prerequisite Patches

·         14635756 - QRMP: FIX NEEDED FOR 10.1.2 JDK 7 UPGRADE
o    Prerequisite (R12.TXK.B) 8919489 – Already applied

Step 2: Download JDK

Download the 32-bit JDK, not the Java Runtime Environment (JRE).
Do not choose the 64-bit version, which is not supported.

Step 3: Shutdown Applications

Stop all application tier services before installing the latest update of JDK 7.0 into the [IAS_ORACLE_HOME]/appsutil/jdk location
o    $ cd $INST_TOP/admin/scripts/
o    $ adstpall.sh

Step 3 : Replace JDK Home Used With Oracle E-Business 12

Oracle E-Business Suite application tier uses the JDK from a fixed installation location, [IAS_ORACLE_HOME]/appsutil/jdk.
This can be replaced either by copying the installation from a separate default location or working directory, or by replacing the old JDK installation with the new one on each application tier node.

Perform this action by entering the applicable commands below.
·         $ cd [IAS_ORACLE_HOME]/appsutil
·         $ mv jdk jdk_old/** Install the latest JDK 7.0 Update here. In the example, the directory name is jdk1.7.0_5 .**/
·         $ mv jdk1.7.0_5 jdk

Step 4 : Rename Existing JRE Directories

The existing JRE directory is no longer needed. Perform this action by entering the applicable commands below.
·         $ mv $IAS_ORACLE_HOME/jre/1.4.2 $IAS_ORACLE_HOME/jre/1.4.2_old

Step 5 : Install Albany (Display) Font

Installation of the font files listed below is required to support Oracle XML Publisher and enable the Oracle UIX Dynamic Image technology to successfully generate images. These font files must be available on each application tier node. They are located under $FND_TOP/resource.

The font files are:
·         ALBANYWT.ttf - Single-byte characters only
·         ALBANWTJ.ttf - Unicode font with Japanese Han Ideographs
·         ALBANWTK.ttf - Unicode font with Korean Han Ideographs
·         ALBANWTS.ttf - Unicode font with Simplified Chinese Han Ideographs
·         ALBANWTT.ttf - Unicode font with Traditional Chinese Han Ideographs

o    $ cp $FND_TOP/resource/font_file_name.ttf $IAS_ORACLE_HOME/appsutil/jdk/jre/lib/fonts


Upgrade the JDK in 10.1.2 Oracle Home from JDK 1.5/1.6 to JDK 7.0

Step 1 : Apply latest Forms & Reports Patches (437878.1)

·         Stop all services
o    Adstpall.sh

·         Apply Prerequisite Technology Stack Patches
o    Patch 8919489 - R12.TXK.B.Delta.3

·         Back Up OracleAS 10.1.2 ORACLE_HOME and Inventory folder

·         Latest certified OracleAS patchset
o    Patch 5983622- Oracle Application Server 10g Patchset

·         Install Forms Bundle Patch
o    Patch 14825718- Forms Bundle Patch

·         Install Additional Patches

Note: Must select "iAS 10.1.2.3" from the release dropdown list before downloading the patch
o    Patch 17303472- Forms Overlay Patch
o    Patch 57121788- Forms Platform Specific Patch
o    Patch 8528194  - Forms Platform Specific Patch
o    Patch 8557019 - Forms C Patch
o    Report C Patches
§  7016961
§  5917053
§  6371228
§  10152652
§  11780669
§  12379038
§  12887068
§  12898423
§  16778382
o    Patch 8339196 Report C Patch
o    Patch 14374587 Report Java Patch
o    Patch 7140392 Report Java Patch
o    Patch 8300196 Report Generic Patch

·         Download and apply 10.1.0.5 RSF fixes
o    Patch 3559326
o    Patch 5394728
o    Patch 5261796
o    Patch 5651245
o    Patch 4047619  
o    Patch 5604120  
o    Patch 16275529  
After applying patch 16275529 perform this task in 10.1.2 ORACLE_HOME.
·         $ cd $ORACLE_HOME/nls/data/old


·         $ perl cr9idata.pl

·         Apply patch 6400501 (Oracle Database 11g only)

Download patch 6400501 for Database 10.1.0.5, and apply it to the OracleAS 10.1.2 Oracle Home. This one-off is originally applied as part of the 11g database upgrade, which is rolled back by the OracleAS 10.1.2.3 patchset.

·         Apply Oracle E-Business Suite Interoperability Patch
o    Patch 14837539 - Oracle E-Business Suite Interoperability Patch
·         Rebuild Forms and Reports Executable
o   cd $ORACLE_HOME/forms/lib32
Note: if this directory does not exist:
o   cd $ORACLE_HOME/forms/lib $ make -f ins_forms.mk install
o   cd $ORACLE_HOME/reports/lib32
Note: if this directory does not exist:
o   cd $ORACLE_HOME/reports/lib $ make -f ins_reports.mk install
·         Regenerate 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
·         Start All Services
o    $ADMIN_SCRIPTS_HOME/adstrtal.sh

·         Run Forms compiler
o   $ORACLE_HOME/bin/frmcmp help=y

·         Run Report Builder
o   $ORACLE_HOME/bin/rwrun ?|grep Release

Step 2 : Download and Apply Patch 12848228 and 5659594

Apply Patch 12848228 and 5659594 to 10.1.2.3 Oracle Home using Opatch
·         Patch 12848228 - APPS6:RWRUN HANGS DUE TO ISSUE IN JOBMANAGER. UPDATEJOBSTATUS (Already applied)
·         Patch 5659594 - R11:REG:RWBUILDER/RWRUN RAISING EXCEPTION WHILE RUNNING REPORT IN VIEW

Step 3 : Download Latest JDK 7.0 Update

Download the 32-bit JDK, not the Java Runtime Environment (JRE).

Do not choose the 64-bit version, which is not supported.

 

Step 4 : Replace JDK Home Used With Oracle E-Business Suite Release 12

The JDK home within the OracleAS 10.1.2 Forms and Reports ORACLE_HOME can be replaced by entering the applicable commands below.
     o    $ cd [10.1.2_ORACLE_HOME]
     o    $ mv jdk jdk_old
/* Now install the downloaded latest update of JDK 7.0 here. In this example the version is 7.0_2. Then */
     o    $ mv jdk1.7.0_2 jdk

Step 5 : Rename The Following Directories

o    $mv [10.1.2_ORACLE_HOME]/jdk64 [10.1.2_ORACLE_HOME]/jdk64_old
o    $mv [10.1.2_ORACLE_HOME]/jre/1.4.2 [10.1.2_ORACLE_HOME]/jre/1.4.2_old
o    $mv [10.1.3_ORACLE_HOME]/jre/1.4.2 [10.1.3_ORACLE_HOME]/jre/1.4.2_old

Step 6 : Rebuild Forms and Reports Executable (For Unix/Linux Only)

Source the environment (under $INST_TOP/ora/10.1.2) to point to the 10.1.2 Oracle Home before relinking forms and reports executable.
o    cd $ORACLE_HOME/forms/lib32
/* Note: if this directory does not exist, use the following command: */
o    cd $ORACLE_HOME/forms/lib
$ make -f ins_forms.mk sharedlib install
o    cd $ORACLE_HOME/reports/lib32
/* Note: if this directory does not exist, use the following command: */
o    cd $ORACLE_HOME/reports/lib $ make -f ins_reports.mk install

Step 7 : Re-generate Oracle E-Business Suite Forms and Reports

Run ADAdmin and select the Forms and Reports regeneration.

Step 8 : Start All Apps

o    $ cd $INST_TOP/admin/scripts/
o   $ adstrtal.sh


Verify Configurations On All Application Tier Nodes

·         Check JDK version and CLASSPATH
Open the $APPL_TOP/admin/adovars.env file and ensure that the environment variables below are defined. Run the following commands to verify that the environment variables ADJVAPRG and AFJVAPRG point to the JDK 7.0 executable. The CLASSPATH and AF_CLASSPATH environment variables must contain the necessary JDK 7.0 libraries.

o    $ $ADJVAPRG -version
o    $ echo $CLASSPATH
o    $ $AFJVAPRG -version
o    $ echo $AF_CLASSPATH

·         Verify Oracle E-Business Suite concurrent programs
o    Log in to Oracle E-Business Suite and select the "System Administrator" responsibility.
Check the Concurrent --> Manager --> Administer form and ensure that all managers have the appropriate numbers for their actual and target. For more details on how to manage concurrent managers and concurrent programs, refer to Managing Concurrent Processing and Concurrent Programs, Chapter 2 of Oracle Applications System Administrator's Guide - Maintenance.