Last week in Stream Processing & Analytics – 22.5.2017

This is the 67th edition of my blog series blog series around Stream Processing and Analytics!

As every week I was also updating the following two lists with the presentations/videos of the current week:

As usual, find below the new blog articles, presentations, videos and software releases from last week:

News and Blog Posts

General

Custom functions to extend ICS transformations – ICS Definitive Guide #4

In the second release of 2017 (17.2.5) ICS will introduce the capability of importing and using custom functions. These functions are created using JavaScript and can be used in transformations, expressions and as a action in Orchestrations. In this definitive guide we will go through all ins and outs of this new capability.  Custom functions – a new pillar of […]

The post Custom functions to extend ICS transformations – ICS Definitive Guide #4 appeared first (more...)

A Sneak Peek at Oracle’s Chatbot Cloud Service and 5 Key Factors Necessary for Bot ROI

Intro

In early May, I flew out to Oracle HQ in San Francisco for an early look at their yet-to-be released Oracle Intelligent Bots Service.  The training left me ecstatic that the technology to quickly build great chatbots is finally here. However, the question remains, can chatbots provide real value for your business?

What is a chatbot?

A chatbot is a program that simulates a conversation partner over a messaging app. It can integrate with (more...)

Presentation Applying “web scale” patterns in the bol.com back office

Presentation Applying “web scale” patterns in the bol.com back office

Codemotion web scale pattern presentationThis week at Codemotion I gave a presentation on web scale patterns and how we apply them in the bol.com back office services. Codemotion is the biggest tech conference in Italy and one of the most important in Europe.

The presentation shows how we go from business goals to software patterns. The following patterns were covered: CQRS, event sourcing, polyglot persistence (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 had to recreate the webutil repository (create_webutil_db.sql) and to recompile webutil.pll. After that, the application runs fine again ...

Last week in Stream Processing & Analytics – 17.5.2017

This is the 66th edition of my blog series blog series around Stream Processing and Analytics!

As every week I was also updating the following two lists with the presentations/videos of the current week:

As usual, find below the new blog articles, presentations, videos and software releases from last week:

News and Blog Posts

General

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

Unboxing the Future of Fishbowl’s On-premise Enterprise Search Offering: Mindbreeze Inspire

Back on April 3rd, Fishbowl announced that we had formed a partner relationship with Mindbreeze to bring their industry leading enterprise search solutions to Fishbowl customers. We will offer their Mindbreeze InSpire search appliance to customers looking for an on-premise solution to search internal file shares, databases, document management systems and other enterprise repositories.

Since that announcement, we have been busy learning more about Mindbreeze InSpire, including sending some members of our development team to their (more...)

How to Configure Microsoft IIS with Oracle WebCenter

I was setting up a Oracle WebCenter 12c Suite in a local development environment utilizing a Windows Server 2012 R2 Operating System with a Microsoft SQL Server. Instead of using a OHS (Oracle HTTP Server), I wanted to try using Microsoft IIS (Internet Information Services) to handle the forwarding of sub-sites to the specified ports.  Since the Oracle applications run specified ports (ex. 16200 for Content Server), when a user requests the domain on the (more...)

Oracle Forms 12c: frmconfighelper – enable_ohs

Yesterday I was blogging about how to create new Forms Managed Servers and how to deploy a new formsapp into them with the frmconfighelper tool (http://dirknachbar.blogspot.com/2017/05/oracle-forms-122120-multiple-managed.html).

Today I was testing the function enable_ohs from the frmconfighelper tool, which is mainly dedicated to generate a forms.conf file in your Oracle HTTP Server which contains the directives for your Forms Environment.

oracle@server> cd $ORACLE_HOME/forms/provision
oracle@server> ./frmconfighelper.sh
using log file /home/oracle/frmconfighelper/logs/frmconfighelper_2017_05_15_20_49_31. (more...)

Connecting directly to DBaaS – ICS Definitive Tip #7

Enriching an integration from data in a database or DBaaS (Database as a Service) is not an unusual requirement. Many integration use cases today need to access a database that is on-premises. The means to connect to the database is fairly obvious – the connection agent. Our book goes into a lot more detail as to […]

The post Connecting directly to DBaaS – ICS Definitive Tip #7 appeared first on Implementing Oracle Integration Cloud Service.

Oracle Forms 12.2.1.2.0 – Multiple Managed Servers via frmconfighelper

In October 2016 I was blogging how to create multiple Oracle Forms 12c Multiple Managed Servers.
In case you are already on the latest Oracle Forms 12.2.1.2.0 Release, you can now create in a really comfortable way multiple Oracle Forms Managed Servers and deploy the necessary formsapp into your newly created Managed Server.

Since Oracle Forms 12.2.1 there is a small not really well know tool added to Oracle (more...)

Presenting at Codemotion next week on web scale patterns

Presenting at Codemotion next week on web scale patterns

Next week I’ll be presenting in Amsterdam at Codemotion on web scale patterns in bol.com back office services. Codemotion is the biggest tech conference in Italy and one of the most important in Europe, with a network of more than 30k developers.

The title of my presentation is: “Applying “web scale” patterns in the bol.com back office”. In the session, we show you how (more...)

Cedar’s Oracle Talent Acquisition Cloud Event / Team

Earlier this week Cedar held its Oracle Talent Acquisition Cloud event in Oracle’s London City office. We have a really strong team of UK-based Talent Acquisition specialists within our ranks:

Taleo Team 2 (plain background)

Jo, Prachi, Marc and Mel are all experts in the various aspects of Oracle Talent Aquisition Cloud – Taleo Recruit, Sourcing and Onboarding – and Cedar has multiple implementations under our belt covering all of the above products, so we were able to put on (more...)

Last week in Stream Processing & Analytics – 10.5.2017

This is the 65th edition of my blog series blog series around Stream Processing and Analytics!

As every week I was also updating the following two lists with the presentations/videos of the current week:

As usual, find below the new blog articles, presentations, videos and software releases from last week:

News and Blog Posts

General

Fully unintended CPU Patch Download for Oracle WebLogic Server

In case you are owning different versions of Oracle WebLogic Server, e.g. 10.3.6, 12.1.3, 12.2.1.2 and so on and you are regularly applying the Oracle Critical Patch Updates, you will have to download various different Patches.

Mainly you will have to click through different Websites and My Oracle Support Notes until you can download the required patches.

For this purpose I have developed a handy script, with (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...)