Hi,
I have been performing an upgarde of Oracle RDBMS 11.2.0.3 to Oracle RDBMS 12cR1 non-container.
After the upgrade:
1)
During the upgrade performed with the DBUA, I came across this error:
SDO component upgrade error
PLS-00539: subprogram
VERTEX_TYPE is declared in an objec type body and must...
This type seems to belong to Oracle Spatial & Graph feature, but I do not know if it is a "standard" feature ir a customized fearture.
Does someone has an idea what I should do with it?
2)
Starting with Oracle Database 12c, OLAP Catalog component is desupported, so I have run the script catnoamd.sql
to remove this component.
3)
The preupgrade.sql script mentions teh following:
INFORMATION: --> There are existing Oracle components that will NOT be
upgraded by the database upgrade script. Typically, such components
have their own upgrade scripts, are deprecated, or obsolete.
Those components are:
OLAP Catalog,OWBe.
I have already run the script catnoamd.sql.
What should I do regarding the above information?
4) At the end, I end up with the following invalid objects:
Owner Object Name Object Type
.
MDSYS VERTEX_TYPE TYPE BODY
OLAPSYS ALL$OLAP2UFACT_LEVEL_USES VIEW
OLAPSYS ALL$OLAP2_FACTTBLFCTMAPS VIEW
OLAPSYS ALL$OLAPMR_FACTTBLFCTMAPS VIEW
OLAPSYS CWM$EXPORT PACKAGE BODY
OLAPSYS CWM2_OLAP_DELETE PACKAGE BODY
OLAPSYS CWM2_OLAP_EXPORT PACKAGE BODY
OLAPSYS CWM2_OLAP_METADATA_REFRESH PACKAGE BODY
OLAPSYS CWM2_OLAP_MR_SECURITY_INIT PACKAGE BODY
OLAPSYS CWM2_OLAP_OLAPAPI_ENABLE PACKAGE BODY
OLAPSYS CWM2_OLAP_VERIFY_ACCESS PACKAGE BODY
OLAPSYS DBA$OLAP2UFACT_LEVEL_USES VIEW
OLAPSYS DBA$OLAP2_FACTTBLFCTMAPS VIEW
OLAPSYS DBA$OLAPMR_FACTTBLFCTMAPS VIEW
OLAPSYS DBMS_AWM PACKAGE BODY
OLAPSYS DBMS_ODM PACKAGE BODY
OLAPSYS ODM$OLAP2UFACT_LEVEL_USES VIEW
OLAPSYS OLAPDIMVIEW PACKAGE BODY
OLAPSYS OLAPFACTVIEW PACKAGE BODY
PL/SQL procedure successfully completed.
They all belong to the OLAP feature except for the first one.
Giving the fact that OLAP Catalog (that was not used) is not supported in 12c, what shall I do with these?
5)
The DBUA upgraded APEX from 3.2 to 4.2.
What should the upgrade has done if APEX was already 4.2 or even 5.0?
Thanks by advance for sharing your experience and tips.
Kind Regards