-
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?
-
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.
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|