Category Archives: Oracle

SCA Diagrammer

SCAWhile doing some research on the web I came across a Service Component Architecture Diagram Generator. The script generates diagrams for applications based on the Service Component Architecture (SCA) model. This can be a great aid to understand the relations between components in large BPEL or SOA applications.

Download the tool here. The readme is over here. The script runs on Linux/Unix and has primarily been tested with Oracle Fusion Middleware 11g applications but should work with other BPEL or SOA frameworks.

SOA and Governance seminar

On December 13th Whitehorses will host a seminar on SOA and Governance. During this seminar we will show the value of a proper architecture and governance for your organization. In the presentation you will get clear guidelines and steps on a pragmatic approach for implementing a manageable SOA solution.

Some of the topics:

  • What is SOA Governance and Why do we need it?
  • SOA reference architecture – The importance of solid standardization.
  • Service life-cycle governance – Design and build the right services and the proper way to reuse them.
  • Service repository – With examples of repositories based on Oracle Enterprise Repository (OER) and a wiki.

rsvp.

Oracle BPM Suite 11g Handbook and free resources

BPM Suite 11gRecently McGraw Hill published the Oracle Business Process Management Suite 11g Handbook. It is available on their site and at Amazon.com.

Here is the table of contents with the links to the free chapters:

    Part I: Introduction

  1. BPM – Background
  2. Standards in BPM
  3. BPM Suite 11g – Overview
  4. Part II: Mastering Oracle BPM 11g

  5. Quick Learners Guide to Oracle BPM 11g
  6. Business Process Modeling and Implementation using BPMN 2.0
  7. Mastering Business Rules
  8. Advanced Human Tasks
  9. Developing Rich User Interfaces for BPM with ADF
  10. Part III: Essentials of Oracle BPM Methodology

  11. Planning a BPM Adoption
  12. Strategic Analysis, Process Selection and Design
  13. Technical Design and Project Delivery Strategies

Oracle releases NoSQL Database, Enterprise Edition 1.1.100

While the NoSQL Database Community Edition still waits for final license approval, Oracle has released it’s NoSQL Database, Enterprise Edition 1.1.100. The download is available on OTN.

The Oracle NoSQL Database is a distributed key-value database. It is designed to provide highly reliable, scalable and available data storage across a configurable set of systems that function as storage nodes.

The documentation page is still rather empty. However Technical Overview and a Data Sheet are already available.

Oracle NoSQL is a key offering in Oracle’s portfolio of Big Data products. The product is based on the Java version of Berkeley DB, an open source database used in embedded systems.

Update

Whitehorses publishes Oracle Forms Survey results

WhitehorsesWhitehorses published the results of their Oracle Forms Survey on their blog. I’ll share three remarkable results. Please read the whole post on their blog:

  • Over 30% is still running Client – Server (Forms 4.5 or 6i).
  • Over 50% doesn’t consider upgrading their unsupported version.
  • When replacing Oracle Forms APEX is the most considered alternative.

The results are mostly in line with the findings in Germany (on which the survey was based).

Memory issues after installing OER

OER assetsAfter installing Oracle Enterprise Repository (OER) we experience some memory issues. Besides the messages in the log files, we also couldn’t use the console and em as we did before (when we were just running SOA Suite). It turned out the installation of OER in the same Weblogic domain resulted in some unexpected things.

The WebLogic Server and SOA Suite are started using the startWebLogic script (for windows .cmd and on Linux/Unix .sh). This script uses the setDomainEnv script to set the environment variable for the domain. The setDomainEnv script in turn calls the setSOADomainEnv that actually sets the USER_MEM_ARGS. That in the end are used in the startWebLogic script.

After the installation of OER the setDomainEnv not only calls the setSOADomainEnv. It also calls a script that sets the USER_MEM_ARGS for the oer_server in the domain. Apparently the memory required for OER is less than needed for the SOA Suite. Since the script for OER is executed last, memory setting remain low. As shown in the smippet taken from the setDomainEnv.cmd:

call "%WL_HOME%\common\bin\commEnv.cmd"
call "%DOMAIN_HOME%\bin\setSOADomainEnv.cmd"
call "%DOMAIN_HOME%\bin\setOERDomainEnv.cmd"

To solve the memory issue when starting the WebLogic Server using the startWebLogic script we alter the sequence so the setOERDomainEnv.cmd goes before the setSOADomainEnv.cmd.

If the installer put a second call to setSOADomainEnv.cmd in the setDomainEnv.cmd. That doesn’t work because the setSOADomainEnv.cmd contains the following check:

REM Skip running this script again if it was run once
if "%XENGINE_DIR%" == "" goto set_env
echo *********************************************************
echo ** SOA specific environment is already set. Skipping ...
goto end_set_env

.

Installing Oracle Enterprise Repository

This blog post will show you how to install Oracle Enterprise Repository, or OER in short. The assumptions is that you have a running WebLogic Server (with SOA Suite on top of it) and a database.

Prepare – database

The most important part of the preparation for the installation of Oracle Enterprise Repository is the creation of tablespaces and the user that will hold the database objects.
Create the required tablespaces
You can change the names of the tablespaces and alter the path and names of the data files according to your needs. The example is based on an installation on the Windows OS. If your on Linux/Unix you probably know what to do to make it work on your platform…

CREATE TABLESPACE OER_DATA
    DATAFILE 'D:\oracle\oraclexe\oradata\XE\oer_data.dbf' SIZE 300M
 AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
    EXTENT MANAGEMENT LOCAL AUTOALLOCATE
    LOGGING
    ONLINE
    SEGMENT SPACE MANAGEMENT AUTO;
 
CREATE TABLESPACE OER_LOB
    DATAFILE 'D:\oracle\oraclexe\oradata\XE\oer_lob.dbf' SIZE 300M
 AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
    EXTENT MANAGEMENT LOCAL AUTOALLOCATE
    LOGGING
    ONLINE
    SEGMENT SPACE MANAGEMENT AUTO;
 
CREATE TABLESPACE OER_INDEX
    DATAFILE 'D:\oracle\oraclexe\oradata\XE\oer_index.dbf' SIZE 300M
 AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
    EXTENT MANAGEMENT LOCAL AUTOALLOCATE
    LOGGING
    ONLINE
    SEGMENT SPACE MANAGEMENT AUTO;

Create the user
Change the user name and password (both OER in this case) to cater your needs.

CREATE USER OER IDENTIFIED BY OER
DEFAULT TABLESPACE OER_DATA
    TEMPORARY TABLESPACE TEMP;
 
GRANT CREATE MATERIALIZED VIEW TO OER;
GRANT CREATE SEQUENCE TO OER;
GRANT CREATE SESSION TO OER;
GRANT CREATE SYNONYM TO OER;
GRANT CREATE TABLE TO OER;
GRANT CREATE TRIGGER TO OER;
GRANT CREATE VIEW TO OER;
GRANT UNLIMITED TABLESPACE TO OER;

Install OER

Us the follwing command from a dos prompt to start the OER installation. By default it will start in graphical mode. You can use the -mode option to start it in console or silent mode.

java -jar OER111150_generic.jar -log=C:\installSOA\logs\OER_install.log

Run WebLogic Server Domain Configuration Wizard

To run the Domain Configuration Wizard on Windows you can click: Start > Programs > Oracle Products > Tools > Configuration Wizard. On any platform you can run the config script in the /common/bin/config.cmd. For example:

> cd oracle\Middleware\wlserver_10.3\common\bin
> config.cmd

Post Install actions

To use all options in the Repository you need to install Java Web Start. To check whether Java Web Start is installed correctly use the test Java link.

In case the JNLP stuff (needed for java Web Start) doesn’t work. This Firefox JNLP fix might help you (via Andreas).

Installing Windows8 in VirtualBox

Wanted to do a quick blog on installing Windows8 in VirtualBox. However work and stuff came in the way and of course now there are multiple sites describing it now like this quite short on Oracle blogs, Life Hacker Guide and How-To Geek. Since especially the first ones lack some screenshots, I’ll share mine:

More info on installing an OS like Ubuntu 11.04 on VirtualBox can give you some background on the general process of creating a new VirtualBox image.

Virtual PC (0x80004005) doesn’t tolerate VMWare or VirtualBox

Since I had to test some webpages with IE6 (please don’t ask), I wanted to use Windows XP Mode on my Windows 7 laptop (actually run it in VMWare as described here). Microsoft provides virtual machines (vhd files) to run in Microsoft Virtual PC.

KB958559 fails with 0x80004005

Rolling back the update

Windows Virtual PC for Windows 7 is released as an update for Windows 7, and has the Knowledge Base Article ID of KB958559. So I tried to install it. That went actually pretty well until I had to reboot my laptop. At about 98% of the update process during the reboot it gave an error and rolled back the update. The log showed:

Installation failure: Windows failed to install the following update with error 0x80004005: Update for Windows KB958559

Digging into the support forums and blog posts on the subject, the most common working solution I found to the problem was to uninstall VMWare and/or VirtualBox. After the uninstall you can install Virtual PC without the error and after that reinstall VMWare and/or VirtualBox.