Forms Application shows a ‘FRM-40735: WHEN-CUSTOM-ITEM-EVENT trigger raised unhandled exception ORA-06508’ after upgrade to 11.1.2.2.0

Situation:

After an upgrade from 11.1.2.1.0 to 11.1.2.2.0 and a patch apply of patch 19933795 (see post Forms Application does not run anymore after java upgrade to 1.8_131 on client), the application shows an 'FRM-40735: WHEN-CUSTOM-ITEM-EVENT trigger raised unhandled exception ORA-06508':



Solution:

I had to recreate the webutil repository (create_webutil_db.sql) and to recompile webutil.pll. After that, the application runs fine again ...

Coming soon: How to create Forms / Reports Domains by using scripts (Non-GUI)

With Forms Reports 12c, Oracle does not support anymore the creation of Forms / Reports domains using a 'silent' mechanism. That isn't a problem when creating only a few domains - but when Your intention is standardization or You have to create several domains, a CLI based 'Forms Domain Config' is a must.

Based on information, I got from Jan-Peter Timmermann (Jan-Peter's Weblog), I developed a scriptset to create a complete Forms Reports (more...)

ODA X4 – Migrating a database from ASM to ACFS

As promised ... Here's the post about migrating a database from ASM to ACFS on an ODA 4 - probably, this will work for newer ODA Servers as well

Given:

- Oracle Database Appliance machine, X4-<something>
- Software Release 12.1.2.7.0
- Prepared DB Software: 11.2.0.3, 11.2.0.4, 12.1.0.2

Story behind:

Task was, to create a new database of release 11.2.0.3 for (more...)

Forms Application does not run anymore after java upgrade to 1.8_131 on client

If Your Forms application cannot be started after a java upgrade to 1.8_131, please check this Oracle Community Thread: https://community.oracle.com/thread/4037666

In short:
Reason is: Java 8u131, MD5-hashes are no longer accepted in certificates
If using Forms 12c, no action has to be taken - if using Forms 11 you'll have to apply patch 19933795

Quick fix (not recommended!): Adapt the appropriate java.security file line
jdk.jar.disabledAlgorithms=MD2, MD5, RSA keySize < 1024
to
jdk.jar.disabledAlgorithms=MD2, RSA keySize < 1024


Coming up next: ODA X4 – migrating a database from ASM to ACFS

When using oakcli 12.1.2.7.0, a 'create database' command will create the database on ACFS ... except for databases of version lower than 11.2.0.4. Those databases are created on ASM. So, instead of dropping and recreating a database, You could 'simply' migrate from ASM to ACFS. The comming post will describe the 'how-to' and the necessary steps to do so.



Starting and Stopping Domains Using WLST – The Easy Way

Yes - another post 'how to start/stop a domain using WLST' ... But, with this scripts You only have to provide information about the nodemanager and the AdminServer. All other information used to start the domain is collected dynamically during runtime.

The tool will start or stop the nodemanager (domain- or host-based), the AdminServer and each ManagedServer. Before starting or stopping a component a check is done if the operation in question is possible or not. (more...)

First Blog Post …

Yes - yet another blog related to Oracle Database and Fusion Middleware stuff ...

Nevertheless, possibly, You'll find useful information to ease Your daily business, how to's to solve problems or to workaround 'unwanted features'.

Feel free to comment my blog posts or to present own solutions (for example by link in Your own blog posts)

Robert