Oracle WebLogic Server 12c (12.1.1) for download available

Since Friday 9th December 2011 the latest release of the Oracle WebLogic Server 12c (12.1.1) is available for download in the Oracle Technology Network under following link: http://www.oracle.com/technetwork/middleware/weblogic/downloads/wls-main-097127.html

Following Versions are available:

• Installer with Oracle WebLogic Server 12c, Oracle Coherence and Oracle Enterprise Pack for Eclipse (for Linux x86 with JVM 32bit, Windows x86 with JVM 32bit and Mac OS X with 32bit)
• Installer with Oracle WebLogic Server 12c and Oracle Coherence (for Linux x86 with JVM 32bit, Windows 32bit with JVM 32bit and a generic version for 64bit platforms)
• Zip Distribution with Oracle WebLogic Server 12c only intended for WebLogic Server development only (for Linux, Windows and Mac OS X)

The documentation for the new Oracle WebLogic Server 12c (12.1.1) can be found under following Link: http://docs.oracle.com/cd/E24329_01/index.htm

Read More

Bye bye WebCache - Welcome Oracle Traffic Director

I am currently sitting here and listen to the WebCasts for the new Oracle WebLogic Server 12c Release.

Some highlights:

• More then 200 new features
• Java EE 6 fully profile certified
• Seamless upgrades (let's see the reality :-) )
• Introduction of Oracle Traffic Director

In my opinion one of the highlights is the introduction of the Oracle Traffic Director, which will be the replacement of the Oracle WebCache on Exalogic platforms. I will miss the WebCache, I really learnt over the years to love this tool ;-)
Oracle Traffic Directory will be officially supported only with Exalogic platforms, but also runable on 64bit OEL platforms ;-)

The downloads for the new Oracle WebLogic Server 12c (12.1.1.0) should be available on Oracle Technology Network from the 5th of December 2011 going.

Note 2nd December 2011: There is also a Data Sheet for the new Oracle Traffic Director available http://www.oracle.com/us/products/middleware/application-server/oracle-traffic-director-ds-1389582.pdf

Read More

Oracle Weblogic Server 12c Launch announced

The Oracle Weblogic Server Release 12c is coming soon :-)

Oracle will unveiling the Oracle Weblogic Server 12c on 1st December 2011.

For the Online Launch Event registration just go here: http://tinyurl.com/cfpud2v

Read More

Why you should never create own objects under SYS

I got many times the request by developers to create objects under the SYS schema and my comment is normally "NO". Here is a nice showcase, why the creation of own objects under the SYS schema can become really dangerous:

conn / as sysdba
select count(*) from dba_objects where status = 'INVALID';
COUNT(*)
----------------
        0
-- Now lets create a simple table named SYSTEM under the SYS schema
create table SYS.SYSTEM (id number);
Table created.
-- Now check for invalid objects again.
-- Note: I didnt do anything special after the creation of the table SYS.SYSTEM
select count(*) from dba_objects where status = 'INVALID';
COUNT(*)
----------------
      149

The critical point here is the name of the created table. As soon as you are creating a table named SYSTEM under the SYS schema, you will get immediately a huge number of invalid objects under SYS, most of them are DBMS-Packages, ALL-Views and DBA-Views. The number of invalid objects you will get is depending on your Oracle Release, even a recompile with utlrp.sql will not validate all objects, there will still be invalid objects.

To get ride of this problem, just drop the table SYS.SYSTEM and recompile all with the utlrp.sql script.

This shows clearly why you should not allow the creation of application related objects under the SYS schema.

Read More

Oracle Forms 11g Release 2 (11.1.2.0.0) now for Linux x86-64 available

Last week you could read in my blog post "Oracle Forms 11g Release 2 (11.1.2.0.0) available" that Oracle Forms 11g Release 2 is available for Linux x86 and Windows x86. Now Oracle released also the Linux x86-64 version of Oracle Forms & Reports 11g Release 2 (11.1.2.0.0).

The download can be found under http://www.oracle.com/technetwork/developer-tools/forms/downloads/index.html

Read More

Oracle Forms 11g Release 2 (11.1.2.0.0) available

Oracle released the latest version of Oracle Forms 11g Release 2 (11.1.2.0.0) for Windows x86 and Linux x86 today.

The download can be found under: http://www.oracle.com/technetwork/developer-tools/forms/downloads/index.html

There is also a short new features paper available under http://www.oracle.com/technetwork/developer-tools/forms/forms11gr2newfeatures-497502-en-gb.pdf

The necessary installation documentation can be found under http://download.oracle.com/docs/cd/E24269_01/index.htm

Read More

Oracle Enterprise Manager Cloud Control 12c for Linux x86 available

Since today in addition the Oracle Enterprise Manager Cloud Control 12c (12.1.0.1.0) for Linux x86 is available in OTN and in Oracle Edelivery.

OTN Download: http://www.oracle.com/technetwork/oem/grid-control/downloads/index.html

The Oracle Edelivery: https://edelivery.oracle.com/

Read More

Oracle Enterprise Manager Cloud Control 12c - First screenshots

In my post from yesterday "Download available for Enterprise Manager Cloud Control 12c Release 1 (12.1.0.1) for Linux x86-64" you could see that the new Oracle Enterprise Manager Cloud Control 12c 12.1.0.1.0 for Linux x86-64 is available for download.

Here are some first impressions:

• According to a presentation from Oracle "What's New in Enterprise Manager 12c Install" the installation should be really simplified now: TRUE :-) It's only 6 screens (under optimal conditions) !!!
• The fight with a correct WebLogic Server Release and which JDK to use is now eliminated :-) Everything is bundled in the installation sources
• The only pre-requirement what you will need is an Oracle Database

My starting position:

• Oracle Enterprise Linux 5 Update 3 x86-64
• Oracle Database Enterprise Edition 11.2.0.1.0 (no additional patches)

Extract the 2 zipfiles em12_linux64_disk1of2.zip and em12_linux64_disk2of2.zip on your server and start the runInstaller:
At first the typical Welcome screen with the optional declaration of my My Oracle Support credentials

As next we can define if we want to download directly possible available patches from My Oracle Support.

Then the prerequirement checks are running, I receive an error due to a minor version of my installed glibc-devel, so I decided to ignore it and everything works for me well :-)

After that we have to chose the installation type. The Simple option is really simple, it installs you all the necessary stuff (JDK, WebLogic Server, OMS and Agent) and configures your new Enterprise Manager Cloud Control 12c.

As next we have to define the Password for the adminstrative Users (Weblogic Admin-User, SYSMAN and OMS registration) and the Database Connectivity for the Enterprise Manager.

After the connectivity check you normally get some errors/warnings (eg. that a Stats Gathering Job must be disabled and that some Database Settings are not aligned). The Stats Gathering Job can be disabled directly from the Installer :-) the other warnings in my case were minor and could be aligned after the installation.

As last step we can review the summing up and start with the installation and configuration. This all what we have to do :-) Really simple and straight forward !!!

As last the Installer shows us the Finish screen with a small summing up of the necessary URL's.

To access the new Enterprise Manager Cloud Control 12c just go to the URL displayed in the Finish screen. The new login screen looks now more blue and from the look'n feel like the Fusion Middleware Login Screens. For the Login you have to use the username SYSMAN.

The first new feature you will see directly after the login. You can now chose your preferred "home page view", e.g. Databases, Middleware, SOA and so on.

The Website of an Oracle Database:

The Website of a WebLogic Server:

The Website of a Host (Oracle Enterprise Linux):

Conclusion: Installation simplified :-) Look'n Feel cool :-) preferred home page view great idea. Seems to be a great new Release from the first look. So let's test deeper ...

