Is This Content Helpful?
We're glad to know this article was helpful.
ArcIMS users can connect to and read spatial data directly in an Oracle database without having to use an ArcSDE Application server; this connection is made by way of Author. Instructions provided describe how to create a direct connection from ArcIMS with an Oracle 9i client to a remote ArcSDE/Oracle 10g Release 1 server in a UNIX environment.
In some cases, the ArcSDE Application server may need to be bypassed to improve performance. To do this, update the SDEWORKSPACE element in the .AXL file and use Direct Connect.
This article assumes Oracle 9i client is used to connect to Oracle 10g Release 1 server.
Before setting up Direct Connect, make sure:
· ArcIMS is setup properly and is working and stable.
· On the ArcIMS machine, install the Oracle client and set up Net service in the tnsnames.ora file. Test the connection to a remote Oracle server by way of Oracle's sqlplus utility:
setenv SDEHOME /home/ims91/arcgis/arcims
setenv ORACLE_HOME /home/ora10g/product/10.1.0
setenv TNS_ADMIN /home/ora10g/product/10.1.0/client_1/network/admin
%ln -s libclntsh.so.10.1 libclntsh.so.9.0
sdelayer -o describe -i sde:oracle9i -u <username> -p <password>@<Net_service>
<SDEWORKSPACE name="sde_ws-0" server="zephyr" instance="port:5151"
database="test" user="test" encrypted="true" password="EPYCJM" geoindexdir="C:\DOCUME~1\ />
<SDEWORKSPACE name="sde_ws-0" server="zephyr" instance="sde:oracle9i"
database="test" user="test" encrypted="false" password="test@ora" geoindexdir="C:\DOCUME~1\ />