Home » RDBMS Server » Server Administration » Invalid component on 10.2 database(2 Merged) (10.2,solaris 10 sparc(64bit))
Invalid component on 10.2 database(2 Merged) [message #539027] Tue, 10 January 2012 20:20 Go to next message
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 #539029 is a reply to message #539027] Tue, 10 January 2012 20:44 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>could you please share with me your valuable advice?

If you are not doing OLAP, then I would ignore it.
Re: Invalid component on 10.2 database [message #539033 is a reply to message #539029] Tue, 10 January 2012 21:57 Go to previous messageGo to next message
mmee
Messages: 38
Registered: July 2007
Member

Thks..

But why this happened? because i could not find any invalid objects for that schema? also i want to make it everything valid before upgradation.
Re: Invalid component on 10.2 database [message #539035 is a reply to message #539033] Tue, 10 January 2012 23:17 Go to previous message
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
Previous Topic: multiple log.xml files
Next Topic: ORA-06544: PL/SQL: internal error, arguments: [ph2_cly out of bounds in PH2POP.], [0], [1240], [], [
Goto Forum:
  


Current Time: Fri Nov 29 04:45:27 CST 2024