I would like to ask you for help with the issue I encounter in
SQLPlus. When I run a command and want to interrupt it with Control +
C (^C), i'm not able to do so as the command is running further.
Moreover if I press ^C on empty command line and the want to run any
command I have no output as well as I'm not able to quit SQLPlus
properly. I believe it's some configuration issue but can't find it. I
already tried to play with stty terminal command as well as with $TERM
env. variable but was not able to fix the issue.
When I connect to server where the database is running locally and run
SQLPlus from there it works fine.
I would be thankful for any hint.
On Mon, Jun 27, 2011 at 1:40 AM, Marcel Paul <marcel.p...@gmail.com> wrote: > Hello,
> I would like to ask you for help with the issue I encounter in > SQLPlus. When I run a command and want to interrupt it with Control + > C (^C), i'm not able to do so as the command is running further. > Moreover if I press ^C on empty command line and the want to run any > command I have no output as well as I'm not able to quit SQLPlus > properly. I believe it's some configuration issue but can't find it. I > already tried to play with stty terminal command as well as with $TERM > env. variable but was not able to fix the issue. > When I connect to server where the database is running locally and run > SQLPlus from there it works fine. > I would be thankful for any hint.
Yeah, intr is set to ^C, that was first thing I checked. Even in
terminal in SQLPlus when I press it I can see it on the screen as the
last characters. After these characters I can't write anything, no
output is sent to screen, everything just hangs.
Best regards,
Marcel
On Jun 28, 1:40 am, George Nachman <gnach...@llamas.org> wrote:
> If not, run this command before starting SQLPlus:
> stty intr ^C
> and see if that helps.
> On Mon, Jun 27, 2011 at 1:40 AM, Marcel Paul <marcel.p...@gmail.com> wrote:
> > Hello,
> > I would like to ask you for help with the issue I encounter in
> > SQLPlus. When I run a command and want to interrupt it with Control +
> > C (^C), i'm not able to do so as the command is running further.
> > Moreover if I press ^C on empty command line and the want to run any
> > command I have no output as well as I'm not able to quit SQLPlus
> > properly. I believe it's some configuration issue but can't find it. I
> > already tried to play with stty terminal command as well as with $TERM
> > env. variable but was not able to fix the issue.
> > When I connect to server where the database is running locally and run
> > SQLPlus from there it works fine.
> > I would be thankful for any hint.
On Tue, Jun 28, 2011 at 12:02 AM, Marcel Paul <marcel.p...@gmail.com> wrote: > Hello, thanks for the quick answer..
> Yeah, intr is set to ^C, that was first thing I checked. Even in > terminal in SQLPlus when I press it I can see it on the screen as the > last characters. After these characters I can't write anything, no > output is sent to screen, everything just hangs.
> Best regards, > Marcel
> On Jun 28, 1:40 am, George Nachman <gnach...@llamas.org> wrote: >> If you run:
>> stty -a
>> does it say:
>> intr = ^C
>> If not, run this command before starting SQLPlus:
>> stty intr ^C
>> and see if that helps.
>> On Mon, Jun 27, 2011 at 1:40 AM, Marcel Paul <marcel.p...@gmail.com> wrote: >> > Hello,
>> > I would like to ask you for help with the issue I encounter in >> > SQLPlus. When I run a command and want to interrupt it with Control + >> > C (^C), i'm not able to do so as the command is running further. >> > Moreover if I press ^C on empty command line and the want to run any >> > command I have no output as well as I'm not able to quit SQLPlus >> > properly. I believe it's some configuration issue but can't find it. I >> > already tried to play with stty terminal command as well as with $TERM >> > env. variable but was not able to fix the issue. >> > When I connect to server where the database is running locally and run >> > SQLPlus from there it works fine. >> > I would be thankful for any hint.
I believe it's the way how Oracle handle ^C command sent via network
as local connection works fine.
I checked the ^\ command before and it worked but it's a kill of an
entire session when I got completely disconnected.
Thanks for your help.
Marcel
On Jun 28, 6:18 pm, George Nachman <gnach...@llamas.org> wrote:
> It sounds like SQLPlus is probably catching the signal. You can try
> ^\, which sends the QUIT signal, and is not usually caught.
> On Tue, Jun 28, 2011 at 12:02 AM, Marcel Paul <marcel.p...@gmail.com> wrote:
> > Hello, thanks for the quick answer..
> > Yeah, intr is set to ^C, that was first thing I checked. Even in
> > terminal in SQLPlus when I press it I can see it on the screen as the
> > last characters. After these characters I can't write anything, no
> > output is sent to screen, everything just hangs.
> > Best regards,
> > Marcel
> > On Jun 28, 1:40 am, George Nachman <gnach...@llamas.org> wrote:
> >> If you run:
> >> stty -a
> >> does it say:
> >> intr = ^C
> >> If not, run this command before starting SQLPlus:
> >> stty intr ^C
> >> and see if that helps.
> >> On Mon, Jun 27, 2011 at 1:40 AM, Marcel Paul <marcel.p...@gmail.com> wrote:
> >> > Hello,
> >> > I would like to ask you for help with the issue I encounter in
> >> > SQLPlus. When I run a command and want to interrupt it with Control +
> >> > C (^C), i'm not able to do so as the command is running further.
> >> > Moreover if I press ^C on empty command line and the want to run any
> >> > command I have no output as well as I'm not able to quit SQLPlus
> >> > properly. I believe it's some configuration issue but can't find it. I
> >> > already tried to play with stty terminal command as well as with $TERM
> >> > env. variable but was not able to fix the issue.
> >> > When I connect to server where the database is running locally and run
> >> > SQLPlus from there it works fine.
> >> > I would be thankful for any hint.
On Wed, Jun 29, 2011 at 1:45 AM, Marcel Paul <marcel.p...@gmail.com> wrote: > I believe it's the way how Oracle handle ^C command sent via network > as local connection works fine. > I checked the ^\ command before and it worked but it's a kill of an > entire session when I got completely disconnected. > Thanks for your help.
> Marcel
> On Jun 28, 6:18 pm, George Nachman <gnach...@llamas.org> wrote: >> It sounds like SQLPlus is probably catching the signal. You can try >> ^\, which sends the QUIT signal, and is not usually caught.
>> On Tue, Jun 28, 2011 at 12:02 AM, Marcel Paul <marcel.p...@gmail.com> wrote: >> > Hello, thanks for the quick answer..
>> > Yeah, intr is set to ^C, that was first thing I checked. Even in >> > terminal in SQLPlus when I press it I can see it on the screen as the >> > last characters. After these characters I can't write anything, no >> > output is sent to screen, everything just hangs.
>> > Best regards, >> > Marcel
>> > On Jun 28, 1:40 am, George Nachman <gnach...@llamas.org> wrote: >> >> If you run:
>> >> stty -a
>> >> does it say:
>> >> intr = ^C
>> >> If not, run this command before starting SQLPlus:
>> >> stty intr ^C
>> >> and see if that helps.
>> >> On Mon, Jun 27, 2011 at 1:40 AM, Marcel Paul <marcel.p...@gmail.com> wrote: >> >> > Hello,
>> >> > I would like to ask you for help with the issue I encounter in >> >> > SQLPlus. When I run a command and want to interrupt it with Control + >> >> > C (^C), i'm not able to do so as the command is running further. >> >> > Moreover if I press ^C on empty command line and the want to run any >> >> > command I have no output as well as I'm not able to quit SQLPlus >> >> > properly. I believe it's some configuration issue but can't find it. I >> >> > already tried to play with stty terminal command as well as with $TERM >> >> > env. variable but was not able to fix the issue. >> >> > When I connect to server where the database is running locally and run >> >> > SQLPlus from there it works fine. >> >> > I would be thankful for any hint.
> Sorry, I'm not sure what's going on. Usually, configuring stty to send
> intr for ^C does the trick. There may be a bug in the SQLPlus client.
> On Wed, Jun 29, 2011 at 1:45 AM, Marcel Paul <marcel.p...@gmail.com> wrote:
> > I believe it's the way how Oracle handle ^C command sent via network
> > as local connection works fine.
> > I checked the ^\ command before and it worked but it's a kill of an
> > entire session when I got completely disconnected.
> > Thanks for your help.
> > Marcel
> > On Jun 28, 6:18 pm, George Nachman <gnach...@llamas.org> wrote:
> >> It sounds like SQLPlus is probably catching the signal. You can try
> >> ^\, which sends the QUIT signal, and is not usually caught.
> >> On Tue, Jun 28, 2011 at 12:02 AM, Marcel Paul <marcel.p...@gmail.com> wrote:
> >> > Hello, thanks for the quick answer..
> >> > Yeah, intr is set to ^C, that was first thing I checked. Even in
> >> > terminal in SQLPlus when I press it I can see it on the screen as the
> >> > last characters. After these characters I can't write anything, no
> >> > output is sent to screen, everything just hangs.
> >> > Best regards,
> >> > Marcel
> >> > On Jun 28, 1:40 am, George Nachman <gnach...@llamas.org> wrote:
> >> >> If you run:
> >> >> stty -a
> >> >> does it say:
> >> >> intr = ^C
> >> >> If not, run this command before starting SQLPlus:
> >> >> stty intr ^C
> >> >> and see if that helps.
> >> >> On Mon, Jun 27, 2011 at 1:40 AM, Marcel Paul <marcel.p...@gmail.com> wrote:
> >> >> > Hello,
> >> >> > I would like to ask you for help with the issue I encounter in
> >> >> > SQLPlus. When I run a command and want to interrupt it with Control +
> >> >> > C (^C), i'm not able to do so as the command is running further.
> >> >> > Moreover if I press ^C on empty command line and the want to run any
> >> >> > command I have no output as well as I'm not able to quit SQLPlus
> >> >> > properly. I believe it's some configuration issue but can't find it. I
> >> >> > already tried to play with stty terminal command as well as with $TERM
> >> >> > env. variable but was not able to fix the issue.
> >> >> > When I connect to server where the database is running locally and run
> >> >> > SQLPlus from there it works fine.
> >> >> > I would be thankful for any hint.
