Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sources.redhat.com/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sources.redhat.com/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com
X-Originating-IP: [12.254.208.112]
X-Originating-Email: [mgainty AT hotmail DOT com]
From: "Martin Gainty" <mgainty AT hotmail DOT com>
To: "Dmitry Melekhov" <dm AT belkam DOT com>, "Harald Maier" <maierh AT myself DOT com>
Cc: <cygwin AT cygwin DOT com>
References: <321323244855 DOT 20030410222844 AT familiehaase DOT de><3E9538B8 DOT 5010107 AT belkam DOT com><321323244855 DOT 20030410222844 AT familiehaase DOT de><3 DOT 0 DOT 5 DOT 32 DOT 20030410233114 DOT 007fcc30 AT incoming DOT verizon DOT net><3E963AF7 DOT 6060101 AT belkam DOT com> <3E96CA54 DOT 35118EA3 AT ieee DOT org><009201c30048$8cf1ad80$141ea8c0 AT dm> <3E96E558 DOT 9D8E5729 AT ieee DOT org><00d501c3004e$ee6a5160$141ea8c0 AT dm> <uadewvv0g DOT fsf AT myself DOT com><014d01c30109$221a7ac0$141ea8c0 AT dm> <un0ivvbaf DOT fsf AT myself DOT com> <007601c301c3$053adca0$141ea8c0 AT dm>
Subject: Re: Exim, .forward and DBD::Oracle
Date: Sun, 13 Apr 2003 09:35:40 -0700
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.2800.1106
Message-ID: <Law10-OE17W2hSsKAfH000015c6@hotmail.com>
X-OriginalArrivalTime: 13 Apr 2003 15:36:17.0195 (UTC) FILETIME=[6C856FB0:01C301D2]


----- Original Message -----
From: "Dmitry Melekhov" <dm AT belkam DOT com>
To: "Harald Maier" <maierh AT myself DOT com>
Cc: <cygwin AT cygwin DOT com>
Sent: Sunday, April 13, 2003 6:46 AM
Subject: Re: Exim, .forward and DBD::Oracle


>
> ----- Original Message -----
> From: <Harald DOT Maier DOT BW AT t-online DOT de>
> To: "Dmitry Melekhov" <dm AT belkam DOT com>
> Cc: <cygwin AT cygwin DOT com>
> Sent: Saturday, April 12, 2003 10:08 PM
> Subject: Re: Exim, .forward and DBD::Oracle
>
>
> > "Dmitry Melekhov" <dm AT belkam DOT 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!!!
>
Please display the solution.
-M

--
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/