APEX Instance Admin Preferences Cheat Sheet

APEX comes with an API - APEX_INSTANCE_ADMIN - where you can both get and set instance preferences. There is a list of available properties on the documentation, however I found that not all preferences were documented there. For example, in Feature Configuration, there are some preferences surrounding packaged applications:
















Looking at the documentation, https://docs.oracle.com/cd/E59726_01/doc.50/e39149/apex_instance.htm#CHDFEICJ, you may find it difficult locating these.

Then, there other properties in there that I don't think are relevant any more (..but not an expert on the subject, so may be wrong). Lets take the example of PASSWORD_HISTORY_DAYS - this states "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.". We can locate the property it's talking about under Security - Authentication Control - Development Environment Settings.





If we attempt to query this property name, you will find nothing is returned.

Connected to:

Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production



SQL> set serveroutput on

SQL> begin

  2    dbms_output.put_line('Value: ' || apex_instance_admin.get_parameter('PASSWORD_HISTORY_DAYS'));

  3  end;

  4  /

Value:



PL/SQL procedure successfully completed.



SQL>

Digging into this, it looks to me this relates to the parameter ACCOUNT_LIFETIME_DAYS.

So anyway, with all this said, here is what I've come up with a table mapping each field to a parameter name - some on the docs, others not.

Text Version:

 Feature Configuration

Application DevelopmentParameter Name
Allow PL/SQL Program Unit EditingPLSQL_EDITING
Create demonstration objects in new workspacesWORKSPACE_PROVISION_DEMO_OBJECTS
Create websheet objects in new workspacesWORKSPACE_WEBSHEET_OBJECTS
Enable SQL Access in WebsheetsWEBSHEET_SQL_ACCESS
Packaged Application install Options
Allow HTTP Header Variable authenticationPKG_APP_AUTH_ALLOW_HHEAD
Allow LDAP Directory authenticationPKG_APP_AUTH_ALLOW_LDAP
Allow Oracle Applicaion Server Single Sign-On authenticationPKG_APP_AUTH_ALLOW_SSO
SQL Workshop
SQL Commands Maximum Inactivity in minutesSQL_COMMAND_MAX_INACTIVITY
SQL Scripts Maximum Script Output Size in bytesSQL_SCRIPT_MAX_OUTPUT_SIZE
SQL Scripts Maximum Workspace Output Size in bytesWORKSPACE_MAX_OUTPUT_SIZE
SQL Script Maximum Script Size in bytesMAX_SCRIPT_SIZE
Enable transactional SQL CommandsENABLE_TRANSACTIONAL_SQL
Enable RESTful ServicesRESTFUL_SERVICES_ENABLED
Monitoring
Enable Database MonitoringALLOW_DB_MONITOR
Application Activity LoggingAPPLICATION_ACTIVITY_LOGGING
Enable Application TracingTRACING_ENABLED
Workspace Administration
Enable Service RequestsSERVICE_REQUESTS_ENABLED
Team Development
Enable Team Developer's File RepositoryWORKSPACE_TEAM_DEV_FILES_YN
Maximum File Size (in MB)WORKSPACE_TEAM_DEV_FS_LIMIT
Security

