Oracle ASM配置使用FTP和HTML訪問ASM

XML Database （XDB）使我們能夠使用FTP和HTML協議訪問和管理ASM磁盤組中的文件，

可以方便的瀏覽和移入和移出。

1. 查看當前的監聽端口信息：-
 

$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 04-NOV-2010 10:42:52

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_DB07
Version                   TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date                29-OCT-2010 13:13:18
Uptime                    5 days 21 hr. 29 min. 34 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /home/oratest/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /home/oratest/product/10.2.0/db_1/network/log/listener_db07.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.32.10.247)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.32.10.72)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "TEST" has 2 instance(s).
Instance "TEST1", status READY, has 2 handler(s) for this service...
Instance "TEST2", status READY, has 1 handler(s) for this service...
Service "TESTXDB" has 2 instance(s).
Instance "TEST1", status READY, has 1 handler(s) for this service...
Instance "TEST2", status READY, has 1 handler(s) for this service...
Service "TEST_XPT" has 2 instance(s).
Instance "TEST1", status READY, has 2 handler(s) for this service...
Instance "TEST2", status READY, has 1 handler(s) for this service...
The command completed successfully

2 . 配置FTP和HTTP端口

SQL> execute dbms_xdb.sethttpport(8080);

PL/SQL procedure successfully completed.

SQL> execute dbms_xdb.setftpport(2100);

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

3. 重啟數據庫
$ srvctl stop database -d TEST
$ srvctl start database -d TEST

4. 查看FTP和HTTP是否被監聽，如果沒有，則重啟監聽
$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 04-NOV-2010 10:57:31

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_DB07
Version                   TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date                29-OCT-2010 13:13:18
Uptime                    5 days 21 hr. 44 min. 13 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /home/oratest/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /home/oratest/product/10.2.0/db_1/network/log/listener_db07.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.32.10.247)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.32.10.72)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db07.jiade.com)(PORT=8080))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db07.jiade.com)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "TEST" has 2 instance(s).
Instance "TEST1", status READY, has 2 handler(s) for this service...
Instance "TEST2", status READY, has 1 handler(s) for this service...
Service "TESTXDB" has 2 instance(s).
Instance "TEST1", status READY, has 1 handler(s) for this service...
Instance "TEST2", status READY, has 1 handler(s) for this service...
Service "TEST_XPT" has 2 instance(s).
Instance "TEST1", status READY, has 2 handler(s) for this service...
Instance "TEST2", status READY, has 1 handler(s) for this service...
The command completed successfully
已經正常監聽HTTP:8080和FTP:2100端口。

5. 看看FTP
$ ftp -n
ftp> open db07 2100
Connected to db07.jiade.com.
220- db07
Unauthorised use of this FTP server is prohibited and may be subject to civil and criminal prosecution.
220 db07 FTP Server (Oracle XML DB/Oracle Database) ready.
530  Please login with USER and PASS.
530  Please login with USER and PASS.
KERBEROS_V4 rejected as an authentication type
ftp> user system system_password (數據庫用戶和密碼)
331 pass required for SYSTEM
230 SYSTEM logged in

簡單命令：
ls  : 列出當前目錄下的所有文件和目錄
cd : 切換目錄

Step-by-Step
ftp> ls
227 Entering Passive Mode (10,32,10,72,112,6)
150 ASCII Data Connection
drw-r--r--   2 SYS      Oracle         0 SEP 14 03:55 home
drw-r--r--   2 SYS      Oracle         0 MAR 12 00:59 public
drw-r--r--   2 SYS      Oracle         0 SEP 14 03:55 sys  

-rw-r--r--   1 SYS      Oracle         0 NOV 04 02:50 xdbconfig.xml

ftp> cd sys
ftp> ls
200 PORT Command successful
150 ASCII Data Connection
drw-r--r--   2 SYS      Oracle         0 MAR 12 00:59 acls
drw-r--r--   2 SYS      Oracle         0 MAR 12 00:59 apps
drw-r--r--   2 SYS      Oracle         0 MAR 12 00:59 asm
-rw-r--r--   1 SYS      Oracle         0 SEP 14 03:55 databaseSummary.xml
drw-r--r--   2 SYS      Oracle         0 MAR 12 00:59 log
drw-r--r--   2 SYS      Oracle         0 MAR 12 00:59 oid
drw-r--r--   2 SYS      Oracle         0 SEP 14 03:55 schemas
226 ASCII Transfer Complete

ftp> cd asm
250 CWD Command successful
ftp> ls
227 Entering Passive Mode (10,32,10,72,56,54)
150 ASCII Data Connection
drw-r--r--   2 SYS      Oracle         0 NOV 04 03:13 DATA                                      （2個DiskGroups）
drw-r--r--   2 SYS      Oracle         0 NOV 04 03:13 FLASH_RECOVERY_AREA
226 ASCII Transfer Complete

ftp> pwd
257 "/sys/asm/data/test/datafile" is current directory.
ftp> ls
200 PORT Command successful
150 ASCII Data Connection
-rw-r--r--   1 SYS      Oracle  681582592 NOV 04 03:18 SYSAUX.256.734110923
-rw-r--r--   1 SYS      Oracle  524296192 NOV 04 03:18 SYSTEM.257.734111145
-rw-r--r--   1 SYS      Oracle  104865792 NOV 04 03:18 EXAMPLE.258.734111271
-rw-r--r--   1 SYS      Oracle  89137152 NOV 04 03:18 UNDOTBS1.259.734111315
-rw-r--r--   1 SYS      Oracle  34611200 NOV 04 03:18 UNDOTBS2.260.734111351
-rw-r--r--   1 SYS      Oracle   5251072 NOV 04 03:18 USERS.262.734111393
226 ASCII Transfer Complete

FLASH_RECOVERY_AREA 磁盤組
ftp> pwd
257 "/sys/asm/flash_recovery_area/test/archivelog/2010_11_04" is current directory.
ftp> ls
200 PORT Command successful
150 ASCII Data Connection
-rw-r--r--   1 SYS      Oracle  45303808 NOV 04 03:20 thread_1_seq_123.472.734176827
226 ASCII Transfer Complete

ftp> lcd   (自己在Server的位置)
Local directory now /

下載文件：
ftp> ls
227 Entering Passive Mode (10,32,10,72,126,198)
150 ASCII Data Connection
-rw-r--r--   1 SYS      Oracle  45303808 NOV 04 03:22 thread_1_seq_123.472.734176827
226 ASCII Transfer Complete
ftp> bin
200  Type set to I.
ftp> get thread_1_seq_123.472.734176827
local: thread_1_seq_123.472.734176827 remote: thread_1_seq_123.472.734176827
227 Entering Passive Mode (10,32,10,72,84,203)
150 BIN Data Connection
226 BIN Transfer Complete
45303808 bytes received in 1 seconds (4.4e+04 Kbytes/s)

6. HTTP
http://www.linuxidc.com:8080
出來窗口輸入數據庫用戶密碼

服務器租用/服務器托管中國五強！虛擬主機域名注冊頂級提供商！15年品質保障！--億恩科技[ENKJ.COM]