* Accessing ORACLE DB via FTP protocol * Note that files loaded into the XDB via FTP are stored within the XDB schema, not the user schema. They can be viewed with Internet Explorer or Enterprise Manager under the "XML Database/Resources" folder. D:\yang\oracle\xml>lsnrctl status LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 14-AUG-2003 14:56: 06 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Produc tion Start Date 05-AUG-2003 08:37:33 Uptime 9 days 6 hr. 18 min. 34 sec Trace Level off Security OFF SNMP OFF Listener Parameter File D:\oracle\ora92\network\admin\listener.ora Listener Log File D:\oracle\ora92\network\log\listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=VALUED-7B9600FA)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=VALUED-7B9600FA)(PORT=8080))(Present ation=HTTP)(Session=RAW)) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=VALUED-7B9600FA)(PORT=2100))(Present ation=FTP)(Session=RAW)) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "athena" has 2 instance(s). Instance "athena", status UNKNOWN, has 1 handler(s) for this service... Instance "athena", status READY, has 1 handler(s) for this service... Service "athenaXDB" has 1 instance(s). Instance "athena", status READY, has 1 handler(s) for this service... Service "phoenix" has 1 instance(s). Instance "phoenix", status UNKNOWN, has 1 handler(s) for this service... Service "saturn" has 1 instance(s). Instance "saturn", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully D:\yang\oracle\xml>ftp ftp> open localhost 2100 Connected to VALUED-7B9600FA. 220 VALUED-7B9600FA FTP Server (Oracle XML DB/Oracle9i Enterprise Edition Releas e 9.2.0.1.0 - Production) ready. User (VALUED-7B9600FA:(none)): jyang 331 pass required for JYANG Password: 230 JYANG logged in ftp> dir 200 PORT Command successful 150 ASCII Data Connection drw-r--r-- 2 SYS oracle 0 MAY 12 17:33 public drw-r--r-- 2 SYS oracle 0 MAY 12 17:33 sys -rw-r--r-- 1 SYS oracle 0 MAY 12 17:34 xdbconfig.xml 226 ASCII Transfer Complete ftp: 190 bytes received in 0.02Seconds 11.88Kbytes/sec. ftp> mkdir home 257 MKD command successful ftp> dir 200 PORT Command successful 150 ASCII Data Connection drw-r--r-- 2 JYANG oracle 0 AUG 14 14:54 home drw-r--r-- 2 SYS oracle 0 MAY 12 17:33 public drw-r--r-- 2 SYS oracle 0 MAY 12 17:33 sys -rw-r--r-- 1 SYS oracle 0 MAY 12 17:34 xdbconfig.xml 226 ASCII Transfer Complete ftp: 250 bytes received in 0.00Seconds 250000.00Kbytes/sec.