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 126.96.36.199 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_cs.transform(shape, 4326) shape,
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