[gdal-dev] Oracle OCI connection in Python OGR
Ivan
ivan.lucena at pmldnet.com
Mon Feb 15 17:33:02 EST 2010
Eric,
Eric Wolf wrote:
> I'm running Oracle 11g on the same machine as the Python script.
>
> I did test cx_Oracle and found that it wasn't working. I was using the
> Unicode cx_Oracle 5.0.3. Switching to the non-Unicode cx_Oracle got it
> working. But OGR is still not connecting.
>
> Does OGR rely on cx_Oracle?
No it doesn't but I was a good to clue.
>
> I think I'll try regressing to an older version of GDAL and see if it works.
I running GDAL/OGR/Python/OCI on OpenSUSE and it works just fine. I am going to test on Windows.
Regards,
Ivan
>
> -Eric
>
> -=--=---=----=----=---=--=-=--=---=----=---=--=-=-
> Eric B. Wolf New! 720-334-7734
> USGS Geographer
> Center of Excellence in GIScience
> PhD Student
> CU-Boulder - Geography
>
> GPG Public Key: http://www.h4h.net/ebwolf.public.key.txt
>
>
> On Sun, Feb 14, 2010 at 12:45 PM, Abhay <abhay.menon at gmail.com
> <mailto:abhay.menon at gmail.com>> wrote:
>
>
>
> On Fri, Feb 12, 2010 at 11:32 PM, Eric Wolf <ebwolf at gmail.com
> <mailto:ebwolf at gmail.com>> wrote:
>
> Thanks for the replies. Sorry I didn't give more details on the
> environment.
>
> I am running on Windows, at the command line, both ogr2ogr and
> the python script.
>
> Created an environment variable for ORACLE_SID=ORCL
>
> I double-checked my OCI string by using sqlplus to connect:
>
> sqlplus scott/tiger at orcl
>
> This works fine. I changed the script to use that in the call to
> ogr.Open(). No luck.
>
> I imported gdal and sprinkled print 'Error:',
> gdal.GetLastErrorMsg() in my exception handlers. I got:
>
> Unable to open Oracle connection None
> Error:
>
> Still no dice. If I take the same script and modify the
> GetDriverByName and Open to use a shapefile, it works perfectly.
>
> -Eric
>
>
>
> -=--=---=----=----=---=--=-=--=---=----=---=--=-=-
> Eric B. Wolf New! 720-334-7734
> USGS Geographer
> Center of Excellence in GIScience
> PhD Student
> CU-Boulder - Geography
>
> GPG Public Key: http://www.h4h.net/ebwolf.public.key.txt
>
>
> On Fri, Feb 12, 2010 at 6:56 AM, Abhay <abhay.menon at gmail.com
> <mailto:abhay.menon at gmail.com>> wrote:
>
>
>
> On Fri, Feb 12, 2010 at 2:48 PM, Eric Wolf <ebwolf at gmail.com
> <mailto:ebwolf at gmail.com>> wrote:
>
> I'm using GDAL/OGR 1.6.1 with ActivePython 2.6.4-10 and
> cx_Oracle-5.0.3-11g. I am trying to connect to an Oracle
> 11g instance.
>
> This works:
>
> ogr2ogr -f "KML" emp.kml OCI:scott/tiger "EMP"
>
> What am I doing wrong. This fails, ds is None:
>
> from osgeo import ogr
>
> try:
> d = ogr.GetDriverByName('OCI')
> except:
> print "Unable to GetDriverByName"
> quit()
>
> ds = None
>
> try:
> ds = ogr.Open('OCI:scott/tiger')
> except:
> print "Unable to open OCI connection"
> quit()
>
> if ds is None:
> print "Unable to open Oracle connection", ds
> quit()
>
> lyr = ds.GetLayerByName('EMP')
> number = lyr.GetFeatureCount()
>
> print "Features: " + str(number)
>
>
>
>
> -=--=---=----=----=---=--=-=--=---=----=---=--=-=-
> Eric B. Wolf New! 720-334-7734
> USGS Geographer
> Center of Excellence in GIScience
> PhD Student
> CU-Boulder - Geography
>
> GPG Public Key: http://www.h4h.net/ebwolf.public.key.txt
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org <mailto:gdal-dev at lists.osgeo.org>
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>
>
> Hi Eric,
>
> Form your mail it not clear what is cause of the problem.
>
> There 2 scenario here
>
> 1) you are on a remote machine form where your trying to
> connect oracle server machine:
>
> a) Have you installed any Oracle Client in your system.
> Considering that you are using the complete oracle client
> installation you can use the following :
> OCI:scott/tiger@<Tnsname entry for eg. ORCL>
>
> b) if you are trying out with Instant client for 11g you
> should try either of the following
>
> OCI:scott/tiger@//localhost/<your ORACLE SERVICE IDENTIFIER
> for eg ORCL>.
>
> 2) you are on the oracle server machine where
>
> you must set the oracle SID. like the following
> on windows
> SET ORACLE_SID=ORCL
> or
> on *nix
> export ORACLE_SID=ORCL
>
> then try your implementation or use methods stated in 1)
>
>
>
>
> Rgds.
>
> Abhay.
>
>
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org <mailto:gdal-dev at lists.osgeo.org>
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>
>
> Hi Eric,
>
> What I still did not get is whether your running Oracle Server 11g
> on the same machine on which your developing.
>
> Also have you tried connecting the same using "cx_Oracle.Connection"
> whether this connect string is working.
>
> Are you using gdal-1.6.1-py2.6-win32.egg install with Python or
> build your on using SWIG python implementation.
>
> Interestingly, what I found is that in gdal-1.6.1-py2.5-win32.egg
> which install using easy_install seem not work with OCI driver as
> way it should. But connection string using cx_Oracle is working. So
> it seem gdal-1.6.1-py*-win32.egg is broken for OCI plugin or
> probably it must be some setup I must have overlooked will setup, if
> someone else is working with same setup could help on this or Howard
> could comment on this.
>
> I have build my own egg using latest repo of gdal build and is
> working. If you need I can share the same egg file (for python 2.6)
> or wait for Howard to compile for the latest build of GDAL-1.7 for
> python officially as you would need gdalwin32-17 for this along with
> OCI build plugin.
>
> Rgds.
>
> Abhay.
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
More information about the gdal-dev
mailing list