Use FTP and HTML to access ASM in OracleASM Configuration

XMLDatabase (XDB) enables us to use FTP and HTML protocols to access and manage files in the ASM disk group, allowing us to conveniently browse and move files into and out. 1. view the current listener

XML Database (XDB) enables us to use FTP and HTML protocols to access and manage files in the ASM disk group, allowing us to conveniently browse and move files into and out. 1. view the current listener

XML Database (XDB) enables us to use FTP and HTML protocols to access and manage files in the ASM disk group,

PL/SQL procedure successfully completed.

SQL>Execute dbms_xdb.setftpport (2100 );

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

3. Restart the database
$ Srvctl stop database-d TEST
$ Srvctl start database-d TEST

4. Check whether FTP and HTTP are listened on. If not, restart the listener.
$ Lsnrctl status

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

Copyright (c) 1991,200 7, 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
Ports HTTP: 8080 and FTP: 2100 have been listened on normally.

5. Check 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(Database User and password)
331 pass required for SYSTEM
230 SYSTEM logged in

Simple command:
Ls: list all files and directories in the current directory
Cd: Switch Directories

Step-by-Step
Ftp>Ls
227 Entering Passive Mode)
150 ASCII Data Connection
Drw-r -- 2 SYS oracle 0 SEP 14 0:55 home
Drw-r -- 2 SYS oracle 0 MAR 12 public
Drw-r -- 2 SYS oracle 0 SEP 14 0:55 sys

-Rw-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 -- 2 SYS oracle 0 MAR 12 acls
Drw-r -- 2 SYS oracle 0 MAR 12 apps
Drw-r -- 2 SYS oracle 0 MAR 12 00:59 asm
-Rw-r -- 1 SYS oracle 0 SEP 14 0:55 databaseSummary. xml
Drw-r -- 2 SYS oracle 0 MAR 12 log
Drw-r -- 2 SYS oracle 0 MAR 12 oid
Drw-r -- 2 SYS oracle 0 SEP 14 0:55 schemas
226 ASCII Transfer Complete

Ftp>Cd asm
250 CWD Command successful
Ftp> ls
227 Entering Passive Mode)
150 ASCII Data Connection
Drw-r -- 2 SYS oracle 0 NOV 04 0:13DATA(2 DiskGroups instances)
Drw-r -- 2 SYS oracle 0 NOV 04 0:13FLASH_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 -- 1 SYS oracle 681582592 NOV 04 SYSAUX.256.734110923
-Rw-r -- 1 SYS oracle 524296192 NOV 04 SYSTEM.257.734111145
-Rw-r -- 1 SYS oracle 104865792 NOV 04 EXAMPLE.258.734111271
-Rw-r -- 1 SYS oracle 89137152 NOV 04 UNDOTBS1.259.734111315
-Rw-r -- 1 SYS oracle 34611200 NOV 04 UNDOTBS2.260.734111351
-Rw-r -- 1 SYS oracle 5251072 NOV 04 USERS.262.734111393
226 ASCII Transfer Complete

FLASH_RECOVERY_AREA disk group
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 -- 1 SYS oracle 45303808 NOV 04 thread_eclipseq_123.472.734176827
226 ASCII Transfer Complete

Ftp>LCD (self-contained Server)
Local directory now/

Download file:
Ftp>Ls
227 Entering Passive Mode (126,198)
150 ASCII Data Connection
-Rw-r -- 1 SYS oracle 45303808 NOV 04 thread_eclipseq_123.472.734176827
226 ASCII Transfer Complete
Ftp> Bin
200 Type set to I.
Ftp>Get thread_eclipseq_123.472.734176827
Local: thread_eclipseq_123.472.734176827 remote: thread_eclipseq_123.472.734176827
227 Entering Passive Mode (84,203)
150 BIN Data Connection
226 BIN Transfer Complete
45303808 bytes encoded ed in 1 seconds (4.4e + 04 Kbytes/s)

6. HTTP
8080
Enter the database user password in the window