REP-69 : Java heap space REP-0069 An Internal error occured

Error: REP-69 : Java heap space REP-0069 An Internal error occured

Problem: The above error coming when multiple pages report are executing


-----Existing Report server configuration File--------

[oracle@said-app RptSvr_said-app_asinst_1]$ vim /u01/oracle/middleware/asinst_1/config/ReportsServerComponent/RptSvr_bach2-app_asinst_1/rwserver.conf



   
       
       
   

    jvmOptions="-Xmx1024m -Xms512m"
maxEngine="16" maxIdle="30" minEngine="1">       
       
   
   
   
   
   
   
   
       
       
   
   
   
   

~                                                                                                                                                                     
~                                                                                                                                                                     
"rwserver.conf" 23L, 1413C                 

Solution

Step 1- Backup Reports Server configuration file
Step 2- Edit Reports Server configuration file and change

FROM
minEngine="0" engLife="50" maxIdle="30" callbackTimeOut="90000">
TO
minEngine="0" engLife="50" maxIdle="30" callbackTimeOut="90000" jvmOptions="-Xmx1024m">

Or


TO
jvmOptions="-Xmx3072m -Xms1024m"
maxEngine="16" maxIdle="30" minEngine="1">
Step 3- Re-start Reports Server and run report again.


Note: Apply first in test server

"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

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

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

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 ...