<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Mike,<br><br>I think I also implemented OS authentication for both driver, OCI and GeoRaster. Have you used that?<br><br>Regards,<br><br>Ivan<br><br><div>> From: Michael.Smith@erdc.dren.mil<br>> To: jukka.rahkonen@maanmittauslaitos.fi; gdal-dev@lists.osgeo.org<br>> Date: Wed, 14 Oct 2015 13:01:56 +0000<br>> Subject: Re: [gdal-dev] [EXTERNAL] Re: How connect to a remote oracle with spatial<br>> <br>> Note that you can also use what Oracle calls the ezconnect syntax which is<br>> user/pass@host:port/service_name. Then no TNS is needed. Also note that<br>> port only needs to be specified if its not 1521.<br>> <br>> Mike<br>> <br>> -- <br>> Michael Smith<br>> <br>> Remote Sensing/GIS Center<br>> US Army Corps of Engineers<br>> <br>> <br>> <br>> On 10/14/15, 3:56 AM, "gdal-dev on behalf of Jukka Rahkonen"<br>> <gdal-dev-bounces@lists.osgeo.org on behalf of<br>> jukka.rahkonen@maanmittauslaitos.fi> wrote:<br>> <br>> >Andrea Peri <aperi2007 <at> gmail.com> writes:<br>> ><br>> >> <br>> >> Hi,<br>> >> I'm trying to test using gdal the access to an oracle dbms.<br>> >> <br>> >> To do this I use the ogrinfo and try this sintax but without success.<br>> >> <br>> >> ogrinfo OCI:username:password <at> "(DESCRIPTION = (ADDRESS_LIST =<br>> >>(ADDRESS<br>> >> = (PROTOCOL = TCP)(HOST = <IP server dbms>)(PORT = <listener<br>> >> port>)))(CONNECT_DATA = (SID =<the sid of dbms>))):<schema>.<table>"<br>> >> <br>> >> The server return<br>> >> <br>> >> ERROR 1: ORA-01005: null password given; logon denied<br>> >> in <unnamed><br>> >> <br>> ><br>> >Don'n you have a record for your connection in the tnsnames.ora<br>> >BlockedBlockedhttp://orafaq.com/wiki/Tnsnames.oraBlocked? If you have,<br>> >use @SERVICE_NAME with ogrinfo<br>> ><br>> >Read also carefully the manual page<br>> >BlockedBlockedhttp://www.gdal.org/drv_oci.htmlBlocked<br>> >You wrote OCI:username:password but it should be<br>> >OCI:username/password@database_instance:table,table<br>> ><br>> >As documented "ogrinfo OCI:username/password@database_instance" is enough<br>> >but at least in our environment it can take several minutes to read the<br>> >metadata from Oracle if table list is not given for limiting the search.<br>> ><br>> >-Jukka Rahkonen-<br>> ><br>> ><br>> >_______________________________________________<br>> >gdal-dev mailing list<br>> >gdal-dev@lists.osgeo.org<br>> >BlockedBlockedhttp://lists.osgeo.org/mailman/listinfo/gdal-devBlocked<br>> <br>> _______________________________________________<br>> gdal-dev mailing list<br>> gdal-dev@lists.osgeo.org<br>> http://lists.osgeo.org/mailman/listinfo/gdal-dev<br></div> </div></body>
</html>