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

Last updated on MAY 15, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

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

select * from (select id,
  survey_id,
  survey_type,
  survey_status,
  site_name,
  site_address1,
  site_address2,
  city,
  state,
  zip_code,
  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_geometry(2001,
  8307,
  sdo_point_type(-104.869326, 39.567272, null),
  null,
  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


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