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
To: "Dmitry Melekhov" <dm AT belkam DOT com>
Cc: <cygwin AT cygwin DOT com>
Subject: Re: Exim, .forward and DBD::Oracle
Reply-To: Harald Maier <maierh AT myself 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>
From: Harald DOT Maier DOT BW AT t-online DOT de
Date: Sat, 12 Apr 2003 20:08:24 +0200
In-Reply-To: <014d01c30109$221a7ac0$141ea8c0@dm> (Dmitry Melekhov's message
 of "Sat, 12 Apr 2003 19:35:22 +0400")
Message-ID: <un0ivvbaf.fsf@myself.com>
User-Agent: Gnus/5.090018 (Oort Gnus v0.18) Emacs/21.3 (windows-nt)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Sender: 320041125923-0001 AT t-dialin DOT net

"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).

For test purposes you may also call the ORACLE programs, tnsping or
sqlplus. 

Harald


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