Re: about good SSH tools with FTP function
From: riverdance <esthershensh_at_yahoo.com>
Date: Fri, 6 Aug 2010 12:42:20 -0700 (PDT)
Message-ID: <40fb8536-986b-4c55-87e3-d85b9759c461_at_x25g2000yqj.googlegroups.com>
On Aug 5, 8:51 pm, Tim X <t..._at_nospam.dev.null> wrote:
> riverdance <esthershe..._at_yahoo.com> writes:
> > On Aug 3, 11:33 am, Rob Burton <burton...._at_gmail.com> wrote:
> >> On Aug 3, 2:41 pm, riverdance <esthershe..._at_yahoo.com> wrote:
>
> >> > Hi,
> >> > I still new in oracle world.
> >> > I had a basic question..about what kind of tools DBA used to access
> >> > oracle server to do their daily job.
>
> >> > I start doing some oracle admin work.. I also need ftp the files from
> >> > my desktop to Unix server from time to time.. is there any good tools
> >> > which could do both SSH and FTP ?
>
> >> > I used to use secure SSH, but it seems not good in oracle. every time,
> >> > from oracle sqlplus session, if I mistype something, it cannot be
> >> > corrected by backspace, the only way is retype the whole command from
> >> > begining..
>
> >> > so I had to switch to putty, since putty don't have this problem. but
> >> > it don't have FTP function, I had to use secure SSH to do the FTP , it
> >> > mean another login process..
>
> >> > I don't know what kind of tools oracle DBA use to do their daily admin
> >> > work? if the tool had xwindows function, that would be great. since
> >> > it looks like some oracle software, must install under GUI , there is
> >> > no command option .
>
> >> > your suggestion is really appreciated.
>
> >> scp can be used to transfer files, or pscp if you're using putty (a
> >> separate download , which also has psftp which I'd guess would do ftp
> >> too.)- Hide quoted text -
>
> >> - Show quoted text -
>
> > Hi, Thanks.
>
> > I tried winscp before , not sure if that is the same scp you
> > mentioned, it seems need to input userid and PW again.. I'm looking
> > for some tools which just need login once and could do FTP and SSH
> > without going through login process again...
>
> > I would try to find pscp /psftp to see if that works..
>
> This is normally handled by an ssh-agent. Don't know what the state is
> under windows, but under Linux and probably Mac, you simply start up an
> ssh-agent as part of your session startup (the agent needs to run in the
> parent process of processes you wish to use it from).
>
> With the ssh-agent running, the first time you try to go to a remote
> host, using either ssh or scp, you are asked for you passphrase via a
> popup (or command line if not running under a GUI). From that point on,
> the ssh-agent handles the passphrase for you - you will not be prompted
> again for the passphrase when you next visit that host or use scp to
> copy files to that host.
>
> Other alternatives would be
>
> * use emacs with its built-in 'tramp' mode. Allows you to edit remote
> files and copy files from local to remote host and vice-versa. Steep
> learning curve if your not familiar with it.
>
> * Set up an NFS, SMB or similar share. If your on windows, setup samba
> on your server
>
> * Use something like dropbox
>
> There are many other possible solutions. A lot depends on exactly what
> you need to do and how often and what level of control/access you have
> to the remote server. I personally rarely need to copy files to the
> database. I run the Oracle instant client from my workstation and that
> pretty much provides all I need 90% of the time. The only time I need to
> copy files around is when I'm using external tables.
>
> Tim
>
> --
> tcross (at) rapttech dot com dot au- Hide quoted text -
>
> - Show quoted text -
Date: Fri, 6 Aug 2010 12:42:20 -0700 (PDT)
Message-ID: <40fb8536-986b-4c55-87e3-d85b9759c461_at_x25g2000yqj.googlegroups.com>
On Aug 5, 8:51 pm, Tim X <t..._at_nospam.dev.null> wrote:
> riverdance <esthershe..._at_yahoo.com> writes:
> > On Aug 3, 11:33 am, Rob Burton <burton...._at_gmail.com> wrote:
> >> On Aug 3, 2:41 pm, riverdance <esthershe..._at_yahoo.com> wrote:
>
> >> > Hi,
> >> > I still new in oracle world.
> >> > I had a basic question..about what kind of tools DBA used to access
> >> > oracle server to do their daily job.
>
> >> > I start doing some oracle admin work.. I also need ftp the files from
> >> > my desktop to Unix server from time to time.. is there any good tools
> >> > which could do both SSH and FTP ?
>
> >> > I used to use secure SSH, but it seems not good in oracle. every time,
> >> > from oracle sqlplus session, if I mistype something, it cannot be
> >> > corrected by backspace, the only way is retype the whole command from
> >> > begining..
>
> >> > so I had to switch to putty, since putty don't have this problem. but
> >> > it don't have FTP function, I had to use secure SSH to do the FTP , it
> >> > mean another login process..
>
> >> > I don't know what kind of tools oracle DBA use to do their daily admin
> >> > work? if the tool had xwindows function, that would be great. since
> >> > it looks like some oracle software, must install under GUI , there is
> >> > no command option .
>
> >> > your suggestion is really appreciated.
>
> >> scp can be used to transfer files, or pscp if you're using putty (a
> >> separate download , which also has psftp which I'd guess would do ftp
> >> too.)- Hide quoted text -
>
> >> - Show quoted text -
>
> > Hi, Thanks.
>
> > I tried winscp before , not sure if that is the same scp you
> > mentioned, it seems need to input userid and PW again.. I'm looking
> > for some tools which just need login once and could do FTP and SSH
> > without going through login process again...
>
> > I would try to find pscp /psftp to see if that works..
>
> This is normally handled by an ssh-agent. Don't know what the state is
> under windows, but under Linux and probably Mac, you simply start up an
> ssh-agent as part of your session startup (the agent needs to run in the
> parent process of processes you wish to use it from).
>
> With the ssh-agent running, the first time you try to go to a remote
> host, using either ssh or scp, you are asked for you passphrase via a
> popup (or command line if not running under a GUI). From that point on,
> the ssh-agent handles the passphrase for you - you will not be prompted
> again for the passphrase when you next visit that host or use scp to
> copy files to that host.
>
> Other alternatives would be
>
> * use emacs with its built-in 'tramp' mode. Allows you to edit remote
> files and copy files from local to remote host and vice-versa. Steep
> learning curve if your not familiar with it.
>
> * Set up an NFS, SMB or similar share. If your on windows, setup samba
> on your server
>
> * Use something like dropbox
>
> There are many other possible solutions. A lot depends on exactly what
> you need to do and how often and what level of control/access you have
> to the remote server. I personally rarely need to copy files to the
> database. I run the Oracle instant client from my workstation and that
> pretty much provides all I need 90% of the time. The only time I need to
> copy files around is when I'm using external tables.
>
> Tim
>
> --
> tcross (at) rapttech dot com dot au- Hide quoted text -
>
> - Show quoted text -
Tim/Mark , Very appreciated for your suggestion. Received on Fri Aug 06 2010 - 14:42:20 CDT