[gdal-dev] Problems using the OCI plugin with ogr2ogr

[David R. Robison]

I am trying to use ogr2ogr to copy data from Oracle spatial to 
PostgreSQL. My command line is:

OGR2OGR -overwrite -f "PostgreSQL" -s_srs 141122 -t_srs 4326 
PG:"host=localhost user=Postgres password=xxxxxx dbname=penngis" 
OCI:"GEOADMIN/geoadmin@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.117.244)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=penngis))):GEOADMIN.RMSSEG" 
-nln orci_rmsseg

In the log I see:

OGR: Auto register C:\Program Files\GDAL\gdalplugins\ogr_OCI.dll using 
RegisterOGROCI.
OCI: Userid=GEOADMIN, Password=geoadmin, 
Database=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.117.244)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=penngis)))
ERROR 1:  in <unnamed>
FAILURE:
Unable to open datasource 
`OCI:GEOADMIN/geoadmin@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.117.244)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=penngis))):GEOADMIN.RMSSEG' 
with the following drivers.
   -> OCI
   -> ESRI Shapefile
   ...

It seems it registers the OCI plugin but does not seem to attempt a 
database connection. Any ideas what I may be doing wrong?
David

-- 

David R Robison
Open Roads Consulting, Inc.
103 Watson Road, Chesapeake, VA 23320
phone: (757) 546-3401
e-mail: david.robison at openroadsconsulting.com
web: http://openroadsconsulting.com
blog: http://therobe.blogspot.com
book: http://www.xulonpress.com/bookstore/bookdetail.php?PB_ISBN=9781597816526



This email communication (including any attachments) may contain confidential and/or privileged material intended solely for the individual or entity to which it is addressed.
If you are not the intended recipient, please delete this email immediately.