[gdal-dev] [EXTERNAL] Re: How connect to a remote oracle with spatial

[Ivan Lucena]

Mike,

I think I also implemented OS authentication for both driver, OCI and GeoRaster. Have you used that?

Regards,

Ivan

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