Some components are INVALID after database upgrade.

  • From: francisco.martinez@xxxxxxxxxxxxxx
  • To: ora-apps-dba@xxxxxxxxxxxxx
  • Date: Thu, 19 Apr 2007 10:54:42 -0500 (CDT)

Hi partners,

I am almost finishing with Note: 216550.1 "Interoperability Notes Oracle
Applications Release 11i with Oracle9i Release 2 (9.2.0)" steps to
accomplish an upgrade from 8.1.7.4 to 9.2.0.8, but after executing
$ORACLE_HOME/rdbms/admin/u0801070.sql script some components are invalid.

COMP_NAME                                     VERSION                     
  STATUS
---------------------------------------------
------------------------------ -----------
Oracle9i Catalog Views                        9.2.0.8.0                   
  VALID
Oracle9i Packages and Types                   9.2.0.8.0                   
  VALID
JServer JAVA Virtual Machine                  9.2.0.8.0                   
  VALID
Oracle9i Java Packages                        9.2.0.8.0                   
  VALID
Oracle XDK for Java                           9.2.0.10.0                  
  VALID
Oracle Text                                   9.2.0.8.0                   
  VALID
Oracle9i Real Application Clusters            9.2.0.8.0                   
  INVALID
Oracle Spatial                                8.1.6.0.0 DEVELOPMENT       
  INVALID
Oracle interMedia                             8.1.6.0.0                   
  INVALID
Oracle OLAP API                               9.2.0.8.0                   
  UPGRADED
OLAP Catalog                                  9.2.0.8.0                   
  VALID

What can I do to validate them?

Thanks in advance.

Kind regards,

Francisco Mtz.


Other related posts: