Oracle Apex 3.2.1 @11gR2(1)(轉)

11G 上的Apex和XE上的是一樣的都採用embedded pl/sql gateway的方式,(文件1.4.2)要更改裡面的images內容或上傳新的圖片就比較費勁了，因為不能像Apache 的mod_plsql那樣從檔案系統的目錄裡可以看到相應的路徑去更改。這是就需要進行一下設定使其能夠進行FTP的訪問，
SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 20 09:39:14 2009
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
and Real Application Testing options
SQL> select banner from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
SQL> exec dbms_xdb.setftpport(2100);
PL/SQL procedure successfully completed.
SQL> alter system register;
System altered.
SQL> host
oracle@oracle11gr2:~> ftp localhost 2100
Connected to localhost.
220- oracle11gr2
Unauthorised use of this FTP server is prohibited and may be subject to civil and criminal prosecution.
220 oracle11gr2 FTP Server (Oracle XML DB/Oracle Database) ready.
Name (localhost:oracle): system
331 pass required for SYSTEM
Password:
230 SYSTEM logged in
Remote system type is Unix.
ftp> ls
227 Entering Passive Mode (127,0,0,2,144,155)
wrong server: return code must be 229
227 Entering Passive Mode (127,0,0,2,60,148)
150 ASCII Data Connection
drw-r--r-- 2 SYS oracle 0 AUG 13 23:17 OLAP_XDS
drw-r--r-- 2 SYS oracle 0 SEP 04 16:54 home
drw-r--r-- 2 SYS oracle 0 AUG 13 23:34 images
drw-r--r-- 2 SYS oracle 0 AUG 13 23:17 olap_data_security
drw-r--r-- 2 SYS oracle 0 AUG 13 23:10 public
drw-r--r-- 2 SYS oracle 0 SEP 04 16:54 sys
-rw-r--r-- 1 SYS oracle 0 SEP 20 13:40 xdbconfig.xml
drw-r--r-- 2 SYS oracle 0 AUG 13 23:17 xds
226 ASCII Transfer Complete
ftp> cd images
250 CWD Command successful
ftp> ls
227 Entering Passive Mode (127,0,0,2,41,87)
150 ASCII Data Connection
-rw-r--r-- 1 SYS oracle 130 AUG 13 23:34 16admin.gif
-rw-r--r-- 1 SYS oracle 43 AUG 13 23:34 1pixelbeige.gif
-rw-r--r-- 1 SYS oracle 799 AUG 13 23:34 1px_gray.gif
-rw-r--r-- 1 SYS oracle 43 AUG 13 23:34 1px_trans.gif
...........省略200多行！
-rw-r--r-- 1 SYS oracle 42 AUG 13 23:34 yellow.gif
-rw-r--r-- 1 SYS oracle 90 AUG 13 23:34 yellow_flag.gif
-rw-r--r-- 1 SYS oracle 1599 AUG 13 23:34 yes.gif
226 ASCII Transfer Complete
ftp> bye
221 QUIT Goodbye.
oracle@oracle11gr2:~> exit
exit
這樣應該會比較直觀的看到目錄裡的內容，進行上傳和下載檔案了。
另，為了安全。使用完後再把FTP 的port設定取消就行了。
SQL> exec dbms_xdb.setftpport(0);
PL/SQL procedure successfully completed.
SQL> alter system register;
System altered.
--EOF [/quote]

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/7656893/viewspace-666164/，如需轉載，請註明出處，否則將追究法律責任。