The Blog from the DBA Classroom

By: Joel Goodman

Archive for October, 2010

Exadata News

Posted by Joel Goodman on 28/10/2010


Exadata and Database Machine at the UKOUG Conference

I will be hosting the Exadata and Database Machine Round Table discussion group at the UKOUG Technology and E-Business Suite conference on November 29th at 11:45 AM. I hope to have members of the Oracle ACS team at the session. All are invited, whether you already have a Database Machine or simply if you are interested in finding out more about it.

The following session on Exadata is also a must for those who are interested in the technology:

  • Performance Stories from Exadata Migrations – 29/11/2010 at 14:15 – presented by Tanel Poder

Exadata and Database Machine Training

Oracle University has a hands on course called Exadata and Database Machine Administration Workshop which was successful in the First teach recently and will be available in EMEA quite soon. The course covers the Database machine hardware, software, planning, configuration, administration, monitoring, troubleshooting and patching.  Please look out for it soon in EMEA.

There is also a seminar version of the course with no hands on labs but which is supplemented by demos.

See here for details.

 

Joel

October 2010

Posted in Oracle | 1 Comment »

Try 11.2.0.2 – You Won’t Feel Out of Place

Posted by Joel Goodman on 11/10/2010


Oracle has released 11.2.0.2 for the Grid Infrastructure and for the Database Server. There are some new features in this patch set, but the one with an immediate impact is “”Out-of-Place” patch set upgrades where the install is done into a separate Oracle Home directory, rather than into the existing Oracle home.

Out of place upgrades relate to:

  • Oracle Database Server
  • Oracle Grid Infrastructure
  • Oracle Database Client
  • Companion/examples
  • Oracle Gateways

Here are some details:

  • “Out-of-Place” upgrades are Full Installs
  • New installs are done by installing the latest patch set, rather than installing the base release and then “patching up” to the latest patch set
  • Upgrades for the Grid Infrastructure Home must be done “Out-of-Place.
  • Upgrades for the Oracle Database Server are recommended to be done “Out-of-Place”
  • Upgrades for the Oracle Database Client may be done either “In-Place” or “Out-of-Place”
  • Note 1189783.1 contains useful information relating to this.

Implications for using “Out-of-Place” upgrades:

  • For new installs it saves the need to patch up to the latest release
  • For upgrades, the process is the same as for a change in version
  • Less downtime is required for an upgrade, because the install, including linking binaries is done without downtime
  • It is safer as it does not modify the Oracle home that is currently used for live systems
  • It requires more disk space at least for a time, since the complete Oracle home is installed in a separate location
  • The steps are different than for upgrades in the past, so it is advisable to read up on the process.
  • Any shell scripts, variables and other files referring to the old Oracle Home, must be checked and modified once the upgrade is finished

My Experience with 11.2.0.2 Upgrade

I downloaded the 11.2.0.2 images for the Grid Infrastructure and Database and used them to upgrade my Grid Infrastructure for a Standalone Server and my Oracle Single Instance Database. Here were the steps I followed:

  1. Extended the file system mounted on /u01 because it lacked the space for the out of place upgrade. As I use Logical Volume Management this was fairly easy to do.
  2. Shut down my database instances running from the Oracle Database home, but left the Grid Infrastructure running from the 11.2.0.1 home
  3. Made sure that the 11.2.0.1 JULY PSU is present in the 11.2.0.1 Grid Infrastructure home IE 11.2.0.1.2
  4. Installed the Grid Infrastructure for a Standalone Server into a new home
  5. Executed the rootupgrade.sh script as instructed to by the installer.
  6. After this script finished, the Grid Infrastructure was running from the new home, and the inventory had been updated to reflect the change in home
  7. The rootupgrade.sh script also modified the entry in /etc/oratab for the ASM instance, and the files in /etc/oracle used to point to the Oracle Local Repository file (OLR) which had been moved and updated into the new home
  8. After rebooting my node however i discovered problems cause by bug 10167269. The rootupgrade.sh script failed to replace the /etc/init.d.init.ohasd and /etc/init.d/ohasd scripts and the scripts used to start the ohasd “lower stack” were still referring to the old Oracle GI home.
  9. I manually modified the scripts to refer to the new Oracle Home to work around the problem and then the ohasd stack started properly.
  10. Once I was satisfied that the Grid Infrastructure was working properly, I removed the old Oracle home.
  11. At this point 11.2.0.2 Grid Infrastructure was running and i was able to use it to manage my 11.2.0.1 Oracle database
  12. I then installed  11.2.0.2 Database home “Out-of-Place” into a new home, having selected the option to upgrade my database in the old home
  13. I executed rootupgrade.sh which updated the inventory and copied and modified other required files for the home
  14. Database Upgrade Assistant then ran to complete the upgrade inside the database
  15. I now had an 11.2.0.2 Database and Database home, managed by the 11.2.0.2 Grid Infrastructure
  16. Finally, when I was convinced that it was all working including after a node reboot, I removed the old database home.

Some observations during and after the upgrade:

  • Startup of the 11.2.0.2 Grid Infrastructure takes longer than 11.2.0.1.  This may be due to my workaround for bug 10167269 but I need more time to investigate this.
  • Note 1230405.1 suggests the manual modification of the scripts to refer to the new location as I did in step 8 listed above
  • The Oracle Universal Installer also supports installation of critical patch updates,  updates for system requirements and other important updates. I tested this by supplying my Oracle Support credentials and it found no updates to 11.2.0.2 but this was not surprising on the day after release.
  • The “Download Software Updates” feature is now the first step in the Universal Installer followed possibly by “Apply Software Updates” followed by the “Installation Option” section.
  • The elapsed time for this work was about 3 hours including the manual workaround due to the bug.
  • As has been pointed out by some, the documentation was missing some details and the README for 11.2.0.2 did not have a step by step set of instructions at the time i loaded the product.

Conclusion

in general the out of place upgrade was easy to do provides a good tradeoff between availability and the use of extra disk space for a period of time. Now that the technote with a workaround for the bug is available you should be confident trying an “Out -of-Place” upgrade.

Have a go!
Joel

11/10/2010

Posted in Oracle | 4 Comments »