Accessing ASM via FTP

This is a documented feature, but I wanted to post my notes so I could reference them if needed.

All you basically have to do to set this up is:

  • install XML DB (package dbms_xdb). This is installed if you create a database with DBCA by default.
  • Set the ftp port used by XML DB
  • Below is the output of executing these steps.

    SQL> exec dbms_xdb.sethttpport(8080);
    
    PL/SQL procedure successfully completed.
    
    SQL> exec dbms_xdb.setftpport(2100);
    
    PL/SQL procedure successfully completed.
    
    SQL> exit
    Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
    With the Partitioning, Real Application Clusters, OLAP, Data Mining
    and Real Application Testing options
    15:27:52 oracle@racperf01 ~ >exit
    logout
    Connection to racperf01 closed.
    15:27:56 oracle@emgrid01 ~ >ftp racperf01 2100
    Connected to racperf01.
    220- racperf01
    Unauthorised use of this FTP server is prohibited and may be subject to civil and criminal prosecution.
    220 racperf01 FTP Server (Oracle XML DB/Oracle Database) ready.
    Name (racperf01:oracle): system
    331 pass required for SYSTEM
    Password:
    230 SYSTEM logged in
    Remote system type is Unix.
    ftp> cd /sys/asm/PRDRAC_ASM_SEED/PRDRAC/DATAFILE
    ftp> ls
    227 Entering Passive Mode (ip_filtered_out)
    150 ASCII Data Connection
    -rw-r--r--   1 SYS      oracle  42750451712 APR 14 19:28 XWCS_LG1.365.649697817
    -rw-r--r--   1 SYS      oracle  104865792 APR 14 19:28 ATHD_LG6.366.649697819
    -rw-r--r--   1 SYS      oracle  94686420992 APR 14 19:28 ATHX_TX1.367.649697837
    -rw-r--r--   1 SYS      oracle  55050248192 APR 14 19:28 ATHX_TX2.368.649699187
    
    
    
    -rw-r--r--   1 SYS      oracle  104865792 APR 14 19:28 XWCX_SM01.9701.745789107
    -rw-r--r--   1 SYS      oracle  4508884992 APR 14 19:28 XWCD_SM01.8544.745789111
    -rw-r--r--   1 SYS      oracle  3565162496 APR 14 19:28 XWCD_LB01_4K.8628.745789139
    -rw-r--r--   1 SYS      oracle  209723392 APR 14 19:28 ITRX_SM01.9662.745850011
    -rw-r--r--   1 SYS      oracle  8808046592 APR 14 19:28 ITRD_SM01.8523.745850017
    226 ASCII Transfer Complete
    ftp>
    

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.