How to install and configure Oracle Forms & Reports 12c fully unattended - Part 2

Important update! (June 14th, 2017):  Please asure that all variables in setLocalEnv.sh are filled in correctly and adapted to Your environment. This especially for all variables regarding the Database Connection, like DB_PWD, DB_HOST, DB_PORT ... If not set correctly, the tool is not able to create the rcu repository which results in an error during runtime:  Problem invoking WLST...

Read More

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

Read More

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

Read 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 testing purposes. Command used...

Read 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: With 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 One possible workaround (not recommended!):...

Read More

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

When using oakcli 12.1.2.x, a 'create database' command will create the database on ACFS ... except for databases of versions 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 coming post will describe the 'how-to' and the necessary steps to do so. p.p1 {margin: 0.0px 0.0px 0.0px 0.0px;...

Read More

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

Read 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) Rob...

Read More