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
X-Mailer: 21.4 (patch 4) "Artificial Intelligence" XEmacs Lucid (via feedmail 10 I)
To: Upat54wo AT aol DOT com
Cc: <cygwin AT cygwin DOT com>
Subject: Re: Invoking SQL*Plus from within cygwin
References: <a1 DOT 1b678e60 DOT 28da2147 AT aol DOT com>
X-Face: I-*}xvwusAv%MlABo'jVNP7TDXf5bb*L[q,r{DnsR1GoL07^Wf)sAu%>!LjXAFlZZN+`OQu
	}?#du]C)[*%ERKR#+l#sX'EoNbSO~|.x AT ogoS5|"-u?<s5ViLslvYMlj7_n!Tq1m AT xt2Bhj4[Zg+e?
	/Yy\SE`V?%v~kRU3GoS1f&U]}
From: "Dr. Volker Zell" <Dr DOT Volker DOT Zell AT oracle DOT com>
Date: 19 Sep 2001 20:18:49 +0200
In-Reply-To: <a1.1b678e60.28da2147@aol.com>
Message-ID: <kv4rpzf3hy.fsf@vzell.de.oracle.com>
Lines: 27
User-Agent: Gnus/5.0808 (Gnus v5.8.8) XEmacs/21.4 (Artificial Intelligence)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

>>>>> "Upat54wo" == Upat54wo  <Upat54wo AT aol DOT com> writes:

    Upat54wo> 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.

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

Believe me, if you have setup Oracle in a correct way (see the Oracle documentation)
including Net8 (or whatever version you have) then working from inside a cygwin environment
is no problem. Just be sure to set the following environment before you start your bash shell.


This is what I have:

[503]> env | grep ORA
ORACLE_SID=VZ                (needed for local connects)
ORACLE_HOME=C:/oracle/o817               "

[504]> env | grep TNS
TNS_ADMIN=C:/oracle/admin    (only needed if you have configured Net8 and have your tnsnames.ora
                              in an unusual place)

[505]> env | grep LOCAL      (not deede at all, but useful sometimes)
LOCAL=vz


Ciao
  Volker


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