There is a known bug in Oracle Forms 12c that the DATETIME item in Forms is set to a different time than what is configured in the Windows or UNIX server. Oracle Support has reported this issue in AIX, but it has been seen in both Windows and Linux as well. The easiest way to work around this bug is to configure the following environment variable to GMT in your env file (e.g. default.env):

FORMS_DATETIME_LOCAL_TZ=GMT

NOTE: Normally when you do not set this variable, the system defaults to GMT, but this is necessary in 12c.

This should correct the time issues, but if for any reason any datetime fields are out of sync still, you may also need to set the following variable to GMT:

FORMS_DATETIME_SERVER_TZ=GMT

Source: Oracle Support document ID 2139346.1

There is a bug in Forms 12c where the Forms application crashes with FRM-93652 errors when calling any forms where data from a record group is populated. Oracle has created a patch to fix this problem. These steps should be followed to fix this problem:

NOTE: This problem is currently only seen in Unix environments (Linux, Solaris, AIX, etc.). It has not been reported in Windows.

  1. Download Oracle Patch 21534616 from My Oracle Support. Make sure to download the version for your server’s OS. NOTE: The patch is technically an Oracle Database patch, version 11.2.0.3.0, but this will be used to patch the DB client which comes with the Forms 12c installation.
  2. Extract the patch in your server. Once it is extracted, navigate into the 21534616 folder.
  3. Make sure the following environment variables are set (this assumes the Oracle home is installed in /oracle/middleware/as_1 but it may be different for your environment)
    1. export ORACLE_HOME=/oracle/middleware/as_1
    2. export PATH=/oracle/middleware/as_1/bin:$PATH:/oracle/middleware/as_1/OPatch
  4. Run opatch prereq CheckConflictAgainstOHWithDetail -ph ./ to make sure there are no conflicts or errors. FRM-93652 1                      FRM-93652 2
  5. Shut down all instances inside the Forms 12c domain (all WebLogic servers, OHS, the standalone reports server, and Node Manager).
  6. Run opatch apply to install the patch.                                                                                                                                                                                   FRM-93652 3
  7. Make sure the Middleware Home is the Oracle Home for Forms 12c. If it is, type y to proceed.                 FRM-93652 4
  8. When it asks if the local system is ready for patching, type y and press Enter.                                            FRM-93652 5
  9. You should receive a message that the patch was successfully applied. There will be some warnings, but you may ignore these warnings. FRM-93652 6
  10. Go to $ORACLE_HOME/forms/lib and run: make -f ins_forms.mk frmweb_install                                                     FRM-93652 7
  11. If you see the output shown in the following screenshot, the step was run successfully.                         FRM-93652 8
  12. Start up your Forms 12c environment.
  13. Recompile all forms, menus, and libraries.

After applying the steps above, you should no longer encounter FRM-93652 errors when opening up any 12c forms where data from a record group is populated.

NOTE: There is a possibility that you may encounter the error FRM-41337 in the same forms. If you do, you will need to apply another Oracle patch as indicated in https://pitss.com/us/2016/05/06/frm-41337-appears/.

There is a bug in Forms/Reports 11.1.2.2.0 where reports generated into PDFs are not displayed correctly in AIX and Solaris (possibly even Windows 32-bit) environments. According to Oracle Support note 1522543.1, an Oracle Patch, 17903693, will need to be applied to the Forms/Reports environment.

NOTE: This patch is already included with Forms and Reports 11.1.2.2.0 for Windows 64-bit.

How to Apply the Patch:

  1. Download Patch 17903693 from My Oracle Support
  2. Extract the patch into your directory. As a reference, let’s call the extracted location PATCH_TOP.
  3. Shut down all WebLogic servers and instances (OPMN).
  4. Set the following environment variables (NOTE: MW_HOME is your Oracle Middleware home):
    1. Windows: set PATH=%PATH%;%MW_HOME%\oracle_common\OPatch
    2. Windows: set ORACLE_HOME=%MW_HOME%\Oracle_FRHome1
    3. Unix: export PATH=$PATH:$MW_HOME/oracle_common/OPatch
    4. Unix: export ORACLE_HOME=$MW_HOME/Oracle_FRHome1
  5. Go to the PATCH_TOP/17903693 directory (PATCH_TOP\17903693 in Windows)
  6. Run: opatch apply
  7. Type ‘y’ and press Enter when it asks if the system is ready for patching.
  8. When the patch is finished, start up the WebLogic servers and OPMN.

PDF reports should display correct after applying the steps above.

