ELOC ADG -- Select SDO_CS from standby DB gets errors ORA-00603 ORA-16000

(Doc ID 2261523.1)

Last updated on NOVEMBER 01, 2017

Applies to:

Oracle Spatial and Graph - Version to 12.2 [Release 11.2 to 12.2]
Information in this document applies to any platform.


The following query is successful in a Primary database, but failed in ADG.

select * from (select id,
  sdo_nn_distance(1) distance,
  sdo_cs.transform(shape, 4326) shape,
  s.shape.sdo_point.x x,
  s.shape.sdo_point.y y,
  row_number() over (order by sdo_nn_distance(1), date_survey_completed desc) as rownumber from survey s
 where org_system='WORKBENCH' and sdo_nn(s.shape,
  sdo_point_type(-104.869326, 39.567272, null),
  'sdo_batch_size=10 distance=' || 5280 || ' unit=foot',
1) = 'TRUE') where rownumber <= 1;

ORA-00603: ORACLE server session terminated by fatal error
ORA-16000: database open for read-only access
ORA-06512: at "MDSYS.SDO_CS", line 114
ORA-06512: at "MDSYS.SDO_CS", line 152
ORA-06512: at "MDSYS.SDO_CS", line 5553
ORA-06512: at "MDSYS.SDO_CS", line 3057


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