123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294
[root@zza-server: /u01/apex/utilities]# sqlplus /nolog
SQL*Plus: Release 11.2.0.2.0 Production on Sun May 27 19:00:36 2018
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> connect sys as sysdba
Enter password:
Connected.
SQL> @report_instance_configuration.sql
================================================================================
Oracle Application Express Instance Configuration 2018-05-27 19:00
================================================================================
Database Information
====================
Parameter Value
-------------------- -----------------------------------------------------------
Server Host zza-server
Database Name XE
Instance Name XE
Version Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
AQ TM Processes 0
Dispatchers (PROTOCOL=TCP) (SERVICE=XEXDB)
Job Queue Processes 100
Shared Servers 4
DB Character Set AL32UTF8
Server Time Zone +06:00
XDB HTTP Port 0
XDB HTTPS Port
XDB Anonymous Access false
Registry Information
====================
Instance Schema Version Status
--------------------- ----------- --------
APEX_180100 18.1.0.00.4 VALID
5
All Application Express Schemas
===============================
Schema Account Status Type Info
------------------------ ---------------- --------------------------- ---------------
FLOWS_FILES EXPIRED & LOCKED APEX File Repository
APEX_180100 EXPIRED & LOCKED APEX Instance (Development) Current - en
APEX_INSTANCE_ADMIN_USER EXPIRED APEX Instance Admin User
ANONYMOUS LOCKED APEX Run User (EPG)
APEX_PUBLIC_USER OPEN APEX Run User (ORDS, OHS)
APEX_LISTENER OPEN ORDS REST Admin User
APEX_REST_PUBLIC_USER OPEN ORDS REST Run User
ORDS_PUBLIC_USER OPEN ORDS REST Run User
ORDS_METADATA EXPIRED & LOCKED ORDS Repository User
Objects in APEX_180100
======================
Status Type Count Last DDL
---------- ------------------------------ ------ ----------
VALID FUNCTION 8 2018-05-26
VALID INDEX 1450 2018-05-26
VALID JOB 4 2018-05-27
VALID LOB 217 2018-05-26
VALID PACKAGE 322 2018-05-26
VALID PACKAGE BODY 316 2018-05-26
VALID PROCEDURE 13 2018-05-26
VALID SEQUENCE 5 2018-05-26
VALID SYNONYM 3 2018-05-26
VALID TABLE 470 2018-05-27
VALID TRIGGER 538 2018-05-26
VALID TYPE 20 2018-05-26
VALID TYPE BODY 5 2018-05-26
VALID VIEW 310 2018-05-27
Constraints in APEX_180100
==========================
Owner Type Status Count
----------- ---- ---------- ------
APEX_180100 C ENABLED 2789
APEX_180100 P ENABLED 452
APEX_180100 R ENABLED 744
APEX_180100 U ENABLED 111
APEX_180100 V ENABLED 1
FLOWS_FILES C ENABLED 3
FLOWS_FILES P ENABLED 1
FLOWS_FILES R ENABLED 1
FLOWS_FILES U ENABLED 1
Constraints in other schemas referencing APEX
=============================================
Versioned APIs
==============
Owner Object Name Version Identifier
----------- ------------------------------ -------------------------------------
APEX_180100 WWV_FLOW_API 75110 2018-05-08 16:39:56
APEX_180100 WWV_FLOW_INTERACTIVE_GRID 74501 2018-04-05 19:21:37
APEX_180100 WWV_FLOW_IR_RENDER
SYS WWV_FLOW_VAL 74620 2018-04-11 14:44:45
Single Sign-On (OSSO)
=====================
- WWV_FLOW_CUSTOM_AUTH_SSO is not installed
- Synonym WWSEC_ENABLER_CONFIG_INFO$ does not exist
- Synonym WWSEC_SSO_ENABLER_PRIVATE does not exist
- SELECT on WWSEC_ENABLER_CONFIG_INFO$ has NOT been granted
- EXECUTE on WWSEC_SSO_ENABLER_PRIVATE has NOT been granted
Network ACLs for APEX_180100
============================
Authorized URLs
===============
Workspace Schema Restrictions And Exceptions
============================================
Restricted Schema Exception for Workspace
------------------------------ -------------------------------------------------
ANONYMOUS
APEX_180100
APEX_INSTANCE_ADMIN_USER
APEX_LISTENER
APEX_PUBLIC_USER
APEX_REST_PUBLIC_USER
APPQOSSYS
AUDSYS
AURORA$JIS$UTILITY$
AURORA$ORB$UNAUTHENTICATED
AVSYS
CTXSYS
DBSFWUSER
DBSNMP
DIP
DMSYS
DVF
DVSYS
EXFSYS
FLOWS_FILES
GGSYS
GSMADMIN_INTERNAL
GSMCATUSER
GSMUSER
HTMLDB_PUBLIC_USER
LBACSYS
MDDATA
MDSYS
MGMT_VIEW
ODM
ODM_MTR
OE
OJVMSYS
OLAPSYS
ORACLE_OCM
ORDDATA
ORDPLUGINS
ORDSYS
ORDS_METADATA
ORDS_PUBLIC_USER
OSE$HTTP$ADMIN
OUTLN
PERFSTAT
PM
QS
QS_ADM
QS_CB
Restricted Schema Exception for Workspace
------------------------------ -------------------------------------------------
QS_CBADM
QS_CS
QS_ES
QS_OS
QS_WS
REMOTE_SCHEDULER_AGENT
RMAN
SCOTT
SH
SI_INFORMTN_SCHEMA
SPATIAL_CSW_ADMIN_USR
SPATIAL_WFS_ADMIN_USR
SYS
SYS$UMF
SYSBACKUP
SYSDG
SYSKM
SYSMAN
SYSRAC
SYSTEM
TSMSYS
WKPROXY
WKSYS
WK_TEST
WMSYS
XDB
XS$NULL
Instance Parameters
===================
Name Value Updated On
--------------------------------------- ---------------------------------------- ----------
ALLOW_DB_MONITOR N 2018-05-26
ALLOW_PUBLIC_FILE_UPLOAD N 2018-05-26
ALLOW_RAS N 2018-05-26
APEX_BUILDER_AUTHENTICATION APEX 2018-05-26
APEX_LISTENER_FOP_PATH _/fop2pdf 2018-05-26
APEX_PATCH_STATUS APPLIED 2018-05-26
APEX_REST_PATH_PREFIX r 2018-05-26
APPLICATION_ACTIVITY_LOGGING U 2018-05-26
APP_EXPORT_TO_DB_ENABLED Y 2018-05-26
AUDIT_LOG_RETENTION 90 2018-05-26
AUTOEXTEND_TABLESPACES Y 2018-05-26
AUTO_SCHEMA_NAME N 2018-05-26
AUTO_WORKSPACE_NAME N 2018-05-26
BIGFILE_TABLESPACES_ENABLED N 2018-05-26
CHECK_FOR_UPDATES Y 2018-05-26
CLONE_SESSION_ENABLED Y 2018-05-26
CONTENT_CACHE_MAX_FILE_SIZE 1048576 2018-05-26
CONTENT_CACHE_SIZE_TARGET 104857600 2018-05-26
DEBUG_MESSAGE_PAGE_VIEW_LIMIT 50000 2018-05-26
DEFAULT_THEMES 42,51 2018-05-26
DELETE_UPLOADED_FILES_AFTER_DAYS 14 2018-05-26
DISABLE_ADMIN_LOGIN N 2018-05-26
DISABLE_WORKSPACE_LOGIN N 2018-05-26
DISABLE_WS_PROV N 2018-05-26
ENABLE_TRANSACTIONAL_SQL N 2018-05-26
ENCRYPTED_TABLESPACES_ENABLED N 2018-05-26
EXPIRE_FND_USER_ACCOUNTS Y 2018-05-26
HPROF_DIRECTORY - 2018-05-26
INSTANCE_ID 227369841019675 2018-05-26
KEEP_SESSIONS_ON_UPGRADE N 2018-05-26
LOGIN_THROTTLE_DELAY 5 2018-05-26
LOGIN_THROTTLE_METHODS USERNAME_IP 2018-05-26
MAX_SCRIPT_SIZE 500000 2018-05-26
MAX_SESSION_IDLE_SEC 3600 2018-05-26
MAX_SESSION_LENGTH_SEC 28800 2018-05-26
MAX_WEBSERVICE_REQUESTS 1000 2018-05-26
MOBILE_DEVELOPMENT_ENABLED N 2018-05-26
PASSWORD_ALPHA_CHARACTERS abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMN 2018-05-26
OPQRSTUVWXYZ
PASSWORD_PUNCTUATION_CHARACTERS !"#$%&()``*+,-/:;<=>?_ 2018-05-26
PKG_APP_AUTH_ALLOW_HHEAD N 2018-05-26
PKG_APP_AUTH_ALLOW_LDAP N 2018-05-26
PKG_APP_AUTH_ALLOW_SSO N 2018-05-26
PKG_APP_ENABLED Y 2018-05-26
PLSQL_EDITING Y 2018-05-26
PRINT_BIB_LICENSED APEX_LISTENER 2018-05-26
Name Value Updated On
--------------------------------------- ---------------------------------------- ----------
REJOIN_EXISTING_SESSIONS P 2018-05-26
REQUIRE_HTTPS N 2018-05-26
REQUIRE_VERIFICATION_CODE N 2018-05-26
REQ_NEW_SCHEMA N 2018-05-26
RESTFUL_SERVICES_ENABLED Y 2018-05-26
SERVICE_REQUESTS_ENABLED Y 2018-05-26
SERVICE_REQUEST_FLOW MANUAL 2018-05-26
SMTP_HOST_ADDRESS localhost 2018-05-26
SMTP_HOST_PORT 25 2018-05-26
SMTP_TLS_MODE N 2018-05-26
SQL_SCRIPT_MAX_OUTPUT_SIZE 200000 2018-05-26
STRONG_SITE_ADMIN_PASSWORD Y 2018-05-26
SYSTEM_HELP_URL http://apex.oracle.com/doc181 2018-05-26
TOP_THEMES 42,51 2018-05-26
TRACING_ENABLED Y 2018-05-26
USERNAME_VALIDATION * 2018-05-26
WEBSERVICE_LOGGING U 2018-05-26
WEBSHEET_SQL_ACCESS N 2018-05-26
WORKSPACE_EMAIL_MAXIMUM 1000 2018-05-26
WORKSPACE_MAX_OUTPUT_SIZE 2000000 2018-05-26
WORKSPACE_PROVISION_DEMO_OBJECTS N 2018-05-26
WORKSPACE_TEAM_DEV_FILES_YN N 2018-05-26
WORKSPACE_TEAM_DEV_FS_LIMIT 15728640 2018-05-26
WORKSPACE_WEBSERVICE_REQUEST_MAX 1000 2018-05-26
WORKSPACE_WEBSHEET_OBJECTS N 2018-05-26
Instance Administrators
=======================
User Name Email Address Last Login Locked?
------------------------------ ---------------------------------------- ---------- -------
ADMIN savenko.denis@blabla.com No
================================================================================