delorie.com/archives/browse.cgi   search  
Mail Archives: cygwin/2007/02/16/23:50:35

X-Spam-Check-By: sourceware.org
Message-ID: <5bfc44150702162050k3cc48d90kd59586813e39607@mail.gmail.com>
Date: Fri, 16 Feb 2007 21:50:08 -0700
From: "Jason Thurston" <jason DOT thurston AT gmail DOT com>
To: cygwin AT cygwin DOT com
Subject: Oracle 10g sqlplus takes 6 quits or exits when run from cygwin
MIME-Version: 1.0
X-IsSubscribed: yes
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Id: <cygwin.cygwin.com>
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sourceware.org/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/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

Hi,
I just installed cygwin and I just installed oracle 10g on my Windows
XP computer.    If I run sqlplus to connect to oracle 10G through a
tns connection then when I want to exit I have to type "quit<enter>" 6
times in a row and then it will exit sqlplus.   Oddly if I run sqlplus
and do not go through the listener I can exit sqlplus with one
"quit<enter>" statement as should happen.    I cannot reproduce this
in the DOS shell.  Well actually if I open a DOS "cmd" shell and then
execute bash from within DOS and then connect to oracle 10g via
sqlplus through the tns listener it will also take 6 "quits" to exit
sqlplus.  Oh and if I start an rxvt bash shell, then type "cmd" to
enter a DOS shell then go into sqlplus via the listener I can exit
with just one quit.    Bash/ash/pdksh/zsh all take 6 "quits" or
"exits" to get out of sqlplus.   On my older computer I had Oracle 9i
and an older version of Cygwin and did not have this problem.   I
don't know if this is a cygwin or oracle issue.  Any ideas?

Again, this only happens if I connect via the TNS Listener meaning
that I'm using the "@XE" at the end of the connect string.
Here's a sample (in DOS this only takes one "quit" to exit sqlplus):

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
$ sqlplus  user/pass AT XE

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 16 21:42:10 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL> quit
Disconnected from Oracle Database 10g Express Edition Release
10.2.0.1.0 - Production

SQL*Plus: Release  10.2.0.1.0 - Production on Fri Feb 16 21:42:14 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL> quit
Disconnected from Oracle Database 10g Express Edition Release
10.2.0.1.0 - Production

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 16 21:42:16 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL> quit
Disconnected from Oracle Database 10g Express Edition Release
10.2.0.1.0 - Production

SQL*Plus: Release  10.2.0.1.0 - Production on Fri Feb 16 21:42:17 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL> quit
Disconnected from Oracle Database 10g Express Edition Release
10.2.0.1.0 - Production

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 16 21:42:19 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL> quit
Disconnected from Oracle Database 10g Express Edition Release
10.2.0.1.0 - Production

SQL*Plus: Release  10.2.0.1.0 - Production on Fri Feb 16 21:42:20 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL> quit
Disconnected from Oracle Database 10g Express Edition Release
10.2.0.1.0 - Production
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++==

(That's 6 times to finally exit)

 Any Ideas?

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

- Raw text -


  webmaster     delorie software   privacy  
  Copyright © 2019   by DJ Delorie     Updated Jul 2019