Oracle access using CONNECTIONTYPE PLUGIN

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Oracle access using CONNECTIONTYPE PLUGIN

Nelly.Howind

Hi,

 

I try to access an oracle DB using following entry in mapfile:

 

CONNECTIONTYPE PLUGIN

PLUGIN "msplugin_oracle.dll"

CONNECTION "localhost,port:1521,<DBname>,<user>,<password>"

DATA "GEOM FROM WSG USING SRID 31467"

 

I installed Oracle 11g locally on Windows 2008 R2 64 bit system and can connect to it via Net Manager or SQL Developer.

I use a compiled mapserver  release MSVC2010 Win 64 downloaded from http://www.gisinternals.com/sdk/, which works fine with file based geodata.

 

Now I get an error message ORA-01005 (null password given; logon denied), but I set password correctly.

 

Has anybody an idea, what I am making wrong? Has connection string using oracle another syntax?

 

Thanks in advance

Nelly

 

Kommunale Informationsverarbeitung Baden-Franken

Nelly Howind

Kommunale Dienstleistungen
Geoinformation und Umwelt
Betriebsstätte Karlsruhe
Pfannkuchstraße 4, 76185 Karlsruhe
Fon: +49 721 9529 351
Fax: +49 721 9529 500351
E-Mail: [hidden email]
Internet: http://www.kivbf.de
 

Zweckverband
Kommunale Informationsverarbeitung Baden-Franken

Pfannkuchstraße 4, 76185 Karlsruhe

Fon +49 721 9529 0, Fax +49 721 9529 120
Verbandsvorsitzender: LR Hämmerle
Hauptgeschäftsführer: William Schmitt

Kommunales Rechenzentrum Baden Franken GmbH

Pfannkuchstraße 4, 76185 Karlsruhe

Fon +49 721 9529 0, Fax +49 721 9529 120

Hauptgeschäftsführer: William Schmitt
Handelsregister des Amtsgerichts Mannheim Nr. HRB 109683

 


_______________________________________________
mapserver-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Oracle access using CONNECTIONTYPE PLUGIN

Eichner, Andreas - SID-NLKM

On our site we use

  CONNECTIONTYPE oraclespatial
  CONNECTION '<username>/<password>@<service_name>'

and in tnsnames.ora:

<instance> =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = <port>))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = <service_name>)
    )
  )

Although you go with the plugin method I would guess it finally uses the same connection string as the integrated driver.

> -----Ursprüngliche Nachricht-----
> Von: [hidden email]
> [mailto:[hidden email]] Im Auftrag
> von [hidden email]
> Gesendet: Dienstag, 30. Juli 2013 09:07
> An: [hidden email]
> Betreff: [mapserver-users] Oracle access using CONNECTIONTYPE PLUGIN
>
> Hi,
>
>  
>
> I try to access an oracle DB using following entry in mapfile:
>
>  
>
> CONNECTIONTYPE PLUGIN
>
> PLUGIN "msplugin_oracle.dll"
>
> CONNECTION "localhost,port:1521,<DBname>,<user>,<password>"
>
> DATA "GEOM FROM WSG USING SRID 31467"
>
>  
>
> I installed Oracle 11g locally on Windows 2008 R2 64 bit
> system and can connect to it via Net Manager or SQL Developer.
>
> I use a compiled mapserver  release MSVC2010 Win 64
> downloaded from http://www.gisinternals.com/sdk/ 
> <http://www.gisinternals.com/sdk/> , which works fine with
> file based geodata.
>
>  
>
> Now I get an error message ORA-01005 (null password given;
> logon denied), but I set password correctly.
>
>  
>
> Has anybody an idea, what I am making wrong? Has connection
> string using oracle another syntax?
>
>  
>
> Thanks in advance
>
> Nelly
>
>  
>
> Kommunale Informationsverarbeitung Baden-Franken
>
> Nelly Howind
>
> Kommunale Dienstleistungen
> Geoinformation und Umwelt
> Betriebsstätte Karlsruhe
> Pfannkuchstraße 4, 76185 Karlsruhe
> Fon: +49 721 9529 351
> Fax: +49 721 9529 500351
> E-Mail: [hidden email]
> Internet: http://www.kivbf.de         
>  
> ________________________________
>
> Zweckverband
> Kommunale Informationsverarbeitung Baden-Franken
>
> Pfannkuchstraße 4, 76185 Karlsruhe
>
> Fon +49 721 9529 0, Fax +49 721 9529 120
> Verbandsvorsitzender: LR Hämmerle
> Hauptgeschäftsführer: William Schmitt
>
> Kommunales Rechenzentrum Baden Franken GmbH
>
> Pfannkuchstraße 4, 76185 Karlsruhe
>
> Fon +49 721 9529 0, Fax +49 721 9529 120
>
> Hauptgeschäftsführer: William Schmitt
> Handelsregister des Amtsgerichts Mannheim Nr. HRB 109683
>
>  
>
>
_______________________________________________
mapserver-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Oracle access using CONNECTIONTYPE PLUGIN

