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

[Jürgen E. Fischer]

Hi Martin,

On Thu, 10. Apr 2014 at 23:33:00 +0200, Martin Landa wrote:
> C:\OSGeo4W_oci>ogrinfo -ro OCI:user/passwd at 127.0.0.1:1251/xe -sql "select count(*) from emp"
> OGR: Auto register C:\OSGeo4W_oci\\bin\gdalplugins\ogr_OCI.dll using RegisterOGR
> OCI.
> OCI: Userid=landa, Password=stratos5, Database=127.0.0.1:1251/xe
> ERROR 1: ORA-12154: TNS:could not resolve the connect identifier specified
>  in <unnamed>
> FAILURE:
> Unable to open datasource `OCI:landa/stratos5 at 127.0.0.1:1251/xe' with the follow
> ing drivers.

Also no 11g XE at hand, but for 11g using the service name instead of the SID might
help.  Not sure what the default for XE is.  lsnrctl status should show it.

Eg. ogrinfo OCI:foo/bar at localhost/xe.world


Jürgen

-- 
Jürgen E. Fischer         norBIT GmbH               Tel. +49-4931-918175-31
Dipl.-Inf. (FH)           Rheinstraße 13            Fax. +49-4931-918175-50
Software Engineer         D-26506 Norden               http://www.norbit.de
QGIS PSC member (RM)      Germany                      IRC: jef on FreeNode                         

-- 
norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH
Rheinstrasse 13, 26506 Norden
GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502