摘要：
一、环境
Oracle 10g 10.2.0.4
Apex 4.0.1
Apex Listener 1.0.2
Window 2003
JDK 6 update22
J2EE 6
GlassfishV3 3.0.1
Oracle 10g需要安装下面的组件
Oracle XML DB
Oracle Text
二、步骤
1、安装 JDK
2、安装Apex 4.0.1
解压缩
将目录变更到 apex跟目录 /apex_4.0.1/apex/下
使用 Oracle 的sys用户登陆sqlplus，
@apexins tablespace_apex tablespace_files tablespace_temp images
Where:
– tablespace_apex is the name of the tablespace for the Oracle
Application Express application user.
– tablespace_files is the name of the tablespace for the Oracle
Application Express files user.
– tablespace_temp is the name of the temporary tablespace.
– images is the virtual directory for Oracle Application Express images. To
support future Oracle Application Express upgrades, define the virtual
image directory as /i/.
Example:
@apexins SYSAUX SYSAUX TEMP /i/
sys用户重新登陆sqlplus
设置Admin密码
@apxchpwd
Configure APEX_PUBLIC_USER Account
Unlocking the APEX_PUBLIC_USER Account
ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK
Changing the Password for the APEX_PUBLIC_USER Account
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY new_password
3、安装 GlassfishV3
按照安装文件提示安装。
To Start the Default Domain
as-install/bin/asadmin start-domain
Copy Oracle Application Express Images
1. Create folder i in
2. Copy all files and its folders from Oracle Application Express images directory
To start the Administration Console, type the URL in your browser.
The default URL for the Administration Console is:
http://localhost:4848
如果admin console 加载缓慢的话，执行下面步骤。执行缓慢的原因，glassfish要更新，下面步骤是去掉更新模块。
参考 in OGS 3.0.1 Admin Console very slow
停止glassfish的默认Dmain
* cd glassfishv3/glassfish
* mv modules/console-updatecenter-plugin.jar modules/console-updatecenter-plugin.jar.ORIG
* rm -r domains/domain1/osgi-cache
* rm -r domains/domain1/generated
4、部署 Apex Listener 1.0.2
Administration Console
1. To start the Administration Console, type the URL in your browser.
The default URL for the Administration Console is:
http://localhost:4848
2. If prompted, log in to the Administration Console.
You will be prompted to log in if you chose to require an administration password at the time GlassFish server was installed.
Users and Roles
The APEX Listener requires users to be assigned roles to access the Application Express Listener Administration. For additional information on Security Realms, Users, Group List, Roles, refer to the Sun GlassFish Enterprise Server documentation.
Create Roles
The APEX Listener requires roles to be assigned to the users to access the Application Express Listener Administration. The two types of roles are: Admin
The user with an APEX Listener Admin role has permission to access the APEX Listener Administration Page. Manager
The user with an APEX Listener Manager role has permission to access the APEX Listener Status Information Page.
You can enable a default principal-to-role mapping on the Application Server using the Admin Console if the group list names is defined the same as the role names.
1. On the navigation tree, select Configuration, then Security. The Security page is displayed.
2. Click on the checkbox next to Default Principal to Role Mapping to enable this option.
3. Click on the Save button.
Note: Enabling the Default Principal to Role requires the Group List to be the same as the role name as described below when creating the user.
Create Users
You will need to create users to access the APEX Listener Administration page and Status page.
1. In the navigation tree, expand the Co