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.csdn.net/tianlesoftware/archive/2010/12/06/6057706.aspx
步骤如下:
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
-------------------------------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
Email: dvd.dba@gmail.com
DBA1 群:62697716(满); DBA2 群:62697977(满) DBA3 群:62697850(满)
DBA 超级群:63306533(满); DBA4 群: 83829929 DBA5群: 142216823
聊天 群:40132017 聊天2群:69087192
--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请
分享到:
相关推荐
This book is designed for JavaScript developers of any skill level that want to get up and running using Node.js and MongoDB to build full-featured web applications. A basic understanding of ...
How to Configure User Status in mySAP SRM.pdf
Using Flume shows operations engineers how to configure, deploy, and monitor a Flume cluster, and teaches developers how to write Flume plugins and custom components for their specific use-cases....
Red Linux6 ,/etc/init.d/oracleasm configure配置所需
This article introduces how to configure ODBC DSN in Client to access remote DB2 for windows in detail. Then I give a sample how to access remote DB2 database with ODBC by DB Query Analyzer ...
2.1.3 Redirecting WDB input and output to a file . . . . . 2.2 Quitting GDB . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2.3 Shell commands . . . . . . . . . . . ....
Beginning Amazon Web Services with Node.js teaches any novice Node.js developer to configure, deploy, and maintain scalable small to large scale Node.js applications in Amazon Web Services. Hosting a ...
Contributors to GDB . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 1 A Sample GDB Session . . . . . . . . . . . . . . . . . . . . 7 2 Getting In and Out of GDB . ....
Add a language definition to your wordfile for use with UltraEdit and UEStudio's powerful syntax highlighting Syntax highlighting and code folding Explanation of highlighting and folding definitions ...
Beginning Robotics with Raspberry Pi and Arduino_Using Python and OpenCV-Apress(2018) Robotics does not have to be difficult. In this book, I introduce you to the field of robotics. The journey will ...
Using Flume shows operations engineers how to configure, deploy, and monitor a Flume cluster, and teaches developers how to write Flume plugins and custom components for their specific use-cases....
4.11.1 A Non-obvious Benefit of Using Checkpoints . . . . . . . . . . . . 5 25 26 28 28 29 29 30 31 31 34 36 37 Stopping and Continuing . . . . . . . . . . . . . . . . . . 39 5.1 Breakpoints, ...
Contributors to gdb. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 1 A Sample gdb Session . . . . . . . . . . . . . . . . . . . . . . 7 2 Getting In and Out of ...
1.1.3. How to Setup and Configure WordPress .........................................10 1.1.4 How to Implement Advanced Functionality .....................................10 1.1.5 How to Optimize and ...
4.12.1 A Non-obvious Benefit of Using Checkpoints . . . . . . . . . . . . . 25 25 28 29 30 30 31 32 32 35 38 40 41 ii 5 Debugging with gdb Stopping and Continuing . . . . . . . . . . . . . . . . . . ....
Chapter 1: Introduction ....................................................................................... 7 Charitable Donation ....................................................................
We cover all the features of Raspberry Pi Zero as you discover how to configure software and hardware, and control external devices. You will find out how to navigate your way in Raspbian, write ...
This book is for anyone who wants to learn more about databases in general and wants to get started with MariaDB. Prior database experience is not required. In Detail MariaDB is a database that has ...