SecurityParameter Name
Set Workspace CookieWORKSPACE_NAME_USER_COOKIE
Disable Adminstrator LoginDISABLE_ADMIN_LOGIN
Disable Workspace loginDISABLE_WORKSPACE_LOGIN
Allow Public File UploadALLOW_PUBLIC_FILE_UPLOAD
Restrict Access by IP AddressRESTRICT_IP_RANGE
Instance ProxyINSTANCE_PROXY
Checksum Hash FunctionCHECKSUM_HASH_FUNCTION
Rejoin SessionsREJOIN_EXISTING_SESSIONS
Unhandled ErrorsHTTP_ERROR_STATUS_ON_ERROR_PAGE_ENABLED
HTTP Protocol
Require HTTPSREQUIRE_HTTPS
Require Outbound HTTPSREQUIRE_OUT_HTTPS
HTTP Response HeadersHTTP_RESPONSE_HEADERS
RESTful Access
Allow RESTful AccessALLOW_REST
Session Timeout
Maximum Session Length in SecondsMAX_SESSION_LENGTH_SEC
Maximum Session Idle Time in SecondsMAX_SESSION_IDLE_SEC
Workspace Isolation
Allow HostnamesALLOW_HOSTNAMES
Resource Consumer GroupRM_CONSUMER_GROUP
Maximum Concurrent Workspace RequestsQOS_MAX_WORKSPACE_REQUESTS
Maximum Concurrent Session RequestsQOS_MAX_SESSION_REQUESTS
Concurrent Session Requests Kill TimeoutQOS_MAX_SESSION_KILL_TIMEOUT
Maximum Size of FIles in WorkspaceWORKSPACE_MAX_FILE_BYTES
Region and Web Service Excluded Domains
Domain Must Not ContainBAD_URLS
Authentication Control
General Settings
Delay after failed login attempts in SecondsLOGIN_THROTTLE_DELAY
Method for computing the DelayLOGIN_THROTTLE_METHODS
Inbound Proxy ServersINBOUND_PROXIES
Single Sign-On Logout URLSSO_LOGOUT_URL
Development Environment Settings
Username validation expressionUSERNAME_VALIDATION
Require User Account Expiration and LockingEXPIRE_FND_USER_ACCOUNTS
Maximum Login Failures AllowedMAX_LOGIN_FAILURES
Account Password Lifetime (days)ACCOUNT_LIFETIME_DAYS
Current Workspace Authentication SchemAPEX_BUILDER_AUTHENTICATION
Password Policy
Password Hash FunctionPASSWORD_HASH_FUNCTION
Minimum Password LengthPASSWORD_MIN_LENGTH
Minimum Password DifferencesPASSWORD_NEW_DIFFERS_BY
Must Contain At Least One Alphabetic CharacterPASSWORD_ONE_ALPHA
Must Contain At Least One Numeric CharacterPASSWORD_ONE_NUMERIC
Must COntain At Least One Punctuation CharacterPASSWORD_ONE_PUNCTUATION
Must Contain At Least One Upper Case CHaracterPASSWORD_ONE_UPPER_CASE
Must Contain At Least One Lower Case CharacterPASSWORD_ONE_LOWER_CASE
Must Not Contain UsernamePASSWORD_NOT_LIKE_USERNAME
Must Not Contain Workspace NamePASSWORD_NOT_LIKE_WS_NAME
Must Not ContainPASSWORD_NOT_LIKE_WORDS
Alphabetic CharactersPASSWORD_ALPHA_CHARACTERS
Punctuation CharactersPASSWORD_PUNCTUATION_CHARACTERS
Service Administrator Poassword PolicySTRONG_SITE_ADMIN_PASSWORD

Instance Settings

Self ServiceParameter Name
Provisioning StatusSERVICE_REQUEST_FLOW
Require Verification CodeREQUIRE_VERIFICATION_CODE
Notification Email AddressNOTIFICATION_EMAIL
Email Provisioning
Email ProvisioningDISABLE_WS_PROV
MessageDISABLE_WS_MSG
Storage
Require New SchemaREQ_NEW_SCHEMA
Auto Extent TablespacesAUTOEXTEND_TABLESPACES
Bigfile TablespacesBIGFILE_TABLESPACES_ENABLED
Encrypted TablespacesENCRYPTED_TABLESPACES_ENABLED
Delete Uploaded Files After (days)DELETE_UPLOADED_FILES_AFTER_DAYS
Email
Application Express Instance URLEMAIL_INSTANCE_URL
Application Express Images URLEMAIL_IMAGES_URL
SMTP Host AddressSMTP_HOST_ADDRESS
SMTP Host PortSMTP_HOST_PORT
SMTP Authentication usernameSMTP_USERNAME
SMTP Authentication passwordSMTP_PASSWORD
Use SSL/TLSSMTP_TLS_MODE
Default Email From AddressSMTP_FROM
Maximum Emails per WorkspaceWORKSPACE_EMAIL_MAXIMUM
Wallet
Wallet PathWALLET_PATH
Wallet PasswordWALLET_PWD
Report Printing
Print ServerPRINT_BIB_LICENSED
Printer Server ProtocolPRINT_SVR_PROTOCOL
Print Server Host AddressPRINT_SVR_HOST
Print Server PortPRINT_SVR_PORT
Print Server ScriptPRINT_SVR_SCRIPT
Print TimeoutPRINT_SVR_TIMEOUT
Help
Help URLSYSTEM_HELP_URL
Application ID Range
ID MinimumAPPLICATION_ID_MIN
ID MaximumAPPLICATION_ID_MAX

