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

最新推荐文章于 2023-04-07 15:15:54 发布

转载最新推荐文章于 2023-04-07 15:15:54 发布 · 160 阅读

本文介绍如何在Oracle Database 11g R2中通过设置PL/SQL Gateway启用FTP功能，以便更方便地管理数据库中的images目录内容，包括上传和下载文件。

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7656893/viewspace-666164/