RE: Sftp for transport tablespace
- From: "Kline.Michael" <Michael.Kline@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 15 Mar 2005 22:36:18 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kline.Michael
> Sent: Tuesday, March 15, 2005 3:53 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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]
************************************************
--
//www.freelists.org/webpage/oracle-l
Other related posts:
