Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

sqlplus & ied

Anthony Petiot
Occasional Visitor

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
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
Occasional Visitor

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
Occasional Visitor

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
Occasional Visitor

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
Occasional Visitor

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
P Turner
Occasional Advisor

Re: sqlplus & ied

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
Phan Wai Keong_1
Occasional Visitor

Re: sqlplus & ied

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