Note that you can also use what Oracle calls the ezconnect syntax which is user/pass@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-boun...@lists.osgeo.org on behalf of jukka.rahko...@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@database_instance:table,table > >As documented "ogrinfo OCI:username/password@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@lists.osgeo.org >BlockedBlockedhttp://lists.osgeo.org/mailman/listinfo/gdal-devBlocked _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev