Configuring Instance Settings
Control a variety of general settings for an Oracle Application Express development instance including configuring workspace provisioning behavior, storage, email, wallet information, report printing, Help menu, workspace size options, and application ID ranges.
- About Configuring Self Service Workspace Provisioning
The Instance administrator determines the amount of automation when provisioning (or creating) a workspace. - Disabling Email Provisioning
Use Email Provisioning to disable workspace provisioning when provisioning with Email Verification. - Configuring Storage
Instance administrators can configure the following storage options: require a new schema when requesting a workspace, auto extend tablespaces, or delete uploaded files are a specified number of days. - Configuring Email
To enable Oracle Application Express to send mail, an instance administrator must configure instance-level email settings. - Configuring Wallet Information
Configure wallet information (which store authentication and signing credentials) for an Oracle Application Express instance. - Configuring Report Printing
Enable end users to download and print reports in various formats, including PDF. - Configuring the Help Menu
Configure the target URL of the Help menu that displays in the upper right corner of the Oracle Application Express development environment. - Configuring Workspace Size Options for Requests
Configure the workspace size options available to users when they request a new workspace and schema and request additional space for an existing workspace. - Managing Application ID Range
Control the range for IDs of new database applications and Websheet applications.
See Also:
Parent topic: Managing Instance Settings
About Configuring Self Service Workspace Provisioning
The Instance administrator determines the amount of automation when provisioning (or creating) a workspace.
To determine how provisioning works, an Instance Administrator selects one of the following Provisioning Status options on the Instance Settings page:
-
Manual - In this mode, an instance administrator creates new workspaces and notifies the Workspace administrator of the login information.
-
Request - Users request workspaces directly in a self-service fashion. Users click a link on the login page to access a request form. After the workspace request has been granted, users are automatically emailed the appropriate login information.
-
Request with Email Verification - In this mode, users request workspaces directly by clicking a link on the Sign In page to access a request form. Each user receives an initial email containing a verification link. When the user clicks the verification link, the request is processed. The user can then access the workspace using the Sign In page.
Note:
To enable users to request a workspace using a link on the Sign In page, you must choose the provisioning status of Request or Request with Email Verification . If the provisioning status is set to Manual, no link appears on the sign in page.
See Also:
"Selecting a Provisioning Mode" "Disabling Email Provisioning," "Configuring Email," and "Managing Workspace and Change Requests"
Parent topic: Configuring Instance Settings
Disabling Email Provisioning
Use Email Provisioning to disable workspace provisioning when provisioning with Email Verification.
To disable email provisioning:
Parent topic: Configuring Instance Settings
Configuring Storage
Instance administrators can configure the following storage options: require a new schema when requesting a workspace, auto extend tablespaces, or delete uploaded files are a specified number of days.
- Requiring a New Schema
Control if a user requesting a workspace can select an existing schema or must request a new schema. - Enabling Auto Extend Tablespaces
Enable Auto Extend Tablespaces. - Enabling Bigfile Tablespaces
Enable support for bigfile tablespaces. - Enabling Encrypted Tablespaces
Enable support for encrypted tablespaces. - Deleting Uploaded Files
Specify the number of days after which Oracle Application Express automatically deletes uploaded files.
Parent topic: Configuring Instance Settings
Requiring a New Schema
Control if a user requesting a workspace can select an existing schema or must request a new schema.
To require a new schema when creating a workspace:
- Sign in to Oracle Application Express Administration Services.
- Click Manage Instance.
- Under Instance Settings, click Instance Settings.
- Scroll down to Storage.
- From Require New Schema, select one of the following:
- Yes - Requires users to request a new schema when they request a new workspace.
- No - Enables users to select an existing schema when they request a new workspace.
- Click Apply Changes.
See Also:
Parent topic: Configuring Storage
Enabling Auto Extend Tablespaces
Enable Auto Extend Tablespaces.
If Auto Extend Tablespaces is enabled, tablespaces provisioned with Oracle Application Express are created with a data file that is one tenth the requested size. The data file automatically extends up to the requested size. For example, if a user requests a 100 MB workspace, the initial size of the data file is 10 MB and automatically extends up to a maximum size of 100 MB.
To enable Auto Extend Tablespaces:
- Sign in to Oracle Application Express Administration Services.
- Click Manage Instance.
- Under Instance Settings, click Instance Settings.
- Scroll down to Storage.
- To enable Auto Extend Tablespaces, select Yes.
- Click Apply Changes.
Parent topic: Configuring Storage
Enabling Bigfile Tablespaces
Enable support for bigfile tablespaces.
When a workspace is provisioned, Oracle Application Express creates the associated database user, tablespace, and data file. If Bigfile Tablespaces is enabled, tablespaces provisioned with Oracle Application Express are created as bigfile tablespaces. A bigfile tablespace is a tablespace with a single, but very large data file. Traditional smallfile tablespaces, in contrast, can contain multiple data files, but the files cannot be as large.
Tip:
Oracle does not recommend using bigfile tablespaces on platforms that do not support large file sizes and can limit tablespace capacity. Refer to your operating system specific documentation for information about maximum supported file sizes.
To enable bigfile tablespaces:
- Sign in to Oracle Application Express Administration Services.
- Click Manage Instance.
- Under Instance Settings, click Instance Settings.
- Scroll down to Storage.
- For Bigfile Tablespaces, select Yes.
- Click Apply Changes.
See Also:
"Available Parameter Values" in Oracle Application Express API Reference to learn about the BIGFILE_TABLESPACES_ENABLED
parameter
Parent topic: Configuring Storage
Enabling Encrypted Tablespaces
Enable support for encrypted tablespaces.
If Encrypted Tablespaces is enabled, tablespaces provisioned with Oracle Application Express are created as encrypted tablespaces using the Oracle database feature Transparent Data Encryption (TDE). TDE encrypts sensitive data stored in data files. To prevent unauthorized decryption, TDE stores the encryption keys in a security module external to the database.
To be able to exploit this feature in Application Express, an encryption wallet must be created and with a master encryption key set. Additionally, the encryption wallet must be open before provisioning a new Application Express workspace.
To enable Encrypted Tablespaces:
- Sign in to Oracle Application Express Administration Services.
- Click Manage Instance.
- Under Instance Settings, click Instance Settings.
- Scroll down to Storage.
- For Encrypted Tablespaces, select Yes.
- Click Apply Changes.
See Also:
"Available Parameter Values" in Oracle Application Express API Reference to learn about the ENCRYPTED_TABLESPACES_ENABLED
parameter
Parent topic: Configuring Storage
Deleting Uploaded Files
Specify the number of days after which Oracle Application Express automatically deletes uploaded files.
Use Delete Uploaded Files After (days) to specify the number of days after which Oracle Application Express automatically deletes uploaded files. Note this automatic deletion process applies to all workspaces in an Oracle Application Express instance. The types of files that are deleted include:
-
Application Export
-
CSS Export
-
Images Export
-
Page Export
-
Plug-in
-
Script Export
-
Spreadsheet / Text Data Import
-
Static Files Export
-
Themes
-
User Interface Defaults
-
Workspace Export
-
XML Data Import
To configure when export and import files are deleted:
Tip:
To view a summary of deleted files, see the Automatic File Delete Log. See "Monitoring Activity Across a Development Instance"
Parent topic: Configuring Storage
Configuring Email
To enable Oracle Application Express to send mail, an instance administrator must configure instance-level email settings.
Tip:
You can configure Oracle Application Express to automatically email users their login credentials when a new workspace request has been approved. See "About Specifying How Workspaces Are Created" and "Selecting a Provisioning Mode."
- About Enabling Network Services
To send outbound mail, use Web services, or use PDF/report printing in Oracle Application Express, an Instance administrator must enable network services. - Configuring Email in a Full Development Environment
An Instance administrator must configure Oracle Application Express to send mail in a full development environment. - Configuring Email in a Runtime Environment
An Instance administrator must configure Oracle Application Express to send mail in a runtime environment. - Determining Email Settings in a Runtime Environment
Determine email settings in runtime environment
See Also:
"Managing the Mail Queue" and "APEX_MAIL" in Oracle Application Express API Reference
Parent topic: Configuring Instance Settings
About Enabling Network Services
To send outbound mail, use Web services, or use PDF/report printing in Oracle Application Express, an Instance administrator must enable network services.
If you are running Oracle Application Express with Oracle Database 11g or later, you must enable outbound mail. Starting with Oracle Database 11g Release 1 (11.1), the ability to interact with network services is disabled by default.
By default, the ability to interact with network services is disabled in Oracle Database 11g
or later. Therefore, if you are running Oracle Application Express with Oracle Database 11g or later, you must use the DBMS_NETWORK_ACL_ADMIN
package to grant connect privileges to any host for the APEX_180200
database user. Failing to grant these privileges results in issues with:
Failing to grant these privileges results in issues with:
-
Sending outbound mail in Oracle Application Express.
-
Using Web services in Oracle Application Express.
-
PDF/report printing.
See Also:
“Enabling Network Services in Oracle Database 11g or Later” for your installation scenario in Oracle Application Express Installation Guide:
Parent topic: Configuring Email
Configuring Email in a Full Development Environment
An Instance administrator must configure Oracle Application Express to send mail in a full development environment.
To configure Oracle Application Express to send mail in a full development environment:
- Sign in to Oracle Application Express Administration Services.
- Click Manage Instance.
- Under Instance Settings, click Instance Settings.
- Scroll down to Storage.
- Under Email, edit the following:
- Click Apply Changes.
Parent topic: Configuring Email
Configuring Email in a Runtime Environment
An Instance administrator must configure Oracle Application Express to send mail in a runtime environment.
To configure Oracle Application Express to send mail in a runtime environment:
See Also:
"SET_PARAMETER Procedure" in Oracle Application Express API Reference
Parent topic: Configuring Email
Determining Email Settings in a Runtime Environment
Determine email settings in runtime environment
To determine email settings in runtime environment:
See Also:
"GET_PARAMETER Function" in Oracle Application Express API Reference
Parent topic: Configuring Email
Configuring Wallet Information
Configure wallet information (which store authentication and signing credentials) for an Oracle Application Express instance.
- About SSL and Wallet Creation
A wallet is a password-protected container that stores authentication and signing credentials (including private keys, certificates, and trusted certificates) needed by SSL. - Configuring a Wallet in a Full Development Environment
Configure wallet settings a full development environment on the Instance Settings page. - Configuring a Wallet in a Runtime Environment
Configure wallet settings a runtime environment by starting SQL*Plus and running the following SQL statements. - Determining Wallet Settings in a Runtime Environment
Configure wallet settings in a runtime environment by starting SQL*Plus and running the following SQL statements.
Parent topic: Configuring Instance Settings
About SSL and Wallet Creation
A wallet is a password-protected container that stores authentication and signing credentials (including private keys, certificates, and trusted certificates) needed by SSL.
Secure Sockets Layer (SSL) is an industry standard protocol that uses RSA public key cryptography with symmetric key cryptography to provide authentication, encryption, and data integrity. When SSL is enabled, https
displays in the URL.
You must create a wallet if you:
-
Call a SSL-enabled URL (for example, by invoking a Web service).
-
Create a region of type URL that is SSL-enabled.
-
Configure secure SMTP, by setting the Use SSL/TLS attribute to Yes.
-
Have applications with LDAP authentication schemes that are configured to use SSL with Authentication.
Overview of Creating a Wallet
To create a wallet:
-
The database administrator must create a wallet on the Oracle Application Express database instance.
-
The instance administrator configures the Wallet attributes on the Instance Settings page to specify the file system path to the wallet and the wallet password (if required).
See Also:
-
"Using Oracle Wallet Manager" in Oracle Database Enterprise User Security Administrator's Guide
-
"Working with SSL Enabled Web Services" in Oracle Application Express App Builder User’s Guide
Parent topic: Configuring Wallet Information
Configuring a Wallet in a Full Development Environment
Configure wallet settings a full development environment on the Instance Settings page.
To specify wallet settings in a full development environment:
- Sign in to Oracle Application Express Administration Services.
- Click Manage Instance.
- Under Instance Settings, click Instance Settings.
- Click Wallet.
- Under Wallet:
- Click Apply Changes.
Parent topic: Configuring Wallet Information
Configuring a Wallet in a Runtime Environment
Configure wallet settings a runtime environment by starting SQL*Plus and running the following SQL statements.
To specify wallet settings in a runtime environment:
See Also:
"SET_PARAMETER Procedure" in Oracle Application Express API Reference
Parent topic: Configuring Wallet Information
Determining Wallet Settings in a Runtime Environment
Configure wallet settings in a runtime environment by starting SQL*Plus and running the following SQL statements.
To determine wallet settings in a runtime environment:
See Also:
"GET_PARAMETER Function" in Oracle Application Express API Reference
Parent topic: Configuring Wallet Information
Configuring Report Printing
Enable end users to download and print reports in various formats, including PDF.
- About Configuring Report Printing
You enable report printing by configuring printing settings as the site-level, instance-level, and page and region-level. - Configuring Report Printing in a Full Development Environment
Configure report printing at the instance-level on the Instance Settings page. - Configuring Report Printing Settings in a Runtime Environment
Configure report printing settings in a runtime environment by starting SQL*Plus and running the following SQL statements. - Determining Report Printing Settings in a Runtime Environment
Determine report printing settings in a runtime environment.
Parent topic: Configuring Instance Settings
About Configuring Report Printing
You enable report printing by configuring printing settings as the site-level, instance-level, and page and region-level.
To set up report printing functionality, you must configure the following printing settings:
-
Site Level: Instance administrators must specify the level of functionality (Standard or Advanced) for an entire Oracle Application Express instance, as described in this section.
-
Application Level: Workspace administrators and developers can define Report Queries and Report Layouts. Report Queries and Report Layouts are stored under Shared Components and are not tied to a specific page.
-
Page/Region Level: Developers can edit the Report regions on specific pages to enable printing. This enables end users to print regions as reports in various formats.
See Also:
-
"Configuring Classic Report Region Print Attributes" in Oracle Application Express App Builder User’s Guide
-
“Enabling Network Services in Oracle Database 11g or Later” for your installation scenario in Oracle Application Express Installation Guide
Parent topic: Configuring Report Printing
Configuring Report Printing in a Full Development Environment
Configure report printing at the instance-level on the Instance Settings page.
To configure the printing of reports in a full development environment:
See Also:
PDF Printing in Application Express to learn more about installing and configuring Oracle BI Publisher.
Parent topic: Configuring Report Printing
Configuring Report Printing Settings in a Runtime Environment
Configure report printing settings in a runtime environment by starting SQL*Plus and running the following SQL statements.
To configure report printing settings in a runtime environment:
See Also:
"SET_PARAMETER Procedure" in Oracle Application Express API Reference
Parent topic: Configuring Report Printing
Determining Report Printing Settings in a Runtime Environment
Determine report printing settings in a runtime environment.
To determine report printing settings in a runtime environment:
See Also:
-
See "Table 2-6" for a description of available parameters.
-
"GET_PARAMETER Function" in Oracle Application Express API Reference
Parent topic: Configuring Report Printing
Configuring the Help Menu
Configure the target URL of the Help menu that displays in the upper right corner of the Oracle Application Express development environment.
By default, the Help menu points to the current Oracle Application Express online documentation library.
To configure the Help menu:
See Also:
"About the Oracle Application Express Documentation" in Oracle Application Express App Builder User’s Guide
Parent topic: Configuring Instance Settings
Configuring Workspace Size Options for Requests
Configure the workspace size options available to users when they request a new workspace and schema and request additional space for an existing workspace.
To configure workspace size options:
See Also:
Parent topic: Configuring Instance Settings
Managing Application ID Range
Control the range for IDs of new database applications and Websheet applications.
You can separate ID ranges in large multi-instance installations to easily move workspaces between the instances and still keep their application IDs. To enable ID ranges, you must specify at least an ID Minimum.
To configure the application ID ranges:
Parent topic: Configuring Instance Settings