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';

---------- -------------------- ----------- -----------
XDB        Oracle XML Database  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))

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

Blog at WordPress.com.