Issues in upgrading from 9i to 10g

Last week I had a chance to upgrade a 9.2.0.7 database to 10.2.0.5. The size of the database was around 800 GB. The major applications connecting to the database were developed in Pro*C and Oracle Forms. The upgrade itself pretty smooth but there were few glitches around that needed to be handled. Just thought about documenting all the issues: Few users in the database were assigned the CREATE SESSION privilege through a password protected role (That role was the default role for that user). 10.2.0.5 onwards, password protected roles can’t be set as default roles. The alternate is to either disable the password for the role or assign CREATE SESSION directly to the user, not through a role. ...

January 29, 2011 at 10:30 PM · 2 min · 300 words · Amardeep Sidhu

OTN forums – 2nd upgrade attempt

Well, as everybody has seen, last week they have again upgraded the OTN forums. And sadly it has been handled in a very poor manner. End result is that it is running terribly slow and throwing some errors many times. In my office, i cant even open it properly may be its too heavy or some issue with the internet. Also there has been lots of hues and cries about the new point system and all. That in my opinion is fine except that speed at which forums are running should be fine. ...

August 28, 2008 at 7:28 AM · 2 min · 330 words · Amardeep Sidhu

Upgrade to WordPress 2.6

Just upgraded my blog to Wordpress 2.6. There are few new things. This video from Wordpress summarizes the new stuff:

July 15, 2008 at 10:28 PM · 1 min · 20 words · Amardeep Sidhu

Automating WordPress 2.5 upgrade

I recently upgraded my blog to Wordpress 2.5. The manual process is real cumbersome. Today I came across few plugins which help in almost automating the upgrade stuff. Wordpress Automatic upgrade: As per description this plugin first takes backup and then upgrades. I didn’t try this one, though. Instant Upgrade: I upgraded one of my blog using this. It doesn’t take care of backup but otherwise the upgrade was super smooth. Just few clicks and you are done. ...

April 6, 2008 at 11:59 AM · 1 min · 81 words · Amardeep Sidhu

Upgrading to WordPress 2.5

Just finished upgrading to Wordpress 2.5. Everything seems to be working fine. Another issue I just came to know that wherever i am using syntaxhighlighter to format the code, it doesn’t display properly in Internet Explorer. May be something to do with the plugin. Will try to fix it. It works fine in Mozilla.

March 30, 2008 at 5:46 PM · 1 min · 54 words · Amardeep Sidhu

Upgrade 10gR1 to 10gR2 – DBUA error

Today I was upgrading 10gR1 to 10gR2 (10.2.0.1) on Linux x86. The upgrade went almost fine (except that I had to install one package and change few kernel parameters) but while running DBUA to upgrade databases, it gave an error: [sourcecode language=‘css’]Could not get database version from the Oracle Server component. The CEP file rdbmsup.sql does not provide the version directive and Start of root element expected. Upgrade Configuration file ‘C:\Oracle10g2\cfgtoollogs\dbua\test\upgrade5\upgrade.xml’ is not a valid XML file.[/sourcecode] ...

March 27, 2008 at 10:53 PM · 2 min · 329 words · Amardeep Sidhu