NOTE: Please review the README file before applying any Oracle patch!

Source: Oracle Support note 1522543.1

ORACLE FORMS & REPORTS 11.1.2.2 INFORMATION AND FINDINGS

UPDATED: June 3, 2014

INTRODUCTION

Oracle has just recently released an updated version of Oracle Forms 11gR2 versioned as 11.1.2.2. For what we have seen on Oracle’s website and Oracle Support, the following has been updated in the latest version of Oracle Forms 11gR2 (11.1.2.2):

·         Many bugs have been fixed (See Oracle Support ID 1612530.1 for a list of the bugs fixed)

·         Only Oracle WebLogic Server (WLS) 10.3.6 is supported

·       The operating system support is the same as 11.1.2.1 except for the following:

o   AIX 6.1 must be Update Level 7 or higher

o   AIX 7.1 must be Update Level 1 or higher

o   Windows XP is no longer supported with Forms 11.1.2.2

o   NOTE: Currently no support for Oracle Forms (any release) with Windows 8

·       JDK support:

o Using Java 6 – JDK 1.6.0_35+

o Using Java 7 – JDK 1.7.0_40+

·         Internet Browser support:

o   Internet Explorer: 8, 9, 10, 11 (IE 11 is only supported if Oracle Patch 18277370 is applied)

o   Firefox: 24+

o   Google Chrome: 29+

o   Safari: 5.x

·         Database support (No changes from Forms 11.1.2.1):

o   10.2.0.4+

o   11.1.0.7+

o   11.2.0.1+

o   12.1.0.1+

·          OAM support (No changes from Forms 11.1.2.1):

o   Oracle SSO 10gR3 (10.1.4.3+)

o   Oracle Access Management 11gR1 (11.1.1.5+)

o   Oracle Access Management 11gR2 (11.1.2.0.0)

o   Oracle Internet Directory (OID) 11gR1 (11.1.1.5+)

o   Oracle Virtual Directory (OVD) 11gR1 (11.1.1.5+)

·          This version is released as both a base installation and a patchset (Oracle patch 17882900) installation meaning that Oracle Forms 11.1.2.2 can either be installed as a separate installation or as a patch to an existing 11.1.2.0 or 11.1.2.1 installation.

·          On the Oracle Forms download page, there are no more downloads for Forms 11.1.2.0 or 11.1.2.1. Only Forms 11.1.2.2 can be downloaded from OTN.

For more information regarding Oracle Forms 11.1.2.2 certifications, please review Oracle’s certification matrix for Forms and Reports 11.1.2.2: http://www.oracle.com/technetwork/es/middleware/docs/oracle-forms-111220certmatrix-2087910.xls?ssSourceSiteId=otnen

SIMILARITIES/DIFFERENCES TO FORMS 11.1.2.1

After successfully installed and configured Oracle Forms & Reports 11.1.2.2 in both our Windows 7 64-bit and Oracle Linux 6.4 64-bit test environments, we found that there are no major functionality changes that we could detect. In our test installations, we worked with Oracle WebLogic Server 10.3.6 using JDK 1.7.0_45 (this was the latest JDK available for download as of January 8, 2014 when the test installs were performed). Based off the installation and configuration, we have noticed the following:

1.       The installation of Oracle Forms and Reports 11.1.2.2 (as well as running config.bat/sh) is identical to installing 11.1.2.1. The same steps are involved.

2.       Environment files and formsweb.cfg work the same. In order to use the latest JRE (since we were using JDK 7 in our test), we had to configure the jpi parameters in formsweb.cfg.

3.       Similar to Forms and Reports 11.1.2.1, we still receive the “REP-52262: Diagnostic output is disablederror when we try to run reports. In previous releases of Oracle Forms & Reports 11gR1 and 11gR2 (11.1.2.0), using the default setting in rwservlet.properties would allow anyone to access anything related to rwservlet such as getjobid, showjobs, showenv, etc. For some reason in 11.1.2.1 and 11.1.2.2, the default settings act the same as using <webcommandaccess>L0</webcommandaccess> in the file. To fix this, we had to manually add the parameter <webcommandaccess>L2</webcommandaccess> into rwservlet.properties and restart WLS_REPORTS before we could view generated reports. NOTE: If this was fixed manually in Forms 11.1.2.1 and you patch the install to 11.1.2.2, you do not have to redo this. URL: https://pitss.com/us/2012/12/20/running-reports-in-formsreports-11-1-2-1-generates-rep-52262-with-default-settings/

4.       Patching your Forms 11.1.2.1 installation to 11.1.2.2 requires little effort. All that is required is to shut down all WebLogic servers associated with Forms 11.1.2.1, OPMN, and Node Manager. Running the patchset install and starting everything up afterward is all that is required.

a.       NOTE: When running the installer, make sure to select “Install Software – Do Not Configure”.

b.      NOTE: If you have an Oracle Database installed on the same PC/server where you are upgrading Forms and Reports, the database, TNS listener, and DB Console will need to be shut down as well in order to prevent a possible error during the upgrade.

5.       The OHS bug which occurred in many Oracle Forms 11.1.2.0 installations that was fixed in 11.1.2.1 is also fixed in 11.1.2.2. The bug was the case where you had to rollback and re-apply an Oracle patch to fix an issue where OHS would lose connectivity with the WLS_FORMS server after a report was run. URL: https://pitss.com/us/2012/10/08/how-to-fix-apache-bridge-error-bug-in-forms-11gr2/

6.       The Reports Builder bug where it crashes when viewing the Data Model in 64-bit machines has NOT been fixed with Forms and Reports 11.1.2.2. Fortunately, applying the fix as mentioned in https://pitss.com/us/2012/10/10/reports-builder-11gr2-crashes-when-viewing-data-model/ will still fix the problem. NOTE: If this was fixed manually in Forms 11.1.2.1 and you patch the install to 11.1.2.2, you do not have to redo this.

7.       Oracle Forms & Reports 11.1.2.2 is backwards-compatible with Oracle Forms & Reports 11.1.2.1. We tested this by successfully opening up or loading a form in either an 11.1.2.1 Forms Builder or PITSS.CON saved in either Forms Builder or PITSS.CON using Forms 11.1.2.2. This means that if you are working with someone who is using Oracle Forms 11.1.2.2, you are able to use your PITSS.CON or Forms Builder using Forms 11.1.2.1 without any problems. NOTE: Forms 11.1.2.2 is not backwards-compatible with Forms 11gR1.

8.       In Oracle Forms 11.1.1.6, 11.1.2.0, and 11.1.2.1, there was a bug where you were unable to edit any configuration files or logging information for OHS within Enterprise Manager as mentioned in https://pitss.com/us/2013/10/18/unable-to-edit-ohs-configuration-files-in-enterprise-manager-for-forms-11-1-1-6-or-11gr2/. This bug has been fixed in Forms 11.1.2.2 (as well as 11.1.1.7 if you are using Forms 11gR1).

9.       All Oracle jar files (frmall.jar, frmwebutil.jar, and any other jar file which starts with “frm”) have been updated with the permissions and codebase manifest attributes needed for the later Java JDK and JRE updates. Before you decide to upgrade your JDK and JRE to the latest version (Java 7u45 or higher) in your Forms and Reports 11.1.2.0 and 11.1.2.1 environment, it is best to upgrade to Forms and Reports 11.1.2.2 first (and WebLogic 10.3.6 if you are using 10.3.5). For any custom jar files used in Forms and Reports, they will still need to contain the permissions and codebase manifest attributes (and signed with trusted certificates). Please see https://pitss.com/us/2013/10/24/how-to-modify-custom-jar-files-with-permissions-and-codebase-attributes/ for more information.

10.   Like earlier releases of Oracle Forms and Reports 11gR2 (11.1.2.0 and 11.1.2.1), WebUtil for Forms 11.1.2.2 uses Jacob 1.14.3. No changes to the Jacob DLLs are required.

11.   If you have Forms and Reports integrated with Oracle Access Manager (OAM) 11g, no changes are required on the OAM or OID side. Simply upgrading Forms from 11.1.2.1 (or 11.1.2.0) to 11.1.2.2 is all that is needed to log into your Forms application using OAM.

12.   When configuring Oracle Forms and Reports 11.1.2.2 (using config.bat or config.sh) and you are integrating with OAM, you will still get an error when connecting to the OAM domain even if all information is entered correctly. This bug that was first seen in Forms 11.1.2.1 and 11.1.1.7 has NOT been fixed in 11.1.2.2. You will need to run config.bat or config.sh using the –novalidation flag to work around this error. NOTE: Be very careful when running the configuration wizard if you use the –novalidation flag as the wizard will NOT perform any tests or checks to see if anything entered is valid or invalid. More information can be found at https://pitss.com/us/2013/04/12/forms-and-reports-11gr2-configuration-fails-at-access-control-step-with-oam-2/.

 

