X-Spam-Check-By: sourceware.org Message-ID: <5bfc44150702162050k3cc48d90kd59586813e39607@mail.gmail.com> Date: Fri, 16 Feb 2007 21:50:08 -0700 From: "Jason Thurston" To: cygwin AT cygwin DOT com Subject: Oracle 10g sqlplus takes 6 quits or exits when run from cygwin MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-IsSubscribed: yes Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm List-Id: List-Subscribe: List-Archive: List-Post: List-Help: , 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" 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" 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/