Oracle Database Discussions

Gurus,

last night, i tried to patch 9.2.0.4 to 9.2.0.8, solaris 10 64-bit on single instance
$ uname -a
SunOS DB 5.10 Generic_118833-17 sun4u sparc SUNW,Sun-Fire-V890

SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for Solaris: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production


actually, the version of oracle database component are :

SQL> select comp_name, version,status from dba_registry;

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


i have read manual documentation for patching database into 9.2.0.8 and there was no left
The failed action was :

SQL> @?/rdbms/admin/catpatch.sql

and it took so long time to complete...
i was not given enough time to patch the database by my client, so that i did call back
* when i check for the invalid objects, i found 999 invalid objects
is it the reason ?

Gurus, i really need your help
(sorry my english is not really good)



regards,
---------------------
abip

Message was edited by:
abip