Oracle APEX 4.2-安装与配置

Oracle APEX 4.2安装与配置 alter session set \

2. 检查存在的安装

sqlplus / as sysdba SELECT username FROM dba_users

WHERE (username LIKE 'FLOWS_%' OR USERNAME LIKE 'APEX_%') AND USERNAME NOT IN ( SELECT 'FLOWS_FILES' FROM DUAL UNION

SELECT 'APEX_PUBLIC_USER' FROM DUAL UNION

SELECT SCHEMA s FROM dba_registry WHERE comp_id = 'APEX');

如果结果包含条目FLOWS_XXXXXX or APEX_XXXXXX where XXXXXX represents six numbers，这些条目是该删除的。 3. 从之前的安装删除schemas

sqlplus / as sysdba

DROP USER FLOWS_030000 CASCADE; 在Oracle Database 11g修复无效的ACL

1. 改变目录到解压安装Oracle Application Express的目录 2. 用sys用户以sysdba登录到数据库

sqlplus / as sysdba EXEC

DBMS_NETWORK_ACL_ADMIN.DELETE_PRIVILEGE('power_users.xml', 'FLOWS_030000');

3.7 性能优化任务

Performance of web applications heavily depend on their size and how often a browser has to request static content like images, CSS and JavaScript files. To improve performance, most web servers allow you to enable on-the-fly file compression and settings on how long browsers can cache a file. Please see your web server manual on how to enable gzip compression and setting the expired header attribute for optimal performance of your Application Express application.

43 / 51

Oracle APEX 4.2安装与配置 3.8 关于Oracle Application Express 运行时环境

Oracle Application Express运行时环境使用户能运行产品应用并且不能改变和编辑应用。它仅包含运行应用必须的包，它不提供Web管理接口。

在Oracle Application Express运行环境中使用SQL*Plus或SQL Developer 调用APEX_INSTANCE_ADMIN API进行管理。

3.8.1 Converting a Runtime Environment to a Full

Development Environment

转换Oracle Application Express runtime environment到full development environment：

改变工作目录到解压安装apex软件的目录。 用sys用户以sysdba登录到数据库

sqlplus / as sysdba @apxdvins.sql

3.8.2 Converting a Full Development Environment to

a Runtime Environment

在转换full development environment 到runtime environment 之前导出所有的Websheet应用。当你转换development environment到runtime, 存在的Websheet data grids和reports将从所有工作空间删除。转换回full development environment将不会恢复这些Websheet data grids or reports。

转换Oracle Application Express full development environment 到runtime environment:

改变工作目录到解压安装apex软件的目录。 用sys用户以sysdba登录到数据库

sqlplus / as sysdba @apxdevrm.sql

44 / 51

Oracle APEX 4.2安装与配置 4 Oracle Application Express疑难解答

4.1 查看安装日志

脚步apexins.sql 在apex目录建立installYYYY-MM-DD_HH24-MI-SS.log类似名字的文件，在安装成功后这个日志文件包含以下内容：

Thank you for installing Oracle Application Express.

Oracle Application Express is installed in the APEX_040200 schema.

4.2 校验有效的Oracle Application Express安装

执行下列查询校验安装：

SELECT STATUS FROM DBA_REGISTRY WHERE COMP_ID = 'APEX'; 返回vaild假定安装成功

4.3 清除失败的Oracle Application Express安装 4.3.1 在升级安装失败后回复到之前版本

1 ． 校验之前存在的Oracle Application Express版本

sqlplus / as sysdba

select username from dba_users

where regexp_like(username,'(FLOWS|APEX)_\\d{6}')

and username <> (select table_owner from all_synonyms where synonym_name = 'WWV_FLOW' and owner = 'PUBLIC')

如果查询返回任何结果，表示之前安装Oracle Application Express 2 ． 回复到之前版本

修改文本别名 /i/ 到你之前备份的images目录 sqlplus / as sysdba

对于不同版本的Application Express Release执行相应的命令

1) Oracle Application Express Release 1.5：

ALTER SESSION SET CURRENT_SCHEMA = FLOWS_010500; exec

flows_010500.wwv_flow_upgrade.switch_schemas('APEX_040200','FLOWS_010500');

45 / 51

Oracle APEX 4.2安装与配置 2) Oracle Application Express Release 1.6：

ALTER SESSION SET CURRENT_SCHEMA = FLOWS_010600; exec

flows_010600.wwv_flow_upgrade.switch_schemas('APEX_040200','FLOWS_010600');

3) Oracle Application Express Release 2.0：

ALTER SESSION SET CURRENT_SCHEMA = FLOWS_020000; exec

flows_020000.wwv_flow_upgrade.switch_schemas('APEX_040200','FLOWS_020000');

4) Oracle Application Express Release 2.2：

ALTER SESSION SET CURRENT_SCHEMA = FLOWS_020200; exec

flows_020200.wwv_flow_upgrade.switch_schemas('APEX_040200','FLOWS_020200');

5) Oracle Application Express Release 3.0：

Change your working directory to apex in the 3.0 source. set define '^'

@apexvalidate x x FLOWS_030000

ALTER SESSION SET CURRENT_SCHEMA = FLOWS_030000; exec

flows_030000.wwv_flow_upgrade.switch_schemas('APEX_040200','FLOWS_030000');

ALTER SESSION SET CURRENT_SCHEMA = SYS; exec validate_apex;

6) Oracle Application Express Release 3.1:

Change your working directory to apex/core in the 3.1 source. @wwv_flow_val.plb @wwv_dbms_sql.sql @wwv_dbms_sql.plb

Change your working directory to apex in the 3.1 source. set define '^'

@apexvalidate x x FLOWS_030100

ALTER SESSION SET CURRENT_SCHEMA = FLOWS_030100; exec

46 / 51