Tamas Szekeres
In reply to this post by Nelly.Howind
Hi,

I'm not exactly sure about your issue specifically but if you don't specify the full tns name in the connection string, then oci will look up for tnsnames.ora at specific locations. Use Process Monitor to identify the possible lookup locations.

Best regards,

Tamas



2013/7/30 <[hidden email]>

Hi,

 

I try to access an oracle DB using following entry in mapfile:

 

CONNECTIONTYPE PLUGIN

PLUGIN "msplugin_oracle.dll"

CONNECTION "localhost,port:1521,<DBname>,<user>,<password>"

DATA "GEOM FROM WSG USING SRID 31467"

 

I installed Oracle 11g locally on Windows 2008 R2 64 bit system and can connect to it via Net Manager or SQL Developer.

I use a compiled mapserver  release MSVC2010 Win 64 downloaded from http://www.gisinternals.com/sdk/, which works fine with file based geodata.

 

Now I get an error message ORA-01005 (null password given; logon denied), but I set password correctly.

 

Has anybody an idea, what I am making wrong? Has connection string using oracle another syntax?

 

Thanks in advance

Nelly

 

Kommunale Informationsverarbeitung Baden-Franken

Nelly Howind

Kommunale Dienstleistungen
Geoinformation und Umwelt
Betriebsstätte Karlsruhe
Pfannkuchstraße 4, 76185 Karlsruhe
Fon: <a href="tel:%2B49%20721%209529%20351" value="+497219529351" target="_blank">+49 721 9529 351
Fax: <a href="tel:%2B49%20721%209529%20500351" value="+497219529500351" target="_blank">+49 721 9529 500351
E-Mail: [hidden email]
Internet: http://www.kivbf.de
 

Zweckverband
Kommunale Informationsverarbeitung Baden-Franken

Pfannkuchstraße 4, 76185 Karlsruhe

Fon <a href="tel:%2B49%20721%209529%200" value="+4972195290" target="_blank">+49 721 9529 0, Fax <a href="tel:%2B49%20721%209529%20120" value="+497219529120" target="_blank">+49 721 9529 120
Verbandsvorsitzender: LR Hämmerle
Hauptgeschäftsführer: William Schmitt

Kommunales Rechenzentrum Baden Franken GmbH

Pfannkuchstraße 4, 76185 Karlsruhe

Fon <a href="tel:%2B49%20721%209529%200" value="+4972195290" target="_blank">+49 721 9529 0, Fax <a href="tel:%2B49%20721%209529%20120" value="+497219529120" target="_blank">+49 721 9529 120

Hauptgeschäftsführer: William Schmitt
Handelsregister des Amtsgerichts Mannheim Nr. HRB 109683

 


_______________________________________________
mapserver-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users



_______________________________________________
mapserver-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Oracle access using CONNECTIONTYPE PLUGIN

jmckenna
Administrator
In reply to this post by Nelly.Howind
For MS4W, I use the following syntax:

#Direct through OracleSpatial

  CONNECTIONTYPE oraclespatial
  CONNECTION "jeff/pass@SID"

#Through OGR

  CONNECTIONTYPE OGR
  CONNECTION "OCI:jeff/pass@SID"

In your shoes I would be likely be trying to connect to your Oracle data
through an ogrinfo call, and then using that exact syntax in my mapfile
for testing.

http://www.maptools.org/ms4w/index.phtml?page=README_INSTALL.html#oracle-10g-11g

-jeff


--
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/



On 2013-07-30 4:07 AM, [hidden email] wrote:

> Hi,
>
>  
>
> I try to access an oracle DB using following entry in mapfile:
>
>  
>
> CONNECTIONTYPE PLUGIN
>
> PLUGIN "msplugin_oracle.dll"
>
> CONNECTION "localhost,port:1521,<DBname>,<user>,<password>"
>
> DATA "GEOM FROM WSG USING SRID 31467"
>
>  
>
> I installed Oracle 11g locally on Windows 2008 R2 64 bit system and can
> connect to it via Net Manager or SQL Developer.
>
> I use a compiled mapserver  release MSVC2010 Win 64 downloaded from
> http://www.gisinternals.com/sdk/, which works fine with file based geodata.
>
>  
>
> Now I get an error message ORA-01005 (null password given; logon
> denied), but I set password correctly.
>
>  
>
> Has anybody an idea, what I am making wrong? Has connection string using
> oracle another syntax?
>
>  
>
> Thanks in advance
>
> Nelly
>
_______________________________________________
mapserver-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Oracle access using CONNECTIONTYPE PLUGIN

Smith, Michael ERDC-RDE-CRREL-NH
I recommend using the EZConnect syntax

User/pass@host:port/service_name

Or if port is 1521 then just

User/pass@host/service_name




On 7/30/13 9:24 AM, "Jeff McKenna" <[hidden email]> wrote:

>For MS4W, I use the following syntax:
>
>#Direct through OracleSpatial
>
>  CONNECTIONTYPE oraclespatial
>  CONNECTION "jeff/pass@SID"
>
>#Through OGR
>
>  CONNECTIONTYPE OGR
>  CONNECTION "OCI:jeff/pass@SID"
>
>In your shoes I would be likely be trying to connect to your Oracle data
>through an ogrinfo call, and then using that exact syntax in my mapfile
>for testing.
>
>http://www.maptools.org/ms4w/index.phtml?page=README_INSTALL.html#oracle-1
>0g-11g
>
>-jeff
>
>
>--
>Jeff McKenna
>MapServer Consulting and Training Services
>http://www.gatewaygeomatics.com/
>
>
>
>On 2013-07-30 4:07 AM, [hidden email] wrote:
>> Hi,
>>
>>  
>>
>> I try to access an oracle DB using following entry in mapfile:
>>
>>  
>>
>> CONNECTIONTYPE PLUGIN
>>
>> PLUGIN "msplugin_oracle.dll"
>>
>> CONNECTION "localhost,port:1521,<DBname>,<user>,<password>"
>>
>> DATA "GEOM FROM WSG USING SRID 31467"
>>
>>  
>>
>> I installed Oracle 11g locally on Windows 2008 R2 64 bit system and can
>> connect to it via Net Manager or SQL Developer.
>>
>> I use a compiled mapserver  release MSVC2010 Win 64 downloaded from
>> http://www.gisinternals.com/sdk/, which works fine with file based
>>geodata.
>>
>>  
>>
>> Now I get an error message ORA-01005 (null password given; logon
>> denied), but I set password correctly.
>>
>>  
>>
>> Has anybody an idea, what I am making wrong? Has connection string using
>> oracle another syntax?
>>
>>  
>>
>> Thanks in advance
>>
>> Nelly
>>
>_______________________________________________
>mapserver-users mailing list
>[hidden email]
>http://lists.osgeo.org/mailman/listinfo/mapserver-users

_______________________________________________
mapserver-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users