Other than what we mentioned above, we did not notice any other major differences. We also setup a test PITSS.CON 12.2.2 environment to run in Oracle Forms & Reports 11.1.2.2. The newest PITSS.CON version, 12.2.2 (as of January 8, 2014), works well with Forms 11.1.2.2. Everything works the same as it did in Oracle Forms 11.1.2.1.

Oracle WebLogic and Forms 11g Setup Prerequisites for IBM-AIX on POWER Systems

 

1.     Minimum System Requirements

1.1.    Supported Operating Systems:

1.1.1. IBM AIX 5.3 UL8+

1.1.2. IBM AIX 6.1 UL7+

1.1.3. IBM AIX 7.1 UL1+

1.2.    RAM: 8GB+

1.3.    HDD Partitioning:

*Software Mount: One file system mount with at least 50GB of free space to store the software and temporary file storage for servers.

TEMPFS Space: 4GB+ (Minimum: 1GB+)

*SWAP: 8GB+

1.4.    OS User Access Requirements:

1.4.1. OS User will need to own the software mount.

1.4.2. Root user access must be accessible for the installation.

*RAM and File System Mount Specifications: For production systems, please consult PITSS or Oracle on sizing recommendations. The amount of RAM, HDD Space for SWAP and Software Mounts will vary depending on end-user usage and application characteristics. If you will be running reports heavily, use at least 20GB of SWAP.

2.     Other AIX OS Requirements

2.1.    Open File Limits:

“soft nofile” should be atleast 4096
“hard nofile” should be atleast 4096 (65535 is recommended)

3.     Required Packages

3.1.1.  IBM AIX 5.3 64-bit

The minimum versions of the packages below will need to be installed before the Forms 11g installation can begin:

 

 

Package Name

bos.adt.base

bos.adt.lib

bos.adt.libm

bos.perf.libperfstat

bos.perf.perfstat

bos.perf.proctools

rsct.basic.rte

rsct.compat.clients.rte

bos.mp64 (version 5.3.0.56)

bos.rte.libc (version 5.3.0.55)

xlC.aix50.rte (version 8.0.0.7)

xlC.rte (version 8.0.0.7)

X11.motif.lib (version 2.1.30)

gpfs.base (version 3.2.1.8) (Only if using Oracle RAC)

 

3.1.2.  IBM AIX 6.1 64-bit

The minimum versions of the packages below will need to be installed before the Forms 11g installation can begin:

 

Package Name

bos.adt.base

bos.adt.lib

bos.adt.libm

bos.perf.libperfstat

bos.perf.perfstat

bos.perf.proctools

rsct.basic.rte

rsct.compat.clients.rte

xlC.aix50.rte (version 11.1.0.4)

xlC.rte (version 11.1.0.4)

X11.motif.lib (version 2.1.30)

gpfs.base (version 3.2.1.8) (Only if using Oracle RAC)

 

For more information from Oracle on required packages please go to: http://download.oracle.com/docs/html/E18558_01/fusion_requirements.htm#BABIDAAA

 

3.1.3.  IBM AIX 7.1 64-bit

The minimum versions of the packages below will need to be installed before the Discoverer 11g installation can begin:

Package Name

bos.adt.base

bos.adt.lib

bos.adt.libm

bos.perf.libperfstat

bos.perf.perfstat

bos.perf.proctools

rsct.basic.rte

rsct.compat.clients.rte

xlC.aix50.rte (version 10.1.0.0)

xlC.rte (version 10.1.0.0)

IZ89165 (Only if using Oracle BI)

For more information from Oracle on required packages please go to: http://download.oracle.com/docs/html/E18558_01/fusion_requirements.htm#BABIDAAA

 

4.     Database Requirements

4.1.    Supported Database Versions:

10.2.0.4+

11.1.0.7+

11.2.0.1+

12.1.0.1+

4.2.    A database user with DBA/SYS privileges accessible.

4.3.    The file tnsnames.ora containing the SID of the database will need to be placed in the server/client in the same location as the other prerequisites.

 

5.     Software Requirements

5.1.    IBM JDK 7 (SR3 or higher)

5.2.    Webutil and JACOB

5.2.1. Please contact PITSS at 248-740-0935 or support@pitssamerica.com for download instructions.

 

5.3.    For an 11g Forms installation you will need to download the following software:

5.3.1. WebLogic 10.3.6

5.3.1.1.              Can be downloaded from: http://www.oracle.com/technetwork/middleware/ias/downloads/wls-main-097127.html

5.3.1.2.              After accepting the license agreement, scroll down to Oracle WebLogic Server 10.3.6. Do NOT install 12c. You will see a plus box next to “Oracle WebLogic Server 10.3.6”. Click the plus box next to “See all files” and more options will be available.

clip_image002[4]

5.3.1.3.              The ‘Oracle WebLogic Server 11gR1 (10.3.6) Coherence – Package Installer’ is the recommended installer of choice.

5.3.1.4.              Please download the file that corresponds to your system OS.  Note for 64-bit AIX, the “Generic” Installer will need to be downloaded.

 

clip_image004[4]

5.3.2. Forms 11.1.1.2

5.3.2.1.              Oracle Forms 11.1.1.2.0 is no longer available on OTN. It can only be downloaded from the Oracle E-Delivery page at:

https://edelivery.oracle.com

5.3.2.2.              Once there, search for the Product Pack “Oracle Fusion Middleware” on Platform “IBM AIX on POWER Systems (64-bit). Next, click on the description link for “Oracle Fusion Middleware 11g Media Pack for IBM AIX on POWER Systems (64-bit).” It will take you to a new page.

 

5.3.2.3.              Scroll down until you see the six downloads highlighted in the screenshot below. Please download the setup files that correspond to your system OS:

clip_image006[4]

5.3.3. Forms 11.1.1.7

The following steps will help guide you through Oracle’s Support website to find the Forms 11.1.1.7 Patch set. This is the only Oracle Website location where the Forms 11.1.1.7 Patch set can be downloaded.

 

5.3.3.1.              Go to support.oracle.com

5.3.3.2.              Login with your Oracle OTN Login that has your organization’s “oracle support identifier” that lets you download “Patches & Updates”

5.3.3.3.              Click on “Patches & Updates

clip_image008[4]

5.3.3.4.              In the Patch search, type in the patch number 16471668. Click the + button to the right to expand.

5.3.3.5.              For Platform, select “IBM AIX on POWER Systems (64-bit)”. Once checked, click “Search”.

clip_image010[4]

5.3.3.6.              The Patchset will appear. Click on the patch number.

clip_image012[4]

5.3.3.7.              Click “Download”.

clip_image014[4]

5.3.3.8.              Click on the links to download. The patch set is approximately 2.1 GB in file size, thus the files may take a decent amount of time to download.

clip_image016[4]

If you have any questions on the above, please contact PITSS for questions.

Log Rotation for WebLogic, Forms, and Reports 11g

1.     About Log Rotation

Log rotation is the process of generating new log files and adding a timestamp to older log files. This helps prevent a log file from growing too large. Log rotation can either be done when a log file gets to a certain size, after a certain time frame, or perhaps both (only available for the standalone reports server). Log rotation can also be configured to have old log files replaced with new log files after a certain amount of rotated log files are generated.

2.     WebLogic Servers for Forms and Reports

By default, the log rotation settings for the WebLogic servers are set to have an unlimited number of log files rotated. The logs are rotated after a log file gets to around 5000 KB.

To change the settings for log rotation, log into the WebLogic Administration Console.

1.       Go to Environment –> Servers

clip_image001[4]

2.       Click on a WebLogic server (such as WLS_FORMS)

clip_image003[4]

3.       Click “Lock & Edit” in the top-left corner

clip_image004[4]

4.       Select the Logging tab and the General subtab.

clip_image006[4]

5.       In the Rotation section, you will see the Rotation type. You can select if you want “By Size” or “By Time”.

a.       By Size – The Rotation file size parameter specifies (in KB) how big the file can get before the log file is rotated. The parameter “Rotation file size” specifies (in KB) how big a log file can get before it is rotated

b.      By Time – The Begin rotation time parameter specifies (in HH:MM of the day) when the log file is rotated. You may also specify a Rotation interval (in hours) for how often a log file is rotated

clip_image008[4]

6.       To limit the number of log files in the directory, select “Limit number of retained files” (unchecked by default).

7.       If you have selected to limit the number of retained files, you can specify in the “Files to retain” parameter how many files to retain in the file system before older log files get overwritten (7 is the default setting).

8.       Click “Save” to save changes

clip_image010[4]

9.       Repeat steps 2-8 for any other WebLogic servers you wish to configure

10.   Click “Activate Changes”

clip_image011[4]

NOTE: If the rotation type (size or time) is unchanged, but the other parameters are updated, no restarts of any WebLogic servers are required. However, if you change the rotation type from “By Size” to “By Time” or vice-versa, any affected WebLogic servers will need to be restarted.

