March 2009
M T W T F S S
« Dec   Apr »
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

Small introduction to SQL*Net debugging [client side]

http://www.liberidu.com/blog/?page_id=230

Posted on September 29, 2005
Filed Under SQL*Net, Protocol Server, RDBMS, Oracle

Say it’s that day again. You try to connect to a (new) database and once again you are facing SQL*Net problems.
C:/oracle/product/10.1.0/client/BIN>sqlplus /nolog
SQL*Plus: Release 10.1.0.4.0 – Production ON Thu Sep 29 10:37:15 2005
Copyright (c) 1982, 2005, Oracle. ALL rights reserved.
SQL> conn scott/tiger@lab.amis.nl
ERROR: ORA-12154:
TNS:could NOT resolve the [...]

Some examples of stty usage

1.Typing invisiable password

?View Code TEXT1
2
3
4
5
echo "Enter your password: \c"
oldstty=`stty -g`
stty -echo intr ^-
read password
stty $oldstty

2.Backspace setting

?View Code TEXT1
stty erase ^h

3.Colunm setting

?View Code TEXT1
stty column 100

4.List current stty setting

?View Code TEXT1
2
3
stty -a (all setting)
stty (undefault setting)
stty -g (RAW mode)

You can get the help files regarding stty usage in the folllowing ways:

?View Code [...]