Showing posts with label Oracle Forms Developer. Show all posts
Showing posts with label Oracle Forms Developer. Show all posts

Tuesday, 25 August 2015

"Error Oracle*Terminal cannot open fmrweb". in Weblogic

Problem: Trying to launch any .fmx, I can see only "Error Oracle*Terminal cannot open fmrweb".

Solution:

This means that you have no access to fmrweb.res file, that is normally located in FORMS directory. You may look for this file or use another terminal file.



The file located in

/u01/oracle/middleware/asinst_1/config/FormsComponent/forms/admin/resource/US/fmrweb.res



Tuesday, 8 April 2014

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

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

Error: 

FRM-92095: Oracle JInitiator version too low. Please install version 1.1.8.2 
I found the root cause for this issue and following is the solution.

Solution:

Root Cause:
Oracle Forms is not compatible with JRE 7 yet

Fix:
1.    Uninstall JRE Version 7
Help Document to uninstall: http://www.java.com/en/download/uninstall.jsp

2.    Once JRE 7 has been un-installed then install latest version of JRE 6 Standard Edition which can be downloaded from here.
http://www.oracle.com/technetwork/java/javase/downloads/index.html

3.    Clear browser cache. Close and Re-launch the browser and finally retest the issue.

Note:
Ensure that JRE updates are done manually by unchecking the "Check for Updates Automatically" button under the Java Control Panel
http://www.java.com/en/download/help/java_update.xml


Reference: 
http://www.strsoftware.com/blog/error-frm-92095-oracle-jinitiator-version-too-low-please-install-version-1-1-8-2-or-higher/
http://orclapp.blogspot.com/2012/10/frm-92095-oracle-jinitiator-version-too.html

Monday, 10 February 2014

Steps of Oracle Developer 6i (Including Patch) Installation in Windows 64bit

Reason: NN60.dll and NNB60.dll included in Developer 6i patch is not supported for
Report Builder Installed in Windows 64bit OS. 

Solution:

1. Install Developer 6i (Forms Developer and Report Developer).
2. Reboot the Computer.
3. copy NN60.dll and NNB60.dll file from C:\orant\BIN\ into a new folder D:\old_dll.
4. Install Developer 6i patch.
5. Reboot the Computer.
6. cut NN60.dll and NNB60.dll file from C:\orant\BIN\ into a new folder D:\new_dll
7. paste NN60.dll and NNB60.dll file from D:\old_dll into  C:\orant\BIN\ location.
8. Connect application through tnsnames.ora located in C:\orant\NET80\ADMIN

Monday, 18 November 2013

Compile 10g Forms/Reports Takes a Very Long Time against 11g database

Here the new issue that I found during upgrade to R12 with 11g Database. As you know the biggest part of patches are generating Forms and Reports in the end of patch installation. This procedure was very slow and takes a lot of time.
After some search in Metalink and Google I found the Doc ID 880660.1 - Compilation Against a 11g Database Hangs or Takes a Very Long Time (Thanks to Harry Tieb).
Action Plan 
1. Apply the database Patch 8560951 on top of your Database. 
   The Patch 8560951 brings modifications in a sensible area and it is needed to use _FIX_CONTROL to enable the fix. 

*** This patch is already included in higher database versions (e.g. 10.2.0.5, 11.2.0.2). For these it's not necessary to install the patch.  But, _FIX_CONTROL='8560951:ON' still needs to be set as the fix is disabled by default. 
2. ALTER SYSTEM SET "_FIX_CONTROL"='8560951:ON'; - This will enable the fix in memory.  OR add this parameter to init.ora file and restart the database.
3. Compile the Forms/Reports again.
    If needed to restore things as they were, you can similarly turn the fix off with:
    ALTER SYSTEM SET "_FIX_CONTROL"='8560951:OFF';
OR  Use the following workaround: 
1. Connect to the DB with SQL*Plus as the user who compiles the Forms application  2. Use the following command to create a synonym all_objects with:
    create synonym all_objects for sys.dba_objects; 
    If it's not working, grant SELECT privelege on sys.dba_objects to the user who will be  compiling the form.
3. Compile the Forms/Reports again.
    If you want at the end, you can drop this synonym with:  drop synonym all_objects;

Good Luck ...