3.     Oracle HTTP Server (OHS)

By default, the log rotation settings for OHS are size-based for up to 10 MB and to only retain 7 log files.

To update the settings, log into the Enterprise Manager for the Forms and Reports environment. Expand Web Tier and select “ohs1”. Once there, click the drop-down menu and go to Administration –> Log Configuration.

clip_image012[4]

The settings are configured in the Rotation Policy. You can either select:

·         No Rotation – No log rotation at all (OHS log files will continue to grow larger)

·         Size Based – Log rotation performed when a file size gets to the limit (Maximum Log File Size (MB))

o   Maximum Files to Retain – The maximum number of files to keep in the server before older log files are overwritten

·         Time Based – Log rotation performed starting at a specified day and time.

o   Rotation Frequency – How often the file is rotated

clip_image014[4]

To save changes, click “Apply”. NOTE: You will need to restart OHS either from Enterprise Manager or OPMN.

NOTE: If you try to access the log configuration for OHS and you get an error “Failed to invoke operation load on MBean”, please review our knowledge base article to update a parameter in admin.conf to fix this error: https://pitss.com/us/2013/10/18/unable-to-edit-ohs-configuration-files-in-enterprise-manager-for-forms-11-1-1-6-or-11gr2/

4.     Standalone Reports Server

By default, the log rotation settings for the standalone reports server is set to a “size based” log rotation policy where the maximum file size is 10 MB and all log files cannot be more than 100 MB.

Log into the Enterprise Manager for Forms and Reports. Expand Reports and select your standalone reports server name “RptSvr…”. Next, select the drop-down menu and go to Logs –> Log Configuration.

clip_image015[4]

Select the “Log Files” tab and you will see three handlers:

·         rwengine_trace_handler – Logs for the reports server engine(s)

·         rwserver_trace_handler – Logs for the standalone reports server itself

·         zrclient_trace_handler – Logs for the network connectivity for reports

To view the rotation policy, select a handler and select “Edit Configuration”.

clip_image017[4]

In the window that appears, you will see the rotation policy. You can either configure the rotation policy for size-based rotation, time-based rotation, or both:

·         Size Based

o   Maximum Log File Size (MB) – How large a single log file can get before rotating the log

o   Maximum Size of All Log Files (MB) – How large all of the log files total can get before old log files are overwritten

·         Time Based

o   Start Time – What day and time to start rotating logs

o   Frequency – How often to rotate log files (in minutes)

clip_image018[4]

To make any changes, click “OK”. Back in the main window, make any changes to the other handlers if needed and click “Apply” to activate the changes. NOTE: You will need to restart the standalone reports server either with Enterprise Manager or OPMN to deploy the changes.

To protect end-users from the latest security threats, Oracle has improved security in Java. Starting with Java Runtime 7 Update 25, you may have noticed the following warnings in the Java Console for jar files such as frmall.jar or any custom-made jar files:

  • Missing Permissions manifest attribute for: http://server.domain:port/forms/java/name_of_jar.jar
  • Missing Codebase manifest attribute for: http://server.domain:port/forms/java/name_of_jar.jar

image

At this time (with using the latest JRE available), these warnings will not cause any problems running any Oracle Forms application. These warnings appear due to how the Forms application jar files are set up. By default, the jar files deployed by every Oracle Forms application such as frmall.jar will present these warnings.

How to Remove the warnings for the Oracle Forms jar files such as frmall.jar, etc.

Oracle Patch 16837591 is able to correct this problem as it will apply the necessary updates to the Oracle Forms jar files supplied by Oracle to prevent this warning from appearing. This patch can be downloaded from My Oracle Support. The patch is available for any Oracle-supported operating system.

Once the patch is downloaded and extracted, you may install it by completing these steps:

  1. Shut down all WebLogic servers and instances running in the Forms domain.
  2. Open up Command Prompt (if using Windows) or an SSH client (if using Unix) and change the directory to the directory where you extracted the patch.
  3. cd 16837591
  4. Set the ORACLE_HOME and PATH environment variables similar to how it is done below (NOTE: The actual values of ORACLE_HOME and PATH may differ depending on how your environment is set up):
    1. Windows
      1. set ORACLE_HOME=C:\Oracle\Middleware\Oracle_FRHome1
      2. set PATH=%PATH%;C:\Oracle\Middleware\oracle_common\OPatch
    2. Unix
      1. export ORACLE_HOME=/oracle/middleware/Oracle_FRHome1
      2. export PATH=$PATH:/oracle/middleware/oracle_common/OPatch
      3. image
  5. Run: opatch version (to make sure you are using an OPatch version level that is supported by the README file which comes with the patch).
    1. image
  6. Run: opatch apply
    1. image
  7. When it asks if the system is ready for patching, type: y
    1. image
  8. Once complete, you may start up the WebLogic servers and OPMN instances in the Oracle home.

              image