Workspace Purge Settings:

Workspace Purge SettingsParameter Name
EnabledPURGE_ENABLED
LanguagePURGE_LANG
Purge Adminsitration Email AddressPURGE_ADMIN_EMAIL
Send Summary Email toPURGE_SUMMARY_EMAIL_TO
Days until purgePURGE_DAYS_TO_PURGE
Reminder days in advancePURGE_REMINDER_DAYS_IN_ADVANCE
Days inactivePURGE_DAYS_INACTIVE
Grace period (days)PURGE_GRACE_PERIOD_DAYS
Maximum execution time (hours)PURGE_MAX_RUN_HOURS
Maximum number of workspacesPURGE_MAX_WORKSPACES
Maximum number of emailsPURGE_MAX_EMAILS

Image:

Feature Configuration:


Security:




Instance Settings:













































































Workspace purge settings:







Popular posts from this blog

APEX 5 Give me Interactive Reports

Image
One of the statements of direction for APEX 5 is multiple interactive reports on a single page. Multiple Interactive Reports – Allow any number of Interactive Reports to be defined on a single page. So, time to explore that functionality. One pattern I've used in the past is loading particular saved reports (rather than the default primary report). You may have some pre-defined filters, a row highlight, specific columns. So for demonstrations, I've built an IR on the emp table. Then I go and apply some filters, and save an alternate report: Then in the page designer assign an alias to that report. As you can see, that allows me to enter in the request portion of the URL: IR_SAL_TOTAL. However, if we add a second IR to the page and try to access that saved report, we would receive an error "Report does not exist". This is because it tries to find that that report name in both IR's. To get around this, you MUST  set a static ID property fo...
Read more

OCI: Enabling X11 Forwarding on an Oracle Linux instance

Image
I was connecting to one of my works servers the other day hoping to copy the contents of a file into my clipboard, which would require the use of an X11 forwarded session, but as I connected to the server with X11 forwarding enabled, I was sad to see the following message: X11 forwarding request failed on channel 0 This is on Oracle Linux. Note, if I connect to an Ubuntu instance, I get the message: /usr/bin/xauth:  file /home/ubuntu/.Xauthority does not exist But this file is created, and X forwarding works from the get-go. OK, back to Oracle Linux - how do we fix this? Actually, the fix is a simple one. SSH is already configured to enable X11Forwarding. The other change you need make is to turn off the setting X11UseLocalhost. So part of your configuration would likely look like this: X11Forwarding yes #X11DisplayOffset 10 X11UseLocalhost no After that, you will want to reload the SSH daemon. Do this by running the command: sudo systemctl reload sshd Fina...
Read more

Installing Oracle Instant Client on Ubuntu

Now that Oracle has enabled us to download instant client without any click through for accepting the license , I wanted to revisit a seamless install of the instant client on a new set up. Ubuntu has the documentation about installing the instant client here: https://help.ubuntu.com/community/Oracle%20Instant%20Client. First - because Oracle provides their releases in RPM archive format (or a tarball), in order to have an installer you need to create a DEB archive. There is a package in the archives, alien, which aids this process. This gives the start of the script: #!/bin/bash # Install dependencies sudo apt install alien The 3 packages the Ubuntu documentation tells us to retrieve are: - devel - basic (I opt for basiclite instead) - sqlplus So, over at the downloads page: https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html we can grab the link. # Download files. Example specific to 19.3 # Some links were not correct on the do...
Read more