« This Week With Astra | Main | Astra Weekly Upgrade »
February 20, 2008
10gR2 Production Upgrade Scheduled
Friday, March 7th, beginning at 5:30 p.m., several of the UCS staff will be having a fun time upgrading our production database from the 9i version to 10gR2. We have created a 10gR2 database on our production server together with an HTTP server. These will be used as part of the upgrade. Our plan of attack is to shut down the database, make a copy just in case, run the upgrade, move all the datafiles to their new Oracle Home, recreate all configuration files to point to the new Oracle Home, then restart the upgraded database. Ron will move our SSL certificate, and Alex will be responsible for all the Unix heavy lifting - file copies and such.
We have learned that we can create our DAD's with names that mimic our existing structure, so that we should not have to go to each package and procedure to enter the new paths. This will save us a bunch of time. This upgrade is long overdue, so it will be nice to get the 10g version into production. It has many features that will resolve some long term issues, such as Oracle Wallet for our website, increased number of sessions, and a much better way to do upgrades and patches. It's supposed to be more efficient, too, but let me tell you it is one very busy application! I am constantly amazed at the wide variety of things that use the Oracle database. The improved performance may not be all that noticable at the user level, primarily because our current database is already running at such high speed. It's like going from 100 mph to 120 mph - one is surely faster, but both speeds are pretty fast.
With any luck at all, we'll have a sweet 10gR2 production database up and running by March 8th. Then I can work on the upgrade to 11i - ah, job security!
Posted by rossm at February 20, 2008 8:35 AM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)