Application Express

PreviousNext

Private Cloud Service

Oracle Application Express provides a "Platform as a Service" (PaaS) framework enabling developers to signup for a development service online and then immediately start developing in a self-contained workspace. Alternatively, Oracle Application Express can be configured for manual provisioning.

Provisioning

Self Service Provisioning

Oracle Application Express can be deployed to enable users to request a workspace. A workspace provides access to an Oracle Application Express application development environment as well as access to one or more database schemas. The self-service model enables application development projects from multiple work groups to be consolidated within a single Oracle database.

Provisioning Modes

Oracle Application Express provides three provisioning modes:

  • Manual - An administrator manually creates each workspace
  • Request - Users follow a link displayed on the login page to request workspaces which administrators then review and approve or decline
  • Email Verification - Users still submit requests but workspaces are only created after email verification by the user

Requesting Additional Service

Workspace Administrators can perform various duties including:

  • Request an additional schema
  • Request Storage
  • Request Termination
  • Define user account expiration and locking
  • Enable / disable Application Builder, SQL Workshop, and Team Development

Resource Monitoring

Workspace Administration

Workspace administrators can monitor workspace activity and resource utilization. Dashboards show key indicators organized by category and provide drill-downs to details. Summarized activity and resource consumption can also be subscribed to and received by email.

Oracle Application Express activity logs, which track detailed records of each page view and page post, are retained, by default, for a minimum of two weeks. Summarized performance information is maintained forever.

Instance Administration

Oracle Application Express contains a separate Instance Administration interface which provides the ability to monitor and manage all workspaces as well as facilities to manage the instance as a whole.

Internal Server Error

500 - Internal Server Error

Request Path passes syntax validation
Mapping request to database pool: PoolMap [_poolName=apex, _regex=null, _workspaceIdentifier=null, _failed=false, _lastUpdate=-1, _template=null, _type=REGEX]
Applied database connection info
Attempting to process with PL/SQL Gateway
==== Processing Request: ====
GET /apex/f?p=4600:37:3775422731084::NO:::
==== Headers in Request ====
accept: */*
user-agent: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
cookie: ORA_WWV_USER_63113586886954=ORA_WWV-IuRhlL+CZe62e4m2NjGSNlHS
accept-encoding: gzip, br, zstd, deflate
referer: http://reconquistatramites.gov.ar:9095/apex/f?p=4600%3A37%3A6255702551057%3A%3ANO%3A%3A%3A
host: reconquistatramites.gov.ar:9095
==== Cookies in Request ====
ORA_WWV_USER_63113586886954 =  ORA_WWV-IuRhlL+CZe62e4m2NjGSNlHS
request parameter: p=4600:37:3775422731084::NO:::
isValidRequest(), procedure name: 
Validating: f
*** Total number of arguments: 15
SID: 238
Parse: 0 ms
-----
begin 
 f(p=>?);
commit;
  end;
*** Total number of arguments: 15
{p=4600:37:3775422731084::NO:::}
p=4600:37:3775422731084::NO:::
p= 4600:37:3775422731084::NO:::
Exec: 50 ms
Got results length: 9110
==== Headers from Results ====
Setting Content-Type (Content-type): text/html; charset=utf-8
Adding X-Frame-Options: DENY
Adding X-DB-Content-length: 9110
Processed PL/SQL Gateway request

WebException [statusCode=500]
	at oracle.dbtools.rt.web.WebException.webException(WebException.java:343)
	at oracle.dbtools.rt.web.WebException.internalError(WebException.java:262)
	at oracle.dbtools.rt.web.WebErrorResponse.internalError(WebErrorResponse.java:101)
	at oracle.dbtools.rt.web.WebErrorResponse.error(WebErrorResponse.java:75)
	at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:132)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Thread.java:662)
Caused by: java.util.ConcurrentModificationException
	at java.util.AbstractList$Itr.checkForComodification(AbstractList.java:372)
	at java.util.AbstractList$Itr.next(AbstractList.java:343)
	at java.util.Collections.sort(Collections.java:120)
	at oracle.dbtools.apex.statistics.Statistics.toString(Statistics.java:226)
	at oracle.dbtools.apex.statistics.Statistics.print(Statistics.java:174)
	at oracle.dbtools.apex.statistics.Statistics.finishRequest(Statistics.java:141)
	at oracle.dbtools.apex.ModApexContext.close(ModApexContext.java:324)
	at oracle.dbtools.common.util.Closeables$2.closeType(Closeables.java:155)
	at oracle.dbtools.common.util.Closeables$2.closeType(Closeables.java:149)
	at oracle.dbtools.common.util.Closeables$BaseCloser.close(Closeables.java:239)
	at oracle.dbtools.common.util.Closeables.close(Closeables.java:97)
	at oracle.dbtools.apex.ModApex.close(ModApex.java:176)
	at oracle.dbtools.apex.ModApex.doGet(ModApex.java:101)
	at oracle.dbtools.apex.ModApex.service(ModApex.java:301)
	at oracle.dbtools.rt.web.HttpEndpointBase.modApex(HttpEndpointBase.java:347)
	at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:130)
	... 13 more