DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Patch

  1. #1
    Join Date
    Jul 2001
    181 Patch

    I have to patch from to, has anyone applied this patch, If so are they any problems when applying it. I must be honest I haven't patched a DB before and would like to find out how to perform this task?

    Thanking you advance

  2. #2
    Join Date
    Feb 2000
    Patches usually come with installation instrunctions in readme file read it carefully, it also lists all restrictions, implications etc.
    And yes always take a backup before applying the patch.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Oct 2000
    1,185 or

    I had some problems with a memory leak in until i patched it to level

    Have a look at metalink for instructions.

    Good luck.
    David Knight
    OCP DBA 8i, 9i, 10g

  4. #4
    Join Date
    Dec 2000
    Follow the steps given below. Go through with patch readme document also.

    1. Shutdown the database in normal mode.
    2. Perform a physical backup of the database, if possible oracle software also.
    3. Stop all the other services of the oracle that are running on the server. Issue the command and check.

    $ ps -ef |grep oracle

    ensure that there are no services of oracle are running.

    4. Unzip the tar file, untar the patch bundle.

    5. Start the oracle Universal installer.

    6. Give the path of the product.jar file of the patch bundle. Continue as the screen progress. Ensure that, there is no errors will the patch is linking.
    7. After the installation is successfull then start the database and run the following scripts.
    1. Catalog.sql
    2. Catproc.sql
    3. Catexp.sql
    if u r running replication feature run Catrep.sql

  5. #5
    Join Date
    Mar 2004

    Is it required to patch to ( or or anything else) to upgrade to 10g?

    Thanks in advance

  6. #6
    Join Date
    Oct 2002
    This might be a good time to read the upgrade document available on technet.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.