This Blog is discontinued, its only read-only

Monday, May 30, 2011

DOAG Conference 2011 - Call for Papers

And once again this year the largest european Oracle User Group (Deutsche Oracle User Group - DOAG) is calling for papers for the DOAG Conference 15th til 17th November in Nürnberg / Germany.



Details for the upcoming conference can be found under http://www.doag.org/konferenz/doag/2011/

The Call for Papers form can be found under http://mydoag.doag.org/termine/cfp.php?id=422990 The Call for Papers is still open until 15th June 2011, so hurry up ... :-)

I am proud that the DOAG asked me once again after last year to be in the selection commitee of the submitted presentations for the stream "Databases - MySQL"

I hope, I will see a lot of submitted presentations for the stream "Databases - MySQL"

Wednesday, May 18, 2011

Oracle JRockit is now free, but ...

Oracle announce that the usage of the Oracle JRockit JVM is now free :-) See Oracle News: http://www.oracle.com/us/corporate/press/173782

Sounds really good, but ... there is a small restriction inside this news announcement:
Premium offerings such as JRockit Mission Control, JRockit Real Time, Java for Business and Enterprise Support will continue to be made available for an additional charge
So only the core functionalities are free of charge, the cool features like Mission Control or Real Time still have to be paid :-(

Wednesday, May 11, 2011

Implementing Oracle WebLogic AdminServer as Windows Service

Today my fight with the Oracle Internet Directory 11.1.1.4.0 from yesterday continues (http://dirknachbar.blogspot.com/2011/05/fighting-with-tns-03505-failed-to.html), but this time the problem were related to the Oracle WebLogic Server. I wanted to implement the startup of the underlying Oracle WebLogic AdminServer and ManagedServer of the Oracle Internet Directory installation as a Windows Service.

For this Oracle provides an installation script %WL_HOME%\server\bin\installSvc.cmd which should be called by a wrapper script which we have to create by ourself. (see http://download.oracle.com/docs/cd/E17904_01/web.1111/e13708/winservice.htm), but unfortunally if you follow this instruction, you will not be able to startup your AdminServer with a Windows Service. In the corresponding logfiles of the AdminServer you will find entries like:

<BEA-000286> <Failed to invoke startup class "JRF Startup Class" ...

After a little bit of Google Search, I found some articles, which point to the fact that a Java Class (ORACLE_COMMON\modules\oracle.jrf_11.1.1\jrf.jar) is missing in the CLASSPATH variable. So I try this, therefore I modified the %WL_HOME%\common\bin\commEnv.cmd which will be called in the installSvc.cmd and added the fullpath including the jar-file name to the variable WEBLOGIC_CLASSPATH. BIG MISTAKE :-) I did this, and re-created the Windows Service for the WebLogic AdminServer newly and try to startup the new Windows Service. This time I got new and strange exceptions . . .

After some investigations and testings I found a valid and working way, which is really simple :-)
At first in the %WL_HOME%\common\bin\commEnv.cmd I modify the line:

# Original:
@rem PRODUCTION_MODE, default to the development mode
set  PRODUCTION_MODE=
# To:
@rem PRODUCTION_MODE, default to the development mode
set  PRODUCTION_MODE=true

As in my case I am running in Production Mode and the declared variable in my wrapper script which calls the %WL_HOME%\server\bin\installSvc.cmd was not taken correctly and secondly I added one line in the %WL_HOME%\server\bin\installSvc.cmd script in order to call the %MW_HOME%\user_projects\domains\<YourDomain>\bin\setDomainEnv.cmd in which all necessary CLASSPATH declarations are included:

# Just add after the first call of the commEnv.cmd
# the call of your setDomainEnv.cmd
. . .
call "%WL_HOME%\common\bin\commEnv.cmd"
call "<YourMW_HOME>\user_projects\domains\<YourDomain>\bin\setDomainEnv.cmd"

After this changes just re-create your Windows Services for the WebLogic AdminServer newly, start the service up and be happy :-)

Tuesday, May 10, 2011

Fighting with "TNS-03505: Failed to resolve name" and OID 11g

I am currently setting up an Oracle Internet Directory 11.1.1.4.0 for the usage of tnsnames resolution and run in a nice error.

The installation and setup were straight forward (even as I had to do it under Windows :-) ), I created a test tnsnames entry in my new OID 11g with the Net Manager from an Oracle Client 11.1. So far so good.
But when I wanted to test my new tnsnames entry in the OID with a simple tnsping, I receive immediately following error:

tnsping testdb
TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - 
Production on 10-MAY-2011 18:16:57
Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
C:\work\network\sqlnet.ora
TNS-03505: Failed to resolve name

Really cool :-) I checked several times my sqlnet.ora and ldap.ora, which are correct. Metalink points to a know problem with OID 11g, that by default an anonymous bind is disabled. So quicktest from my client with ldapbind:

ldapbind -h myoidserver -p 3060
bind successful



Looks ok . . . but even when this ldapbind shows you successful, be aware, in my case it proof nothing :-(

I connected to the Fusion Middleware Control Enterprise Manager, open below my Farm the Entry "Identity and Access", chose the subentry "oid1" (might have a different name in your case) and select under the menu point "Oracle Internet Directory" in the center window the option "Administration/Server Properties" and saw under the General Tab for the option "Anonymous Bind" that it was disabled.

I just switched the option to "Allows", click the Apply button.



After that I try again from my client the tnsping and it worked perfectly this time :-)

Monday, May 9, 2011

Firefox Search Plugin for Oracle Fusion Middleware Documentation

Some weeks ago a friend of mine (Gregory Steulet, http://www.dbi-services.com/) has published some nice Firefox Search Plugins for Oracle Database Documentation and MySQL Documentation. As I am a pure fan of the Oracle Fusion Middleware Stack I ask him, if he could create also a Firefox Search Plugin for the Oracle Fusion Middleware Documentation and he did it :-)

His blog entry for the annoucement can be found here: http://www.dbi-services.com/index.php/blog/entry/stop-looking-for-oracle-fusion-and-oracle-grid-control-documentation-use-the-dbi-services-firefox-add-ons

The download of the Firefox Search Plugin can be found here: https://addons.mozilla.org/en-US/firefox/addon/fusion-11114/

Thanks @ Greg for the fast implementation of my feature request :-)

Fusion Middleware 11.1.1.5.0 Patch Set 4 for selected Components available

Since about 10 days now are patches for selected components of the Oracle Fusion Middleware are available in the My Oracle Support (http://support.oracle.com/).
The patches are available for following Operating Systems at the moment:
  • Linux x86
  • Linux x86-64
  • Windows 32-bit
  • Windows 64-bit
  • Oracle Solaris on SPARC (64-bit)
  • Oracle Solaris on SPARC (32-bit)
  • Oracle Solaris on x86-64
  • Oracle Solaris on x86
  • IBM AIX on Power Systems (64-bit)
  • HP-UX PA-RISC (64-bit)
For following components are the Patch Set 5 (11.1.1.5.0) is available:
  • Oracle Data Integrator
  • Oracle Enterprise Content Management
  • Oracle Identity Management
  • Oracle Application Development Runtime
  • Oracle SOA Suite
  • Oracle WebCenter Suite
  • Oracle Service Bus
  • Oracle Fusion Middleware Web Tier Utilities











A really good summary of the Installation Types and the necessary patches inlcuding the necessary links to each patch or fullinstaller can be found under the link: http://download.oracle.com/docs/cd/E23104_01/download_readme_ps4/download_readme_ps4.htm

I hope the remaining components will follow soon.