Jagjeet's Oracle Blog!

October 9, 2008

Access ASM through FTP and HTTP using XDB Configuration

Filed under: ASM — Tags: , , — Jagjeet Singh @ 11:25 am

10g release 2 introduced a new feature to access the ASM disk groups outside the database via FTP and through a web browser using HTTP.

The use of FTP and HTTP adds a flexibility to manage the ASM environment. Any FTP client can be used to move/copy the files stored on ASM.


Because ASM is not a regular file system which can be accessed using standard FTP and HTTP service. To make this enable we need to setup the Oracle XML DB access which is a one time setup. Oracle XML DB provides the file mapping functionality.


Disk groups can be available outside the database via a Virtual file system /sys/asm.


Please follow the below steps:


1) Follow the Note: 243554.1 “How to Deinstall and Reinstall XML Database(XDB)” to install the XDB.


We can check if XDB is installed from dba_registry.


SQL> select comp_id,comp_name,version,status from dba_registry
2 where comp_id = 'XDB';


COMP_ID    COMP_NAME            VERSION     STATUS
---------- -------------------- ----------- -----------
XDB        Oracle XML Database  10.2.0.1.0  VALID


2) Configure the ports for FTP and HTTP


This can be done by two ways:


i) By executing the below script from sysdba and pass the FTP and HTTP port.


SQL> start ?/rdbms/admin/catxdbdbca 2100 8000


ii) By calling the package’s routines after connecting sysdba.


SQL>; exec dbms_xdb.setftpport(2100)
PL/SQL procedure successfully completed.


SQL>; exec dbms_xdb.sethttpport(8000)
PL/SQL procedure successfully completed.


Configuration for FTP and HTTP port can be confirmed using


SQL> ho lsnrctl status | grep TP


(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=js)(PORT=2100))(Presentation=FTP) (Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=js)(PORT=8000))(Presentation=HTTP)(Session=RAW))


Now we are ready to access ASM disk groups using FTP client or HTTP browser.
I have used the System database user to connect.


For access through web browser : http://hostaddress:8000


Below is the screen shot for FTP

FTP Client connected to ASM

FTP Client connected to ASM

Create a free website or blog at WordPress.com.