How to configure XDB for using ftp and http protocols with ASM [ID 357714.1]

Configuration of XDB（XML Database）to be able to use ftp and http protocols to browse and manage ASM directories

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 environment.

之前的测试文档：

设置FTP / HTTP访问RAC ASM磁盘组

http://blog.youkuaiyun.com/xujinyang/article/details/6833712

步骤如下：

1)As root check that ftp service is running:

# netstat -a | grep ftp
tcp 0 0 *:ftp *:* LISTEN

If no output is returned, start ftp:

# service vsftpd start
Starting vsftpd for vsftpd: [ OK ]

Also configure ftp to start automatically

# chkconfig vsftpd on

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

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

to check use:
select dbms_xdb.GETFTPPORT() from dual;
select dbms_xdb.GETHTTPPORT() from dual;

3)Check the dispatchers configuration for xdb, if it is not set set it up,

for single instance:

ALTER SYSTEM SET dispatchers = =(PROTOCOL=TCP)(SERVICE=<sid>XDB)" SCOPE=BOTH

For RAC instances:

ALTER SYSTEM SET siebprod1.dispatchers = "(PROTOCOL=TCP)(SERVICE=<sid1>XDB)" SCOPE=BOTH

ALTER SYSTEM SET siebprod2.dispatchers = "(PROTOCOL=TCP)(SERVICE=<sid2>XDB)" SCOPE=BOTH

If you are not using the default Listener ensure you have set LOCAL_LISTENER in the (init.ora/spfile) as prescribed for RAC/NON-RAC instances or the end points will not register.

4) Restart the listener:

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

5)Check that the following lines are returned when executing lsnrctl, if they are not you may need to restart your database.

(DESCRIPTION =(ADDRESS = (PROTOCOL = tcp)(HOST = <host>)(PORT = 2100))(Presentation = FTP)(Session = RAW))

(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp)(HOST = <host>)(PORT = 8080))(Presentation = HTTP)(Session = RAW))

6)Connect to the ftp as follows :

OS> ftp -n
open <host> 2100
user system <password>
cd sys
cd asm
...
...

7)From browser : follow the below

for FTP type the url :---ftp://<host>:2100/
for HTTP type the url :--http://<host>:8080/

Enter the user and password as SYSTEM and <password>

8) Troubleshooting:

If you do not succeed to connect to ftp then :

（1）. Check for any invalid XDB owned objects:

SQL> select count(*) from dba_objects

where owner='XDB' and status='INVALID';

COUNT(*)

----------

0

（2）. Check DBA_REGISTRY for XDB status:

SQL> select comp_name, status, version from DBA_REGISTRY where comp_name='Oracle XML Database'

The results should indicate the correct version and patch in a valid status.

（3）. Restart database and listener to enable Oracle XML DB protocol access.

From Oracle

-------------------------------------------------------------------------------------------------------