Spatial java classes invalid after upgrade

(Doc ID 399187.1)

Last updated on AUGUST 31, 2017

Applies to:

Oracle Spatial and Graph - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Oracle Spatial and Graph - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 01-Apr-2015***

Symptoms

The spatial java classes were invalid after running catupgrd.sql to upgrade 9.2.0.6 database to 10.2.0.2.

Since the applications are using spatial, reinstalling spatial is not a option.

select comp_id,version,status from dba_registry; 
 COMP_ID VERSION STATUS 

------------------------------ 
XDB 10.2.0.2.0 VALID 

CONTEXT 10.2.0.2.0 VALID 

SDO 10.2.0.2.0 INVALID 

ORDIM 10.2.0.2.0 VALID 

CATALOG 10.2.0.2.0 VALID 

CATPROC 10.2.0.2.0 VALID 

RAC 10.2.0.2.0 INVALID 

JAVAVM 10.2.0.2.0 VALID 

XML 10.2.0.2.0 VALID 

CATJAVA 10.2.0.2.0 VALID
SQL> select owner,object_name,object_type from dba_objects where status <> 'VALID' order by owner,object_type; 



OWNER OBJECT_NAME OBJECT_TYPE 

------------------------------ --------------------------------------



MDSYS oracle/spatial/network/AStar JAVA CLASS 

MDSYS /52be9f77_AllShortestPaths JAVA CLASS 

MDSYS /7a490022_AnalysisInfo JAVA CLASS 

MDSYS /f10c86eb_AnalysisInfoImpl JAVA CLASS 

MDSYS oracle/spatial/network/Bfs JAVA CLASS 

MDSYS /88bab003_ConvexHull JAVA CLASS 

MDSYS /a179f687_CostNode JAVA CLASS 

MDSYS oracle/spatial/network/Dfs JAVA CLASS 

MDSYS /562bfaec_Dijkstra JAVA CLASS 

MDSYS /9b99493a_DistanceFunction JAVA CLASS 

MDSYS /f877485d_FlowLink JAVA CLASS 

MDSYS /bfb98d82_FlowNetwork JAVA CLASS 

MDSYS /d92bb36d_FlowNode JAVA CLASS 

MDSYS /1a68c692_GeometryMetadata JAVA CLASS 

MDSYS /91c0cefa_GoalNode JAVA CLASS 

MDSYS /5add49ef_GraphLayout JAVA CLASS 

MDSYS oracle/spatial/network/KDTree JAVA CLASS 

MDSYS oracle/spatial/network/KMeans JAVA CLASS 

MDSYS oracle/spatial/network/Kruskal JAVA CLASS 

MDSYS oracle/spatial/network/Link JAVA CLASS 

MDSYS /56edd96a_LinkImpl JAVA CLASS 

MDSYS /7f9770f0_LinkTypeConstraint JAVA CLASS 

MDSYS oracle/spatial/network/MBR JAVA CLASS 

MDSYS oracle/spatial/network/MBRImpl JAVA CLASS 

MDSYS oracle/spatial/network/MDPoint JAVA CLASS 

MDSYS /b54e1e2_MDPointImpl JAVA CLASS 

MDSYS oracle/spatial/network/NetNode JAVA CLASS 

MDSYS oracle/spatial/network/Network JAVA CLASS 

MDSYS /af2b5ee0_NetworkAdapter JAVA CLASS 

MDSYS /afbfad1c_NetworkAdapterSDO JAVA CLASS 

MDSYS /1d3641da_NetworkCache JAVA CLASS 

MDSYS /d1026c84_NetworkCacheItem JAVA CLASS 

MDSYS /b118aca3_NetworkConstraint JAVA CLASS 

MDSYS /5e695b59_NetworkFactory JAVA CLASS 

MDSYS /b0bf4886_NetworkImpl JAVA CLASS 

MDSYS /58cdebe3_NetworkManager JAVA CLASS 

MDSYS /1fd3523c_NetworkMetadata JAVA CLASS 

MDSYS /387504d3_NetworkMetadataImpl JAVA CLASS 

MDSYS /7efa21f0_NetworkPartition JAVA CLASS 

MDSYS /f3abaa0f_NetworkUtility JAVA CLASS 

