OEM 10gR3 is out!

emgrid is not the second patchset of 10gR2, it is Oracle Enterprise Manager Grid Control Release 3.

Well, it is still called a patch set and must be applied to or

But it is a new release !

You can download the soft and the doc on otn

Out of the new features, you have a Linux pack for your Unbreakable Linux, Management pack for Siebel and Oracle Content Database, and also Linux Server Administration to manage your Linux (RHEL4 and SuSE9).

Critical Patch Update

The critical patch update for january is released. However, not for every version.

Already in CPU Oct 2006, many versions were delayed. The release date of 10gR1 Tru64 for example was Nov 15, but the note has not been updated for months. Linux was released so late (29 Dec), that the CPU2006OCT-9208 is considered to be CPU2007JAN (patch 5490859). For, there is no CPU2007JAN

I applied both 9208-cpu2006oct and 10105-cpu2007jan to my notebook database.

Both complained about not existing XDB schema, but I ignore those (I have no XDB schema). Otherwise it went fine.

I apply the CPU as soon as released for testing purpose. However, applying the CPU as soon as possible in PROD does not apply to most of my customers.

Fit for RAC

I will be speaking tomorrow in German and Wednesday in English in Credit Suisse Bank.

The workshop is about the differences between single instance and RAC

Some of them : architecture, availability, scalability, manageability, skills required, price. I will talk also about the operational aspects, upgrade, dictionary, parameter file.

Oracle 9iR2 desupport

How long is Oracle 9iR2/10g going to be supported? Infinitely!

Metalink updated the upcoming desupport advisory.

For 8iR3, you had something like :

Error Correction Support (ECS):     31-DEC-2004
Extended Support (ES):              31-DEC-2007
Extended Maintenance Support (EMS): 31-DEC-2006

Now for 9iR2, 10gR1, 10gR2, you have this :

Release  GA Date   Premier   Extended  Sustaining
                   Support   Support   Support
-------  --------  --------  --------  ----------
DB 9.2   Jul 2002  Jul 2007  Jul 2010  Indefinite
DB 10.1  Jan 2004  Jan 2009  Jan 2012  Indefinite
DB 10.2  Jul 2005  Jul 2010  Jul 2013  Indefinite

Sustaining support is less than extended support, you do not get upgrade script and compatibility with new products (ex: connection from 9i client to Oracle 14x is not supported). But it let you keep your very old stuff supported by Oracle.

Read more :
Oracle Lifetime Support Policy Datasheet PDF 110K
Oracle Technical Support Policies PDF 258K

Oracle Magazine January-February 2007

Check the oracle magazine on otn.oracle.com/oramag

In the peer-to-peer, you can read more about 3 Oracle Aces, Steve Karam, Nicolas Gasparotto, Dave Moore.

In the technology columns, three more aces talk about Oracle technlogies. Steven Feuerstein about The Right Place for PL/SQL, Arup Nanda about Recover in a Flash, and Tom Kyte about On Top-n and Pagination Queries. Tom also remind us that group by does not sort. However, if you have one application which used to expect sorted result in 9i and is now produced unexpected result in 10g, you can still read the Note:345048.1 in Metalink to find some workarounds, for example by deactivating hash-group-by with _gby_hash_aggregation_enabled parameter set to false

Welcome to the Oracle Database 11g Release 1 Beta Program!

Today is a good day, I have been accepted to the beta program and will be able to download 11gR1 beta 4 shortly.

There is a Confidential Disclosure Agreement, so do not expect to read more on 11g here before the production release.

My blog articles about 11g in OpenWorld 2006:
11g New Features
11g New Features part II

I successfully installed 10gR2 patchset 2 on my notebook :

SQL> select ACTION,VERSION,COMMENTS from registry$history;

------- ---------- ------------------------------
CPU CPUOct2006
UPGRADE Upgraded from

SQL> select COMP_NAME,VERSION,STATUS from dba_registry;
COMP_NAME                           VERSION    STATUS
----------------------------------- ---------- -----------
Oracle Expression Filter   VALID
Oracle Database Catalog Views VALID
Oracle Database Packages and Types VALID
Oracle Database Java Packages VALID
JServer JAVA Virtual Machine VALID
Oracle XDK                 VALID

apply CPUOct2006

I downloaded the CPUOct2006 patch for and applied it successfully to my database.

SQL> select action,id,comments from dba_registry_history;
------ ---------- ----------
CPU       5490848 CPUOct2006

in the logfile, apart from a few ignorable ORA-02303: cannot drop or replace a type with type or table dependents errors, everything went fine.

Applying the security patch shortly after they are released is in my opinion a good practice, because a fix could sometimes reverse-engineered to reveal the bug.

Tomorrow afternoon I flight via London to SF for OOW2006. I am quite unhappy about not taking my notebook, my phone, not even a book or a SuDoKu in the plane 🙁 Well, I hope BA will not refuse to serve me wine this time as Delta did last year

OTN forums new release

I read forums.oracle.com frequently. I have read and answered thousands of questions there.

Those days, they launched a new release, I do not know what the improvements are, but it is fairly unstable. Well, it has been worst in the past, but I keep getting We’re sorry, the server encountered an unexpected condition and timetouts occasionaly.

Another nightmare for users was the blank-trimming effect, it was hardly possible to format the post, all multiple spaces were trimmed to one space, even by using [code] or [pre]. It is now fixed!

There has been also two new icons, Usefull answer and Correct answer, but it has been removed already. It makes me remembers the smilies they introduced in a previous release, where :p bind variable was translated to a smile…

Problem with the downtime is that the experts go away. I post and read hundreds of messages on metalink, especially in sqlplus and plsql forums. The problem on metalink, lot’s of users expect to have an immediate and advanced answer from Oracle, because they pay for support, and they do not invest time to write the question properly nor to say please or thank you.

I recently start writing on the linux and oracle forums of developpez.net, where they put a high value on proper formatting, code of conduct, correct spelling (in french).

isqlplus and sqlplusw desupport

isqlplus and sqlplusw (gui sqlplus windows) will be desupported in 2010. Read Note 359855.1 and Note 359859.1 on Metalink.

Oracle recommends migrating to Raptor (SQLDeveloper) or to Application Express (HTMLDB) or command line sqlplus.

Oracle Support apparently does not know that Raptor changed name before going to production, well, names change so often, it is difficult to know them all!