Auswahl  

Interessante APEX Parameter, die über die Kommandozeile gesetzt werden können 

Oracle
APEX
APEX 20.1:APEX 20.2:APEX 5.x
12.07.18 (MP)
12.01.21
APEX

Passende Schulungen zum Thema

Wenn Sie sich mal im Internal Workspace ausgetobt haben und dabei einige Parameter so verstellt worden sind, dass man sich nicht mehr anmelden kann, hilft Ihnen evtl. der folgende Tipp.

Auch lassen sich viele schöne APEX Einstellungen über ein kleines Skript schneller umsetzen, als die jeweilige Option wieder grafisch in einem der Untermenues zu finden.

Die Quelle alle internen Parameter ist die Tabelle wwv_platform_prefs;

SELECT    name||'='||value
FROM
    apex_200200.wwv_flow_platform_prefs
ORDER BY 1;
 
ACCOUNT_LIFETIME_DAYS = 365
ALLOW_DB_MONITOR = N
ALLOW_PUBLIC_FILE_UPLOAD = N
ALLOW_RAS = N
APEX_BUILDER_AUTHENTICATION = APEX
APEX_LISTENER_FOP_PATH = _/fop2pdf
APEX_PATCH_STATUS = APPLIED
APEX_REST_PATH_PREFIX = r
APEX_19_1_0_PATCH_29369869 = 2019-04-08_08-56-37
APEX_19_2_0_PATCH_30392181 = 2020-03-09_10-40-49
APP_EXPORT_TO_DB_ENABLED = Y
APPLICATION_ACTIVITY_LOGGING = U
APPLICATION_ID_MIN = 100
AUDIT_LOG_RETENTION = 90
AUTOAPPROVE_STORAGE_LIMIT = 0
AUTOEXTEND_TABLESPACES = Y
AUTO_SCHEMA_NAME = N
AUTO_WORKSPACE_NAME = N
BIGFILE_TABLESPACES_ENABLED = N
CHECK_FOR_UPDATES = Y
CLONE_SESSION_ENABLED = Y
CONTENT_CACHE_MAX_FILE_SIZE = 1048576
CONTENT_CACHE_SIZE_TARGET = 104857600
DEBUG_MESSAGE_PAGE_VIEW_LIMIT = 50000
DEFAULT_THEMES = 42,51
DELETE_UPLOADED_FILES_AFTER_DAYS = 14
DISABLE_ADMIN_LOGIN = N
DISABLE_WORKSPACE_LOGIN = N
DISABLE_WS_PROV = N
EMAIL_IMAGES_URL = https://172.30.30.8/i/
EMAIL_INSTANCE_URL = https://172.30.30.8/muso/
ENABLE_TRANSACTIONAL_SQL = N
ENCRYPTED_TABLESPACES_ENABLED = N
EXPIRE_FND_USER_ACCOUNTS = Y
GET_STARTED_URL = https://apex.oracle.com/go/get_started_apex
GETTING_STARTED_ENABLED = N
HPROF_DIRECTORY = -
HTTP_ERROR_STATUS_ON_ERROR_PAGE_ENABLED = N
IGNORED_FRIENDLY_URL_PARAMETERS = utm_campaign,utm_source,utm_medium,utm_term,utm_content,fbclid
INSTANCE_ID = 248274626595597
KEEP_SESSIONS_ON_UPGRADE = N
LOGIN_THROTTLE_DELAY = 5
LOGIN_THROTTLE_METHODS = USERNAME_IP
MAX_APPLICATION_BACKUPS = 25
MAX_LOGIN_FAILURES = 5
MAX_SCRIPT_SIZE = 500000
MAX_SESSION_IDLE_SEC = 7200
MAX_SESSION_LENGTH_SEC = 28800
MAX_WEBSERVICE_REQUESTS = 1000
MLE_LANGUAGES = JAVASCRIPT  -- Neu in 20.2
MOBILE_DEVELOPMENT_ENABLED = N
PASSWORD_ALPHA_CHARACTERS = abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ
PASSWORD_MIN_LENGTH = 0
PASSWORD_NEW_DIFFERS_BY = 0
PASSWORD_NOT_LIKE_USERNAME = N
PASSWORD_NOT_LIKE_WORDS = oracle:hello:welcome:guest:user:database
PASSWORD_NOT_LIKE_WS_NAME = N
PASSWORD_ONE_ALPHA = N
PASSWORD_ONE_LOWER_CASE = N
PASSWORD_ONE_NUMERIC = N
PASSWORD_ONE_PUNCTUATION = N
PASSWORD_ONE_UPPER_CASE = N
PASSWORD_PUNCTUATION_CHARACTERS = !"#$%&()``*+,-/:;<=>?_
PKG_APP_AUTH_ALLOW_HHEAD = N
PKG_APP_AUTH_ALLOW_LDAP = N
PKG_APP_AUTH_ALLOW_SSO = N
PKG_APP_ENABLED = Y
PLSQL_EDITING = Y
PRINT_BIB_LICENSED = APEX_LISTENER
PRINT_SVR_TIMEOUT = 300
REJOIN_EXISTING_SESSIONS = P
REQ_NEW_SCHEMA = N
REQUIRE_HTTPS = N
REQUIRE_OUT_HTTPS = N
REQUIRE_VERIFICATION_CODE = N
RESTFUL_SERVICES_ENABLED = Y
SELF_SERVICE_SCHEMA_PREFIX = WKSP_  -- Neu in 20.2
SERVICE_REQUEST_FLOW = MANUAL
SERVICE_REQUESTS_ENABLED = Y
SMTP_HOST_ADDRESS = 172.30.30.8
SMTP_HOST_PORT = 25
SMTP_TLS_MODE = N
SQL_SCRIPT_MAX_OUTPUT_SIZE = 200000
STATS_LAST_SENT = 20210104
STRONG_SITE_ADMIN_PASSWORD = N
SYSTEM_HELP_URL = https://apex.oracle.com/doc202
TOP_THEMES = 42,51
TRACING_ENABLED = Y
UPGRADE_DEFER_DAYS = 30
UPGRADE_DEFERRED = N
USERNAME_VALIDATION = *
WALLET_PATH = file:///opt/oracle/admin/o21c/https_wallet
WEBSERVICE_LOGGING = U
WEBSHEET_CREATE_ENABLED = N -- Neu in 20.2
WEBSHEET_SQL_ACCESS = N
WORKSPACE_EMAIL_MAXIMUM = 1000
WORKSPACE_ISSUE_FILES_YN = Y
WORKSPACE_ISSUE_FS_LIMIT = 15728640
WORKSPACE_MAX_OUTPUT_SIZE = 2000000
WORKSPACE_NAME_USER_COOKIE = Y
WORKSPACE_PROVISION_DEMO_OBJECTS = N
WORKSPACE_TEAM_DEV_FILES_YN = N
WORKSPACE_TEAM_DEV_FS_LIMIT = 15728640
WORKSPACE_WEBSERVICE_REQUEST_MAX = 1000
WORKSPACE_WEBSHEET_OBJECTS = N
WS_REQUEST_USAGE_Q = N

 

Wir wollen mal zwei interessante Parameter herausgreifen:
Der erste verhindert ein anmelden am INTERNAL Workspace:


EXEC apex_instance_admin.set_parameter('DISABLE_WORKSPACE_LOGIN','Y');
COMMIT;

 

Der zweite stellt die Idle Time auf 4800 Sekunden um:


EXEC apex_instance_admin.set_parameter('MAX_SESSION_IDLE_SEC','4800');

 

Mit folgenden Select können Sie für einen Parameter den aktuellen Inhalt hoch offiziell auslesen:


select APEX_INSTANCE_ADMIN.GET_PARAMETER('DISABLE_ADMIN_LOGIN') from dual;

Viel Spass beim Ausprobieren und ich hoffe wir sehen uns in einem unserer schönen APEX Kurse:-)

APEX interne Parameter

Weitere Interessante Kurs-Tipps zum Thema