Re: Ctrl C in SQLPlus exits Windows

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 8 Apr 2019 14:50:19 -0400

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@xxxxxxxxx <mailto:lambu999@xxxxxxxxx>> 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

Other related posts: