DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: "stty: : Inappropriate ioctl for device"?

  1. #1
    Join Date
    Mar 2001
    Posts
    287
    I run a shell on Solaris and got "stty: : Inappropriate ioctl for device" message. The program runs very well except that message. I know this is because I use "host" inside the SQL PLUS session. But, why? If I run this in a standalone SQL PLUS session (I mean, not through a shell),
    there is no such message.

    Does any one have any idea?


    =======================================
    This is the shell I run:

    CURR_DIR=/u01/tom;export CURR_DIR
    SCRIPT_DIR=$CURR_DIR/script;export SCRIPT_DIR
    LOG_FILE=$CURR_DIR/log/ck_perf.log;export LOG_FILE

    EMAIL_ADDRESS=tom@tty.com; export EMAIL_ADDRESS

    if test $# -ne 1
    then
    echo Usage: `basename $0` sid
    exit 1
    fi

    cd $SCRIPT_DIR
    {
    sqlplus -s /nolog <<__EOF 1>$LOG_FILE 2>&1
    connect dba_admin/$DBA_PWD@$1
    select sysdate from dual;
    host date
    __EOF
    }>$LOG_FILE
    cat $LOG_FILE|mailx -s "logfile" tom@tty.com

    =====================================
    The result of the logfile. Please see the "ioctl" at the bottom.

    Connected.

    SYSDATE
    ---------
    26-APR-01

    stty: : Inappropriate ioctl for device
    Thu Apr 26 11:19:35 PDT 2001


  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    It might be because that when you transfre the control to the host, it is getting to confuse what shell to use.

    try using :"truss" to find out where it is going wrong.

    Hope this would help you to debug things.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width