Brent,
firstly, whilst SQLPLUS is a useful tool to ensure the Oracle environment is
correctly configured, it does not test ODBC - nor does the very much nicer, Java
based, SQL Developer, which is also not restricted to use with Oracle.
Secondly, how many tables are there in your Oracle tablespace? I currently
have around 70 or 80 and OGR takes forever to start. OGR reads the schema for
every table in the tablespace, trying to identify the spatial tables and
pre-load the key data in readiness. If you have a lot of tables, the
initialisation step may certainly seem to hang.
Thirdly, enabling debug in GDAL will enable you to track a lot of what is
going on and should enable you to quickly determine what is causing the hang -
although fixing it may take rather more effort, of course.
Lastly, I built GDAL against the Oracle Call Interface (OCI) libraries, not
ODBC: this connects to Oracle in a similar manner to that used by the Oracle
products and I find it to be fast and efficient.
Best wishes,
Peter
pcr...@pcreso.com wrote:
Thanks Stephen,
I should have included this in my first msg, apologies, but thanks for the
reply.
I'm running GDAL v1.6.1, from
ogrinfo --version
GDAL 1.6.1, released 2009/05/11
And, running isql (from unixodbc) also works.
isql --help
unixODBC 2.2.12
isql -v metp niwatest niwatest
libnuma: Warning: /sys not mounted or no numa system. Assuming one node: No
such file or directory
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> select count(*) from land_station;
+-----------------------------------------+
| COUNT(*) |
+-----------------------------------------+
| 8338 |
+-----------------------------------------+
So isql succeeds, and is definately using ODBC.
ogrinfo just hangs. Both have the /sys warning msg, which I am ignoring.
I'm still lost with respect to this....
Thanks,
Brent
--- On Mon, 2/21/11, Stephen Woodbridge <wood...@swoodbridge.com> wrote:
From: Stephen Woodbridge <wood...@swoodbridge.com>
Subject: Re: [mapserver-users] OGR VRT ODBC connection problem
To: pcr...@pcreso.com
Cc: mapserver-us...@lists.osgeo.org, gdal-dev@lists.osgeo.org
Date: Monday, February 21, 2011, 2:12 PM
Hi Brent,
I'm certainly not an expert on this, but I think the issue might be that
sqlplus does not use an ODBC connection it uses some proprietary Oracle
socket protocol to connect.
Do you have ODBC services setup, configured and running on the Linux
host? How have you verified this?
If not then this is likely the issue. Sorry I don't use ODBC, so I can't
help much more then this.
-Steve W
On 2/20/2011 7:12 PM, pcr...@pcreso.com wrote:
Hi,
Apologies for the cross posting, but I figure there are experts on both
lists.
I'm trying to get a ogr virtual connection working from a Linux host to
a remote Oracle DB to use mapserver for a WFS service providing the
required data..
ODBC is working, eg:
sqlplus user/user@metp <mailto:niwatest/niwatest@metp>
select count(*) from land_station;
8338
etc...
However, when testing with ogr2ogr, I get:
ogrinfo ODBC:user/user@metp land_station
libnuma: Warning: /sys not mounted or no numa system. Assuming one node:
No such file or directory
and the terminal window hangs, I'm unable to get any response, & have to
kill the connection to continue.
Any suggestions?
Thanks,
Brent Wood
_______________________________________________
mapserver-users mailing list
mapserver-us...@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
------------------------------------------------------------------------
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev
--
--------------------------------------------------------------------------------
Peter J Halls, GIS Advisor & Acting Team Leader Applications Support Group,
Information Directorate, University of York
Telephone: 01904 323806 Fax: 01904 323740
Snail mail: C/O IT Services, University of York, Heslington, York YO10 5DD
This message has the status of a private and personal communication
--------------------------------------------------------------------------------
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev
