Mailing-List: contact cygwin-help@cygwin.com; run by ezmlm
List-Subscribe: <mailto:cygwin-subscribe@cygwin.com>
List-Archive: <http://sources.redhat.com/ml/cygwin/>
List-Post: <mailto:cygwin@cygwin.com>
List-Help: <mailto:cygwin-help@cygwin.com>, <http://sources.redhat.com/ml/#faqs>
Sender: cygwin-owner@cygwin.com
Mail-Followup-To: cygwin@cygwin.com
Delivered-To: mailing list cygwin@cygwin.com
Message-ID: <007601c301c3$053adca0$141ea8c0@dm>
From: "Dmitry Melekhov" <dm@belkam.com>
To: "Harald Maier" <maierh@myself.com>
Cc: <cygwin@cygwin.com>
References: <321323244855.20030410222844@familiehaase.de><3E9538B8.5010107@belkam.com><321323244855.20030410222844@familiehaase.de><3.0.5.32.20030410233114.007fcc30@incoming.verizon.net><3E963AF7.6060101@belkam.com> <3E96CA54.35118EA3@ieee.org><009201c30048$8cf1ad80$141ea8c0@dm> <3E96E558.9D8E5729@ieee.org><00d501c3004e$ee6a5160$141ea8c0@dm> <uadewvv0g.fsf@myself.com><014d01c30109$221a7ac0$141ea8c0@dm> <un0ivvbaf.fsf@myself.com>
Subject: Re: Exim, .forward and DBD::Oracle
Date: Sun, 13 Apr 2003 17:46:00 +0400
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000


----- Original Message -----
From: <Harald.Maier.BW@t-online.de>
To: "Dmitry Melekhov" <dm@belkam.com>
Cc: <cygwin@cygwin.com>
Sent: Saturday, April 12, 2003 10:08 PM
Subject: Re: Exim, .forward and DBD::Oracle


> "Dmitry Melekhov" <dm@belkam.com> writes:
>
> >> Can you call your script as following:
> >>
> >>   $ ORACLE_HOME=c:/oracle/ora81 <this script>
> >
> > I tried to set this as
> >   environment="ORACLE_HOME='c:\oracle\ora81'"
> > environment="ORACLE_HOME='c:\oracle\ora81'"
> > in pipe configuration in exim.conf, but this doesn't help. Well,
situation
> > becomes differernt, I received  error:
> > DynaLoader::bootstrap for DBD::Oracle (auto/DBD/Oracle/Oracle.dll)
> > DBI connect('host=oracle.belkam.com;sid=TABEL','tabel',...) failed:
Error
> > while trying to retrieve text for error ORA-12538 (DBD ERROR:
> > OCIServerAttach) at /home/tabel/test.pl line 11
> > Died at /home/tabel/test.pl line 11.
>
>
> Now the ORACLE_HOME seems to be correct, but from the error message
> above it looks that something is wrong in the specification of your
> remote oracle service. Here the description of the Oracle Error.
>
> $ oerr ora 12538
> 12538, 00000, "TNS:no such protocol adapter"
> // *Cause: The protocol adapter requested (by way of the "(PROTOCOL=..)"
> // keyword-value pair in a TNS address) is unknown. If the supplied
address
> // is typographically correct then the protocol adaptor is not installed.
> // *Action: Install the protocol adapter or correct typographically error,
> // as appropriate.  Note: if the supplied address was derived from
> // resolving the service name, check the address in the appropriate file
> // (TNSNAMES.ORA, LISTENER.ORA or TNSNET.ORA).
>

May be this is security problem, may be something else.
I have the same situation if I run script from .forward as SYSTEM without
pre-setting ORACLE_HOME outside of script.

Looks very strange, but...
Anyway, now I have working combination, which is good enough for me :-)
Thank you!!!



--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/