Oracle Application Express (Oracle APEX), formerly called HTML DB, is a rapid web application development tool for the Oracle database. Using only a web browser and limited programming experience, you can develop and deploy professional applications that are both fast and secure. Oracle Application Express combines the qualities of a personal database, productivity, ease of use, and flexibility with the qualities of an enterprise database, security, integrity, scalability, availability and built for the web. Application Express is a tool to build web-based applications and the application development environment is also conveniently web-based.
Oracle Application Express
The pattern identifies the product on Windows and Unix platforms.
Oracle Application Express Detail
Oracle Database Server
Oracle Application Express Software Instance
Oracle Application Express
Two methods of versioning for the Oracle Application Express Detail are tried.
Various database queries are used for versioning. Unlike other patterns, these database queries cannot be disabled in the pattern configuration block as the pattern is worthless without these queries. If you do not want database queries to be run, please disable this pattern
The following query is run on the Oracle Database, version information is extracted from the results
This method is only tried is the Oracle Application Express#Standard Query fails
The following query is run on the Oracle Database
The output of this query is parsed using the following regular expression
The version is taken to be $1.$2.$3
The Oracle Application Express Software Instance obtains its version information from the Oracle Application Express Detail it triggers from
Unlike other patterns, these database queries cannot be disabled in the pattern configuration block as the pattern is worthless without these queries. If you do not want database queries to be run, please disable this pattern
The following steps should be performed on the Oracle Database in order to create a user with read privileges:
It is necessary to insert Oracle connection details into the Foundation appliance to enable it to run queries on the host during discovery process. For information on how to configure Foundation to access the Oracle database please refer to these documents
The Software Credential Group where the credentials should be entered is 'Oracle Applications'.
By default the pattern obtains the port to access the Oracle Database via the Oracle Database Software Instance.
It is possible for the user to configure the pattern to override this default. In the pattern configuration section, set use_default_port to be True, then specify the default_port to be used
Oracle Application Express has its own scheme installed within Oracle SID. In order to run, Oracle APEX must have access to either the embedded PL/SQL gateway or Oracle HTTP Server and mod_plsql.
Some additional attributes are obtained from database queries. Unlike other patterns, these database queries cannot be disabled in the pattern configuration block as the pattern is worthless without these queries. If you do not want database queries to be run, please disable this pattern
The Detail pattern attempts to obtain the status by running the following query
The Software Instance pattern obtains the status information from the Detail it triggers on
The Detail pattern sets Enabled to be true if the following query can be run successfully
If this fails, the Detail pattern sets Enabled to be true if the following two conditions are satisfied:
The Detail pattern sets Enabled to be false if the following two conditions are satisfied
The Detail pattern attempts to obtain port information by running the following query:
The Software Instance pattern obtains port information from the Detail it triggers on
This pattern triggers on a Detail node, which has "Oracle Application Express" type. Since only one installation of this software may be running per Oracle SID, a simple SI key containing the 'APEX Oracle SID', 'type' and 'host key' attributes is used on creation of the Software Instance.
The Detail and Software Instance will be aged if both of the following queries fail:
By default a Software Instance or Detail that is aged will be destroyed after seven unsuccessful attempts at database access. This value can be changed using the pattern configuration.
The Detail and Software Instance will be immediately destroyed if:
Pattern module creates dependency relation between the Oracle Application Express Software Instance and an Oracle Database Software Instance that contains the Oracle Application Express Detail node.
Subject Matter Expert input will be welcome on any other potential approaches not discussed to improving product versioning coverage and depth of Oracle Application Express.
Current patterns had been tested on 'Windows 2003 server' and on Linux platforms to ensure that all methods of obtaining the version are working and and the Detail and SI are being created with defined attributes.
There are no known open issues with this pattern.
Created By: Olexander Kashkevich (20 Feb 2009)
Reviewed By: Chris Blake (5 Mar 2009)
Updated By: Chris Blake (9 Nov 2010)