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

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

[@more@]

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

上一篇： APEX 3.2.1 Released

下一篇：沒有了~

請登入後發表評論登入

全部評論

mainkampft

博文量
6
訪問量

9400

Oracle Apex 3.2.1 @11gR2(1)

最新文章

相關文章