Sponsored Content
Top Forums Shell Programming and Scripting sqlplus @ not working sqlplus \@ working.. Post 302507532 by kunwar on Thursday 24th of March 2011 06:27:41 AM
Old 03-24-2011
I tried something to solve this issue I manually type the below. This thing has solved the login problem but gives rise to anothe problem Smilie.
1. When i press backspace it hits ENTER.
2. When i press the SHIFT+BACKSPACE it presses ^H character.

stty kill ^K (character above 6 in keypad and K)

Now Backspace is not working..which was working with Shift+Backspace earlier!!

Hi Please find below the details which you asked(After the changes which i tried Smilie)
Code:
> echo $SHELL
/bin/ksh
> stty -a
speed 38400 baud; line = 0;
rows = 37; columns = 154
min = 4; time = 0;
intr = DEL; quit = ^\; erase = #; kill = ^K
eof = ^D; eol = ^@; eol2 <undef>; swtch = ^@
stop = ^S; start = ^Q; susp <undef>; dsusp <undef>
werase <undef>; lnext <undef>
-parenb -parodd cs8 -cstopb hupcl cread -clocal -loblk -crts
-ignbrk brkint ignpar -parmrk -inpck istrip -inlcr -igncr icrnl -iuclc
ixon ixany -ixoff -imaxbel -rtsxoff -ctsxon -ienqak
isig icanon -iexten -xcase echo -echoe echok -echonl -noflsh
-echoctl -echoprt -echoke -flusho -pendin
opost -olcuc onlcr -ocrnl -onocr -onlret -ofill -ofdel -tostop

sqlplus REF1SSTDBO1/REF1SSTDBO1@TKS3N10G

By the above command i am trying to a login to a db named TKS3N10G ,REF1SSTDBO1 is the username ,REF1SSTDBO1 is the password.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Multiple SQLPLUS background processes not working properly

Hi All, I am running 25 background process from a Unix shell script which calls a single Oracle procedure with different paramenters each time. These 25 process creates 25 different files. When i run these 25 Background SQLPLUS processes, few files are not created completly but if i run 25... (1 Reply)
Discussion started by: rawat_me01
1 Replies

2. Shell Programming and Scripting

Sqlplus Set Heading not Working

Hello, Could someone tell me why this still returns headings? echo "SELECT columnA from tableA group by columnA;" | sqlplus -s ${DB_CONNECT} set heading OFF | while read line do arr="$line" echo ${arr} let i=$i+1 done (2 Replies)
Discussion started by: flowervz
2 Replies

3. Shell Programming and Scripting

Sqlplus error - sqlplus -s <login/password@dbname> : No such file or directory

i am using bash shell Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127. IFS="," declare -a Arr=($Variable1); SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE} echo "set head off ; " > ${SQLCMD} echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
Discussion started by: arghadeep adity
6 Replies

4. AIX

SQLPLUS -S option not working

Hi All, I am using the following script to run some sql on database but i am not getting the result. When i tried the same by removing "-s" option it is working fine but getting other things as well with my input as shown below. Can anyone please suggest why "-s" option is not working in AIX and... (2 Replies)
Discussion started by: ssk250
2 Replies

5. UNIX and Linux Applications

Problem on SQLplus command ""bash: sqlplus: command not found""

Hi all, i face an error related to my server ""it's running server"" when i use sqlplus command $ sqlplus bash: sqlplus: command not found the data base is up and running i just need to access the sqlplus to import the dump file as a daily backup. i already check the directory... (4 Replies)
Discussion started by: clerck
4 Replies

6. Shell Programming and Scripting

Working with UTF char sqlplus

I have below SQL that I wasnt to run from a solaris machine using sqlplus select * from TABLE_NAME where regexp_like(field_value, 'Α|Β|Γ|Δ|Ε|Ζ|Η|Θ|Ι|Κ|Λ|Μ|Ν|Ξ|Ο|Π|Ρ|Σ|Τ|Υ|Φ|Χ|Ψ|Ω|α|β|γ|δ|ε|ζ|η|θ|ι|κ|λ|μ|ν|ξ|ο|π|ρ|σ|τ|υ|φ|χ|ψ|ω'); When I cat the file UTF char shows perfect however when i run... (1 Reply)
Discussion started by: varun22486
1 Replies

