Invalid component on 10.2 database(2 Merged) [message #539027] |
Tue, 10 January 2012 20:20 |
mmee
Messages: 38 Registered: July 2007
|
Member |
|
|
Hi team,
we are doing database upgradation to 11.2 from 10.2,i have found two invalid components but i couldn't find any invalid objects for those related components. pls find the output ...
SQL> set pagesize 500
SQL> set linesize 100
SQL> select substr(comp_name,1,40) comp_name, status, substr(version,1,10) version from
dba_registry order by comp_name; 2
COMP_NAME STATUS VERSION
---------------------------------------- ----------- ----------
JServer JAVA Virtual Machine VALID 10.2.0.3.0
OLAP Analytic Workspace INVALID 10.2.0.3.0
OLAP Catalog INVALID 10.2.0.3.0
Oracle Data Mining VALID 10.2.0.3.0
Oracle Database Catalog Views VALID 10.2.0.3.0
Oracle Database Java Packages VALID 10.2.0.3.0
Oracle Database Packages and Types VALID 10.2.0.3.0
Oracle Enterprise Manager VALID 10.2.0.3.0
Oracle Expression Filter VALID 10.2.0.3.0
Oracle OLAP API VALID 10.2.0.3.0
Oracle Rules Manager VALID 10.2.0.3.0
Oracle Text VALID 10.2.0.3.0
Oracle Workspace Manager VALID 10.2.0.1.0
Oracle XDK VALID 10.2.0.3.0
Oracle XML Database VALID 10.2.0.3.0
Oracle interMedia VALID 10.2.0.3.0
Spatial VALID 10.2.0.3.0
17 rows selected.
SQL> select substr(object_name,1,40) object_name,substr(owner,1,15) owner,object_type from
dba_objects where status='INVALID' order by owner,object_type; 2
no rows selected
SQL> select owner,object_type,count(*) from dba_objects where status='INVALID' group by
owner,object_type order by owner,object_type ; 2
no rows selected
could you please share with me your valuable advice?
|
|
|
|
|
Re: Invalid component on 10.2 database [message #539035 is a reply to message #539033] |
Tue, 10 January 2012 23:17 |
|
Michel Cadot
Messages: 68716 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Quote: i could not find any invalid objects for that schema?
What "that" is?
Quote:i want to make it everything valid before upgradation
Execute (as SYS) $ORACLE_HOME/rdbms/admin/olap.sql SYSAUX <temp tablespace>
If there is any error then post them.
Regards
Michel
|
|
|