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

[Smith, Michael ERDC-RDE-CRREL-NH]

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