26 November 2011

Unable to sftp “OTN Developer Days” Box - Received message too long


Today, I was not able to connect my “OTN Developer Days” Box via sftp interface. When I check it, profile file (the file which executes initially when you connect) was echoing some informational data. I think sftp interface has some problems with initially printed messagesJ. Then I comment some lines in the .bashrc and .bash_profile files in order to connect my RedHat box. I showed the solution as follows. Please note that I gave static IP address to my RH box.


connect sftp
====================
[root@dhcppc5 oracle]# sftp oracle@192.168.1.38
Connecting to 192.168.1.38...
The authenticity of host '192.168.1.38 (192.168.1.38)' can't be established.
RSA key fingerprint is 07:15:bb:a2:a6:ba:60:3f:c3:31:a9:c9:4a:7c:51:6a.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '192.168.1.38' (RSA) to the list of known hosts.
oracle@192.168.1.38's password:
Received message too long 1097624608





connect via ssh before any changes
======================================================
Last login: Tue Nov 22 22:57:06 2011 from 192.168.1.35
All passwords are oracle or noted if otherwise.

The SQL Developer and Data Modeler scripts are in the directory:
/home/oracle/Desktop/SQLDev_Tutorials/sqldev

To Reset the labs:
SQL Developer:            /home/oracle/reset_sqldev
Application Express:      /home/oracle/reset_apex
In-Memory Database Cache: /home/oracle/reset_imdbcache
XML Database:             /home/oracle/reset_xmldb

Oracle Enterprise Manager
Start: emctl start dbconsole
Stop : emctl stop dbconsole
URL  : https://127.0.0.1:1158/em

*** Please note that this appliance is for testing purposes only,
as such it is unsupported and should not be used as a production environment.


          inet addr:192.168.1.38  Bcast:192.168.1.255  Mask:255.255.255.0
          inet addr:127.0.0.1  Mask:255.0.0.0

LD_LIBRARY_PATH set to /home/oracle/app/oracle/product/TimesTen/tt1121/lib:/home/oracle/app/oracle/product/TimesTen/tt1121/ttoracle_home/instantclient_11_1:/home/oracle/app/oracle/product/11.2.0/dbhome_2/lib

ANT_HOME set to /home/oracle/app/oracle/product/TimesTen/tt1121/3rdparty/ant

PATH set to /home/oracle/app/oracle/product/TimesTen/tt1121/bin:/home/oracle/app/oracle/product/TimesTen/tt1121/quickstart/sample_code/oci:/home/oracle/app/oracle/product/TimesTen/tt1121/quickstart/sample_code/odbc:/home/oracle/app/oracle/product/TimesTen/tt1121/quickstart/sample_code/odbc/xla:/home/oracle/app/oracle/product/TimesTen/tt1121/quickstart/sample_code/jdbc:/home/oracle/app/oracle/product/TimesTen/tt1121/quickstart/sample_code/odbc_drivermgr:/home/oracle/app/oracle/product/TimesTen/tt1121/quickstart/sample_code/proc:/home/oracle/app/oracle/product/TimesTen/tt1121/quickstart/sample_code/ttclasses:/home/oracle/app/oracle/product/TimesTen/tt1121/quickstart/sample_code/ttclasses/xla:/home/oracle/app/oracle/product/TimesTen/tt1121/ttoracle_home/instantclient_11_1:/home/oracle/app/oracle/product/TimesTen/tt1121/ttoracle_home/instantclient_11_1/sdk:/home/oracle/app/oracle/product/TimesTen/tt1121/3rdparty/ant/bin:/usr/java/latest/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/app/oracle/product/11.2.0/dbhome_2/bin:/home/oracle/bin

CLASSPATH set to /home/oracle/app/oracle/product/TimesTen/tt1121/lib/ttjdbc6.jar:/home/oracle/app/oracle/product/TimesTen/tt1121/lib/orai18n.jar:/home/oracle/app/oracle/product/TimesTen/tt1121/lib/timestenjmsxla.jar:/home/oracle/app/oracle/product/TimesTen/tt1121/3rdparty/jms1.1/lib/jms.jar:.:/home/oracle/app/oracle/product/11.2.0/dbhome_2/ucp/lib/ucp.jar:/home/oracle/app/oracle/product/11.2.0/dbhome_2/jdbc/lib/ojdbc6.jar

TNS_ADMIN set to /home/oracle/app/oracle/product/11.2.0/dbhome_2/network/admin

IP Address is:
          inet addr:192.168.1.38  Bcast:192.168.1.255  Mask:255.255.255.0
          inet addr:127.0.0.1  Mask:255.0.0.0
[oracle@dhcppc5 ~]$




change .bashrc
================
## following lines have been commented by mennan for ftp issue
# cat ~/Desktop/README.txt

# /sbin/ifconfig | grep "inet addr"

change .bash_profile
==================================
## following line has been commented by mennan for ftp issue
## please note that if you are using TimesTen in memory database, please do not comment and check contents of following file and remove any unnecessary _echoes_
# . $TT_HOME/bin/ttenv.sh


connect via ssh after changes
======================================================
Last login: Sat Nov 26 22:42:14 2011 from 192.168.1.35
IP Address is:
          inet addr:192.168.1.38  Bcast:192.168.1.255  Mask:255.255.255.0
          inet addr:127.0.0.1  Mask:255.0.0.0
[oracle@dhcppc5 ~]$


connect sftp after changes
========================================
[root@dhcppc5 oracle]# sftp oracle@192.168.1.38
Connecting to 192.168.1.38...
oracle@192.168.1.38's password:
sftp> exit

1 comment:

Anonymous said...

Nice one - used this today! Cheers