Oracle Application Express Listener

Oracle Application Express Listener

Version 1.0.2

August 2010

Table of Contents

Installation .............................................................................................................. 4

Using the Embedded Web Container .................................................................................5 Quick Launch .................................................................................................................5 APEX Listener Launch Options ......................................................................................5 Stopping the Server ........................................................................................................6

Using a Java Enterprise Edition Application Server............................................................7

Installing with Oracle WebLogic Server .................................................................................8 Create Web Archive for Oracle Application Express Images ..........................................8

Administration Server Console ...........................................................................................8 Deployment ........................................................................................................................9 Users and Roles ..............................................................................................................13

Create Users ................................................................................................................13 Create Roles ................................................................................................................14 APEX Listener Administration ..........................................................................................15

Installing with Oracle GlassFish Server ...............................................................................16 Copy Oracle Application Express Images .....................................................................16

Administration Console ....................................................................................................16 Users and Roles ..............................................................................................................17

Create Roles ................................................................................................................17 Create Users ................................................................................................................17 Deployment ......................................................................................................................18 APEX Listener Administration ..........................................................................................19

Installing with Oracle Containers for J2EE (OC4J)...............................................................20 Copy Oracle Application Express Images .....................................................................20 Start OC4J Server ........................................................................................................20

Application Server Control Console..................................................................................20 Users and Roles ..............................................................................................................21

Create Roles ................................................................................................................21 Create Users ................................................................................................................21 Deployment ......................................................................................................................22 APEX Listener Administration ..........................................................................................23

Upgrading Oracle Application Express Listener ...................................................................24 Before You Begin .........................................................................................................24

Oracle WebLogic Server ..................................................................................................24 Redeploy ......................................................................................................................24

Oracle GlassFish Server ..................................................................................................24 Redeploy ......................................................................................................................24

Oracle Containers for J2EE (OC4J) .................................................................................25 Redeploy ......................................................................................................................25

Upgrading Oracle Application Express Images ....................................................................26 Oracle WebLogic Server ..................................................................................................26 Redeploy ......................................................................................................................26 2

Oracle GlassFish Server ..................................................................................................26 Oracle Containers for J2EE (OC4J) .................................................................................26

Troubleshooting ...................................................................................................................27 Issue: Application Express images are not being displayed. ........................................27 Issue: Cannot logon to Application Express Listener Administration. ...........................30

Configuration ....................................................................................................... 31

Accessing Application Express Listener ...........................................................................31 Administration ............................................................................................................... 31 Status Information ........................................................................................................31

Administration ..................................................................................................................32 Connection ....................................................................................................................... 32

Basic Connection Type .............................................................................................33 TNS Connection Type ...............................................................................................34 Advanced Connection Type ......................................................................................35 JDBC Settings...........................................................................................................36 Security ............................................................................................................................37 Allowed Procedures ..................................................................................................38 Blocked Procedures ..................................................................................................39 Internal Exclusion List ...............................................................................................39 Database Validation Function ...................................................................................40 Database Validation Function Format .......................................................................40 Security Settings .......................................................................................................41 Security Feature Considerations ......................................................................................42 Security Processing .........................................................................................................42 Caching ............................................................................................................................ 43 Caching Files ............................................................................................................43 Cache Settings..........................................................................................................44 Pre and Post Processing Procedures...............................................................................45 Pre-Processing Procedure ........................................................................................46 Post-Processing Procedure.......................................................................................46 Status ............................................................................................................................... 47 Statistics ...................................................................................................................47 Error Tracking ...........................................................................................................48 Logging .....................................................................................................................49 Status Information for Users with Manager Role ..............................................................50 Miscellaneous ..................................................................................................................51 Saving and Applying the Configuration Information ..........................................................52 Updating the Configuration Information ............................................................................52

Configuration File ................................................................................................ 53

Configuration File Parameters..........................................................................................55

3

Oracle Application Express Listener

This document is divided into two parts:

1. Installation 2. Configuration

Installation

The Oracle Application Express Listener is available on Oracle Technology Network (OTN).

Requirements: Oracle Database 10.2+ or later releases

Java 6 Update 20 JDK or higher Java Servlet Specification 2.3 or higher

The Oracle Application Express Listener supports the following Java Enterprise Edition application servers:

Application Server

Oracle WebLogic Server Oracle GlassFish Server Oracle Containers for J2EE

Version

11g Release 1 (10.3.3) 3 + 10.1.3.4 or higher

The Oracle Application Express Listener can be deployed in two ways:

1. Using the Embedded Web Container This enables the Listener to be run standalone without needing an application server. This is the simplest way to get the Listener up and running but offers limited control over the environment in which the Listener runs.

2. Using a Java Enterprise Edition Application Server This enables the Listener to be integrated with an existing application server environment. Requires more effort to deploy and configure but gives more control over the environment in which the Listener runs.

4

Using the Embedded Web Container

1. Download the Application Express Listener zip file 2. Unzip the downloaded Application Express Listener zip file into a temporary directory.

Quick Launch

To launch the Application Express Listener immediately, type the following at a command prompt:

java ?jar \apex.war

where is the directory location of the unzipped Application Express Listener.

You will be prompted to choose a user name and password for the Application Express Listener Administrator and Manager roles.

Note: You will only be prompted for the usernames and passwords the first time you launch the Listener.

On your browser, specify to display the Oracle Application Express Listener Administration. Refer to the Configuration section for detailed information.

APEX Listener Launch Options

The APEX Listener provides several options for you to configure your listener, such as the Application Express images directory location, the APEX listener home directory to store the runtime files and the HTTP listen port. It also provides the option of removing the runtime files from your APEX listener home directory. To display a full list of the command line options, type the following on the command line:

java ?jar \apex.war --help

where is the directory location of the unzipped Application Express Listener.

The following output will be displayed: java [options] -jar apex.war [--help]

Options:

-Dapex.home=/path/to/apex

: Path to the folder used to store the

web container runtime, defaults to:

${user.home}/.apex/nnnn,

where nnnn is the HTTP listen port

-Dapex.port=nnnn

: HTTP listen port, default 8080

-Dapex.images=/images/location : Path to the folder containing static

resources required by APEX

-Dapex.erase=true

: Erase the contents of ${apex.home}

before launching

--help

: Print this usage message

5

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download