Hmm, this one should have work ogrinfo -ro OCI:user/password@geo1:1521/xe -sql "select count(*) from emp"
You can use debug mode and see what might be going on. This is windows I see so try SET CPL_DEBUG=ON ogrinfo -ro OCI:user/password@geo1:1521/xe -sql "select count(*) from emp" That might give you some more information. Does sqlplus connect and allow access? Mike -- Michael Smith US Army Corps Remote Sensing GIS/Center On 4/9/14, 7:11 PM, "Martin Landa" <[email protected]> wrote: >2014-04-10 1:00 GMT+02:00 Smith, Michael ERDC-RDE-CRREL-NH ><[email protected]>: >> What does >> >> lsrnctl status >> >> Return? That will report back the status of the listener and the host, >> port and sid info. > >Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) >STATUS of the LISTENER >------------------------ >Alias LISTENER >Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 >- Produ >ction >Start Date 09-DUB-2014 03:26:29 >Uptime 0 days 21 hr. 39 min. 33 sec >Trace Level off >Security ON: Local OS Authentication >SNMP OFF >Default Service XE >Listener Parameter File >C:\oraclexe\app\oracle\product\11.2.0\server\network\a >dmin\listener.ora >Listener Log File >C:\oraclexe\app\oracle\diag\tnslsnr\geo1\listener\aler >t\log.xml >Listening Endpoints Summary... > (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc))) > (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=geo1)(PORT=1521))) > >(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=geo1)(PORT=8080))(Presentation=H >TTP) >(Session=RAW)) >Services Summary... >Service "CLRExtProc" has 1 instance(s). > Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this >service... >Service "PLSExtProc" has 1 instance(s). > Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this >service... >Service "XEXDB" has 1 instance(s). > Instance "xe", status READY, has 1 handler(s) for this service... >Service "xe" has 1 instance(s). > Instance "xe", status READY, has 1 handler(s) for this service... >The command completed successfully >LSNRCTL> > >I tried > >ogrinfo -ro OCI:user/password@localhost:1521/xe -sql "select count(*) >from emp" > >and > >ogrinfo -ro OCI:user/password@geo1:1521/xe -sql "select count(*) from emp" > >but with no success. Martin > >-- >Martin Landa * http://geo.fsv.cvut.cz/gwiki/Landa _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
