Oracle Fusion Middleware & Application Server

Thursday, January 27, 2011

More Fusion Middleware Components available

I just discover that on the Oracle Edelivery Website are more Oracle Fusion Middleware Components available for download, but unfortunally right now only for 32-bit Operating Systems Windows and Linux.

You will find there:
  • Oracle Fusion Middleware Companion 11g (
  • Oracle Portal, Forms, Reports and Discoverer 11g Patch Set 3 (
  • Oracle Identity Management 11g Patch Set 3 (

I hope that in the next days the 64-bit Operating System Releases will follow :-)
In the meantime everybody who got an My Oracle Support (formerly Oracle Metalink) account can download the Patches for Oracle Fusion Middleware for 64-bit Operating Systems (Linux x86-64, Windows 64-bit, Oracle Solaris SPRAC, AIX) from there.

In the meantime: happy downloading and testing :-)

Update Note: I just saw that now also the Oracle Fusion Middleware for Linux x86-64, Windows 64bit and Oracle Solaris SPARC 64bit is available on

Tuesday, January 25, 2011

Oracle WebCenter Suite available

Since today the new release of the Oracle WebCenter Suite (11g Release 1 PS3) is available in the Oracle Technology Network under the following link:

There are several new features, mainly I am interested to see the integration with the latest Oracle Universal Content Management.

Moreover Oracle is providing on the 2nd February 2011 at 10 a.m. PT (19:00 CET) a Webcast for the new launch of the Oracle WebCenter 11g R1 PS3. Registration can found done under following link: Register here.

There is also a good White Paper New Features available under following link: Click here
Also the new designed OTN download page is cool :-) Now you can see directly what additional software you will need including direct download link.

Deferred Segment Creation under Oracle 11.2 and Sequences

An ex-colleague (Christian Zuberb├╝hler) of me pointed me to a strange behavior under Oracle 11.2 with sequences.
So I had a quick look at it, following show case:

create sequence seq_t1_id start with 1;
create table t1 (id number, col1 varchar2(20));
insert into t1 values (seq_t1_id.nextval, 'Test Value expected 1');
select * from t1;
ID          COL1
---------- --------------------
2           Test Value expected 1

Nice :-) Normally everybody is expecting under the column ID the value 1.

As my test table is created under Oracle 11.2 the default setting for the new feature deferred_segment_creation is true. Therefor the insert command is facing an ORA-14403 internally as the affected table doesn't have any segment. A new segment will be created for my test table and the insert command will be re-run, so the inserted value from the used sequence will be one value higher.
The internally faced ORA-14403 can easily proven with the event 14403. Just set the event 14403 before you execute the insert statement:

create sequence seq_t1_id start with 1;
create table t1 (id number, col1 varchar2(20));
ALTER SESSION SET EVENTS '14403 trace name errorstack level 3'; 
insert into t1 values (seq_t1_id.nextval, 'Test Value expected 1');

In the corresponding alertlog you will find then something similar like this:

Tue Jan 25 16:54:19 2011
Errors in file e:\oracle\diag\rdbms\xxx\xxx\trace\xxx_ora_6072.trc:
ORA-14403: cursor invalidation detected after getting DML partition lock
Tue Jan 25 16:54:26 2011
Trace dumping is performing id=[cdmp_20110125165426]

According to Oracle this is not a bug, its an expected behavior from Oracle 11.2 going. The recommended solution from Oracle is "deferred_segment_creation=FALSE" . . .

Wednesday, January 19, 2011

I am now Oracle ACE

Last night I receive an email from Oracle, that I was nominated by Dmitri Khanine (, who is also an Oracle ACE, for the Oracle ACE Award and the I receive the Award :-)

So, I am now Oracle ACE, cool ;-)

More informations about the Oracle ACE Award can be found under

Dmitri, many thanks for the nomination ;-)

Saturday, January 15, 2011

Oracle Jdeveloper and Oracle ADF 11g Release 1 PatchSet 3 is available

Since yesterday (Friday, 14.01.2011) the Patch Set 3 ( is available for download in the Oracle TechNet (OTN) under the link:

The complete list of new features and bugfixes can be found under the link:

So happy downloading ;-)