Available Parameter Values

Table 10-1 lists all the available parameter values you can set within the APEX_INSTANCE_ADMIN package, including parameters for email, wallet, and reporting printing.

Table 10-1 Available Parameters

Parameter Name	Description
`ACCOUNT_LIFETIME_DAYS`	The maximum number of days an end-user account password may be used before the account is expired.
`ALLOW_DB_MONITOR`	If set to `Y`, the default, database monitoring is enabled. If set to `N`, it is disabled.
`ALLOW_PUBLIC_FILE_UPLOAD`	If set to `Y`, file uploads are allowed without user authentication. If set to `N`, the default, they are not allowed.
`ALLOW_REST`	If set to `Y`, the default, developers are allowed to expose report regions as RESTful services. If set to `N`, the are not allowed.
`APPLICATION_ACTIVITY_LOGGING`	Controls instance wide setting of application activity log ([A]lways, [N]ever, [U]se application settings)
`AUTOEXTEND_TABLESPACES`	If set to `Y`, the default, provisioned tablespaces is autoextended up to a maximum size. If set to `N` tablespaces are not autoextended.
`BIGFILE_TABLESPACES_ENABLED`	If set to `Y`, the tablespaces provisioned through Oracle Application Express are created as bigfile tablespaces. If set to `N`, the tablespaces are created as smallfile tablespaces.
`DELETE_UPLOADED_FILES_AFTER_DAYS`	Uploaded files like application export files, websheet export files, spreadsheet data load files are automatically deleted after this number of days. Default is `14`.
`DISABLE_ADMIN_LOGIN`	If set to `Y`, administration services are disabled. If set to `N`, the default, they are not disabled.
`DISABLE_WORKSPACE_LOGIN`	If set to `Y`, the workspace login is disabled. If set to `N`, the default, the login is not disabled.
`DISABLE_WS_PROV`	If set to `Y`, the workspace creation is disabled for requests sent out by using e-mail notification. If set to `N`, the default, they are not disabled.
`EMAIL_IMAGES_URL`	Specifies the full URL to the images directory of Application Express instance, including the trailing slash after the images directory. For example: http://your_server/i/
`EMAIL_INSTANCE_URL`	Specifies the URL to Application Express instance, including the trailing slash after the Database Access Descriptor. For example: http://your_server/pls/apex/
`ENABLE_TRANSACTIONAL_SQL`	If set to `Y`, the default, transactional SQL commands are enabled on this instance. If set to `N`, they are not enabled.
`ENCRYPTED_TABLESPACES_ENABLED`	If set to `Y`, the tablespaces provisioned through Oracle Application Express are created as encrypted tablespaces. If set to `N`, the tablespaces are not encyrpted.
`EXPIRE_FIND_USER_ACCOUNTS`	If set to `Y`, expiration of Application Express accounts is enabled. If set to `N`, they are not enabled.
`INBOUND_PROXIES`	Comma-separated list of IP addresses for proxy servers through which requests come in.
`LOGIN_THROTTLE_DELAY`	The flag which determines the time increase in seconds after failed logins.
`LOGIN_THROTTLE_METHODS`	The methods to count failed logins. Colon-separated list of `USERNAME_IP`, `USERNAME, IP`.
`MAX_SESSION_IDLE_SEC`	The number of seconds an internal application may be idle.
`MAX_SESSION_LENGTH_SEC`	The number of seconds an internal application session may exist.
`PASSWORD_ALPHA_CHARACTERS`	The alphabetic characters used for password complexity rules. Default list of alphabetic characters include the following: abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ
`PASSWORD_MIN_LENGTH`	A positive integer or 0 which specifies the minimum character length for passwords for instance administrators, workspace administrators, developers, and end user Application Express accounts.
`PASSWORD_NEW_DIFFERS_BY`	A positive integer or 0 which specifies the number of differences required between old and new passwords. The passwords are compared character by character, and each difference that occurs in any position counts toward the required minimum difference. This setting applies to accounts for instance administrators, workspace administrators, developers, and end user Application Express accounts.
`PASSWORD_PUNCTUATION_CHARACTERS`	The punctuation characters used for password complexity rules. Default list of punctuation characters include the following: !"#$%&()``*+,-/:;<=>?_
`PLSQL_EDITING`	If set to `Y`, the default, the SQL Workshop Object Browser is enabled to allow users to edit and compile PL/SQL. If set to `N`, users are not allowed.
`REQUIRE_HTTPS`	If set to `Y`, access to the instance must be over SSL. If set to `N`, the default, access is not restricted to SSL.
`REQUIRE_VERIFICATION_CODE`	If set to `Y`, the Verification Code is displayed and is required for someone to request a new workspace. If set to `N`, the default, the Verification Code is not required.
`REQ_NEW_SCHEMA`	If set to `Y`, the option for new schema for new workspace requests is enabled. If set to `N`, the default, the option is disabled.
`RESTFULL_SERVICES_ENABLED`	If set to `Y`, the default, RESTful services development is enabled. If set to `N`, RESTful services are not enabled.
`SERVICE_REQUESTS_ENABLED`	If set to `Y`, the default, workspace service requests for schemas, storage, and termination is enabled. If set to `N`, these requests are disabled.
`SERVICE_REQUEST_FLOW`	Determines default provisioning mode. Default is `MANUAL`.
`SMTP_FROM`	Defines the "from" address for administrative tasks that generate email, such as approving a provision request or resetting a password. Enter a valid email address, for example: `someone@somewhere.com`
`SMTP_HOST_ADDRESS`	Defines the server address of the SMTP server. If you are using another server as an SMTP relay, change this parameter to that server's address. Default setting: localhost
`SMTP_HOST_PORT`	Defines the port the SMTP server listens to for mail requests. Default setting: 25
`SMTP_PASSWORD`	Defines the password Application Express takes to authenticate itself against the SMTP server, with the parameter `SMTP_USERNAME`.
`SMTP_TLS_MODE`	Defines whether Application Express opens an encrypted connection to the SMTP server. Encryption is only supported on database versions 11.2.0.2 and later. On earlier database versions, the connection is not encrypted. If set to `N`, the connection is unencrypted (default). If set to `Y`, the connection is encrypted before data is sent. If `STARTTLS`, Application Express sends the SMTP commands `EHLO <SMTP_HOST_ADDRESS>` and `STARTTLS` before encrypting the connection.
`SMTP_USERNAME`	Defines the username Application Express takes to authenticate itself against the SMTP server (default is null). Starting with database version 11.2.0.2, Application Express uses `UTL_MAIL`'s `AUTH` procedure for authentication. This procedure negotiates an authentication mode with the SMTP server. With earlier database versions, the authentication mode is always `AUTH` `LOGIN`. If `SMTP_USERNAME` is null, no authentication is used.
`SQL_SCRIPT_MAX_OUTPUT_SIZE`	The maximum allowable size for an individual script result. Default is `200000`.
`STRONG_SITE_ADMIN_PASSWORD`	If set to `Y`, the default, the apex_admin password must conform to the default set of strong complexity rules. If set to `N`, the password is not required to follow the strong complexity rules.
`SYSTEM_HELP_URL`	Location of the help and documentation accessed from the Help link within the development environment. Default is `http://apex.oracle.com/doc41`.
`TRACING_ENABLED`	If set to `Y` (the default), an application with Debug enabled can also generate server side db trace files using `&p_trace=YES` on the URL. If set to `N`, the request to create a trace file is ignored.
`USERNAME_VALIDATION`	The regular expression used to validate a username if the Builder authentication scheme is not APEX. Default is as follows: ˆ[[:alnum:]._%-]+@[[:alnum:].-]+\.[[:alpha:]]{2,4}$
`WALLET_PATH`	The path to the wallet on the file system, for example: file:/home/<username>/wallets
`WALLET_PWD`	The password associated with the wallet.
`WEBSHEET_SQL_ACCESS`	If set to `Y`, the default, SQL tags and SQL reports are possible in Websheet applications. If set to `N`, they are not possible.
`WORKSPACE_EMAIL_MAXIMUM`	Maximum number of emails allowed to be sent by using APEX_MAIL per workspace in a 24 hour period. Default is `1000`.
`WORKSPACE_MAX_OUTPUT_SIZE`	The maximum space allocated for script results. Default is `2000000`.
`WORKSPACE_PROVISION_DEMO_OBJECTS`	If set to `Y`, the default, demonstration applications and database objects are created in new workspaces. If set to `N`, they are not created in the current workspace.
`WORKSPACE_WEBSHEET_OBJECTS`	If set to `Y`, the default, Application Express Websheet database objects are created in new workspaces. If set to `N`, they are not created in the current workspace.
`PASSWORD_HISTORY_DAYS`	Defines the maximum number of days a developer or administrator account password may be used before the account expires. The default value is 45 days.
`PRINT_BIB_LICENSED`	Specify either standard support or advanced support. Advanced support requires an Oracle BI Publisher license. Valid values include: `STANDARD` `ADVANCED`
`PRINT_SVR_PROTOCOL`	Valid values include: `http` `https`
`PRINT_SVR_HOST`	Specifies the host address of the print server converting engine, for example, `localhost`. Enter the appropriate host address if the print server is installed at another location.
`PRINT_SVR_PORT`	Defines the port of the print server engine, for example `8888`. Value must be a positive integer.
`PRINT_SVR_SCRIPT`	Defines the script that is the print server engine, for example: /xmlpserver/convert
`REQUIRE_HTTPS`	Set to `Y` to allow authentication pages within the Application Express development and administration applications to be used only when the protocol is HTTPS. Select `N` to allow these application pages to be used when the protocol is either HTTP or HTTPS.