X

Alejandro Vargas' Blog

  • December 17, 2006

ASM access through ftp and html using XDB configuration

Alejandro Vargas
Technical Leader, ACS Global Delivery, Infrastructure & BigData

The use of ftp and html add flexibility to manage the ASM environment, here a brief description of how to implement this configuration.

ASM XDB CONFIGURATION
========================

Xdb configuration enable the possibility to use FTP from an ftp session on unix or through a browser on Windows.

Files can be easily moved in/out from ASM this way

It also provides an http interface to easily browse through ASM directories in a graphic environement.

Please follow the below steps:

1) Follow the Note: 243554.1 "How to Deinstall and Reinstall XML Database (XDB)" to install the XDB, if not ready.

2) Configure the FTP and HTTP ports of XDB using:



connect / as sysdba
execute dbms_xdb.sethttpport(8080);
execute dbms_xdb.setftpport(2100);
commit;

3) Add the following entries in the listener.ora file, if your listener already has them, then this is not required.  Also, after restarting the database they will register automatically with the listener if you don't add them to the listener.ora file.



(DESCRIPTION =(ADDRESS = (PROTOCOL = tcp)(HOST = testdb1)(PORT = 2100))
                        (Presentation = FTP)(Session = RAW))

(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp)(HOST = testdb1)(PORT = 8080))
                        (Presentation = HTTP)(Session = RAW))



4) Restart the database and  the listener :         





sqlplus '/ as sysdba'
> shutdown immediate
> startup



lsnrctl stop <LISTENER NAME>
lsnrctl start <LISTENER NAME>



5) Connect to the ftp as follows:






OS> ftp -n
open testdb1 2100
user system xxxx
cd sys
cd asm
...
...


6) From browser : follow the below



for FTP type the url :--- ftp://testdb1:2100/
for HTTP type the url :-- http://testdb1:8080/

Enter the user and password as SYSTEM and xxxx

Join the discussion

Comments ( 4 )
  • nm Saturday, December 23, 2006
    Hi,
    Is testdb, the hostname of server where the ASM instance is running from?
  • Alejandro Vargas Sunday, December 24, 2006
    In this case the server name is testdb1. This test was done on the first node a RAC database. I had a typo on the ftp example.
  • nm Monday, December 25, 2006
    Hi,
    Ive set this up ftp and http. A few things. If I use the browser mode - http://hostname:8080. I can navigate to my oracle datafiles - but if i select the link for the file it opens it in the browser and garbage is seen. If i try to do a 'file save as' - it shows me an htm file for download. Would i need to perhaps configure the mimetypes for xmldb - since ftp and http work out of it?
    Also you can use windows explorer - create a new network place and plugin the http://hostname:8080 - this will alow you windows explorer access to asm - just like content services. However a problem here to - I tried to copy a file into one of the asm folders and it did not work. I also tried overwriting my spfile via ftp and that too did not work - for some reason doing a put command on the spfile gives an error and then removes the spfile - after which you can no longer start the instance.
  • nm Wednesday, December 27, 2006
    just an update ,BUG 5735482, has been filed for this issue.
    Naqi Mirza
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.