Oracle APEX 4.2安装与配置 END; /
COMMIT;
2. 无效的ACL错误疑难解答
如果在运行之前脚本后收到ORA-44416: Invalid ACL error，使用下列查询定位无效的ACL
REM Show the dangling references to dropped users in the ACL that is assigned REM to '*'.
SELECT ACL, PRINCIPAL
FROM DBA_NETWORK_ACLS NACL, XDS_ACE ACE
WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL AND NACL.ACLID = ACE.ACLID AND
NOT EXISTS (SELECT NULL FROM ALL_USERS WHERE USERNAME = PRINCIPAL);
下一步，运行下列代码修复ACL
DECLARE
ACL_ID RAW(16); CNT NUMBER; BEGIN
-- Look for the object ID of the ACL currently assigned to '*' SELECT ACLID INTO ACL_ID FROM DBA_NETWORK_ACLS
WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL; -- If just some users referenced in the ACL are invalid, remove just those -- users in the ACL. Otherwise, drop the ACL completely. SELECT COUNT(PRINCIPAL) INTO CNT FROM XDS_ACE WHERE ACLID = ACL_ID AND
EXISTS (SELECT NULL FROM ALL_USERS WHERE USERNAME = PRINCIPAL); IF (CNT > 0) THEN
FOR R IN (SELECT PRINCIPAL FROM XDS_ACE WHERE ACLID = ACL_ID AND
NOT EXISTS (SELECT NULL FROM ALL_USERS
WHERE USERNAME = PRINCIPAL)) LOOP
UPDATE XDB.XDB$ACL SET OBJECT_VALUE =
DELETEXML(OBJECT_VALUE,
15 / 51
Oracle APEX 4.2安装与配置 '/ACL/ACE[PRINCIPAL=\ WHERE OBJECT_ID = ACL_ID; END LOOP; ELSE
DELETE FROM XDB.XDB$ACL WHERE OBJECT_ID = ACL_ID; END IF; END; /
REM commit the changes. COMMIT;
3.3.9 安全考虑
Oracle强烈推荐使用Secure Sockets Layer (SSL)确保密码和其他敏感信息不会在传输过程存在潜在的暴露可能。
3.3.10 管理JOB_QUEUE_PROCESSES
JOB_QUEUE_PROCESSES确定并行运行的工作数。在 Oracle Application Express Release 4.2中事务与SQL脚本都需要job支持，JOB_QUEUE_PROCESSES如果未启用或正确的工作，那么不能成功的执行脚本。
1. 检查JOB_QUEUE_PROCESSES参数
登录Oracle Application Express，查看About Application Express页面，或使用sqlplus连接到数据库
sqlplus / as sysdba
show parameter JOB_QUEUE_PROCESSES
2. 设置JOB_QUEUE_PROCESSES参数
sqlplus / as sysdba
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=100;
3.3.11 使用其它语言运行Oracle Application Express
Oracle Application Express界面能转变为German, Spanish, French, Italian, Japanese, Korean, Brazilian Portuguese, Simplified Chinese, and Traditional Chinese。一个单实例的Oracle Application Express 能够安装一种或多种翻译版本。开发者能够在任何已安装的语言中选择一种运行Application Express
16 / 51
Oracle APEX 4.2安装与配置 开发环境，通过登录Application Builder主页简单的进行选择。
为了安装其它语言必须使用 apex_4.2.zip文件。如果你先前下载apex_4.2_en.zip,，那么不需要重新安装Oracle Application Express。仅需简单的下载apex_4.2.zip并解压文件到之前apex_4.2_en.zip时相同的目录。
The translated version of Oracle Application Express should be loaded into a database that has a character set that supports the specific language. If you attempt to install a translated version of Oracle Application Express into a database that does not support the character encoding of the language, the installation may fail or the translated Oracle Application Express instance may appear corrupt when run. The database character set AL32UTF8 supports all the translated versions of Oracle Application Express.
You can manually install translated versions of Oracle Application Express using SQL*Plus. The installation files are encoded in AL32UTF8
注：不管目标数据库的字符集，你安装Oracle Application Express时，必须设置NLS_LANG环境变量为AL32UTF8，在运行sqlplus之前。
1. 安装Oracle Application Express的翻译版本
无论是升级还是安装新的版本都需要运行load_lang.sql脚本来转换Oracle Application Express。
这个安装脚本位于解压apex/builder目录下相对应语言代码的子目录，如German版本位于apex/builder/de ，Japanese版本位于apex/builder/ja。在每个目录内，有一个语言代码标识的脚本 (例： load_de.sql or load_ja.sql).
为安装a translated version of Oracle Application Express: 设置NLS_LANG环境变量为AL32UTF8，例： SIMPLIFIED CHINESE_CHINA.AL32UTF8 Bourne or Korn shell:
NLS_LANG=American_America.AL32UTF8 export NLS_LANG C shell:
setenv NLS_LANG American_America.AL32UTF8 For Windows based systems:
set NLS_LANG=American_America.AL32UTF8
进入你需要安装的语言的目录，用sys用户以sysdba角色登录到Oracle Application Express安装的数据库
sqlplus / as sysdba
ALTER SESSION SET CURRENT_SCHEMA = APEX_040200; @load_lang.sql
其中lang是指定的语言 (例：load_de.sql for German or load_ja.sql for
17 / 51
Oracle APEX 4.2安装与配置 Japanese)。
3.3.12 配置SHARED_SERVERS参数
Embedded PL/SQL gateway使用Oracle数据库的共享服务器体系，当使用embedded PL/SQL gateway时为获得可接受的性能，确保SHARED_SERVERS 数据库初始化参数设置为相应的值(不要是0或1)。对于小规模的并发用户Oracle推荐SHARED_SERVERS设置为5.
sqlplus / as sysdba
ALTER SYSTEM SET SHARED_SERVERS = 5 SCOPE=BOTH;
3.3.13 在Oracle Application Express建立一个工作空
间并添加一个用户
使用Web浏览器访问Oracle Application Express主页并登录一个工作空间。Web浏览器的JavaScript必须是启用的。
工作空间是一个虚拟的私有数据库，允许多个用户在同一个Oracle Application Express安装中工作并保持他们的对象，数据和应用私有。每个工作空间有一个唯一的ID和名称。
An instance administrator can create a workspace manually within Oracle Application Express Administration Services or have users submit requests. Oracle Application Express Administration Services is a separate application for managing an entire Oracle Application Express instance.
1. 手工建立一个工作空间
登录到Oracle Application Express Administration Services。
打开浏览器
http://hostname:port/apex/apex_admin 输入：admin/password
点击“管理工作空间” 点击“建立工作空间” 输入：
工作空间名：输入唯一的工作空间名
工作空间ID：保留空白Oracle将自动输入一个ID，ID是至少大空间描述
18 / 51
于100000的整型
下一步，输入schema，指定是否使用现有的或建立一个新的
相关推荐：
loading