After completing the steps above, the warnings should no longer appear for any of the Oracle-supplied jar files:

image

NOTE: All end-users will be re-presented with this warning. As the frmall.jar file is from Oracle, you may run this and click the option to trust the publisher.

image

NOTE (Modified October 24, 2013): We have also created a knowledge base article specifying how you may update custom jar files with these parameters: https://pitss.com/us/2013/10/24/how-to-modify-custom-jar-files-with-permissions-and-codebase-attributes/

NOTE: Be sure to review the README file included with an Oracle patch before applying it. PITSS will not be held responsible for anything that happens when running any Oracle patch. Also, never make any changes or updates to any Oracle-supplied jar files (jar files which start with “frm”) without consent by Oracle (outside of this patch). Failure to do so may require a reinstallation of Oracle Forms and Reports.

NOTE: This Oracle patch is only supported with Forms 11.1.1.6.0, 11.1.1.7.0, 11.1.2.0.0, and 11.1.2.1.0. If you are using an older Forms version, it is recommended to upgrade to one of these four versions before applying this patch.

Source: Oracle Support note 1563023.1.

There is a bug in Forms/Reports 11.1.2.1.0 where reports generated into PDFs are not displayed correctly in Windows, AIX, and Solaris environments. According to Oracle Support note 1522543.1, an Oracle Patch 16046595 will need to be applied to the Forms/Reports environment.

How to Apply the Patch:

  1. Download Patch 16046595 from My Oracle Support
  2. Extract the patch into your directory. As a reference, let’s call the extracted location PATCH_TOP.
  3. Shut down all WebLogic servers and instances (OPMN).
  4. Set the following environment variables (NOTE: MW_HOME is your Oracle Middleware home):
    1. Windows: set PATH=%PATH%;%MW_HOME%\oracle_common\OPatch
    2. Windows: set ORACLE_HOME=%MW_HOME%\Oracle_FRHome1
    3. Unix: export PATH=$PATH:$MW_HOME/oracle_common/OPatch
    4. Unix: export ORACLE_HOME=$MW_HOME/Oracle_FRHome1
  5. Go to the PATCH_TOP/16046595 directory (PATCH_TOP\16046595 in Windows)
  6. Run: opatch apply
  7. Type ‘y’ and press Enter when it asks if the system is ready for patching.
  8. When the patch is finished, start up the WebLogic servers and OPMN.

PDF reports should display correct after applying the steps above.

NOTE: Please review the README file before applying any Oracle patch!

Source: Oracle Support note 1522543.1

There is a bug in Forms and Reports 11.1.2.1.0 and 11.1.2.2.0 (11gR2) where no reports can be run directly from the URL when using the standalone reports server. The bug occurs when no userid is specified in the URL.

Reproducing the Error:

