Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Friday, April 25, 2008

DBUA vs manual upgrade

While upgrading an Oracle Database, which is better DBUA or manual upgrade ?

Arguments for DBUA:
1. DBUA takes care of all the pre-install checks like kernel parameters, memory, space etc.
2. DBUA gives the option of automatic RMAN backup of the existing DB
3. DBUA upgrade is faster than manual upgrade.(As DBUA automatically sets job_queue_processes)
4. Easier to use.

Arguments against DBUA:
1. If there are errors during the upgrade, there is usually no way to resume. In many cases, where a single or multiple components of the upgrade have failed, you can restart DBUA and it takes care of the missed steps without issues.
2. Manual upgrade gives you absolute control. You know exactly where you are in the upgrade process. Tracking this in DBUA involves watching DBUA logs, Alert log at the time DBUA is running. I never liked the progress bar. It doesn't convey anything. Along with progress bar, DBUA should also show DB alert log and what script is being executed. That helps in debugging and keeps you in touch with the upgrade instead of insulating you from it.
3. DBUA takes the value of sga and other memory settings from your 9i database and creates 10g/11g init.ora based on those. Unless you pre-size your 9i init.ora, you may get ORA-4031 errors during the actual upgrade with DBUA.

Most of the time, when DBUA screws up, you have to continue your upgrade by abandoning DBUA and take a detour to manual upgrade. E-Business Suite Databases are not small, and do not provide you the luxury of restoring backup and starting with DBUA again.

1 comment:

Dave said...

I'm probably in the minority but I prefer dbua. The less steps, the less chance of error. Frequently, as an apps dba myself, our downtime is usually at odd hours and for major upgrades you could be working some pretty long hours. Its very easy to make mistakes, skip a step, etc when your starting to get tired.

Our testing cycle is pretty intensive, so its not unlikely to have performed 4-6 upgrades before production. Plenty of time to iron out any issues with dbua.

w.r.t issues, the only major ones i've ever had were related to running dbua via vpn from home. If your ISP decides its a good time to renew your ip, thats a problem. ;) So normally I remote desktop to a local computer and run it from there.