MDSYS oracle/spatial/network/Node JAVA CLASS 

MDSYS /b1a193de_NodeImpl JAVA CLASS 

MDSYS oracle/spatial/network/OraTst JAVA CLASS 

MDSYS /188738d2_PartitionKmeans JAVA CLASS 

MDSYS /dcaeccf3_PartitionManager JAVA CLASS 

MDSYS /bc76ba38_PartitionMultilevel JAVA CLASS 

MDSYS /207ff2ab_PartitionPairMyInteg JAVA CLASS 

MDSYS /e34598e8_PartitionPair JAVA CLASS 

MDSYS oracle/spatial/network/Path JAVA CLASS 

MDSYS /dde577b3_PathImpl JAVA CLASS 

MDSYS /c7f46be2_RandomGraph JAVA CLASS 

MDSYS /3db48bb6_ShortestPathAStar JAVA CLASS 

MDSYS /b2a4dad7_SystemConstraint JAVA CLASS 

MDSYS oracle/spatial/network/TspPath JAVA CLASS 

MDSYS /48a4e345_UserDataIO JAVA CLASS 

MDSYS /dd8d0896_XMLAdapter1 JAVA CLASS 

MDSYS /e9a7519a_XMLAdapterDatabaseMe JAVA CLASS 

MDSYS /22e5e947_XMLAdapter JAVA CLASS 

MDSYS /97736ae5_linkComparator JAVA CLASS 

MDSYS /16e6a92f_nodeCostComparator JAVA CLASS 

MDSYS /4d90f23d_nodeDegreeComparator JAVA CLASS 

MDSYS /dcb9dbfc_nodeIncLnkCostCompar JAVA CLASS 

MDSYS oracle/spatial/topo/CompGeom JAVA CLASS 

MDSYS oracle/spatial/topo/Edge JAVA CLASS 

MDSYS /3f81fc50_TopoFrame1 JAVA CLASS 

MDSYS oracle/spatial/topo/TopoFrame JAVA CLASS 

MDSYS /d0ab1c33_TopoMapAlongEdgeComp JAVA CLASS 

MDSYS /77cd6977_TopoMapAlongSegmentC JAVA CLASS 

MDSYS /2b248550_TopoMapEdgeSplit JAVA CLASS 

MDSYS /7f552369_TopoMapInt JAVA CLASS 

MDSYS /c48c78e0_TopoMapPointStackEnt JAVA CLASS 

MDSYS /4dc30889_TopoMapSmartPoint JAVA CLASS 

MDSYS oracle/spatial/topo/TopoMap JAVA CLASS 

MDSYS /8a634753_TopoPreprocess JAVA CLASS 

MDSYS /324fdcae_TopoMapWrapper JAVA CLASS 

MDSYS /fb37c292_NetworkWrapper JAVA CLASS 

PUBLIC oracle/spatial/network/Link SYNONYM 

PUBLIC /56edd96a_LinkImpl SYNONYM 

PUBLIC /7f9770f0_LinkTypeConstraint SYNONYM 

PUBLIC oracle/spatial/network/MBR SYNONYM 

PUBLIC oracle/spatial/network/MBRImpl SYNONYM 

PUBLIC oracle/spatial/network/MDPoint SYNONYM 

PUBLIC /b54e1e2_MDPointImpl SYNONYM 

PUBLIC oracle/spatial/network/NetNode SYNONYM 

PUBLIC oracle/spatial/network/Network SYNONYM 

PUBLIC /af2b5ee0_NetworkAdapter SYNONYM 

PUBLIC /afbfad1c_NetworkAdapterSDO SYNONYM 

PUBLIC /1d3641da_NetworkCache SYNONYM 

PUBLIC /d1026c84_NetworkCacheItem SYNONYM 

PUBLIC /b118aca3_NetworkConstraint SYNONYM 

PUBLIC /5e695b59_NetworkFactory SYNONYM 

PUBLIC /b0bf4886_NetworkImpl SYNONYM 

PUBLIC /58cdebe3_NetworkManager SYNONYM 

PUBLIC /1fd3523c_NetworkMetadata SYNONYM 

PUBLIC /387504d3_NetworkMetadataImpl SYNONYM 

PUBLIC /7efa21f0_NetworkPartition SYNONYM 

PUBLIC /f3abaa0f_NetworkUtility SYNONYM 

PUBLIC oracle/spatial/network/Node SYNONYM 

PUBLIC /b1a193de_NodeImpl SYNONYM 

PUBLIC oracle/spatial/network/OraTst SYNONYM 

PUBLIC /188738d2_PartitionKmeans SYNONYM 

PUBLIC /dcaeccf3_PartitionManager SYNONYM 

PUBLIC /bc76ba38_PartitionMultilevel SYNONYM 

PUBLIC /207ff2ab_PartitionPairMyInteg SYNONYM 

PUBLIC /e34598e8_PartitionPair SYNONYM 

PUBLIC oracle/spatial/network/Path SYNONYM 

PUBLIC /dde577b3_PathImpl SYNONYM 

PUBLIC /c7f46be2_RandomGraph SYNONYM 

PUBLIC /3db48bb6_ShortestPathAStar SYNONYM 

PUBLIC /b2a4dad7_SystemConstraint SYNONYM 

PUBLIC oracle/spatial/network/TspPath SYNONYM 

PUBLIC /48a4e345_UserDataIO SYNONYM 

PUBLIC /dd8d0896_XMLAdapter1 SYNONYM 

PUBLIC /e9a7519a_XMLAdapterDatabaseMe SYNONYM 

PUBLIC /22e5e947_XMLAdapter SYNONYM 

PUBLIC /97736ae5_linkComparator SYNONYM 

PUBLIC /16e6a92f_nodeCostComparator SYNONYM 

PUBLIC /4d90f23d_nodeDegreeComparator SYNONYM 

PUBLIC /dcb9dbfc_nodeIncLnkCostCompar SYNONYM 

PUBLIC oracle/spatial/topo/CompGeom SYNONYM 

PUBLIC oracle/spatial/topo/Edge SYNONYM 

PUBLIC /3f81fc50_TopoFrame1 SYNONYM 

PUBLIC oracle/spatial/topo/TopoFrame SYNONYM 

PUBLIC /d0ab1c33_TopoMapAlongEdgeComp SYNONYM 

PUBLIC /77cd6977_TopoMapAlongSegmentC SYNONYM 

PUBLIC /2b248550_TopoMapEdgeSplit SYNONYM 

PUBLIC /7f552369_TopoMapInt SYNONYM 

PUBLIC /c48c78e0_TopoMapPointStackEnt SYNONYM 

PUBLIC /4dc30889_TopoMapSmartPoint SYNONYM 

PUBLIC oracle/spatial/topo/TopoMap SYNONYM 

PUBLIC /8a634753_TopoPreprocess SYNONYM 

PUBLIC /324fdcae_TopoMapWrapper SYNONYM 

PUBLIC /fb37c292_NetworkWrapper SYNONYM 

PUBLIC oracle/spatial/network/AStar SYNONYM 

PUBLIC /52be9f77_AllShortestPaths SYNONYM 

PUBLIC /7a490022_AnalysisInfo SYNONYM 

PUBLIC /f10c86eb_AnalysisInfoImpl SYNONYM 

PUBLIC oracle/spatial/network/Bfs SYNONYM 

PUBLIC /88bab003_ConvexHull SYNONYM 

PUBLIC /a179f687_CostNode SYNONYM 

PUBLIC oracle/spatial/network/Dfs SYNONYM 

PUBLIC /562bfaec_Dijkstra SYNONYM 

PUBLIC /9b99493a_DistanceFunction SYNONYM 

PUBLIC /f877485d_FlowLink SYNONYM 

PUBLIC /bfb98d82_FlowNetwork SYNONYM 

PUBLIC /d92bb36d_FlowNode SYNONYM 

PUBLIC /1a68c692_GeometryMetadata SYNONYM 

PUBLIC /91c0cefa_GoalNode SYNONYM 

PUBLIC /5add49ef_GraphLayout SYNONYM 

PUBLIC oracle/spatial/network/KDTree SYNONYM 

PUBLIC oracle/spatial/network/KMeans SYNONYM 

PUBLIC oracle/spatial/network/Kruskal SYNONYM 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms