You receive the following error at the end of the olap.sql script:
SQL> @?/olap/admin/olap.sql SYSAUX TEMP; SQL> execute cwm2_olap_metadata_refresh.mr_refresh; BEGIN cwm2_olap_metadata_refresh.mr_refresh; END; * ERROR at line 1: ORA-04063: package body "OLAPSYS.CWM2_OLAP_METADATA_REFRESH" has errors ORA-06508: PL/SQL: could not find program unit being called: "OLAPSYS.CWM2_OLAP_METADATA_REFRESH" ORA-06512: at line 1
Solution:
Drop the OLAPSYS user and rerun the script:
$ sqlplus '/ as sysdba' SQL> drop user OLAPSYS cascade SQL> @?/olap/admin/olap.sql SYSAUX TEMP; SQL> @?/rdbms/admin/utlrp.sql
Sources: Doc ID 726253.1 "Errors: ORA-04063, ORA-06508, ORA-06512 When Adding OLAP Using the Script 'olap.sql SYSAUX TEMP;'"
No comments:
Post a Comment