Oracle Fusion Middleware & Application Server

Friday, December 10, 2010

Last Day in my Consulting Life

Today will be my last day in my consulting life :-) After several years as consultant, time is coming to settle down.
But at first XMas vacation will be starting today and from 1st January 2011 I will have a new position at Philip Morris International.
But I will still work in the Oracle Section and I will still continue to blog here about my favorite stuff Oracle Fusion Middleware :-)
So, stay tune for the next post . . .

Wednesday, December 1, 2010

WebLogic Server Logfiles

I am actually giving an Oracle University Course "Oracle WebLogic Server 11g: Administration Essentials". Today we reach the chapter Logfiles and an interesting question came up from one student:

Is it possible to define one logfile for multiple Managed Server and the global Domain Logfile? So that I don't have to go through multiple logfiles for investigation of problems or errors

So, we just tested it live as I never came to this idea to merge the Managed Server Logfiles into the Domain Logfile.
I just copy the fullpath of the Domain Logfile into the logfile defintion of one Managed Server of the Domain, saved this changes and did a restart of the Managed Server and ... Its working :-) All Managed Server related log entries were captured in the Domain Logfile :-)

Even as a teacher you can learn from time to time something during holding a course :-)

Wednesday, November 24, 2010

Oracle 11g Release 2 Interactive Quick Reference

Today I discover the new available Oracle 11g Release 2 Interactive Quick Reference. The Quick Reference can be downloaded from following link
The download contains 2 files, one Flash Player executable and a PDF.
The Flash Player executable is really cool :-) nice work from Oracle. Its contains all DBA-Views, all Oracle Processes and an Oracle Architecture Diagram. The PDF contains just teh Oracle Architecture Diagram.

I hope they will also provide a version of the Interactive Quick Reference for Non-Windows users :-)

Friday, September 17, 2010

Creating a Windows Service for Oracle WebLogic Server

In case you are using the Oracle WebLogic Server under Windows, you may want to run your WebLogic Server as a Windows Service instead of all time running the provided cmd files to startup your WebLogic Server.
For this Oracle provides us a small script to create a Windows Service for our WebLogic Server, the script is located in %WL_HOME%\server\bin with the name installsvc.cmd. The best way to use this script is to build up a small wrapper script with all the necessary variable declarations and a call on the installsvc.cmd:

echo off

set DOMAIN_NAME=DemoDomain
set USERDOMAIN_HOME=D:\oracle\fmw-11.1.1\user_projects\domains\DemoDomain
set SERVER_NAME=DemoAdminServer
set JAVA_HOME=D:\oracle\fmw-11.1.1\jrmc-4.0.1-1.6.0
set MEM_ARGS=-Xms256m -Xmx512m
call "D:\oracle\fmw-11.1.1\wlserver-10.3.3\server\bin\installSvc.cmd"

Just adjust the above example to your settings and run the wrapper script, this will create you a Windows Service "beas %DOMAIN_NAME%_%SERVER_NAME%", if you dont like the naming convention for the Windows Service to be created, just edit the installsvc.cmd script. Nearly at the end you will find following line:
"%WL_HOME%\server\bin\beasvc" -install -svcname:"beasvc %DOMAIN_NAME%_%SERVER_NAME%" -javahome:"%JAVA_HOME%" -execdir:"%USERDOMAIN_HOME%" -maxconnectretries:"%MAX_CONNECT_RETRIES%" -host:"%HOST%" -port:"%PORT%" -extrapath:"%EXTRAPATH%" -password:"%WLS_PW%" -cmdline:%CMDLINE%

Just adjust the option -svcname to your prefered settings.

Sunday, September 12, 2010

Oracle Universal Content Management 11g in another way

Today I discover the "Adventures of ECM 11g" from Billy Cripe (Fishbowl Solutions). That's really another cool way how to learn about Oracle Enterprise and Universal Content Management :-)

Enjoy it ...

That,s just part 1, right now you'll find 4 parts under Youtube

Wednesday, August 18, 2010

