视频1 视频21 视频41 视频61 视频文章1 视频文章21 视频文章41 视频文章61 推荐1 推荐3 推荐5 推荐7 推荐9 推荐11 推荐13 推荐15 推荐17 推荐19 推荐21 推荐23 推荐25 推荐27 推荐29 推荐31 推荐33 推荐35 推荐37 推荐39 推荐41 推荐43 推荐45 推荐47 推荐49 关键词1 关键词101 关键词201 关键词301 关键词401 关键词501 关键词601 关键词701 关键词801 关键词901 关键词1001 关键词1101 关键词1201 关键词1301 关键词1401 关键词1501 关键词1601 关键词1701 关键词1801 关键词1901 视频扩展1 视频扩展6 视频扩展11 视频扩展16 文章1 文章201 文章401 文章601 文章801 文章1001 资讯1 资讯501 资讯1001 资讯1501 标签1 标签501 标签1001 关键词1 关键词501 关键词1001 关键词1501 专题2001
OracleASM配置使用FTP和HTML访问ASM
2020-11-09 12:09:00 责编:小采
文档


XML Database (XDB)使我们能够使用FTP和HTML协议访问和管理ASM磁盘组中的文件,可以方便的浏览和移入和移出。1. 查看当前的监听

XML Database (XDB)使我们能够使用FTP和HTML协议访问和管理ASM磁盘组中的文件,



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 137152 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
:8080
出来窗口输入数据库用户密码

下载本文
显示全文
专题