Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2002
    Posts
    165

    Unanswered: Patch number 9.2.0.3

    I am dumb,so-without patch number i cannot find patch for download from metalink.So,i need patch number of patch 9.2.0.3 for Oracle Server.
    Thanks a lot,Zvonimir

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    How come you can't find patch you need?
    - go to Metalink
    - select "Patch & Updates" tab
    - go to "Simple search"
    . - search by "Product and Family"
    . - click the "List of values" button
    . - select what you want to search (for example, "Database and tools")
    . - enter what you're looking for (for example, "database")
    . - select one result (for example, "Oracle Database Family")
    . - choose the Release you are interested in (for example, "Oracle 9.2.0.3")
    . - choose patch type ("Patch")
    . - choose platform or language (for example, "Microsoft Windows (32-bit)")
    . - click the "Go" button

    You'll probably get more than one result - choose the one your need (could it be patch #3237426?).

  3. #3
    Join Date
    Jan 2002
    Posts
    165
    Thanks for advice,I download patch 3237426,but I don't find any product.jar.
    Can you tell me how can I start to install this patch?

    Thanks a lot!!!

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    on the same page as the patch, there is a link to installation instructions.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  5. #5
    Join Date
    Jan 2002
    Posts
    165
    Thanks for advice,but on README.TXT we find only this instructions:

    Patch Installation Instructions:
    # --------------------------------
    # To apply the patch, make sure ORACLE_HOME is set to the correct Oracle
    # Home which needs to be patched and then set your current directory to
    # the directory where the patch is located e.g. cd 3237426.
    # OPatch is not included in this patch.
    # Refer to the following link for details on Perl and OPatch:
    #
    #http://metalink.oracle.com/metalink/...cument?p_datab
    #ase_id=NOT&p_id=189489.1

    We don't have Perl, please give us more details about this installation.
    We don't see any setup.exe or products.jar in this "installation 9.2.0.3 Patch 3 (bug 3237426)"

  6. #6
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    The assumption is that you have some patching experence. A non-dba should not be patching a database. They won't know what to do if something bad happens. If this is a production database and you are not a DBA, do NOT!!!! perform the patching without a qualified DBA. If you don't mind loosing the database, go for it. That being said, try the following.


    1)Untar or unzip the patch file into it's own EMPTY directory.
    2) shut down your database. If you are on windows make sure that ALL oracle services are shutdown.
    3) Backup the server!!!. If some thing goes wrong, you can restore and get back to where you were.
    4) Set ORACLE_HOME to the directory that contains your current database software. It should already be set if you are logged on as the oracle user, which you MUST be.
    5) change your directory to the directory that you unzipped/untared your patch in.
    6) Run the Oracle installer that is part of the patch, do not use the one already on the server.
    7) When it finishes, run any post installation instructions that are in the read me.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  7. #7
    Join Date
    Jul 2003
    Posts
    2,296
    I suggest patching to 9.2.0.7

    Why patch to 9203? If anything, 9206-9207 is more stable.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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