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

Thread: upgrade oracle database from 9.2.0.4 to 9.2.0.6

  1. #1
    Join Date
    Mar 2006
    Posts
    2

    upgrade oracle database from 9.2.0.4 to 9.2.0.6

    Hi everyone,

    Environment: Suse Linux Enterprise edition 9.0

    i install the patchset 9.2.0.6 in the oracle database 9.2.0.4 by following
    Apply upgrade to oracle 9.2.0.6. After i migrate the database, i check the version with sql command "select comp_name,version,status from dba_registry". The versions are mostly 9.2.0.4.

    Is it normal? Should the version number changes to 9.2.0.6?

  2. #2
    Join Date
    Apr 2003
    Location
    Gourock, Scotland
    Posts
    102
    What results are listed in patch.log?
    If I have to choose between two evils, I always like to choose the one I haven't tried yet.

  3. #3
    Join Date
    Jan 2002
    Posts
    7
    hi
    i think you missed out these sqls

    @?/rdbms/admin/catpatch.sql
    @?/rdbms/admin/utlrp.sql

    after this check for the invalid objects in dba_registry

  4. #4
    Join Date
    Mar 2006
    Posts
    2
    I have done

    @?/rdbms/admin/catpatch.sql
    @?/rdbms/admin/utlrp.sql

    My pathch.log result:

    TIMESTAMP
    --------------------------------------------------------------------------------

    DOC> END Component Patches */

    COMP_NAME STATUS VERSION
    ----------------------------------- ----------- ----------
    Oracle9i Catalog Views VALID 9.2.0.4.0
    Oracle9i Packages and Types VALID 9.2.0.4.0
    Oracle Workspace Manager VALID 9.2.0.1.0
    JServer JAVA Virtual Machine VALID 9.2.0.4.0
    Oracle XDK for Java VALID 9.2.0.6.0
    Oracle9i Java Packages VALID 9.2.0.4.0
    Oracle interMedia VALID 9.2.0.4.0
    Spatial VALID 9.2.0.4.0
    Oracle Text VALID 9.2.0.4.0
    Oracle XML Database VALID 9.2.0.4.0
    Oracle Ultra Search VALID 9.2.0.4.0

    COMP_NAME STATUS VERSION
    ----------------------------------- ----------- ----------
    Oracle Data Mining VALID 9.2.0.4.0
    OLAP Analytic Workspace UPGRADED 9.2.0.4.0
    Oracle OLAP API UPGRADED 9.2.0.4.0
    OLAP Catalog VALID 9.2.0.4.0
    DOC>================================================================
    DOC> The above query lists the components in the database, along
    DOC> with their current patchset version and status.
    DOC>================================================================
    DOC>*/
    DOC> END CATPATCH.SQL */

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