Additional Note: For everybody who is searching for the documentation (like me :-) ): http://download.oracle.com/docs/cd/E24628_01/index.htm I just found the documentation, sometimes its better to read the documentation before you start with the installation, according to the installation guide, I had to apply for my Oracle Database 11.2.0.1.0 two additional patches :-)

Read More

Download available for Enterprise Manager Cloud Control 12c Release 1 (12.1.0.1) for Linux x86-64

3rd and most important post for today about Oracle Enterprise Manager 12c: Enterprise Manager 12c is available for download in Oracle Technet !!!



Under the link http://www.oracle.com/technetwork/oem/grid-control/downloads/linuxx8664soft-085949.html is the Linux x86-64 Release available:

My download is already started :-)

Read More

Next Next update on Oracle Enterprise Manager 12 Launch

Just some hours ago, I posted "Next update on Oracle Enterprise Manager 12 Launch" and here we go with the next update on Oracle Enterprise Manager 12 (Grid Control) :-)

I just saw in My Oracle Support a Note (ID 1363757.1) dated from 3rd October 2011 which is related Oracle Enterprise Manager 12.1.0.1.0 (12c). Seems that the naming convention is confirmed with 12c

Read More

Next update on Oracle Enterprise Manager 12 Launch

On 4th August 2011, I posted "Oracle Enterprise Manager 12 Launch - 15.11.2011 on DOAG Conference". Now some more proofs, that the new Oracle Enterprise Manager (Grid Control) 12 will come soon :-)

In My Oracle Support you can find already under the Patch Section a selection for Oracle Grid Control 12.1.0.1.0 (see last line in the drop down list). So we know at least the Release Number, but if the new release will be named "12c" is still unconfirmed.

So stay tuned for the next updates ...

Read More

Mobile My Oracle Support available

I just saw that the My Oracle Support (MOS) website offers now a Mobile Support :-)

Just go to http://support.oracle.mobi/

Read More

Oracle Database 11g XE not longer BETA

In my blogposts from 1st April 2011 and 2nd April 2011 I was talking about the newly released Oracle Database 11g XE BETA (11.2).

The BETA is now removed for the Oracle Database 11g XE :-)

The downloads can be found under http://www.oracle.com/technetwork/database/express-edition/downloads/index.html

But still are only 2 versions available, one release for Linux x64 and one release for Windows x32.

Read More

Tanel Poder's Oracle Troubleshooting TV show available

For anybody who has missed Tanel Poder's "Secret Hacking Session - about full scans, direct path reads, object level checkpoints, ORA-8103s" its now available under:

http://blip.tv/tanel-poder-oracle-troubleshooting-tv/oracle-troubleshooting-tv-show-season-1-episode-2-5459181

This show is really a must-see :-)

Read More

Oracle Enterprise Manager 12 Launch - 15.11.2011 on DOAG Conference

During the DOAG (German Oracle User Group) Conference on 15.11.2011 to 17.11.2011 Oracle will present the new Oracle Enterprise Manager Release 12 (Oracle Grid Control 12) within a keynote. The presentation will be done by Richard Sarwal, Oracle Corporation.

Link to the Conference Program (unfortunally in german language) can be found here: http://mydoag.doag.org/konferenz/2011-konferenzplan.php

I am really curious what will be the new features/options, I am expecting them as it will be a new major release :-)

Read More

Oracle Virtual Developer Day REA Material available for download

Some time ago the Oracle Virtual Developer Day Rich Enterprise Applications (REA) took place. For anybody who couldn't attend, here is a link to the presentations, On-Demand-Sessions, Lab Materials and so on.

http://www.oracle.com/technetwork/community/developer-day/virtual-dev-day-rea-369353.html

You will find there presentations by people like Frank Nimphius, Grant Ronald and so on. The presentations are covering topics like:

• From Forms to ADF - When, Why, How?
• Rich Web UI made simple - an ADF Faces Overview
• ADF Bindings Internals
• Introduction to Developing with Oracle WebCenter
• and much more

Read More

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"

Read More

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 :-(

Read More

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

Read More

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

Read More