1. Run a report from URL using the standalone reports server (Example: http://server.domain:9002/reports/rwservlet?server=name_of_standalone_reports_server&report=name_of_report&desformat=pdf&destype=cache

image

2. After logging in with the database credentials, the REP-51002 error (REP-51002: Bind to Reports Server name_of_standalone_reports_server failed) appears:

image

 

Solution:

IMPORTANT: Before applying any Oracle patches, it is recommended to review the README file which comes with the Oracle patch as well as to make a backup of your Middleware environment.

UPDATE REGARDING REPORTS VERSION 11.1.2.2.0 (3/10/14): This bug also occurs in Reports 11.1.2.2.0. The below fix is only for Reports 11.1.2.1.0. There is currently no patch available for version 11.1.2.2.0 as the patchset below fails when trying to apply in Reports 11.1.2.2.0.

  1. Download Patch 16426793 from My Oracle Support.
  2. Extract the zip file in the machine where the problem is occurring.
  3. Shutdown all WebLogic servers and instances in the affected domain.
  4. Open up Command Prompt as an administrator (or open a terminal session if using Linux/Unix)
  5. Set the following environment variables:
    1. Windows:
      1. set ORACLE_HOME=C:\Oracle\Middleware\as_1 (can also be Oracle_FRHome1 or something equivalent)
      2. set PATH=%PATH%;C:\Oracle\Middleware\oracle_common\OPatch
    2. Linux/Unix:
      1. export ORACLE_HOME=$MW_HOME/as_1 (can also be Oracle_FRHome1 or something equivalent) (Replace $MW_HOME with the path to your Middleware home)
      2. export PATH=$PATH:$MW_HOME/oracle_common/OPatch
  6. Go to the directory where you extracted the zip file and go into the 16426793 in Command Prompt or your terminal window.
  7. Run: opatch apply
  8. Press ‘y’ when it asks if the system is ready for patching.
  9. When complete, start up your WebLogic servers and instances.

After completing the steps above, the report should run without a problem after logging into the login screen shown in step 1 in the “Reproducing the Error” section using the same URL.

Source: Oracle Support Note 1454773.1

Oracle Database 11gR2 Setup Prerequisites for IBM AIX on POWER Systems

1.     Minimum System Requirements

1.1.    Oracle Supported DB Platforms:

1.1.1. Version 5.3 UL 9+

1.1.2. Version 6.1 UL2+

1.1.3. Version 7.1 UL0+

1.2.    *RAM: 2 GB+ (8 GB+ for production environments)

1.3.    Virtual Memory: 4 GB+ (16 GB+ for production environments)

1.4.    HDD Partitioning:

*Software Mount: One file system mount with at least 10 GB of free space to store the software and temporary file storage for servers. This value could be significantly higher (hundreds of GB if not TB) depending on the size of the data.

TEMPFS Space: 4GB+ (Minimum: 1GB+)

*SWAP: 2-16 GB (equal to amount of RAM if between 2-16 GB RAM; 16 GB if more than 16 GB of RAM)

1.5.    OS User Access Requirements:

1.5.1. OS User will need to own the software mount.

1.5.2. Root user access must be accessible for the installation.

*RAM and File System Mount Specifications: For production systems, please consult PITSS or Oracle on sizing recommendations. The amount of RAM, HDD Space for SWAP and Software Mounts will vary depending on end-user usage and application characteristics such as the expected size of the data tablespaces you plan to use.

2.     Other Unix OS Requirements

2.1.    Open File Limits:

“soft nproc” should be at least 2047
“hard nproc” should be at least 16384

“soft nofile” should be at least 1024
“hard nofile” should be 65536

“soft stack” should be at least 10240

3.     Required AIX Packages

3.1.    Below is a list of packages/libraries that need to be installed prior to installing Oracle Database 11gR2. Please note the difference between the release types.

 

AIX 5.3 UL9+

AIX 6.1 UL2+

AIX 7.1 UL0+

bos.adt.base

bos.adt.base

bos.adt.base

bos.adt.lib

bos.adt.lib

bos.adt.lib

bos.adt.libm

bos.adt.libm

bos.adt.libm

bos.perf.libperfstat 5.3.9.0+

bos.perf.libperfstat 6.1.2.1+

bos.perf.libperfstat

bos.perf.perfstat

bos.perf.perfstat

bos.perf.perfstat

bos.perf.proctools

bos.perf.proctools

bos.perf.proctools

xlC.aix50.rte.10.1.0.0+

xlC.aix61.rte.10.1.0.0+

xlC.aix61.rte.10.1.0.0+

gpfs.base 3.2.1.8+

xlC.rte.10.1.0.0+

xlC.rte.10.1.0.0+

 

gpfs.base 3.2.1.8+

gpfs.base 3.3.0.11+

 

 

 

 

 

 

 

 

 

 

 

 


For more information from Oracle on required package information please go to: http://docs.oracle.com/cd/E11882_01/install.112/e24335/toc.htm#CHDFFBIF

 

4.     Software Requirements

4.1.    Oracle Database 11gR2 (11.2.0.3)

4.1.1. Go to support.oracle.com

4.1.2. Login with your Oracle OTN Login that has your organization’s “oracle support identifier” that lets you download “Patches & Updates”

4.1.3. Click on “Patches & Updates

clip_image002

4.1.4. In the Patch Search window, type in 10404530 for the patch number. Select the operating system and click Search.

clip_image004

 

4.1.5. In the Patch Search Results, only one patch should appear. Click on the patch number.

clip_image006

4.1.6. Click on Download.

clip_image008

 

After clicking Download, you should be able to select the zip file and download to your machine. Only download the first two zip packages.

 

clip_image010

 

 

If you have any questions on the above, please contact PITSS.