管理介面是很熟悉的介面，是Application Express 2.1.0.00.39

以下采用的是第一种安装方式，升级到3.2.1：

管理介面是很熟悉的介面，是Application Express 2.1.0.00.39

以下采用的是第一种安装方式，升级到3.2.1：

Scenario 1: Downloading from OTN and Configuring the Embedded PL/SQL Gateway

Follow the steps in this scenario if you are downloading Oracle Application Express

from Oracle Technology Network (OTN) and configuring the embedded PL/SQL

gateway. Required installation steps in this scenario include:

■ Step 1: Install the Oracle Database and Complete Pre-installation Tasks

■ Step 2: Download and Install Oracle Application Express

■ Step 3: Change the Password for the ADMIN Account

■ Step 4: Restart Processes

■ Step 5: Configure the Embedded PL/SQL Gateway

■ Step 6: Enable Network Services in Oracle Database 11g

■ Step 7: Security Considerations

■ Step 8: About Running Oracle Application Express in Other Languages

■ Step 9: About Managing JOB_QUEUE_PROCESSES

■ Step 10: Configuring the SHARED_SERVERS Parameter

■ Step 11: Create a Workspace and Add Oracle Application Express Users

具体来说：

第一步，安装XE，并在APEX安装前，完成检查；

需要升级PL/SQL Web toolkit:

Installing the PL/SQL Web Toolkit 10.1.2.0.6

--------------------------------------------

1) Stop all applications using the database

2) Navigate to the directory apex/owa

3) Connect via SQL*Plus as the database user SYS

4) Run the PL/SQL Web Toolkit installation script by issuing: @owainst.sql

5) Review the output displayed from owainst.sql and ensure no errors were encountered.

6) Confirm the PL/SQL Web Toolkit version is 10.1.2.0.6 or greater by connecting to the database

as the SYS user and running the query:

select owa_util.get_version from dual;

7) Run the utlrp.sql script from the Oracle Database home to recompile all invalid PL/SQL

packages now instead of when the packages are accessed for the first time. This step is

optional but recommended. To run utlrp.sql, issue: @?/rdbms/admin/utlrp.sql

第二步，下载3.2的APEX包，然后按照步骤一步步完成在之前的XE上APEX的升级工作。

使用@apexins SYSAUX SYSAUX TEMP /i/ 来安装，否则要后悔。

第三步，修改Admin密码；

@apxchpwd

第四步，重启XE，和监听器；

第五步，配置EPG；

因为是升级过来的，可以不跑apex_epg_config.sql。但需要运行 @apxldimg.sql， 因为apex是解压到d:oracle下的，所以@apxldimg.sql d:oracle而非@apxldimg.sql d:oracleapex。

查看XML DB的http端口：

SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

第六步， 因为不是11g，所以忽略；

第七步， 安全性暂时不考虑；

第八步， 安装语言包。可以考虑安装中文包。字符集一定要是AL32UTF8，否则安装包会失败。

建个NLS_LANG的环境变量，值为American_America.AL32UTF8

Or Simplified Chinese_China.AL32UTF8，

或者C:>SET NLS_LANG=American_America.AL32UTF8

然后运行

ALTER SESSION SET CURRENT_SCHEMA = APEX_030200;

@D:Oracleapexuilderzh-cnload_zh-cn

如果安装成功，可以查看installed Translation:

第九步，查看JOB_QUEUE_PROCESSES参数，此参数决定了并行运行的最大任务数量。我的为10。

SELECT VALUE FROM v$parameter WHERE NAME = 'job_queue_processes'

如要改变参数，以sys作为sysdba登录后：

ALTER SYSTEM SET JOB_QUEUE_PROCESSES =

第十步，配置SHARED_SERVERS参数。对于少量用户，配置为5。

ALTER SYSTEM SET SHARED_SERVERS = 5 SCOPE=BOTH;

第十一步，就是最终的配置workspace和用户的步骤。