RE: Sftp for transport tablespace

From: Kline.Michael <Michael.Kline_at_SunTrust.com>
Date: Tue, 15 Mar 2005 22:36:18 -0500
Message-ID: <52C70FF150F49E479DAF59C68A27149DAFD586@va016a0e2.corp.suntrust.com>

Forgot a few things here. This may fill in the "rest of the story". ga016a28 -> uname -a
HP-UX ga016a28 B.11.11 U 9000/800 892920641 unlimited-user license

ga016a28 -> ls -latr sftp*
-rwxr-xr-x 1 root sys 470168 Sep 19 2000 sftp-server2.static

-rwxr-xr-x   1 root       sys        1314280 Oct 30  2000 sftp2
-rwxr-xr-x   1 root       sys         481888 Oct 30  2000 sftp-server2
lrwxrwxrwx   1 root       root             5 Jul 18  2003 sftp -> sftp2
lrwxrwxrwx   1 root       root            12 Jul 18  2003 sftp-server ->

sftp-server2

ga016a28 -> chatr sftp2
sftp2:

         shared executable
         shared library dynamic path search:
             SHLIB_PATH     disabled  second
             embedded path  disabled  first  Not Defined
         shared library list:
             dynamic   /usr/lib/libnsl.1
             dynamic   /usr/lib/libgen.2
             dynamic   /usr/lib/libsec.2
             dynamic   /usr/lib/librpcsvc.1
             dynamic   /usr/lib/libc.2
         shared library binding:
             deferred
         global hash table disabled
         plabel caching disabled
         shared vtable support disabled
         static branch prediction disabled
         executable from stack: D (default)
         kernel assisted branch prediction enabled
         lazy swap allocation disabled
         text segment locking disabled
         data segment locking disabled
         third quadrant private data space disabled
         fourth quadrant private data space disabled
         data page size: D (default)
         instruction page size: D (default)

[/usr/local/bin - oracle]
ga016a28 ->

Michael Kline
Database Administration
Outside 804.261.9446
Cell 804.744.1545
3-9446

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org

[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kline.Michael
> Sent: Tuesday, March 15, 2005 3:53 PM
> To: oracle-l_at_freelists.org
> Subject: Sftp for transport tablespace
>
> I'm trying to use sftp for "security" reasons, but I've got some
> tablespaces that are quite large, and they are giving me some very
> strange errors. The old "bad" ftp routine handles these just
perfectly.
> The disk being sent to is more than large enough, some 60GB.
>
>
> Can't find much on google, but there's talk that if it's a 32-bit
module
> it may not be able to handle files > 4gb. Still, these are only about
> 3GB.
>
>
>
> Anyone recently, "Been there, done that, here's the solution?"
>
>
>
> Thanks.
>
>
>
>
>
>
>
> Is there a file size limit or something to sftp?
>
>
>
> [/PFPRD_p013/oradata/PFPRD - oracle]
>
> ga016a28 -> ls -latr
>
> total 43069648
>
> drwxr-xr-x 3 oracle oinstall 96 Mar 11 2003 ..
>
> drwxr-xr-x 2 oracle oinstall 8192 May 18 2004 .
>
> -rw-r----- 1 oracle oinstall 2097160192 Feb 14 21:15
> iinc_r00_m2_01.dbf
>
> -rw-r----- 1 oracle oinstall 1053827072 Feb 14 21:15
> istatus_r00_m2_01.dbf
>
> -rw-r----- 1 oracle oinstall 2207260672 Feb 14 21:15
> instr_f00_m2_01.dbf
>
> -rw-r----- 1 oracle oinstall 3150979072 Feb 15 01:07
> ivol_r00_m1_02.dbf
>
> -rw-r----- 1 oracle oinstall 9442435072 Feb 15 01:07
> ledger_indx_01.dbf
>
> -rw-r----- 1 oracle oinstall 948969472 Feb 15 01:07
> iother_r00_m1_01.dbf
>
> -rw-r----- 1 oracle oinstall 3150979072 Feb 15 01:07
> ivol_r00_m1_01.dbf
>
> [/PFPRD_p013/oradata/PFPRD - oracle]
>
> ga016a28 -> cat $HOME/sftp.bat
>
> cd /PFRPT_TRANSPORT02/PFRPT
>
> mput ivol_r00_m1*
>
> quit
>
>
>
> [/PFPRD_p013/oradata/PFPRD - oracle]
>
> ga016a28 -> sftp2 -b $HOME/sftp.bat ga016afe
>
> sftp> cd /PFRPT_TRANSPORT02/PFRPT
>
> /PFRPT_TRANSPORT02/PFRPT
>
> sftp> mput ivol_r00_m1*
>
> ledger_indx_01.dbf: Undefined error occurred.
>
> ivol_r00_m1_01.dbf: Undefined error occurred.
>
> ivol_r00_m1_02.dbf: Undefined error occurred.
>
> instr_f00_m2_01.dbf: Undefined error occurred.
>
> sftp> quit
>
> [/PFPRD_p013/oradata/PFPRD - oracle]
>
> ga016a28 ->
>
>
>
>
>
> Michael Kline
> Database Administration
> SunTrust Technology Center
> 1030 Wilmer Avenue
> Richmond, Virginia 23227
> Outside 804.261.9446
> STNet 643.9446
>
> Cell 804.744.1545

The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer. [ST:A234]

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 15 2005 - 22:39:53 CST