Oracle Database 11g Release 2 for Windows released!

They have finally arrived, the Windows 64 and 32 bit versions of Oracle 11gR2.

Download Oracle Database 11g Release 2 for Windows

The 64 bit version was released a bit earlier, so I was hoping the 32 bit version would not come… Why do we want the 32 bit versions? Older systems? Ancient systems! Why…?!

Now I don’t have an excuse to update my almost 10 years old Windows XP OS (running on 64bit hardware) to a much nicer Windows 7 64 bit. The only excuse now is that I could use 600+ megs of memory… enough to run that XP OS virtually!

A small demo machine with SOA/BPEL/WebLogic/ADF/APEX

Today I had to babysit a demo machine I set-up for a proof of concept. All went well, as I expected.

A two gigabyte RAM Linux machine with SOA/BPEL 11g, two WebLogic 10.3 domains extended with ADF and Apex XE running on it. It kept running, but at one point is had only 30 megs of memory left!

Check out ‘Extending your WebLogic standalone environment with ADF runtime libraries‘ for more information about setting up the WebLogic environment with ADF.

Temporary stop listener to log with ‘set log_status’

When moving/deleting the listener.log, I used to stop and start the listener and move/delete the listener in between the actions.
This method has a big inconvenience: users can not connect to the database for a few seconds…
What I never knew was that the listener could be told to stop and start logging and take the appropriate action in between. Continue reading

Oracle Database 11g Release 2 Launch

After a nice Lower Cost talk by Mark Townsend and the new Sun Oracle Exadata and Database Machine by Chris Baker, I attended ‘Upgrade to 11g – Best Practices’ by Mike Dietrich, ‘Consolidate on Low-Cost Server and Storage Grids’ by John Abrahams, ‘Oracle’s Maximum Availability Architecture’ also by John Abrahams & Lucas Jellema, CTO AMIS and ‘DBA 2.0’ by Ed Bangma.

It was nice to see our Whitehorses logo in the main presentation at the Oracle Netherlands 25 years sheet!

More on Oracle ASM Cluster File Management, Dynamic Volume Manager, RAC One Node, Grid Plug ‘n Play, Server Pools, Cluster Health Monitor and Electronic Sudoku Devices… Continue reading

create database: “ORA-01991: invalid password file” and “ORA-01403: no data found”

Last week I created a new database (Oracle 9.2) and got the following message when the ‘create database’ script was almost finished: ORA-01991: invalid password file.

OK, the database instance existed before, so I created a new password file with orapwd. Trying to open the database after this gave me the following message: ORA-01403: no data found. Continue reading