Mailing-List: contact cygwin-help@sourceware.cygnus.com; run by ezmlm
List-Subscribe: <mailto:cygwin-subscribe@sources.redhat.com>
List-Archive: <http://sources.redhat.com/ml/cygwin/>
List-Post: <mailto:cygwin@sources.redhat.com>
List-Help: <mailto:cygwin-help@sources.redhat.com>, <http://sources.redhat.com/ml/#faqs>
Sender: cygwin-owner@sources.redhat.com
Delivered-To: mailing list cygwin@sources.redhat.com
X-Mailer: 21.4 (patch 4) "Artificial Intelligence" XEmacs Lucid (via feedmail 10 I)
To: Upat54wo@aol.com
Cc: <cygwin@cygwin.com>
Subject: Re: Invoking SQL*Plus from within cygwin
References: <a1.1b678e60.28da2147@aol.com>
X-Face: I-*}xvwusAv%MlABo'jVNP7TDXf5bb*L[q,r{DnsR1GoL07^Wf)sAu%>!LjXAFlZZN+`OQu
	}?#du]C)[*%ERKR#+l#sX'EoNbSO~|.x@ogoS5|"-u?<s5ViLslvYMlj7_n!Tq1m@xt2Bhj4[Zg+e?
	/Yy\SE`V?%v~kRU3GoS1f&U]}
From: "Dr. Volker Zell" <Dr.Volker.Zell@oracle.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@aol.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/