7. Shell Programming and Scripting

Automating pbrun /bin/su not working, whenever manually it is working using putty

I am trying to automate a script where I need to use pbrun /bin/su but for some reason it is not passing thru the pbrun as my code below. . ~/.bash_profile pbrun /bin/su - content c h 1 hpsvn up file path I am executing this from an external .sh file that is pointing to this scripts file... (14 Replies)
Discussion started by: jorgejac
14 Replies

8. Shell Programming and Scripting

Sqlplus not working through ssh

Hi Gurus, I was trying to execute sqlplus command remotely like ssh -q IP venkat@"which sqlplus" am getting error as which: no sqlplus in (/usr/local/bin:/bin:/usr/bin) if i connect manually and executing which sqlplus it working fine. Please help to fix the issue. Regard's Venky (7 Replies)
Discussion started by: venky.b5
7 Replies

9. Shell Programming and Scripting

Disk Space Utilization in HTML format working in one environment and not working on the other

Hi Team, I have written the shell script which returns the result of the disk space filesystems which has crossed the threshold limit in HTML Format. Below mentioned is the script which worked perfectly on QA system. df -h | awk -v host=`hostname` ' BEGIN { print "<table border="4"... (13 Replies)
Discussion started by: Harihsun
13 Replies

10. UNIX for Beginners Questions & Answers

"SQLPLUS -S " is not working in one environment where same code is working in another

"SQLPLUS -S " is not working in one environment where same code is working in another getting below error =================================== SQL*Plus: Release 11.2.0.3.0 Production Copyright (c) 1982, 2011, Oracle. All rights reserved. Use SQL*Plus to execute SQL, PL/SQL and SQL*Plus... (1 Reply)
Discussion started by: yogendra.barode
1 Replies
IO::Stty(3)						User Contributed Perl Documentation					       IO::Stty(3)

