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