• August 11, 2005 11 Aug'05

    Why are patches so complicated?

    One of the issues that I cannot understand is why applying a patch/upgrade is still such a lengthy and complicated process. Can't Oracle simplify things and make the updates/patches more intelligent?  Continue Reading

  • August 11, 2005 11 Aug'05

    Doubts about applying and removing patches

    I have some doubts about applying patches. I have Oracle databases. Once I tried to apply patches and got some errors, and I was not able to rollback to the previous stage of the database. So I am afraid that if I apply patches it will ...  Continue Reading

  • August 11, 2005 11 Aug'05

    Speeding up the startup migrate process during upgrade

    We are not allowed any downtime in order to upgrade from Oracle to Oracle Our plan is to install Oracle in a separate Oracle Home and patch it to Oracle on each node in the cluster. We would then shut down the active ...  Continue Reading

  • August 11, 2005 11 Aug'05

    How do I know if I really need a patch?

    When I asked Oracle about a specific vulnerability in the latest advisory, the answer was simply a rehash of the matrix. I wanted to understand if our particular situation is actually vulnerable since we do not use the feature in question. How do ...  Continue Reading

  • August 11, 2005 11 Aug'05

    Failure during patch installation

    I am trying to apply Patch Release 2 ( Patch Set 5 for Windows (32-Bit), but the OUI is failing in the middle, throwing an exception that one of the services is still running, although I have shut down the Oracle9i database and stopped all...  Continue Reading

  • August 11, 2005 11 Aug'05

    Upgrading on a production server

    I am working as a DBA on a production server and we are using, so I would like to upgrade. Can I upgrade to 9i or 10g, and can I convert it into RAC?  Continue Reading

  • August 11, 2005 11 Aug'05

    Converting to a locally managed tablespace

    I recall during a recent course being told there is a problem when upgrading to a 9i database and making the system tablespace locally managed when the previous version was not. The only thing I can remember is that it makes the tablespace READ ONLY...  Continue Reading

  • August 11, 2005 11 Aug'05

    Upgrading from Oracle 7.3.4 to 10g

    What is the easiest way to upgrade from Oracle 7.3.4 to Oracle 10g? Are there any direct upgrade tools/scripts provided by Oracle? If so, are there any risks, and what are they?  Continue Reading

  • August 11, 2005 11 Aug'05

    Errors after patch installation

    I was trying to upgrade from Oracle to so I applied a patch. But after applying, when I tried "startup migrate" it threw error invalid options and "catpatch.sql" was missing. It is still showing, but when I tried ...  Continue Reading

  • August 11, 2005 11 Aug'05

    Post-installation steps after applying patches

    After Patch8 is on and I create a new database, do I then have to do the post-install steps for that newly created db? Also, if I have only one Oracle home but multiple databases, can some databases continue to run okay if I don't do the ...  Continue Reading