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

[Martin Landa]

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=HTTP)
(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