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://www.cndba.cn/Dave/article/959

      

 

 

步骤如下：

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

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

QQ: 492913789
Email: ahdba@qq.com
Blog: http://www.cndba.cn/dave

DBA1 群：62697716(满);   DBA2 群：62697977(满)   DBA3 群：62697850(满)  

DBA 超级群：63306533(满);  DBA4 群： 83829929  DBA5群： 142216823   

聊天 群：40132017   聊天2群：69087192

--加群需要在备注说明Oracle表空间和数据文件的关系，否则拒绝申请