<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif;">
<div>Ivan,</div>
<div><br>
</div>
<div>I've never tried OS authentication.</div>
<div><br>
</div>
<div>Mike</div>
<div><br>
</div>
<div>
<div>
<div>
<div>-- </div>
<div>Michael Smith</div>
</div>
<div>Remote Sensing/GIS Center</div>
<div>US Army Corps of Engineers</div>
</div>
</div>
<div><br>
</div>
<span id="OLK_SRC_BODY_SECTION">
<div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<span style="font-weight:bold">From: </span>Ivan Lucena <<a href="mailto:lucena_ivan@hotmail.com">lucena_ivan@hotmail.com</a>><br>
<span style="font-weight:bold">Date: </span>Wednesday, October 14, 2015 at 9:44 AM<br>
<span style="font-weight:bold">To: </span>Michael Smith <<a href="mailto:michael.smith@erdc.dren.mil">michael.smith@erdc.dren.mil</a>>, Jukka Rahkonen <<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi">jukka.rahkonen@maanmittauslaitos.fi</a>>, "<a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a>"
<<a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a>><br>
<span style="font-weight:bold">Subject: </span>RE: [gdal-dev] [EXTERNAL] Re: How connect to a remote oracle with spatial<br>
</div>
<div><br>
</div>
<blockquote id="MAC_OUTLOOK_ATTRIBUTION_BLOCKQUOTE" style="BORDER-LEFT: #b5c4df 5 solid; PADDING:0 0 0 5; MARGIN:0 0 0 5;">
<div><style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style>
<div 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: <a href="mailto:Michael.Smith@erdc.dren.mil">Michael.Smith@erdc.dren.mil</a><br>
> To: <a href="mailto:jukka.rahkonen@maanmittauslaitos.fi">jukka.rahkonen@maanmittauslaitos.fi</a>;
<a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><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>
> <<a href="mailto:gdal-dev-bounces@lists.osgeo.org">gdal-dev-bounces@lists.osgeo.org</a> on behalf of<br>
> <a href="mailto:jukka.rahkonen@maanmittauslaitos.fi">jukka.rahkonen@maanmittauslaitos.fi</a>> 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>
> >BlockedBlockedBlocked<a href="http://orafaq.com/wiki/Tnsnames.oraBlockedBlocked">http://orafaq.com/wiki/Tnsnames.oraBlockedBlocked</a>? If you have,<br>
> >use @SERVICE_NAME with ogrinfo<br>
> ><br>
> >Read also carefully the manual page<br>
> >BlockedBlockedBlocked<a href="http://www.gdal.org/drv_oci.htmlBlockedBlocked">http://www.gdal.org/drv_oci.htmlBlockedBlocked</a><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>
> ><a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br>
> >BlockedBlockedBlocked<a href="http://lists.osgeo.org/mailman/listinfo/gdal-devBlockedBlocked">http://lists.osgeo.org/mailman/listinfo/gdal-devBlockedBlocked</a><br>
> <br>
> _______________________________________________<br>
> gdal-dev mailing list<br>
> <a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br>
> Blocked<a href="http://lists.osgeo.org/mailman/listinfo/gdal-devBlocked">http://lists.osgeo.org/mailman/listinfo/gdal-devBlocked</a><br>
</div>
</div>
</div>
</div>
</blockquote>
</span>
</body>
</html>