1748234 Members
3211 Online
108759 Solutions
New Discussion юеВ

Re: sqlplus & ied

 
Anthony Petiot
New Member

sqlplus & ied

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
11 REPLIES 11
Jon Mattatall
Esteemed Contributor

Re: sqlplus & ied

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...
A little knowledge is dangerous - none is absolutely terrifying!!!
Anthony Petiot
New Member

Re: sqlplus & ied

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 ?
Tim Sanko
Trusted Contributor

Re: sqlplus & ied

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
Andreas Pinter
New Member

Re: sqlplus & ied

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
Massimo Bianchi
Honored Contributor

Re: sqlplus & ied

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

Andreas Pinter
New Member

Re: sqlplus & ied

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
Massimo Bianchi
Honored Contributor

Re: sqlplus & ied

Do you use any "stty" command ?

Massimo
Andreas Pinter
New Member

Re: sqlplus & ied

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?
Vishal Augustine
Frequent Advisor

Re: sqlplus & ied

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