Mailing-List: contact cygwin-help AT sourceware DOT cygnus DOT com; run by ezmlm
List-Subscribe: <mailto:cygwin-subscribe AT sources DOT redhat DOT com>
List-Archive: <http://sources.redhat.com/ml/cygwin/>
List-Post: <mailto:cygwin AT sources DOT redhat DOT com>
List-Help: <mailto:cygwin-help AT sources DOT redhat DOT com>, <http://sources.redhat.com/ml/#faqs>
Sender: cygwin-owner AT sources DOT redhat DOT com
Delivered-To: mailing list cygwin AT sources DOT redhat DOT com
Subject: RE: Invoking SQL*Plus from within cygwin
Date: Wed, 19 Sep 2001 18:41:45 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Message-ID: <B3872CE9A0AFB34AABEBEEF06016BC480B5A68@gop-server.GOP-server.local>
X-MS-Has-Attach: 
Content-Class: urn:content-classes:message
X-MimeOLE: Produced By Microsoft Exchange V6.0.4712.0
X-MS-TNEF-Correlator: 
Thread-Topic: Invoking SQL*Plus from within cygwin
Thread-Index: AcFBKFbyRxqBylirRRqOOa53j4R5sgAAPwSg
From: "Jacob Vennervald Madsen" <JVM AT gopinocchio DOT com>
To: <Upat54wo AT aol DOT com>
Cc: <cygwin AT cygwin DOT com>
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from quoted-printable to 8bit by delorie.com id MAA16950

If you want to connect to a remote Oracle DB you need NET8 to do so.

Jacob

-----Original Message-----
From: Upat54wo AT aol DOT com [mailto:Upat54wo AT aol DOT com]
Sent: 19. september 2001 18:27
To: alecclews AT yahoo DOT com; troy DOT noble AT channelpoint DOT com
Cc: cygwin AT cygwin DOT com
Subject: Re: Invoking SQL*Plus from within cygwin



The latest good news is sqlplus no longer crashes - I actually get a
password prompt, so I am much closer than before.   Thanks for all the
hints.

I do still have a problem, though.  I am getting ORA-012560 -
TNS:protocol adaptor error

From my experience on UNIX, I had a registry entry  TNS_ADMIN which
contained the path of tnsnames.ora.  I don't see any registry or NT
environment variables on the server or client which performs the same
function.  I've added both and re-tried but I still receive the same
message.

I don't have Oracle installed on my client.  Do I need to have NET8
installed locally?  Remember I can run sqlplus from the cmd prompt and
sqlplusw from a shortcut mapped to the server without any problems.

Thanks again for all the help.

In a message dated Wed, 19 Sep 2001  9:05:39 AM Eastern Daylight Time,
"Alec Clews" <alecclews AT yahoo DOT com> writes:

> OK,
> 
> Unset all env variables except the path. SQLPLus should pick em up
from the
> Registry OK. I'm geussing it's because SQLPlus cannot grog the cygwin
mount
> point in ORACLE_HOME etc.
> 
> Alternative is to set ORACLE_HOME etc using NT notation (not sure
about
> LD_LIBRARY_PATH. Assume you don't need it for SQLPlus
> 
> Let me know how you go
> 
> 


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


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