OID database upgrade to

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 10 Jun 2009 10:51:09 -0700
Message-ID: <bf46380906101051ie3af878nda38f4bf0c597fd_at_mail.gmail.com>

As shipped, OID runs on the version of the Oracle Database.

I am attempting to upgrade the database to so that security patches will be available for the database for a longer period of time.

While this should be fairly straight forward, it is not.

ML Note *376689.1*, "Upgrading the Application Server 10g (10.1.2|10.1.4) Seeded Database from 10.1 to 10.2", covers the upgrade process.

Unfortunately it does not work as is.

It is also necessary to follow note *278100.1*, "How To Drop, Create And Recreate DB Control In A 10g Database", as EM controls do not get upgraded by the upgrade to

After following these instructions, there are still things that don't work.

While OID will start/stop via opmnctl, oidctl no longer works.

On the database side, iasconsole and dbconsole are inoperable.

The command to recreate the controls fails:   emca -config dbcontrol db -repos create

Has anyone here successfully upgraded on OID database from to

And by 'successfully', I mean that all functionality that worked on 10gR1 continues to work on 10gR2.

If so, can you share information on how it was done?

Yes, there is an SR associated with this topic already...

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Received on Wed Jun 10 2009 - 12:51:09 CDT

Original text of this message