The Oracle Universal Content Management Handbook - available

Under my post in May 2010 I recommended the book "Oracle Universal Content Management Handbook" from Dmitri Khanine. Now the book is published and ready to buy or order.

Once again, if you are working with the Oracle Universal Content Management, this book might help you :-)

Details for Dmitri's book can be found under

@Dmitri: Really good work :-)

Thursday, July 15, 2010

New Book: Oracle JRockit - The Definitive Guide

A couple of weeks ago I receive a request from Packt Publishing, if I am interested in reviewing and writing a short summing up of the new book "Oracle JRockit - The definitive Guide" and here we go :-)

The book are written by Marcus Hirt and Marcus Lagergren, two developers of the original JRockit therefore they really know about what they are writing :-) and the blurb of the book dont't distend that "this book helps you gain in-depth knowledge of Java from the JVM's point of view". What they promise, you will really get :-)

The book is well structured, starting with a classical "Getting Started" chapter, steping over to Code Genereation and Memory Management and Threads & Synchronization. After that my personal favorit chapters following.
The chapter about "Benchmarking and Tuning" is pretty good, starting with different types of Benchmarking, why we need them and how to decide which Benchmarking could be the right one for you. Logically in the same chapter you will find after your benchmarks a section about tuning.
The chapter about "JRockit Mission Control" is in my opinion the best one of the book (but that's just my personal opinion) and in combination with the chapter about "The Flight Recorder" it's unbeatable :-) Here the authors show how to use this powerful tool really in a practical way, so that you gain in-depth knowledge and you learn how to use it in your day-to-day tasks.
The chapter about "The Memory Leak Detector" is also really usefull if you run in such problems.
Moreover there is an interesting chapter about the brandnew "JRockit Virtual Edition", which will be in my opinion the future of how to use and implement a JVM.

My personal conclusion about this book: It's really a must for everybody who is working with the Oracle JRockit, no matter if you are a developer or a WebLogic Server Administrator. So checkit out either in your bookstore or just go the Packt Publishing Website.

Enterprise 2.0 - How Iron Man would work - Presentation by Emiliano Pecis

Today I discover a really good presentation by Emiliano Pecis from Oracle ( about Enterprise 2.0

Friday, July 9, 2010

Oracle Web Tier Utility Configuration Error INST-07281: JRF is not set up in the specific domain

You may receiving following the error message "INST-07281: JRF is not set up in the specific domain" during the configuration of the Oracle Web Tier in order to connect your Web Tier with an existing Oracle WebLogic Server.

The problem is really simple, the necessary JRF Libaries are not by installed configured in a WebLogic Server Domain if you had used the standard template for the domain configuration.

Therefor you have to extend your WebLogic Server Domain, just startup under the WL_HOME/common/bin the script and chose the option "Extend an existing WebLogic Server Domain". Then chose in the tree your WebLogic Server Domain, after that you will reach below provided screenshot and chose under "Extend my domain automatically to suppoprt the following added products" the option "Oracle JRF -".

After the extension of your WebLogic Server Domain is finished, you have to restart your WebLogic Server Domain AdminServer in order to load the newly added Libaries.

After the restart of the AdminServer you can try again your configuration of the Oracle Web Tier and you will see, that now the configuration process will proceed.

The most practical way is, if you install your Oracle Web Tier at first with the option "Install only", after that you run the WL_HOME/common/bin/ script to add the necessary Oracle JRF components to your WebLogic Admin Server, perform a restart of your Admin Server and as last you run the script for the Oracle Web Tier in the directory WebTier_ORACLE_HOME/bin and go through the configuration steps.

Wednesday, June 23, 2010

Oracle Application Express (APEX) 4.0 available

I just saw, that Oracle Application Express (APEX) 4.0 is now available for downloads in the Oracle TechNet:

The most interesting new features in my opinion are the Websheet and the Oracle Application Express Listener. The full list of the new features can be found under:

Tuesday, June 15, 2010

Oracle Code Ninja Chronicles Episode

Sometimes Oracle knows how to produce cool promotions :-)

Call for Papers DOAG Conference 2010

The DOAG Conference 2010 (the biggest Oracle User Conference in Europe) is still looking for presentation for MySQL Stuff (for DBA's & Developers) as MySQL is now part of the great Oracle Community :-)

The DOAG Conference 2010 will take place in Nuernberg/Germany from 16th November until 18th November 2010.

Under following link you can register your presentation The Call for Papers will be closed on 30th June, so hurry up ...

Tuesday, June 8, 2010

Recommended Reading - Rework by Jason Fried and David Hansson

This post is nothing about Oracle Stuff or Technology, it's just a recommendation for a book, which might help you in your daily work :-)

It's the book "Rework by Jason Fried and David Hansson".

An excerpt of the book can be found under following link:

Enjoy the reading :-)

Friday, June 4, 2010

Did you forget your WebLogic Admin User password?

Several month ago you install your Oracle Fusion Middleware Environment, you didn't connect to the WebLogic console and now you realize, that you forget the password of the WebLogic Server Admin User "weblogic".
Here is a small How To in order to reset the Admin User "weblogic" password.

1st Step: Stop your Weblogic Server, if it's running
oracle@server>cd $MW_HOME/user_projects/domains/<your_domain>/bin
oracle@server>./ <your_server>

2nd Step: Source the necessary environment variables for your WebLogic Server
oracle@server>cd $MW_HOME/user_projects/domains/<your_domain>/bin

3rd Step: Creation of a new WebLogic Server Admin User
oracle@server>cd $MW_HOME/user_projects/domains/<your_domain>/security

# the first value after the command "java"
# is the new username
# the second value is the password for the new Admin User
# IMPORTANT !!! After the password value you must place a "." (dot) !!!!
# This command will update the DefaultAuthenticatorInit.ldift
# configuration file

oracle@server>java myadmin oracle11g .
4th Step: Delete the file DefaultAuthenticatormyrealmInit.initialized
oracle@server>cd $MW_HOME/user_projects/domains/<your_domain>/servers/AdminServer/data/ldap
oracle@server>rm DefaultAuthenticatormyrealmInit.initialized

5th Step: Startup the WebLogic Server
# Depending if you are using a file
# you must choose between the two following options
# a) Without configuration file

oracle@server>cd $MW_HOME/user_projects/domains/<your_domain>/bin
oracle@server> ./ <your_domain>

# Here you will be prompted for your WebLogic Server Admin User and his Password
# Use now your newly created Admin User

# b) With a configured configuration file
# Remove your configuration file

oracle@server>cd $MW_HOME/user_projects/domains/<your_domain>/servers/AdminServer/security

# Startup your WebLogic Server

oracle@server>cd $MW_HOME/user_projects/domains/<your_domain>/bin
oracle@server> ./

# Here you will be prompted for your WebLogic Server Admin User and his Password
# Use now your newly created Admin User

For the above mentioned two options see my Blog Post

6th Step: Login to your WebLogic Server Console with your newly created Admin User and change the password of the original WebLogic Server Admin User "weblogic"
# Navigate to "Security Realms"
# There you'll see two Admin Users: weblogic and your newly created Admin User
# Change the password of the user weblogic

7th Step (optionally): If you was using a configuration file before, you must recreate it with the new values for the Admin User and the reseted password

Additional Note (26.01.2011): Please be aware that the above described procedure is NOT working with a database security store !!! (Thanks for the input from Nazir, see comments below)

Wednesday, June 2, 2010

Last post "Review of The Oracle Universal Content Management Handbook written by Dmitri Khanine" removed

To anybody who is looking for my last post "Review of The Oracle Universal Content Management Handbook written by Dmitri Khanine", I had to remove it temporarily due to an request by the publisher of Dmitri Khanine upcoming book "The Oracle Universal Content Management Handbook".

As soon as the book is published, I will change my book review post to be active again.

Personally I don't understand why the publisher don't want postive feedback about the upcoming book before it's published, in my opinion such reviews are a free advertisment :-)

Saturday, May 29, 2010

Review of The Oracle Universal Content Management Handbook written by Dmitri Khanine

Some days ago, I receive a message through LinkedIn from Dmitri Khanine (, if he could mention my blog in his upcoming Book "The Oracle Universal Content Management Handbook".
My answer was short: "Of course yes :-)" and I offer Dmitri as soon as his book is out, I will buy a copy and take a look at it and write a review.
Dmitri's reply was also quite short: "He just provided my a draft (nearly final version) of his book :-)"
In the last days I got the chance to read his book and my summing up is: BUY IT !!

Dmitri's book is mainly for beginners with the Oracle Universal Content Management ( He guides from the basic concepts up to the installation, configuration, usage, integration and security with Oracle UCM.
What I personally like, when I am reading a book title like "Handbook" I am excepting, that inside the book, I will be guided through all necessary installation, configuration or development steps. Dmitri's book is in my opinion really a "Handbook" :-) For every important step you will find a screenshot with explaination and the steps between screenshots are in detail explained. So the reader is nowhere lost and can follow anytime. This book will really help you for a successfull implementation of Oracle UCM.

Even administrators or developers which are working already with Oracle UCM will find in Dmitri's book usefull information.

According to Dmitri and Packt Publishing (the publisher) the book "The Oracle Universal Content Management Handbook" will be published in July 2010. More details about the book you can find under
If you are a starter or already a administrator or developer of Oracle UCM, take a look at this book or better buy it :-)

@Dmitri: When you read this, really good work and thanks for providing me the pre-release of your book. I will buy the final release of your book !!

Friday, May 28, 2010

New Layout of my blog

After blogging 2 years with the same layout it was time to change the old layout (really old fashioned) to something new :-)

So, if you are a regular reader of my blog, dont be shocked, you are still at the right blog :-)

Hope you will like the new layout? If not, feel free to complain :-)

Sunday, May 9, 2010

Oracle Grid Control 11g ( for Solaris available

After the Linux Releases (x86 & x86-64) now Oracle Grid Control (Enterprise Manager) 11g ( for Solaris (SPARC) is available under following link

Wednesday, April 28, 2010

Oracle WebLogic Server Virtual Edition

Nearly silent Oracle announce this time a really cool new stuff: Oracle WebLogic Server Virtual Edition

The concept is really simple but cool: Install a JRockit Virtual Edition directly (native) on Oracle VM (without any Operating System) and run your WebLogic without any overhead of a Operating System directly on the JRockit Virtual Edition.

The download can be found under:

A datasheet of the Oracle WebLogic Server Virtual Edition can be found under
Within the next days I will test this cool new stuff :-)

Update January 2011: Oracle has moved the download page of the Oracle WebLogic Server Virtual Edition to

Saturday, April 17, 2010

Oracle Grid Control 11g Release 1 ( - First Screenshots

In my last post "Oracle Grid Control 11g ( for Linux available" you could see that almost one week before the official launch of Oracle the new Release of Oracle Grid Control / Enterprise Manager 11g Release 1 ( is available for download.

Today I will show you some screenshots of the new Grid Control / Enterprise Manager. If you are expecting a complete new layout and look'n feel, you will be dissappointed. The layout remains the same.
The startpage in Grid Control looks the same like the previous release:

Under the link "About Oracle Enterprise Manager" you will see, thats really a release :-)
The database section looks the same like before.
Only if you click the tab "Performance" you can see that the webpage has been changed to ADF.

Under section Middleware you will find your Oracle WebLogic Server, as the Oracle WebLogic Server is a prerequirement to install the new Oracle Enterprise Manager 11g Release 1.
If you access the Oracle WebLogic Server included in your section Middleware, you will find the classical WebLogic Server Administration Console

Thursday, April 15, 2010

Oracle Grid Control 11g ( for Linux available

I just discover that the new Oracle Grid Control / Enterprise Manager 11g Release 1 ( is available for download for Linux x86 and Linux x86-64.

The download is only available at the moment under :-)

Addendum 15.04.2010 19:00 CET:
One of my colleague mentioned to me, that he also try to download the Grid Control 11g Release 1 ( from, but he only receives "500 Internal Server Error". I am right now check it by myself and I receive the same error message and I saw that the download buttons are now disabled with a grey background.
It seems, that Oracle placed the Grid Control 11g Release 1 downloads by mistake on edelivery :-) Anybody who downloaded the installation software already: BE HAPPY :-) I am happy, I got the software :-)

Addendum 15.04.2010 22:45 CET:
Now the download of Grid Control 11g Release is working again even if the download buttons are in grey background colour, so happy downloading :-)

Friday, April 9, 2010

How To Series: Oracle Fusion Middleware 11g Part 2

Within this post I will continue the "How To Series Oracle Fusion Middleware 11g" with the installation of the Oracle WebLogic Server 10.3.2 on a Oracle Linux Enterprise Server 5 x86-64.

The Oracle WebLogic Server is the base for every installation of Oracle Fusion Middleware 11g components, e.g. Oracle Forms & Reports 11g, WebCenter Suite and so on.

In order to install a Oracle WebLogic Server on a 64 bit Operating System we will need at first a JDK, therefore we can choose between the SUN JDK or the Oracle JRockit. In the shown example here I'll use the Oracle JRockit 3.1.2 for Java 1.6.
The necessary software can be found under following links:

I will show here only the important screenshots, the full screenshots you will find under the slides shown at the end of this post.

Download the 2 necessary files (JRockit & "Oracle WebLogic Server - Generic") and transfer them to your server to any directory which is accessable for your oracle installation user.

At first we must install the JRockit 3.1.2 for Java 1.6. My personal directory structure is as follows:

  • ORACLE_BASE=/u00/app/oracle
  • FMW_HOME=$ORACLE_BASE/product/fmw-11.1.1
The JRockit software target directory will be under the $FMW_HOME/jrrt-3.1.2-1.6.0, but you are free to adapt the directory settings to your personal preferences :-)

Just start the JRockit installation with the command ./jrrt-3.1.2-1.6.0-linux-x64.bin, aknowlegde the Welcome Screen and after choose your installation directory.
On the screen Optional Components we don't have to choose anything. Wait some time until the software is copied to your target directory and we are finish with the installation of the JRockit 3.1.2 for Java 1.6

As next we can install the Oracle WebLogic Server 10.3.2
For this we change to the directory where we transfer the installation software and set 2 environment variables:

  • export JAVA_HOME=/u00/app/oracle/product/fmw-11.1.1/jrrt-3.1.2-1.6.0
  • export PATH=$JAVA_HOME/bin:$PATH
After that we can start the Oracle WebLogic Server installation with:

  • java -jar wls1032_generic.jar

Aknowledge the well known Welcome Screen and choose your Fusion Middleware Home (FMW_HOME)
If you are choosing my prefered directory structure, the installer will prompt you, that your choosen Fusion Middleware Home is not empty, just aknowledge this popup.
As next choose, if you want to receive security updates through Oracle Support (Metalink). After choose the Installation Type, here you can choose "Typical"
The JDK selection will have automaticly detected the before JDK JRockit 3.1.2
Then we must define the Oracle WebLogic Server target directory, normally this will be under the Fusion Middleware Home directory
Aknowledge the Installation Summary and wait some minutes, if the installation is finish, deselect the option "Run Quickstart" as the necessary WebLogic Domain will be created within the installation of the specific Fusion Middleware components. And we are ready with the installation of the Oracle WebLogic Server 10.3.2

In the next part, I'll show how to install the Oracle Identity Management 11g.

Under you will find the full presentation with all screens to install the Oracle JRockit and the Oracle WebLogic Server 10.3.2

Wednesday, April 7, 2010

How To Series: Oracle Fusion Middleware 11g Part 1

Today I will start my How To Series for installing and configure the Oracle Fusion Middleware 11g (
The first part will be about how to install the Metadata Repository for the Fusion Middleware 11g.

Why we need a Metadata Repository? Most components of the Fusion Middleware 11g have to store informations in a repository, therefore we will need a database for creating the necessary schemas.

The Metadata Repository must be created for following components:

  • Identity Management
  • Enterprise Content Management
  • WebLogic Communication Services
  • SOA and BPM Infrastructure
  • WebCenter Suite
  • Portal and Business Intelligence
For Oracle Forms & Reports we will not need the Metadata Repository.

As preparation for the Metadata Repository, we will need an Oracle Database, my personal recommendation is use a Oracle (but its also possible to use an Oracle 11.2.x). The database should be configured with following options:

  • Oracle Text
  • Oracle Ultra Search
  • Spatial
The SGA sizing should be at least 1.5 GB and the init.ora parameters processes and sessions should be at least 500.

Download the Repository Creation Utility (RCU) from for your platform (available for Windows or Linux). As the RCU can configure a remote database your target database can even reside on e.g. a Solaris server.
Just extract the RCU to any directory, no additional software is required as the RCU contains a full Oracle Client. Change to the directory rcuHome/bin and run for Linux "./rcu" or Windows rcu.bat.

In the following I will just show the important screens (a link to a slideshow with all the screens is given at the end).

At first the famous Welcome Screen comes up. After this you can choose between either to "Create" or to "Drop" a Metadata Repository, just choose "Create".
As next we must define the database connection to our target database:

The connection to the target database must be done with SYSDBA privileges.

Directly at the database connect the RCU will execute some prerequirement checks. After sucessfully passing these checks we can choose the components we want to install and configure in the Metadata Repository. In my example I will just install everything. Normally you should only install the components you really need.
Within the selection of the components, we also have to define the general schema prefix for the created schemas. Normally you should choose a naming convention like "DEV" for development environments, "PRD" for production environments and so on. After the selection of the components/schemas to be installed another prerequirement check is running, just aknowledge them.
As next we must define the passwords for the new schemas, here we can define one password for all schemas or we can define own passwords per schema.
After this we have to manage the new tablespaces which will be created. Aknowledge the next 2 Popup's, the first one warns you, that the tablespaces will be created if they are not already existing and the second popup is a validation for the tablespace creation. Then we are nearly at the end, just review the summary page and lets start with the creation of the choosen components/schemas.
Time for a small coffee :-) Anybody who knows the previous version of the Oracle Application Server knows that the creation of the Metadata Repository tooks quite a long time, but with the Fusion Middleware 11g it's really fast now. The reason is simply, it's just a "basic creation" of the schemas, the huge data load and so on will come when we are installing the Fusion Middleware Components himself later. So at the end: no time saving :-(

At the end of the creation process you should see a screen like this:

And ready is our Fusion Middleware Metadata Repository.

Thats all for today, the next part will contain, how to install the Oracle WebLogic Server 11g Release 1 (10.3.2), as this will be the base for all following installation.

Under you will find the full presentation with all the screens to install the Metadata Repository.

Tuesday, April 6, 2010

Oracle for Windows Platforms available

Since this weekend the Oracle Database is for Windows Platforms (32 bit and 64 bit) available.

The software can be found under

The Grid Infrastructure Software is only available for 64 bit platforms.

Friday, April 2, 2010

Oracle Enterprise Manager 11g Launch 22nd April

On 22nd April 2010 the official launch of Oracle Enterprise Manager 11g will take place in New York.
For details look look here

Thursday, April 1, 2010

My second Blog - Web 2.0 Technologies

I decided to split now my Blog post into technical Oracle stuff and stuff about Web/Enterprise 2.0.

Therefore I created a new Blog under

I hope you will enjoy it :-)

Wednesday, February 24, 2010

The Sixt Sense

Incredibale :-) Enjoy it - real future technology ;-)

Sunday, February 21, 2010

Enterprise Information Management - Presentation by Billy Cripe

I just see a new presentation by Billy Cripe from Fishbowl Solutions about "Enterprise Information Management 7 Trends & Why They Matter".

