Pages

Search This Blog

Monday, March 23, 2020

How to open a .JNLP file (Launch forms using Java Web Start) ?


Assumptions:
1. Java is already installed on your machine.
2. Your EBS form sessions are JWS enabled.

How to open a JNLP file:

1. Login to E-Business Suite.
2. Open a form.
3. It downloads frmservlet.jnlp file into your downloads folder.
4. Right-click on the file and choose Open with then click Choose another app.
5. If you see Java (TM) Web Start Launcher in this list (you may need to click More apps to expand the list), select it and check the box that says Always use this app to open .jnlp files then click the OK button.
6. If Java (TM) Web Start Launcher is not in the list, check the box that says Always use this app to open .jnlp files then click Look for another app on this PC.
    Navigate to the following location:
    C:\Program Files (x86)\Java\jreXXXX\bin
    XXXX represents a number that will vary based on the version of Java installed on the computer, for example: jre1.8.0_181.
    Select the file named javaws.exe and click Open.
7. Going forward, all .jnlp files will open using Java Web Start.


Tuesday, March 10, 2020

adoacorectl.sh start, failed with 'ERROR : Timed out( 100000 ): Interrupted Exception'

Issue Details:

$INST_TOP/admin/scripts/adoacorectl.sh start
Timeout specified in context file: 100 second(s)


ERROR : Timed out( 100000 ): Interrupted Exception
You are running adoacorectl.sh version 120.13


--> Upon checking logs, found the issue.

Logs:
$LOG_HOME/appl/admin/log/adoacorectl.txt
$LOG_HOME/ora/10.1.3/opmn/default_group~oacore~default_group~1.log


Issue:
Java HotSpot(TM) Server VM warning: CodeCache is full. Compiler has been disabled.
Java HotSpot(TM) Server VM warning: Try increasing the code cache size using -XX:ReservedCodeCacheSize=
Code Cache  [0xf3e00000, 0xf6e00000, 0xf6e00000)
total_blobs=6685 nmethods=6295 adapters=331 free_code_cache=1843Kb



Solution:

Java HotSpot(TM) 64-Bit Server VM Warning: CodeCache Is Full (Doc ID 2579830.1)

Reboot the server on which OVM Manager is installed.
This activity will not have any effect on the running VMs.



Monday, February 24, 2020

Oracle Database 19c: [INFO] [INS-32183] Use of clone.pl is deprecated in this release.

I was trying to clone oracle 19c ORACLE_HOME binaries from one server to another server.  Though it says deprecated, clone.pl worked end of the day.

Source the Environment on Target Host:

export ORACLE_SID=ORCL
export ORACLE_BASE=/ora/db/ORCL
export ORACLE_HOME=/ora/db/19.0.0
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$ORACLE_HOME/bin:.

Run Clone Script:

$ORACLE_HOME/perl/bin/perl \
$ORACLE_HOME/clone/bin/clone.pl \
ORACLE_BASE=$ORACLE_BASE \
ORACLE_HOME=$ORACLE_HOME \
OSDBA_GROUP=oinstall \
OSOPER_GROUP=oinstall \
ORACLE_HOME_NAME=ORCL_HOME

Command Line output for clone script:

[oracle@mydbserver ~]$ $ORACLE_HOME/perl/bin/perl \
> $ORACLE_HOME/clone/bin/clone.pl \
> ORACLE_BASE=$ORACLE_BASE \
> ORACLE_HOME=$ORACLE_HOME \
> OSDBA_GROUP=oinstall \
> OSOPER_GROUP=oinstall \
> ORACLE_HOME_NAME=ORCL_HOME


[INFO] [INS-32183] Use of clone.pl is deprecated in this release. Clone operation is equivalent to performing a Software Only installation from the image.
You must use /ora/db/19.0.0/runInstaller script available to perform the Software Only install. For more details on image based installation, refer to help documentation.


Starting Oracle Universal Installer...

You can find the log of this install session at:
 /ora/db/oraInventory/logs/cloneActions2020-02-23_06-56-11AM.log
..................................................   5% Done.
..................................................   10% Done.
..................................................   15% Done.
..................................................   20% Done.
..................................................   25% Done.
..................................................   30% Done.
..................................................   35% Done.
..................................................   40% Done.
..................................................   45% Done.
..................................................   50% Done.
..................................................   55% Done.
..................................................   60% Done.
..................................................   65% Done.
..................................................   70% Done.
..................................................   75% Done.
..................................................   80% Done.
..................................................   85% Done.
..........
Copy files in progress.

Copy files successful.

Link binaries in progress.
..........
Link binaries successful.

Setup files in progress.
..........
Setup files successful.

Setup Inventory in progress.

Setup Inventory successful.
..........
Finish Setup successful.
The cloning of O19CAPEX_HOME was successful.
Please check '/ora/db/oraInventory/logs/cloneActions2020-02-23_06-56-11AM.log' for more details.

Setup Oracle Base in progress.

Setup Oracle Base successful.
..................................................   95% Done.

As a root user, execute the following script(s):
        1. /ora/db/19.0.0/root.sh



..................................................   100% Done.
[oracle@mydbserver ~]$


FRM-92095: Oracle JInitiator version is too low. Please install version 1.1.8.2 or higher.

Issue Details:

When ever you launch forms, it may end up with below error.

FRM-92095: Oracle JInitiator version is too low.  Please install version 1.1.8.2 or higher.

Solution:

Window 7 Users:
(Windows Key > Right click on My Computer > Properties > Advanced System Settings > Environment Variables > Add either a User or System attribute > Click on the New button > Enter "JAVA_TOOL_OPTIONS" under Parameter Name and -Djava.vendor="Sun Microsystems Inc." under Parameter Values)

IE issue when launching Java forms for EBS R12.1

Issue Details:

We installed EBS 12.1 and when we tried to open forms in IE11, it threw an error message "In order to access this application, you must install the J2SE Plugin version 1.5.0_13. To install this plugin, click here to download the oaj2se.exe executable. Once the download is complete, double-click the oaj2se.exe file to install the plugin. You will be prompted to restart your browser when the installation ".


Solution:

The steps we performed to resolve the issue are:

1. Go to tools>compatibility settings>and add the domain. My domain was oracle.com so i added it.
2. Tools>internet options>security>internet>custom level>disable xss filter
3. Under internet options>security>Local Intranet>sites>advance option>added the site http://myebs.myappserver.com
4. internet options>security>Local Intranet>custom level>disable xss filter
5. The final step was to apply the RPM-openmotif21-2.1.30-11.EL5.i386.rpm, Shut down ebs services including database and install the RPM. Once installed, start the services and test it.