Martin Landa landa.martin at gmail.com writes:
Hi all,
2014-04-11 4:00 GMT+02:00 Ivan Lucena lucena_ivan at hotmail.com:
[...]
I know that is not the same situation you have, but when I need to run GDAL
build for Win32 on my Win64 machine I need to place an OCI.DLL from a
Hi Martin,
On Thu, 10. Apr 2014 at 23:33:00 +0200, Martin Landa wrote:
C:\OSGeo4W_ociogrinfo -ro OCI:user/passwd@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,
Hi all,
2014-04-11 4:00 GMT+02:00 Ivan Lucena lucena_i...@hotmail.com:
[...]
I know that is not the same situation you have, but when I need to run GDAL
build for Win32 on my Win64 machine I need to place an OCI.DLL from a
InstantClient-32 first on my PATH. Otherwise it will try to load the
as a default. What is
very misleading. It has nothing to deal with SID or the Listener setting.
Date: Fri, 11 Apr 2014 12:08:35 +0200
Subject: Re: [gdal-dev] [EXTERNAL] oci and oracle express 11
From: landa.mar...@gmail.com
To: lucena_i...@hotmail.com
CC: mate...@loskot.net; gdal-dev
Martin,
when working with Oracle, it is always worth looking up an ORA
message number at Oracle: you will find a full explanation and suggestions
for resolution.
For your error, look up http://ora-12154.ora-code.com/
In summary, the error means that the Oracle client is unable
Hi,
2014-04-10 3:27 GMT+02:00 Smith, Michael ERDC-RDE-CRREL-NH
michael.sm...@erdc.dren.mil:
If user/passwd@xe works in sqlplus, you can use that in OGR. Its using
the same libs to connect.
Try ogrinfo -ro OCI:user/passwd@xe
I already tried that but without success...
ERROR 1: ORA-12154:
Martin Landa landa.martin at gmail.com writes:
Hi,
2014-04-10 3:27 GMT+02:00 Smith, Michael ERDC-RDE-CRREL-NH
Michael.Smith at erdc.dren.mil:
If user/passwd at xe works in sqlplus, you can use that in OGR.
Its using
the same libs to connect.
Try ogrinfo -ro OCI:user/passwd at xe
On 10 April 2014 11:27, Martin Landa landa.mar...@gmail.com wrote:
Hi,
2014-04-10 3:27 GMT+02:00 Smith, Michael ERDC-RDE-CRREL-NH
michael.sm...@erdc.dren.mil:
If user/passwd@xe works in sqlplus, you can use that in OGR. Its using
the same libs to connect.
Try ogrinfo -ro OCI:user/passwd@xe
Hi all,
2014-04-10 12:06 GMT+02:00 Jukka Rahkonen jukka.rahko...@mmmtike.fi:
ERROR 1: ORA-12154: TNS:could not resolve the connect identifier specified
in unnamed
What we have is
- environment set as TNS_ADMIN=path/to/directory
- tnsnames.ora file in the TNS_ADMIN directory
- entry in
On 10 April 2014 21:39, Martin Landa landa.mar...@gmail.com wrote:
C:\oraclexe\app\oracle\product\11.2.0\server\hs\admin\tnsnames.ora
The file contains:
XE =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
Try changing to HOST=127.0.0.1 and restart Oracle
Best
Hi,
2014-04-10 21:47 GMT+02:00 Mateusz Łoskot mate...@loskot.net:
On 10 April 2014 21:39, Martin Landa landa.mar...@gmail.com wrote:
C:\oraclexe\app\oracle\product\11.2.0\server\hs\admin\tnsnames.ora
The file contains:
XE =
(DESCRIPTION=
2014-04-10 12:30 GMT+02:00 Mateusz Łoskot mate...@loskot.net:
Also, check you are using the same type of binaries (32 or 64 bit) of
GDAL/OGR and InstantClient. AFAIR, they don't mix.
it remembers me, the PC runs on MS Windows Server 2008 64 bit. I
downloaded Oracle 11 g Express from [1]. They
Date: Thu, 10 Apr 2014 23:37:01 +0200
From: landa.mar...@gmail.com
To: mate...@loskot.net
CC: gdal-dev@lists.osgeo.org; michael.sm...@erdc.dren.mil
Subject: Re: [gdal-dev] [EXTERNAL] oci and oracle express 11
2014-04-10 12:30 GMT+02:00 Mateusz Łoskot mate...@loskot.net:
Also, check
Martin,
You need a bit more info in the connection
ogrinfo -ro OCI:user/password@hostname/sid -sql select count(*) from emp
Where hostname is the server name (or something like localhost) and sid is
the oracle instance name. if this is XE, then the sid is xe
So try ogrinfo -ro
Hi Micheal,
2014-04-10 0:39 GMT+02:00 Smith, Michael ERDC-RDE-CRREL-NH
michael.sm...@erdc.dren.mil:
[...]
thanks for super-quick answer...
So try ogrinfo -ro OCI:user/password@localhost/xe -sql select count(*)
from emp
ogrinfo -ro OCI:user/password@localhost/xe -sql select count(*) from
What does
lsrnctl status
Return? That will report back the status of the listener and the host,
port and sid info.
Mike
On 4/9/14, 6:47 PM, Martin Landa landa.mar...@gmail.com wrote:
Hi Micheal,
2014-04-10 0:39 GMT+02:00 Smith, Michael ERDC-RDE-CRREL-NH
michael.sm...@erdc.dren.mil:
[...]
2014-04-10 1:00 GMT+02:00 Smith, Michael ERDC-RDE-CRREL-NH
michael.sm...@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
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
Hi,
2014-04-10 1:40 GMT+02:00 Smith, Michael ERDC-RDE-CRREL-NH
michael.sm...@erdc.dren.mil:
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
If user/passwd@xe works in sqlplus, you can use that in OGR. Its using
the same libs to connect.
Try ogrinfo -ro OCI:user/passwd@xe
Mike
On 4/9/14, 8:01 PM, Martin Landa landa.mar...@gmail.com wrote:
Hi,
2014-04-10 1:40 GMT+02:00 Smith, Michael ERDC-RDE-CRREL-NH
michael.sm...@erdc.dren.mil:
20 matches
Mail list logo