I can strongly recommend this presenation.

Monday, February 15, 2010

How To Series: Oracle Fusion Middleware 11g

As now the new Oracle Fusion Middleware 11g becomes common within the Oracle World, I will start within this week a small series with some How To's:

  • Concept of Oracle Fusion Middleware
  • Installation of simple and complex Fusion Middleware environments
  • Configuration of Fusion Middleware Components
  • and a focus on Web Center Suite (which is in my opinion a really cool Product Stack, but the price is also cool :-) )

If you have any special request for a How To, drop me here a comment or follow me on LinkedIn (see button on the left side)

Hope you will enjoy this series and hopefully it will help some people to see a little bit more clear about the "Mega" Fusion Middleware 11g :-)

Oracle WebLogic Security Patch CVE-2010-0073 released

A few days ago Oracle released a security patch for the Oracle WebLogic Server, mainly all releases of the Oracle WebLogic Server are affected

  • Oracle WebLogic Server 10.3.1 & 10.3.2
  • Oracle WebLogic Server 10.3.0
  • Oracle WebLogic Server 10.0
  • Oracle WebLogic Server 7.0 & 8.1 & 9.0 & 9.1 & 9.2

The CVSS Base Score for this security hole is 10 (!!), but only on Windows Platforms. On Unix Platforms the Base Score is just 7.5 (which is still high enough).

So it's really advisable to install this Security Patch, detailed informations can be found under

Wednesday, February 10, 2010

Web 2.0 - Blessing or Curse?

Nearly everbody is using Web 2.0 in one way or another, mostly with Social Networking like Facebook, LinkedIn, Twitter and so on.

Normally I should be a maintainer of Web 2.0 technologies due to my job, but if you are really getting tired of all your Social Networking accounts and what to get ride of them and return into the real world :-) here is a really good solution:

If you are sitting in a bar with some friends and you communicating with them through your mobile phone, then maybe it's time to click the link above :-)

N.B.: At the moment the website is a little bit overloaded, so be patient

Friday, January 22, 2010

How to create a valid tnsnames.ora from Oracle Internet Directory (OID)

Many of customers are using now an Oracle Internet Directory (OID) to store the tnsnames.ora entries in order to avoid a rollout to every client workstation, if a tnsnames.ora entry has been changed, deleted or added.
From time to time my customers asking me, how to spool out / create a tnsnames.ora file out of the entries of the Oracle Internet Directory.

Here two commands which you can use:

ldapsearch -b "" -s sub '((objectclass=orclNetService)(objectclass=orclService))' orclnetdescstring '((objectclass=orclNetService)(objectclass=orclNetServiceAlias))' orclnetdescstring aliasedobjectname > /tmp/temp_tnsnames.txt

sed -e 's/orclnetdescstring=/ /' -e 's/cn=//' -e 's/,dc=/./g' -e 's/,cn=OracleContext//' -e '/^$/d' -e 's/$/=/g' -e 's/)=/)/' -e '/)))/G' /tmp/temp_tnsnames.txt > /tmp/tnsnames.ora

Be aware both commands must be each in one line !

Friday, January 8, 2010

Oracle WebCenter Suite: People Connection Service

Nearly silently Oracle integrates in the latest Release of Oracle WebCenter Suite a new service: People Connection Service.

People who are registered with Services like Linkedin or Xing will feel really familiar :-) So now Oracle is also providing a complete Social Networking Stack.

More details on People Connection Service can be found in the Documentation, just search for "People Connection"
A sample in Oracle TechNet is also availabile, click here :-)

Wednesday, January 6, 2010

Enterprise Content Management Superstar Billy Cripe moved to Fishbowl Solutions

The first entry for this year will just be a small notice on that Billy Cripe (formerly working for Oracle) has been moved to Fishbowl Solutions.

If you got ever the chance to join a presentation of him: JUST DO IT !!! :-) If you don't got the possiblity to see him live, checkout his presentations at

His new blog can be found under following link:

N.B.: @Billy: If you read this: good luck in your new position