The status of OLAP Catalog in dba_registry is invalid. You can check the status of OLAP components in dba_registry using the following query:
SQL> col comp_name for a20 SQL> select comp_name, status, version 2 from DBA_REGISTRY 3 where comp_name= 'OLAP Catalog'; COMP_NAME STATUS VERSION -------------------- ----------- ----------------- OLAP Catalog INVALID 10.2.0.3.0
Cause of the Problem
The problem happened due to either Oracle database upgrade bug or OLAP Option has not been installed properly.
Solution of the Problem
1. Try re-compiling the Invalid Objects by running the following SQL script:
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sqlThen, check the status of OLAP Catalog in dba_registry by running following script:
SQL> select COMP_ID,COMP_NAME,VERSION,STATUS from dba_registry where COMP_NAME LIKE '%OLAP%';
2. If Step 1 does not make OLAP Catalog Valid, then run the following scripts:
SQL> SPOOL olap_validate.log SQL> @$ORACLE_HOME/olap/admin/amdrelod.sql SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql SQL> SPOOL OFFAfter you run these scripts review the spool output olap_validate.log file to check whether there are any errors while executing the script.
3. Check for the invalid OLAP objects under SYS schema which are valid under OLAPSYS schema by running the following query and delete these invalid OLAP objects from SYS schema.
SQL> select a.object_name,a.object_type,a.status "SYS",b.status "OLAPSYS" from dba_objects a, dba_objects b where a.owner = 'SYS' and b.owner = 'OLAPSYS' and a.object_name = b.object_name and a.object_type = b.object_type and a.status <> 'VALID' and b.status <> 'INVALID' order by a.status;4. Verify the status of OLAP Catalog in dba_registry as follows:
SQL> select COMP_ID,COMP_NAME,VERSION,STATUS from dba_registry where COMP_NAME LIKE '%OLAP%;