[mapserver-users] Connecting Oracle Spatial

[lballard at YesVirginia.org]

ERROR:
msOCIConnect() in msOracleSpatialLayerOpen(): OracleSpatial error.


Redhat 7.2
Oracle Client 9.0.1
Mapserver nightly build 6/6

Config command:
./configure --with-oraclespatial=/opt/oracle/product/9.0.1/
--with-sde=/usr/local/apache/htdocs/mapserver/tmp/sdeexe81/
--with-sde-version=81
--with-gd=static,/usr/local/apache/htdocs/mapserver/tmp/gd-1.8.4/

Map File snippet:
LAYER
  NAME states
  TYPE polygon
  STATUS default
  MAXSCALE 10000000
  CONNECTIONTYPE oraclespatial
  CONNECTION 'u/p at gisdb'
  DATA "SHAPE FROM LD_QT_NAMSTATES_SDO"
  CLASS
    NAME 'states'
    COLOR 220 224 230
    OUTLINECOLOR 0 0 0
  END
END

tnsping:
[oracle at gisintranet tmp]$ tnsping gisdb

TNS Ping Utility for Linux: Version 9.0.1.0.0 - Production on 07-JUN-2002
12:38:51

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:
/opt/oracle/product/9.0.1/network/admin/sqlnet.ora

Used ONAMES adapter to resolve the alias
Attempting to contact
(DESCRIPTION=(SOURCE_ROUTE=OFF)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=qt
vadb01.questerra.com)(PORT=1521)))(CONNECT_DATA=(SID=gisdb)(SRVR=DEDICATED))
)
OK (10 msec)

I can connect successfully through SQPLUS.
I added the Oracle Library path to the httpd.conf file:
setenv LD_LIBRARY_PATH /opt/oracle/product/9.0.1/lib


Thanks,

Lowell Ballard