Re: [gdal-dev] [EXTERNAL] oci and oracle express 11
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 InstantClient-32 first on my PATH. Otherwise it will try to load the default on DLL my system, that happens to a Win64 OCI.DLL. that was! When I removed oci.dll from c:\osgeo4w than it started magically work! ogrinfo -ro OCI:user/passwd Thanks for saving me from madness Martin Hi, It took quite a lot of thinking for many people before you got it to work. Driver page http://www.gdal.org/ogr/drv_oci.html does not give any help, it does not even mention that oci.dll is somehow involved. Could the more advanced OCI users/developers suggest what to add to the driver page for helping next new users? -Jukka Rahkonen- ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] [EXTERNAL] oci and oracle express 11
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, 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@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@localhost/xe.world Jürgen -- Jürgen E. Fischer norBIT GmbH Tel. +49-4931-918175-31 Dipl.-Inf. (FH) Rheinstraße 13Fax. +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 ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] [EXTERNAL] oci and oracle express 11
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 default on DLL my system, that happens to a Win64 OCI.DLL. that was! When I removed oci.dll from c:\osgeo4w than it started magically work! ogrinfo -ro OCI:user/passwd Thanks for saving me from madness :-) Martin ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] [EXTERNAL] oci and oracle express 11
I glad to know that it solved your problem, even with my poor cellphone typing. It seems like Windows doesn't detect that the oci.dll version/architecture is wrong and loads it with without a problem, but when the GDAL driver try to call the OCI API to open a connection that error comes 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@lists.osgeo.org; michael.sm...@erdc.dren.mil 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 default on DLL my system, that happens to a Win64 OCI.DLL. that was! When I removed oci.dll from c:\osgeo4w than it started magically work! ogrinfo -ro OCI:user/passwd Thanks for saving me from madness :-) Martin ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] [EXTERNAL] oci and oracle express 11
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 to find / connect to the Oracle service name specified in the Oracle connection string. In the past, this meant that the service name specified could not be found in the file tnsnames.ora - there are some alternative ways of specifying Oracle services now, so please do look up the web page mentioned above. Best wishes, Peter On 10 April 2014 02:27, Smith, Michael ERDC-RDE-CRREL-NH michael.sm...@erdc.dren.mil wrote: 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: 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 unfortunately there is not so much info... OGR: Auto register C:\OSGeo4W_oci\\bin\gdalplugins\ogr_OCI.dll using RegisterOGR OCI. OCI: Userid=user, Password=passwd, Database=geo1:1521/xe ERROR 1: ORA-12154: TNS:could not resolve the connect identifier specified in unnamed Does sqlplus connect and allow access? This works... SQL connect user/passwd@xe Connected. Martin ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev -- Peter J Halls, PhD Student, Post-war Reconstruction and Development Unit (PRDU) Department of Politics, University of York Snail mail: PRDU, Derwent College, University of York, Heslington, York YO10 5DD This message has the status of a private and personal communication ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] [EXTERNAL] oci and oracle express 11
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: TNS:could not resolve the connect identifier specified in unnamed Martin ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] [EXTERNAL] oci and oracle express 11
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 I already tried that but without success... 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 tnsnames.ora as described in http://orafaq.com/wiki/Tnsnames.ora - GDAL connection as OCI:user/passwd at entry_made_above -Jukka Rahkonen- ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] [EXTERNAL] oci and oracle express 11
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 I already tried that but without success... ERROR 1: ORA-12154: TNS:could not resolve the connect identifier specified in unnamed Try easy connection mode with username/password@127.0.0.1:1521/xe Also, check you are using the same type of binaries (32 or 64 bit) of GDAL/OGR and InstantClient. AFAIR, they don't mix. Also, for development purposes, I usually replace hostname with IP address in tnsnames.ora, as the name resolving proved troublesome for me. Best regards, -- Mateusz Łoskot, http://mateusz.loskot.net ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] [EXTERNAL] oci and oracle express 11
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 tnsnames.ora as described in http://orafaq.com/wiki/Tnsnames.ora - GDAL connection as OCI:user/passwd at entry_made_above I have tried to follow these instructions, unfortunately there is still something missing... C:\OSGeo4W_ociecho %TNS_ADMIN% 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)) (CONNECT_DATA=(SID=xe)) (HS=OK) ) set CPL_DEBUG=ON C:\OSGeo4W_ociogrinfo -ro OCI:user/passwd@127.0.0.1:1521/xe -sql select cou nt(*) from emp OGR: Auto register C:\OSGeo4W_oci\\bin\gdalplugins\ogr_OCI.dll using RegisterOGR OCI. OCI: Userid=user, Password=passwd, Database=127.0.0.1:1521/xe ERROR 1: ORA-12154: TNS:could not resolve the connect identifier specified in unnamed I have tried various variations like OCI:user/passwd@geo1:1521/xe OCI:user/passwd@localhost:1521/xe OCI:user/passwd@xe but still with no success. Any idea what I am doing wrong? I I try to connect using sqldeveloper, it's using xe_landa user@//localhost:1521/xe so I tried also OCI:user/passwd@//localhost:1521/xe but it also failed... Thanks in advance! Martin -- Martin Landa * http://geo.fsv.cvut.cz/gwiki/Landa ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] [EXTERNAL] oci and oracle express 11
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 regards, -- Mateusz Łoskot, http://mateusz.loskot.net ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] [EXTERNAL] oci and oracle express 11
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= (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)) Try changing to HOST=127.0.0.1 and restart Oracle I modified the file: XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) Then from cmd: C:\OSGeo4W_ociecho %TNS_ADMIN% C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN\tnsnames.ora 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, 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@127.0.0.1:1251/xe' with the follow ing drivers. On this PC is running older Oracle 9i (but it's broken, the person who installed it some months ago told me that he didn't managed to install it correctly, MS Windows 2008 hasn't been supported by Oracle 9i AFAIU). It was the reason that I installed Oracle 11g Express on this machine. I can connect to XE using sqldeveloper or sqlplus, but not via OGR. That's strange. It's my first experience with Oracle, so I am sure where could be the problem. From debug message there is nothing what could help. Any idea where to get more relevant info (Oracle logs)? Thanks, Martin -- Martin Landa * http://geo.fsv.cvut.cz/gwiki/Landa ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] [EXTERNAL] oci and oracle express 11
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 claims that 64bit Windows are not supported. But I was able to install it, and DB server is apparently running (I can connect via sqlplus or sqldeveloper). Hm, could be a problem that I installed GDAL via OSGeo4W 32bit? Thanks, Martin [1] http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html -- Martin Landa * http://geo.fsv.cvut.cz/gwiki/Landa ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] [EXTERNAL] oci and oracle express 11
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 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 claims that 64bit Windows are not supported. But I was able to install it, and DB server Yes, That is what it says: - Does not work in Windows x64 http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html is apparently running (I can connect via sqlplus or sqldeveloper). Hm, That is interesting. But usually any Win32 application should work on a Win64 system. Right? could be a problem that I installed GDAL via OSGeo4W 32bit? As far as I can remember, the OSGeo4W installation comes with OCI.DLL. Unfortunately I don't one installation at hand. But, have you tried to force GDAL tools to use the OCI.DLL from the XE installation instead? 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 default on DLL my system, that happens to a Win64 OCI.DLL. In that situation I recall vaguely that the operation system doesn't give you any clear error or warning message and the connection fails when you try to run the command. Just like you are seeing. Have you tried the GDAL installation pack from http://www.gisinternals.com/sdk ? You can download and install for example, gdal-110-1600-x64-core.msi and a gdal-110-1600-x64-oracle.msi. BTW. It doesn't matter if the server is 32 or 64. What is important is that GDAL and the OCI.DLL are on the same architecture. Regards, Ivan Thanks, Martin [1] http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html -- Martin Landa * http://geo.fsv.cvut.cz/gwiki/Landa ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] [EXTERNAL] oci and oracle express 11
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 OCI:user/password@localhost/xe -sql select count(*) from emp Mike -- Michael Smith US Army Corps Remote Sensing GIS/Center On 4/9/14, 6:31 PM, Martin Landa landa.mar...@gmail.com wrote: Hi all, I would like to set up connection between OGR and Oracle Express 11g, I downloaded Oracle SQL Developer and set up the connection, when I try to connect to the database using user/password it works. When using OGR I entered to command line ogrinfo -ro OCI:user/password -sql select count(*) from emp but it failed with ERROR 1: ORA-12560: TNS:protocol adapter error in unnamed Thanks in advance for any pointers! Martin -- Martin Landa * http://geo.fsv.cvut.cz/gwiki/Landa ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] [EXTERNAL] oci and oracle express 11
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 emp ERROR 1: ORA-12154: TNS:could not resolve the connect identifier specified in unnamed I double-checked user/password, and it seems to be OK, any idea? Martin -- Martin Landa * http://geo.fsv.cvut.cz/gwiki/Landa ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] [EXTERNAL] oci and oracle express 11
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: [...] 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 emp ERROR 1: ORA-12154: TNS:could not resolve the connect identifier specified in unnamed I double-checked user/password, and it seems to be OK, any idea? Martin -- Martin Landa * http://geo.fsv.cvut.cz/gwiki/Landa ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] [EXTERNAL] oci and oracle express 11
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 LISTENER Alias LISTENER Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Produ ction Start Date09-DUB-2014 03:26:29 Uptime0 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@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 gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] [EXTERNAL] oci and oracle express 11
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 landa.mar...@gmail.com wrote: 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 LISTENER Alias LISTENER Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Produ ction Start Date09-DUB-2014 03:26:29 Uptime0 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 gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] [EXTERNAL] oci and oracle express 11
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 CPL_DEBUG=ON ogrinfo -ro OCI:user/password@geo1:1521/xe -sql select count(*) from emp unfortunately there is not so much info... OGR: Auto register C:\OSGeo4W_oci\\bin\gdalplugins\ogr_OCI.dll using RegisterOGR OCI. OCI: Userid=user, Password=passwd, Database=geo1:1521/xe ERROR 1: ORA-12154: TNS:could not resolve the connect identifier specified in unnamed Does sqlplus connect and allow access? This works... SQL connect user/passwd@xe Connected. Martin ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] [EXTERNAL] oci and oracle express 11
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: 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 unfortunately there is not so much info... OGR: Auto register C:\OSGeo4W_oci\\bin\gdalplugins\ogr_OCI.dll using RegisterOGR OCI. OCI: Userid=user, Password=passwd, Database=geo1:1521/xe ERROR 1: ORA-12154: TNS:could not resolve the connect identifier specified in unnamed Does sqlplus connect and allow access? This works... SQL connect user/passwd@xe Connected. Martin ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev