We have 2 ArcSDE 10.0 services on Red Hat Linux 5 set up on the same server. (Server "A")
We have 2 Oracle instances also the same server (Server "A")
1 is 10g (10.2.0.4.0) seabed_sde
1 is 11g (11.2.0.1.0) corp_sde
(A 3rd Party application we need uses the seabed_sde service and the highest supported RDBMS is Oracle10g.
Otherwise we would have had both instances be 11g).
Everything was running fine (so it seemed), until I attempted to use st_geometry calls via SQL plus on the 11g (corp_sde) service.
Is there any way to configure the Oracle listener (extProc) so that st_geometry calls to both ArcSDE 10 services will work ?