Install Apex 4.0 on Oracle 10g

Abstract:

This article describes how to install the Oracle Apex 4.0 on Oracle 10g and how to install the Language Pack.

I. Environment

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
Install the following components for Oracle 10 GB

Oracle XML DB
Oracle Text

Step 2

1. Install JDK

2. Install Apex 4.0.1

Extract

Change the directory to the/apex_4.0.1/apex/directory.

Use the Oracle sys user to log on to 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.

Support future Oracle Application Express upgrades, define the virtual

Image directory as/I /.

Example:

@ Apexins sysaux temp/I/

Sys user re-login sqlplus

Set Admin Password

@ 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. Install GlassfishV3

Follow the prompts in the installation file.

To Start the Default Domain

As-install/bin/asadmin start-domain

Copy Oracle Application Express Images

1. Create folder I in <glassfish directory>/domains/<domainName>/docroot.

2. Copy all files and its folders from Oracle Application Express images directory <apex directory>/images to <glassfish directory>/domains/<domainName>/docroot/I.

To start the Administration Console, type the URL in your browser.

The default URL for the Administration Console is:

Http: // localhost: 4848

If the admin console is slow to load, perform the following steps. The cause of slow execution is that glassfish needs to update. The following steps remove the update module.

See in OGS 3.0.1 Admin Console very slow

Stop the default Dmain of glassfish

* 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. Deploy 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 Configuration node.

2. Expand the Security node.

3. Expand the Realms node.

4. Select the realm to add your user (e.g., file)

5. The Edit Realm page opens.

6. On the Edit Realm page, click the Manage Users button.

7. The File Users page opens.

8. On the File Users page, click New.

9. The New File Realm User page opens.

10. In the User ID field, type the name of the APEX Listener administrator: adminlistener

11. In the Group List field, type the role to which the user belongs: Admin

12. In the Password field, type a unique password.

13. In the Confirm New Password field, type the user password again.

14. Click OK.

15. Create another user for the APEX Listener manager:

A. User ID: managerlistener

B. Group List: Manager

C. Click OK when you are done.

 

Deployment

Before You Begin

The Application Express Listener file, apex. war, must be available before you start this task.

1. On the navigation tree, click on Application node. The Applications page is displayed.

2. Click the Deploy button. The Deploy Applications or Modules page is displayed.

3. Select Packaged File to be Uploaded to the Server, and click Browse.

4. Navigate to the location of the apex. war file, select the file, and click Open. You are returned to the Deploy Applications or Modules page.

5. Specify and select the following:

A. Type: Web Application

B. Context Root: apex

C. Application Name: apex

D. Status: Enabled

E. Description: Application Express Listener

F. Accept all other default settings, and click OK.

 

You are returned to the Applications page. If a check mark does not appear in the Enabled field for apex, then select the check box next to the apex application and click the Enable button.

APEX Listener Administration

1. On your browser, specify http: // host: port/apex/listenerConfigure to display the Oracle Application Express Listener Administration. Refer to the Configuration section for detailed information.

Log on to Apex Administration and configure users and workspace

Create the first user and workspace

5. Install the Chinese Language Pack

Chinese Shell

Set NLS_LANG = SIMPLIFIED CHINESE_CHINA.AL32UTF8

Japanese Shell

Set NLS_LANG = JAPANESE_JAPAN.AL32UTF8

Set the NLS_LANG environment variable, making sure that the character set is AL32UTF8. For example:
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
Navigate to the directory under apex/builder based on the language you need to install. for example for German, navigate to apex/builder/de. start SQL * Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role. for example:
On Windows:
SYSTEM_DRIVE: \ sqlplus/nolog
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password
On UNIX and Linux:
$ Sqlplus/nolog
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password
Execute the following statement:
Alter session set CURRENT_SCHEMA = APEX_040000;
Execute the appropriate language specific script. For example:
@ Load_lang. SQL