topic Re: sqlplus & ied in Operating System - HP-UX

sqlplus & ied

Anthony Petiot — Fri, 02 May 2003 14:53:25 GMT

Hi,

I am facing problems using ied. When i type

$ ied sqlplus user/pass

it just hangs. If i do a ^c to get out, it prints the following message.

ied: final TCSETA ioctl failed: Not a typewriter
ied terminating.

A uname -r on my m/c give me this B.11.00 And a what on my ied give
me "ied version 82.3 97/09/10". My TERM is set to vt100 (i am using
a telnet session).

Would appreciate any help to fix the problem.

Thanks in advance,
Anthony

Re: sqlplus & ied

Jon Mattatall — Fri, 02 May 2003 17:24:09 GMT

I'm not real familiar with ied, but as a first step, try

ied -d sqlplus user/pass

Is this how you normally access sqlplus? Telnet or console, we don't use ied here...

Re: sqlplus & ied

Anthony Petiot — Mon, 05 May 2003 13:51:15 GMT

Effectively, I should have done it before. Thanks.
The only problem (and I forgot to mention it) is that "ied sqlplus" work from time to time, and "unfortunatelly" it works right now so I cannot test it immediately.

Any other idea ?

Re: sqlplus & ied

Tim Sanko — Mon, 05 May 2003 14:20:44 GMT

Anthony,

ied has it's own quirks. It has hooks into the oracle commands to allow the rollback of the commands.

Did you upgrade Oracle without a complete relink of Oracle. We had problems when we had several versions of 8.0.6 and 8.1.6 with four instances on one box. We had to cut down to 8.0.6 again before ied was happy (we only had small 100 M tests in place.) we relinked oracle after finishing our testing, and were happy with ied again.

Tim

Re: sqlplus & ied

Andreas Pinter — Wed, 02 Jul 2003 12:20:34 GMT

Hello,

I just wanted to say: I'm having EXACTLY the same problem, the only difference is, that I want to run ied on isql (Sybase-Client..).

I get exactly the same error message when doing ^c ("final TCSETA ioctl failed....").

And, another problem Anthony had as well: from time to time ied works, and most of the time it doesn't :-(

It would be really nice to find a fix for this problem.

cheers,
Andreas

Re: sqlplus & ied

Massimo Bianchi — Wed, 02 Jul 2003 12:25:31 GMT

Hi,
to track down the problem, can both of you specify
SHELL
EDITOR
HISTFILE
values for variables...

I think to some shell related problem... or term settings ? Anything strange ?

Massimo

Re: sqlplus & ied

Andreas Pinter — Wed, 02 Jul 2003 12:31:17 GMT

SHELL=/sbin/sh
EDITOR=vi

A HISTFILE variable wasn't set, but setting it
to the filename of an empty file I created
didn't help getting ied working.

Andreas

Re: sqlplus & ied

Massimo Bianchi — Wed, 02 Jul 2003 14:10:02 GMT

Do you use any "stty" command ?

Massimo

Re: sqlplus & ied

Andreas Pinter — Fri, 18 Jul 2003 06:47:53 GMT

No, I'm actually not setting something with stty, but that's what stty is reporting:

speed 9600 baud; evenp hupcl -cread
intr = ^C; erase = ^H; kill = ^U;
swtch ;
brkint -inpck icrnl -ixany ixoff onlcr
-iexten echo echoe echok
-echoctl -echoke

Perhaps I should change some of those stty-settings?

Re: sqlplus & ied

Vishal Augustine — Mon, 13 Oct 2003 17:36:57 GMT

Me too face the same probs.

Not sure if it is oracle related or HP (ied) related probs.

Try "ied sh", "ied bc" when u encounter the problem with "ied sqlplus". U will get the same result/error. This prompts me to think tht the cause has nothing to do with 8.1.7 or 8.0.6 versions of oracle.

I have ied version PATCH_11_00: version.o ied.o emacs.o history.o vi.o edit.o 01/12/12.

IT Guru's, do u know the soln to this problem ? Any patches to cover this bug.

Regards
Vishal

Re: sqlplus & ied

P Turner — Thu, 13 Nov 2003 08:16:48 GMT

I also am having this problem when using ied with another product. The problem seems related to the use of /dev/pty files. On our system the first six ied sessions start ok but no more than that. Each session uses a /dev/pty file but although there are plenty more free files the subsequent ied sessions just hang.

PT

Re: sqlplus & ied

Phan Wai Keong_1 — Tue, 12 Oct 2004 04:50:40 GMT

So, anybody has got an answer to the problem? Any fixes?