My Oracle Support Banner

ELOC ADG -- Select SDO_CS from standby DB gets errors ORA-00603 ORA-16000 (Doc ID 2261523.1)

Last updated on MARCH 28, 2019

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.