Oracle ASM Advanced Tranning 5 —— Configure XDB for ASM Access Through FTP and HTML

Configure FTP and HTTP Ports Using DBMS_XDB

Setup the ports to be used by http and ftp protocols

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.

Reboot the database

SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area 1224736768 bytesFixed Size    2095896 bytesVariable Size  318768360 bytesDatabase Buffers  889192448 bytesRedo Buffers   14680064 bytesDatabase mounted.Database opened.

Check the listener status look for the HTTP and FTP Listening Endpoints. If they are not present restart the listener

Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vasm)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vasm)(PORT=8080))(Presentation=HTTP)(Session=RAW))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vasm)(PORT=2100))(Presentation=FTP)(Session=RAW))

[oracle@vasm ~]$ lsnrctl statusLSNRCTL for Linux: Version 10.2.0.5.0 - Production on 21-FEB-2013 14:40:13Copyright (c) 1991, 2010, Oracle.  All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vasm)(PORT=1521)))STATUS of the LISTENER------------------------Alias                     LISTENERVersion                   TNSLSNR for Linux: Version 10.2.0.5.0 - ProductionStart Date                21-FEB-2013 11:43:38Uptime                    0 days 2 hr. 56 min. 35 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.oraListener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.logListening Endpoints Summary...  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vasm)(PORT=1521)))  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vasm)(PORT=8080))(Presentation=HTTP)(Session=RAW))  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vasm)(PORT=2100))(Presentation=FTP)(Session=RAW))Services Summary...Service "+ASM" has 1 instance(s).  Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...Service "+ASM_XPT" has 1 instance(s).  Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...Service "zhongwc" has 2 instance(s).  Instance "zhongwc", status UNKNOWN, has 1 handler(s) for this service...  Instance "zhongwc", status READY, has 1 handler(s) for this service...Service "zhongwcXDB" has 1 instance(s).  Instance "zhongwc", status READY, has 1 handler(s) for this service...Service "zhongwc_XPT" has 1 instance(s).  Instance "zhongwc", status READY, has 1 handler(s) for this service...The command completed successfully

FTP Session Example
Open the FTP session with the -n option, that can be uses from scripts also, pass the server name and port to connect to,
use user sys or system.

[oracle@vasm ~]$ ftp -nftp> open vasm 2100Connected to vasm.220- vasm Unauthorised use of this FTP server is prohibited and may be subject to civil and criminal prosecution.220 vasm 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 typeftp> user system oracle331 pass required for SYSTEM230 SYSTEM logged in

For moving around use ‘ls’ to check where you are, ‘cd’ to change directory inside ASM and ‘lcd’ to change directory on
the server or print you local directory.
In this example we move over to the archived logs destination directory inside the DATADGNR diskgroup

[oracle@vasm ~]$ ftp -nftp> open vasm 2100    Connected to vasm.220- vasm Unauthorised use of this FTP server is prohibited and may be subject to civil and criminal prosecution.220 vasm 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 typeftp> user system oracle331 pass required for SYSTEM230 SYSTEM logged inftp> ls227 Entering Passive Mode (192,168,1,51,31,106)150 ASCII Data Connectiondrw-r--r--   2 SYS      oracle         0 FEB 21 08:52 publicdrw-r--r--   2 SYS      oracle         0 FEB 21 08:52 sys-rw-r--r--   1 SYS      oracle         0 FEB 21 14:37 xdbconfig.xml226 ASCII Transfer Completeftp> cd sys250 CWD Command successfulftp> ls227 Entering Passive Mode (192,168,1,51,172,253)150 ASCII Data Connectiondrw-r--r--   2 SYS      oracle         0 FEB 21 08:52 aclsdrw-r--r--   2 SYS      oracle         0 FEB 21 08:52 appsdrw-r--r--   2 SYS      oracle         0 FEB 21 08:52 asmdrw-r--r--   2 SYS      oracle         0 FEB 21 08:52 logdrw-r--r--   2 SYS      oracle         0 FEB 21 08:52 oiddrw-r--r--   2 SYS      oracle         0 FEB 21 08:52 schemas226 ASCII Transfer Completeftp> cd asm250 CWD Command successfulftp> ls227 Entering Passive Mode (192,168,1,51,83,59)150 ASCII Data Connectiondrw-r--r--   2 SYS      oracle         0 FEB 21 14:47 DATADGNR226 ASCII Transfer Completeftp> cd DATADGNR250 CWD Command successfulftp> ls227 Entering Passive Mode (192,168,1,51,55,92)150 ASCII Data Connectiondrw-r--r--   2 SYS      oracle         0 FEB 21 14:47 ZHONGWCdrw-r--r--   2 SYS      oracle         0 FEB 21 14:47 DB_UNKNOWN226 ASCII Transfer Completeftp> cd ZHONGWC250 CWD Command successfulftp> ls227 Entering Passive Mode (192,168,1,51,46,194)150 ASCII Data Connectiondrw-r--r--   2 SYS      oracle         0 FEB 21 14:47 DATAFILEdrw-r--r--   2 SYS      oracle         0 FEB 21 14:47 CONTROLFILEdrw-r--r--   2 SYS      oracle         0 FEB 21 14:47 BACKUPSET-rw-r--r--   1 SYS      oracle      3584 FEB 21 14:47 spfilezhongwc.oradrw-r--r--   2 SYS      oracle         0 FEB 21 14:47 CHANGETRACKINGdrw-r--r--   2 SYS      oracle         0 FEB 21 14:47 TEMPFILEdrw-r--r--   2 SYS      oracle         0 FEB 21 14:47 ONLINELOG226 ASCII Transfer Completeftp> cd DATAFILE250 CWD Command successfulftp> ls227 Entering Passive Mode (192,168,1,51,66,27)150 ASCII Data Connection-rw-r--r--   1 SYS      oracle  398467072 FEB 21 14:47 SYSTEM.260.807968997-rw-r--r--   1 SYS      oracle  146808832 FEB 21 14:47 SYSAUX.256.807968999-rw-r--r--   1 SYS      oracle  335552512 FEB 21 14:47 UNDOTBS1.258.807968999-rw-r--r--   1 SYS      oracle   5251072 FEB 21 14:47 USERS.259.807968999226 ASCII Transfer Completeftp> lcd /home/oracleLocal directory now /home/oracleftp> bin                    200  Type set to I.ftp> get USERS.259.807968999local: USERS.259.807968999 remote: USERS.259.807968999227 Entering Passive Mode (192,168,1,51,16,61)150 BIN Data Connection226 BIN Transfer Complete5251072 bytes received in 0.12 seconds (4.4e+04 Kbytes/s)ftp> by221 QUIT Goodbye.[oracle@vasm ~]$ ls -l /home/oracle/USER*-rw-r--r-- 1 oracle oinstall 5251072 Feb 21 14:48 /home/oracle/USERS.259.807968999

HTML Session Example
Using a browser go the the URL : http://<hostname>:8080 A window requiring authenthication will apppear, connect as system.

Check the copied datafile

[oracle@vasm ~]$ ls -l /tmp/SYSTEM*-rw-r--r-- 1 root root 398467072 Feb 21 14:55 /tmp/SYSTEM.260.807968997