Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We have an Oracle RAC production environment with primary and secondary DB. Our DBA has asked to update oracle version from 11.2.0.1.0(64 bit) to 11.2.0.3(64 bit) with patch 6880880,10404530,16803769 and 16803775.

In our current database we have Shared storage,ACL settings, security settings,Gateway/Heteregenous connectivity, Dataguard, Data broker, Backup policy and Oracle Client installed on other machines.

DBA has estimated that he need to do installation, settings from scratch and test.. So, when the version is updated, do we really need to reconfig and install everything (Shared storage,ACL settings, security settings,Gateway/Heteregenous connectivity, Dataguard, Data broker, Backup policy and Oracle Client installed on other machines) ?? If yes its fine, but no then I need to justify it.

I can understand testing would be required..

share|improve this question

migrated from stackoverflow.com Aug 12 '13 at 8:10

This question came from our site for professional and enthusiast programmers.

    
Could you elaborate situation a bit? What steps are planned and which step is not clear? –  Mindaugas Riauba Aug 12 '13 at 15:45
    
I've deleted my answer after your edit, but then I don't know what are you asking for. What do you mean with "do we really need to perform all these again"? What "all these"? The test? the whole upgrade process? the shared/ACL/security/gateway/dataguard/RAC/... settings? –  vegatripy Aug 12 '13 at 16:02
    
Do we need to perform the shared/ACL/security/gateway/dataguard/RAC/... settings –  paramupk Aug 12 '13 at 23:28

1 Answer 1

You should be able to test this patchset in a non-production environment with a clone of your current production server. If a separate server is not available, the same server may be used. The 11.2.0.3 patchset is a completely new install. Your database(s) that use the 11.2.0.1 will be unaffected and continue to use the current install until they are upgraded AND updated to use the new environment (typically with the tool DBUA).

Sometimes, those things listed above can break, so yes, testing is required. It depends on your comfort level and time-to-resolution on troubleshooting issues. Once the new instance is made available in your testing environment, test out your application thoroughly, then schedule the update for production.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.