[UNCLASSIFIED][ms4w-users]Problem connecting to Oracle Spati al

Tue Sep 5 02:36:45 EDT 2006

Thanks for your help Daniel. It was hint number 2. I had to fully qualify the service name because there was no default zone in the sqlnet.ora file on the database server.

-----Original Message-----
From: Daniel Goetz [mailto:madprof at gmx.ch] 
Sent: Tuesday, 5 September 2006 4:17 PM
To: Lynch, Damien - BRS; ms4w-users at lists.maptools.org
Subject: Re: [ms4w-users] [UNCLASSIFIED]Problem connecting to Oracle Spatial

Hi Damien,

have made correct settings in the tnsnames.ora (alias, port, etc.) and in the sqlnet.ora and did they lie in your /oralce/admin/network directory? the second hint would be to play with the service name in the CONNECTION objet of your mapfile. Try to take the exact expression as the alias in the tnsnames.ora. third I would also copy the \ms4w\gdalplugins\ignored\OCI.dll to \ms4w\gdalplugins\ otherwise you could not communicate via OCI. Try this. In my case (and I am using exactly the same components) everything works fine. Good luck.

regards

Daniel

P.S. the settings in the httpd.conf of apache are not necessary in my case.

-------- Original-Nachricht --------
Datum: Mon, 4 Sep 2006 16:43:36 +1000
Von: Damien.Lynch at brs.gov.au
An: ms4w-users at lists.maptools.org
Betreff: [ms4w-users] [UNCLASSIFIED]Problem connecting to Oracle Spatial

> I have installed ms4w 2.1 and version 1 of the Oracle 10g client. I 
> have swapped the libmap.dll library and added the following lines to 
> Apache's httpd.conf file:
>  
> SetEnv ORACLE_HOME "c:/oracle/product/10.1.0/Client"
> SetEnv TNS_ADMIN "c:/oracle/product/10.1.0/Client/NETWORK/ADMIN"
> SetEnv PATH "c:/oracle/product/10.1.0/Client/bin"
> 
> and I think I have the layer in the mapfile correct:
>  
>   layer
>     name           nvis1
>     connectiontype oraclespatial
>     connection     "user/pass at service"
>     data           "location from grid"
>     status         on
>     type           point
>   end
> 
> but I still cannot connect to Oracle spatial. When I enter 
> http://localhost/cgi-bin/mapserv.exe?map=c:/ms4w/apps/lccsApp/vegetati
> on.map 
> <http://localhost/cgi-bin/mapserv.exe?map=c:/ms4w/apps/lccsApp/vegetat
> ion.map&layers=nvis1&mode=map> &layers=nvis1&mode=map in my browser, I 
> get the following error:
>  
> msDrawMap(): Image handling error. Failed to draw layer named 'nvis1'. 
> msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI 
> Handlers. Connection failure. Check the connection string. Error: ORA-12560:
> TNS:protocol adapter error .
>  
> I have no problem connecting using sqlplus using the same connect string.
>  
> The only non-standard thing is that I had the 8i client already 
> installed and I installed 10g alongside it. I have since removed 8i 
> and used the registry editor to change all references to 10g.
>  
> Any ideas why I can't connect?
>  
> Damien Lynch
>  
> 
> ----------------------------------------------------------------------
> IMPORTANT - This message has been issued by The Department of 
> Agriculture, Fisheries and Forestry (DAFF).  The information 
> transmitted is for the use of the intended recipient only and may 
> contain confidential and/or legally privileged material.  It is your 
> responsibility to check any attachments for viruses and defects before opening or sending them on.
> Any reproduction, publication, communication, re-transmission, 
> disclosure, dissemination or other use of the information contained in 
> this e-mail by persons or entities other than the intended recipient 
> is prohibited.  The taking of any action in reliance upon this 
> information by persons or entities other than the intended recipient 
> is prohibited.  If you have received this e-mail in error please 
> notify the sender and delete all copies of this transmission together 
> with any attachments.  If you have received this e-mail as part of a 
> valid mailing list and no longer want to receive a message such as 
> this one advise the sender by return e-mail accordingly.  Only e-mail 
> correspondence which includes this footer, has been authorised by DAFF
> ----------------------------------------------------------------------

-- 

Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer

---------------------------------------------------------------------- 
IMPORTANT - This message has been issued by The Department of Agriculture, Fisheries and Forestry (DAFF).  The information transmitted is for the use of the intended recipient only and may contain confidential and/or legally privileged material.  It is your responsibility to check any attachments for viruses and defects before opening or sending them on.  
Any reproduction, publication, communication, re-transmission, disclosure, dissemination or other use of the information contained in this e-mail by persons or entities other than the intended recipient is prohibited.  The taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.  If you have received this e-mail in error please notify the sender and delete all copies of this transmission together with any attachments.  If you have received this e-mail as part of a valid mailing list and no longer want to receive a message such as this one advise the sender by return e-mail accordingly.  Only e-mail correspondence which includes this footer, has been authorised by DAFF 
----------------------------------------------------------------------