NAME
Change and print terminal line settings SYNOPSIS
# calling the script directly stty.pl [setting...] stty.pl {-a,-g,-v,--version} # Calling Stty module use IO::Stty; IO::Stty::stty(*TTYHANDLE, @modes); use IO::Stty; $old_mode=IO::Stty::stty(*STDIN,'-g'); # Turn off echoing. IO::Stty::stty(*STDIN,'-echo'); # Do whatever.. grab input maybe? $read_password = <>; # Now restore the old mode. IO::Stty::stty(*STDIN,$old_mode); # What settings do we have anyway? print IO::Stty::stty(*STDIN,'-a'); DESCRIPTION
This is the PERL POSIX compliant stty. INTRO
This has not been tailored to the IO::File stuff but will work with it as indicated. Before you go futzing with term parameters it's a good idea to grab the current settings and restore them when you finish. stty accepts the following non-option arguments that change aspects of the terminal line operation. A `[-]' before a capability means that it can be turned off by preceding it with a `-'. stty parameters Control settings [-]parenb Generate parity bit in output and expect parity bit in input. [-]parodd Set odd parity (even with `-'). cs5 cs6 cs7 cs8 Set character size to 5, 6, 7, or 8 bits. [-]hupcl [-]hup Send a hangup signal when the last process closes the tty. [-]cstopb Use two stop bits per character (one with `-'). [-]cread Allow input to be received. [-]clocal Disable modem control signals. Input settings [-]ignbrk Ignore break characters. [-]brkint Breaks cause an interrupt signal. [-]ignpar Ignore characters with parity errors. [-]parmrk Mark parity errors (with a 255-0-character sequence). [-]inpck Enable input parity checking. [-]istrip Clear high (8th) bit of input characters. [-]inlcr Translate newline to carriage return. [-]igncr Ignore carriage return. [-]icrnl Translate carriage return to newline. [-]ixon Enable XON/XOFF flow control. [-]ixoff Enable sending of stop character when the system input buffer is almost full, and start character when it becomes almost empty again. Output settings [-]opost Postprocess output. Local settings [-]isig Enable interrupt, quit, and suspend special characters. [-]icanon Enable erase, kill, werase, and rprnt special characters. [-]echo Echo input characters. [-]echoe, [-]crterase Echo erase characters as backspace-space-backspace. [-]echok Echo a newline after a kill character. [-]echonl Echo newline even if not echoing other characters. [-]noflsh Disable flushing after interrupt and quit special characters. * Though this claims non-posixhood it is supported by the perl POSIX.pm. [-]tostop (np) Stop background jobs that try to write to the terminal. Combination settings ek Reset the erase and kill special characters to their default values. sane Same as: cread -ignbrk brkint -inlcr -igncr icrnl -ixoff opost isig icanon echo echoe echok -echonl -noflsh -tostop also sets all special characters to their default values. [-]cooked Same as: brkint ignpar istrip icrnl ixon opost isig icanon plus sets the eof and eol characters to their default values if they are the same as the min and time characters. With `-', same as raw. [-]raw Same as: -ignbrk -brkint -ignpar -parmrk -inpck -istrip -inlcr -igncr -icrnl -ixon -ixoff -opost -isig -icanon min 1 time 0 With `-', same as cooked. [-]pass8 Same as: -parenb -istrip cs8 With `-', same as parenb istrip cs7. dec Same as: echoe echoctl echoke -ixany Also sets the interrupt special character to Ctrl-C, erase to Del, and kill to Ctrl-U. Special characters The special characters' default values vary from system to system. They are set with the syntax `name value', where the names are listed below and the value can be given either literally, in hat notation (`^c'), or as an integer which may start with `0x' to indicate hexadecimal, `0' to indicate octal, or any other digit to indicate decimal. Giving a value of `^-' or `undef' disables that special character. intr Send an interrupt signal. quit Send a quit signal. erase Erase the last character typed. kill Erase the current line. eof Send an end of file (terminate the input). eol End the line. start Restart the output after stopping it. stop Stop the output. susp Send a terminal stop signal. Special settings min N Set the minimum number of characters that will satisfy a read until the time value has expired, when <E>-icanon<E> is set. time N Set the number of tenths of a second before reads time out if the min number of characters have not been read, when -icanon is set. N Set the input and output speeds to N. N can be one of: 0 50 75 110 134 134.5 150 200 300 600 1200 1800 2400 4800 9600 19200 38400 exta extb. exta is the same as 19200; extb is the same as 38400. 0 hangs up the line if -clocal is set. OPTIONS -a Print all current settings in human-readable form. -g Print all current settings in a form that can be used as an argument to another stty command to restore the current settings. -v,--version Print version info. Direct Subroutines stty() IO::Stty::stty(*STDIN, @params); From comments: I'm not feeling very inspired about this. Terminal parameters are obscure and boring. Basically what this will do is get the current setting, take the parameters, modify the setting and write it back. Zzzz. This is not especially efficent and probably not too fast. Assuming the POSIX spec has been implemented properly it should mostly work. show_me_the_crap() Needs documentation AUTHOR
Austin Schutz <auschutz@cpan.org> (Initial version and maintenance) Todd Rinaldo <toddr@cpan.org> (Maintenance) BUGS
This is use at your own risk software. Do anything you want with it except blame me for it blowing up your machine because it's full of bugs. See above for what functions are supported. It's mostly standard POSIX stuff. If any of the settings are wrong and you actually know what some of these extremely arcane settings (like what 'sane' should be in POSIX land) really should be, please open an RT ticket. ACKNOWLEDGEMENTS
None COPYRIGHT &; LICENSE Copyright 1997 Austin Schutz, all rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.18.2 2017-10-06 IO::Stty(3)
All times are GMT -4. The time now is 02:52 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy