[gdal-dev] [EXTERNAL] oci and oracle express 11

[Smith, Michael ERDC-RDE-CRREL-NH]

Hmm, this one should have work

ogrinfo -ro OCI:user/password at 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 at 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" <landa.martin at gmail.com> wrote:

>2014-04-10 1:00 GMT+02:00 Smith, Michael ERDC-RDE-CRREL-NH
><Michael.Smith at erdc.dren.mil>:
>> 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 at localhost:1521/xe -sql "select count(*)
>from emp"
>
>and
>
>ogrinfo -ro OCI:user/password at geo1:1521/xe -sql "select count(*) from emp"
>
>but with no success. Martin
>
>-- 
>Martin Landa * http://geo.fsv.cvut.cz/gwiki/Landa