Re: Ctrl C in SQLPlus exits Windows

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 8 Apr 2019 14:50:19 -0400
Message-ID: <1b6a0d60-3fa9-d3bc-d856-94e6e28f3467_at_gmail.com>



Winduhs is not POSIX compliant. If you check the POSIX signals, here:

https://dsa.cs.tsinghua.edu.cn/oj/static/unix_signal.html

You will find that signals

On 4/7/19 9:13 PM, Jared Still wrote:
> CTL-C is handled differently on Windows than it is on any other OS
> that Oracle runs on.
>
> Linux for instance supports out of band breaks in the TCP stack, while
> Windows does not.
>
> When a database on a Linux service is supporting a connection from a
> Windows machine, every 4th packet Oracle polls the client; kind of
> asking "are you still there?"
>
> The out of band breaks are how CTL-C is detected on linux clients,
> while on Windows it is a polling operation.
>
> It appears that there is a bug in the CTL-C handling for Windows clients.
>
> It is kind of funny you referred to my 10 year old post on the topic.
>
> 1) the poster responded that sometimes Oracle is installed on Windows.
>  yeah, I knew that, as I had spend 8 years at that time adminstering
> Windows based databases, but I did it mostly from Linux.
>
> 2) if thus is a bug, it is a very old bug.  but sometimes you have to
> file an SR to get a bug fixed. Two weeks ago I got fed up and filed
> and SR for a sqlnet bug that has been around since at least 11gR2, but
> was still present in 19c.
>
> you may want to create an SR. :)
>
>
>
> On Sun, Mar 10, 2019 at 00:00 Ram K <lambu999_at_gmail.com
> <mailto:lambu999_at_gmail.com>> wrote:
>
> Installed Oracle in my home Windows PC and playing around with it.
> But pressing Ctrl-C always exits SQL Plus, when I run queries.
> grr... Tried searching online and found  this:
>
> https://grokbase.com/t/freelists.org/oracle-l/095myarkwd/11g-sqlplus-on-windows-and-ctrl-c
>
> Is there a solution for Ctrl C only to interrupt and not to exit
> SQL Plus in windows.
>
> --
> Thanks,
> Ram.
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
> Principal Consultant at Pythian
> Pythian Blog http://www.pythian.com/blog/author/still/
> Github: https://github.com/jkstill
>
>

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 08 2019 - 20:50:19 CEST

Original text of this message