Microsoft Windows [Version 10.0.22631.3155] (c) Microsoft Corporation. All rights reserved. C:\Windows\System32>cd C:\app\product\ords C:\app\product\ords>ords --config C:\app\product\ords\config install ORDS: Release 23.4 Production on Thu Feb 22 16:14:06 2024 Copyright (c) 2010, 2024, Oracle. Configuration: /C:/app/product/ords/config The configuration folder C:\app\product\ords\config does not contain any configuration files. Oracle REST Data Services - Interactive Install Enter a number to select the type of installation [1] Install or upgrade ORDS in the database only [2] Create or update a database pool and install/upgrade ORDS in the database [3] Create or update a database pool only Choose [2]: Created folder C:\app\product\ords\config Enter a number to select the database connection type to use [1] Basic (host name, port, service name) [2] TNS (TNS alias, TNS directory) [3] Custom database URL Choose [1]: 2 Enter the TNS location: C:\app\product\21c\dbhomexe\network\admin Enter a number to select the TNS Network alias to use [1] LISTENER_XE (ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)) [2] ORACLR_CONNECTION_DATA (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=EX... [3] PARISHSERVER1 ...SERVICE_NAME=xepdb1))) [4] XE ...SERVICE_NAME=XE))) [5] XEPDB1 ...SERVICE_NAME=XEPDB1))) Choose [1]: 3 Provide database user name with administrator privileges. Enter the administrator username: sys Enter the database password for SYS AS SYSDBA: Connecting to database user: SYS AS SYSDBA url: jdbc:oracle:thin:@PARISHSERVER1?TNS_ADMIN=C:\\app\\product\\21c\\dbhomexe\\network\\admin Retrieving information. Enter the default tablespace for ORDS_METADATA and ORDS_PUBLIC_USER [SYSAUX]: Enter the temporary tablespace for ORDS_METADATA and ORDS_PUBLIC_USER [TEMP]: Enter a number to select additional feature(s) to enable: [1] Database Actions (Enables all features) [2] REST Enabled SQL and Database API [3] REST Enabled SQL [4] Database API [5] None Choose [1]: Enter a number to configure and start ORDS in standalone mode [1] Configure and start ORDS in standalone mode [2] Skip Choose [1]: Enter a number to select the protocol [1] HTTP [2] HTTPS Choose [1]: 2 Enter the HTTPS port [8443]: 9090 Enter a number to select the certificate type [1] Use self-signed certificate (generates automatically) [2] Use my SSL certificate (requires SSL certificate and SSL certificate private key) Choose [1]: 2 Enter the path for the SSL Certificate: C:\app\product\ords\fullchain.pem Enter the path for the SSL Certificates private key: C:\app\product\ords\privkey.der Enter the APEX static resources location: C:\app\product\apex\images The setting named: db.connectionType was set to: tns in configuration: default The setting named: db.tnsAliasName was set to: PARISHSERVER1 in configuration: default The setting named: db.tnsDirectory was set to: C:\app\product\21c\dbhomexe\network\admin in configuration: default The setting named: plsql.gateway.mode was set to: proxied in configuration: default The setting named: db.username was set to: ORDS_PUBLIC_USER in configuration: default The setting named: db.password was set to: ****** in configuration: default The setting named: feature.sdw was set to: true in configuration: default The global setting named: database.api.enabled was set to: true The setting named: restEnabledSql.active was set to: true in configuration: default The setting named: security.requestValidationFunction was set to: ords_util.authorize_plsql_gateway in configuration: default The global setting named: standalone.https.port was set to: 9090 The global setting named: standalone.https.cert was set to: /C:/app/product/ords/fullchain.pem The global setting named: standalone.https.cert.key was set to: /C:/app/product/ords/privkey.der The global setting named: standalone.static.path was set to: /C:/app/product/apex/images/ The global setting named: standalone.static.context.path was set to: /i The global setting named: standalone.context.path was set to: /ords The global setting named: standalone.doc.root was set to: C:\app\product\ords\config\global\doc_root 2024-02-22T16:16:14.815Z INFO Cannot create or write to the log folder in the current working directory: /C:/app/product/ords/logs. Logging will be displayed on the console. 2024-02-22T16:16:14.864Z INFO Installing Oracle REST Data Services version 23.4.0.r3461619 in XEPDB1 ------------------------------------------------------------ Date : 22 Feb 2024 16:16:14 Release : Oracle REST Data Services 23.4.0.r3461619 Type : ORDS Install Database : Oracle Database 21c Express Edition DB Version : 21.3.0.0.0 ------------------------------------------------------------ Container Name: XEPDB1 Executing scripts for core ------------------------------------------------------------ [*** script: ords_prereq_env.sql] INFO: Checking prerequisites for Oracle REST Data Services PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. INFO: Prerequisites verified. 2024-02-22T16:16:15.762Z INFO ... Verified database prerequisites [*** script: ords_verify_tablespace.sql] PL/SQL procedure successfully completed. [*** script: ords_alter_session_script.sql] PL/SQL procedure successfully completed. [*** script: ords_create_rest_users.sql] PL/SQL procedure successfully completed. 2024-02-22T16:16:16.171Z INFO ... Created Oracle REST Data Services proxy user [*** script: ords_alter_session_script.sql] PL/SQL procedure successfully completed. [*** script: ords_create_schema.sql] INFO: Creating schema for Oracle REST Data Services PL/SQL procedure successfully completed. INFO: Created schema ORDS_METADATA 2024-02-22T16:16:16.625Z INFO ... Created Oracle REST Data Services schema [*** script: ords_grant_privs.sql] INFO: Grant object and system privileges to ORDS owner GRANT EXECUTE ON SYS.DBMS_NETWORK_ACL_ADMIN TO "ORDS_METADATA" GRANT READ ON SYS.DBA_OBJECTS TO "ORDS_METADATA" GRANT READ ON SYS.DBA_ROLE_PRIVS TO "ORDS_METADATA" GRANT READ ON SYS.DBA_TAB_COLUMNS TO "ORDS_METADATA" GRANT READ ON SYS.DBA_USERS TO "ORDS_METADATA" GRANT READ ON SYS.DBA_NETWORK_ACL_PRIVILEGES TO "ORDS_METADATA" GRANT READ ON SYS.DBA_NETWORK_ACLS TO "ORDS_METADATA" GRANT READ ON SYS.DBA_REGISTRY TO "ORDS_METADATA" PL/SQL procedure successfully completed. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. INFO: Completed granting object and system privileges 2024-02-22T16:16:17.083Z INFO ... Granted privileges to Oracle REST Data Services [*** script: ords_alter_session_metadata.sql] Session altered. [*** script: ords_validate.sql] Procedure VALIDATE_ORDS compiled No errors. [*** script: ords_database_objects.sql] Table CFG_PLSQL_GATEWAYS created. Comment created. Comment created. Comment created. INDEX CFG_PLSQL_GATEWAYS_IDX1 created. INDEX CFG_PLSQL_GATEWAYS_IDX2 created. Table CFG_PLSQL_GATEWAYS altered. Table OAUTH_APPROVAL_PRIVS created. INDEX OAUTH_APP_PRIVS_UNIQUE1 created. Index OAUTH_APP_PRIVS_IDX1 created. Index OAUTH_APP_PRIVS_IDX2 created. Table OAUTH_APPROVAL_PRIVS altered. Table OAUTH_APPROVALS created. Table OAUTH_APPROVALS altered. Comment created. Comment created. Comment created. INDEX OAUTH_APPROVALS_UNIQUE1 created. Index OAUTH_APPROVALS_IDX1 created. Index OAUTH_APPROVALS_IDX2 created. Index OAUTH_APPROVALS_IDX3 created. Table OAUTH_APPROVALS altered. Table OAUTH_CLIENT_PRIVILEGES created. INDEX OAUTH_CLIENT_PRIVS_UNIQ1 created. Index OAUTH_CLIENT_PRIVS_IDX1 created. Index OAUTH_CLIENT_PRIVS_IDX2 created. Table OAUTH_CLIENT_PRIVILEGES altered. Table OAUTH_CLIENT_ROLES created. Table OAUTH_CLIENT_ROLES altered. Table OAUTH_CLIENTS created. Comment created. Comment created. Comment created. Comment created. Comment created. Comment created. Comment created. Comment created. Comment created. Comment created. INDEX OAUTH_CLIENTS_UNIQUE1 created. INDEX OAUTH_CLIENTS_UNIQUE2 created. Index OAUTH_CLIENTS_IDX1 created. Table OAUTH_CLIENTS altered. Table OAUTH_CLIENTS altered. Table OAUTH_CLIENTS altered. Table OAUTH_JWT_PROFILE created. Comment created. Comment created. Comment created. Comment created. Comment created. Comment created. Table OAUTH_JWT_PROFILE altered. Table OAUTH_JWT_PROFILE altered. Table OAUTH_JWT_PROFILE altered. Table OAUTH_JWT_PROFILE altered. Table OAUTH_PENDING_APPROVALS created. Comment created. Comment created. Index OAUTH_PEND_APPRV_IDX1 created. Index OAUTH_PEND_APPRV_IDX2 created. Index OAUTH_PEND_APPRV_IDX3 created. Table OAUTH_PENDING_APPROVALS altered. Table OAUTH_PENDING_APPROVALS altered. Table OAUTH_SESSIONS created. Comment created. INDEX OAUTH_USER_SESS_IDX1 created. Index OAUTH_USER_SESS_IDX4 created. Table OAUTH_SESSIONS altered. Table ORDS_HANDLERS created. Table ORDS_HANDLERS altered. Comment created. Comment created. Comment created. Comment created. Comment created. INDEX ORDS_HANDLERS_UNIQUE1 created. Index ORDS_HANDLERS_IDX2 created. Index ORDS_HANDLERS_IDX3 created. Table ORDS_HANDLERS altered. Table ORDS_MODULES created. Table ORDS_MODULES altered. Comment created. Comment created. Comment created. Comment created. INDEX ORDS_MODULES_UNIQUE1 created. Table ORDS_MODULES altered. Table ORDS_MODULES altered. Table ORDS_MODULES altered. Table ORDS_OBJECTS created. Table ORDS_OBJECTS altered. Table ORDS_OBJECTS altered. Table ORDS_OBJECTS altered. Table ORDS_OBJECTS altered. Comment created. Comment created. Comment created. Comment created. Comment created. Comment created. Comment created. Comment created. Comment created. INDEX ORDS_OBJECTS_PK created. INDEX ORDS_OBJECTS_ALIAS_UN created. Index ORDS_OBJECTS_UOS_IDX created. Table ORDS_OBJECTS altered. Table ORDS_PARAMETERS created. Table ORDS_PARAMETERS altered. Table ORDS_PARAMETERS altered. Table ORDS_PARAMETERS altered. Comment created. Comment created. Comment created. Comment created. Comment created. INDEX ORDS_PARAMS_UNIQUE1 created. INDEX ORDS_PARAMS_UNIQUE2 created. Index ORDS_PARAMS_IDX1 created. Index ORDS_PARAMS_IDX2 created. Table ORDS_PARAMETERS altered. Table ORDS_PARAMETERS altered. Table ORDS_PARAMETERS altered. Table ORDS_PARAMETERS altered. Table ORDS_PARAMETERS altered. Table ORDS_PROP_FACTS created. Comment created. Comment created. Comment created. Comment created. Comment created. INDEX ORDS_PROP_FACTS_UNQ created. Index ORDS_PROP_FACTS_IDX created. Index ORDS_PROP_FACTS_IDX2 created. Table ORDS_PROP_FACTS altered. Table ORDS_PROP_FACTS altered. Table ORDS_PROP_FACTS altered. Table ORDS_PROP_VALUES created. Comment created. Comment created. Comment created. Index ORDS_PROP_VALUES_IDX created. Index ORDS_PROP_VALUES_IDX2 created. Table ORDS_PROP_VALUES altered. Table ORDS_SCHEMA_REQUESTS created. Index ORDS_SCHEMA_REQUESTS_IDX1 created. Index ORDS_SCHEMA_REQUESTS_IDX2 created. Index ORDS_SCHEMA_REQUESTS_IDX3 created. Table ORDS_SCHEMA_REQUESTS altered. Table ORDS_SCHEMA_REQUESTS altered. Table ORDS_SCHEMA_REQUESTS_ROLES created. Index ORDS_SCHEMA_REQUESTS_ROLES_IDX created. Table ORDS_SCHEMA_REQUESTS_ROLES altered. Table ORDS_SCHEMA_VERSION created. Comment created. Comment created. Comment created. Table ORDS_SCHEMA_VERSION altered. Table ORDS_SCHEMAS created. Table ORDS_SCHEMAS altered. Table ORDS_SCHEMAS altered. Comment created. Comment created. Comment created. Comment created. Comment created. INDEX ORDS_SCHEMAS_PARSING created. Table ORDS_SCHEMAS altered. Table ORDS_TEMPLATES created. Table ORDS_TEMPLATES altered. Comment created. Comment created. Comment created. Comment created. Comment created. Comment created. INDEX ORDS_TEMPLATES_UNIQUE1 created. Index ORDS_TEMPLATES_IDX1 created. Index ORDS_TEMPLATES_IDX2 created. Table ORDS_TEMPLATES altered. Table ORDS_TEMPLATES altered. Table ORDS_TEMPLATES altered. Table ORDS_TEMPLATES altered. Table ORDS_URL_MAPPINGS created. Table ORDS_URL_MAPPINGS altered. Table ORDS_URL_MAPPINGS altered. Table ORDS_URL_MAPPINGS altered. Table ORDS_WORKSPACE_SCHEMAS created. Table ORDS_WORKSPACE_SCHEMAS altered. Table ORDS_WORKSPACE_SCHEMAS altered. Table SEC_AUTHENTICATORS created. Table SEC_AUTHENTICATORS altered. Comment created. Comment created. Comment created. Comment created. Comment created. INDEX SEC_AUTHS_UNQ_NAME created. INDEX SEC_AUTHS_UNQ_PROVIDER created. Table SEC_AUTHENTICATORS altered. Table SEC_KEYS created. Table SEC_KEYS altered. Table SEC_OBJECT_ALLOW_LIST created. Comment created. Comment created. Comment created. Comment created. Comment created. Comment created. INDEX SEC_OBJECT_ALLOW_LIST_UNIQUE1 created. Table SEC_OBJECT_ALLOW_LIST altered. Table SEC_OBJECT_ALLOW_LIST altered. Table SEC_ORIGINS_ALLOWED_MODULES created. Table SEC_ORIGINS_ALLOWED_MODULES altered. Table SEC_ORIGINS_ALLOWED_MODULES altered. Table SEC_PRIVILEGE_AUTHS created. INDEX PRIVILEGE_AUTHS_UNIQUE1 created. Table SEC_PRIVILEGE_AUTHS altered. Table SEC_PRIVILEGE_MAPPINGS created. Table SEC_PRIVILEGE_MAPPINGS altered. Table SEC_PRIVILEGE_MAPPINGS altered. Table SEC_PRIVILEGE_MODULES created. Table SEC_PRIVILEGE_MODULES altered. Table SEC_PRIVILEGE_MODULES altered. Table SEC_PRIVILEGE_ROLES created. INDEX PRIVILEGE_ROLES_UNIQUE1 created. Table SEC_PRIVILEGE_ROLES altered. Table SEC_PRIVILEGES created. Comment created. Comment created. Comment created. Comment created. Comment created. INDEX PRIVILEGES_UNQ_NAME created. Table SEC_PRIVILEGES altered. Table SEC_ROLE_MAPPINGS created. INDEX ROLE_MAPPINGS_UNQ_PATTERN created. Table SEC_ROLE_MAPPINGS altered. Table SEC_ROLES created. INDEX ROLES_UNQ_NAME created. Table SEC_ROLES altered. Table SEC_SESSIONS created. Table SEC_SESSIONS altered. Table SEC_SESSIONS altered. Table SEC_SESSIONS altered. Table SEC_AUTHENTICATORS altered. Table OAUTH_APPROVAL_PRIVS altered. Table OAUTH_APPROVAL_PRIVS altered. Table OAUTH_APPROVAL_PRIVS altered. Table OAUTH_APPROVALS altered. Table OAUTH_APPROVALS altered. Table OAUTH_CLIENT_PRIVILEGES altered. Table OAUTH_CLIENT_PRIVILEGES altered. Table OAUTH_CLIENT_PRIVILEGES altered. Table OAUTH_CLIENT_ROLES altered. Table OAUTH_CLIENT_ROLES altered. Table OAUTH_CLIENT_ROLES altered. Table OAUTH_CLIENTS altered. Table OAUTH_JWT_PROFILE altered. Table OAUTH_PENDING_APPROVALS altered. Table OAUTH_PENDING_APPROVALS altered. Table OAUTH_SESSIONS altered. Table OAUTH_SESSIONS altered. Table OAUTH_SESSIONS altered. Table ORDS_HANDLERS altered. Table ORDS_HANDLERS altered. Table ORDS_MODULES altered. Table ORDS_OBJECTS altered. Table ORDS_PARAMETERS altered. Table ORDS_PARAMETERS altered. Table ORDS_PROP_VALUES altered. Table ORDS_PROP_VALUES altered. Table ORDS_SCHEMA_REQUESTS_ROLES altered. Table ORDS_SCHEMAS altered. Table ORDS_TEMPLATES altered. Table ORDS_TEMPLATES altered. Table ORDS_WORKSPACE_SCHEMAS altered. Table SEC_PRIVILEGE_AUTHS altered. Table SEC_PRIVILEGE_AUTHS altered. Table SEC_PRIVILEGE_AUTHS altered. Table SEC_PRIVILEGE_ROLES altered. Table SEC_PRIVILEGE_ROLES altered. Table SEC_PRIVILEGE_ROLES altered. Table SEC_PRIVILEGES altered. Table SEC_ROLE_MAPPINGS altered. Table SEC_ROLE_MAPPINGS altered. Table SEC_ROLES altered. Table SEC_KEYS altered. Table SEC_ORIGINS_ALLOWED_MODULES altered. Table SEC_PRIVILEGE_MAPPINGS altered. Table SEC_PRIVILEGE_MAPPINGS altered. Table SEC_PRIVILEGE_MODULES altered. Table SEC_PRIVILEGE_MODULES altered. Table SEC_PRIVILEGE_MODULES altered. Table SEC_SESSIONS altered. View DBA_ORDS_PROP_DB_VALUES created. View DBA_ORDS_PROP_FACTS created. View DBA_ORDS_PROP_SCHEMA_VALUES created. View DBA_ORDS_SCHEMAS created. View DBA_ORDS_URL_MAPPINGS created. View DBA_PLSQL_GATEWAY_ALLOW_LIST created. View ORDS_CLIENT_ROLES created. View ORDS_MODULE_SERVICES created. View ORDS_PRIVILEGE_MAPPINGS created. View ORDS_REPVERSION created. View ORDS_VERSION created. View PLSQL_GATEWAY_ALLOW_LIST created. View PLSQL_GATEWAY_CONFIG created. View POOL_CONFIG created. View USER_ORDS_APPROVALS created. View USER_ORDS_CLIENT_PRIVILEGES created. View USER_ORDS_CLIENT_ROLES created. View USER_ORDS_CLIENTS created. View USER_ORDS_ENABLED_OBJECTS created. View USER_ORDS_HANDLERS created. View USER_ORDS_JWT_PROFILE created. View USER_ORDS_MODULES created. View USER_ORDS_OBJ_MEMBERS created. View USER_ORDS_OBJECTS created. View USER_ORDS_PARAMETERS created. View USER_ORDS_PENDING_APPROVALS created. View USER_ORDS_PRIVILEGE_MAPPINGS created. View USER_ORDS_PRIVILEGES created. View USER_ORDS_PRIVILEGE_MODULES created. View USER_ORDS_ROLES created. View USER_ORDS_PRIVILEGE_ROLES created. View USER_ORDS_PROPERTIES created. View USER_ORDS_SCHEMAS created. View USER_ORDS_SERVICES created. View USER_ORDS_TEMPLATES created. 2024-02-22T16:16:19.121Z INFO ... Created Oracle REST Data Services database objects [*** script: ords_triggers.sql] Sequence ORDS_ID_SEQ created. Trigger ORDS_SCHEMA_REQUESTS_ROLES_TRG compiled Trigger ORDS_SCHEMA_REQUESTS_TRG compiled Trigger OAUTH_APPROVALS_TRG compiled Trigger OAUTH_APPROVAL_PRIVS_TRG compiled Trigger OAUTH_CLIENTS_TRG compiled Trigger OAUTH_CLIENT_PRIVILEGES_TRG compiled Trigger OAUTH_PENDING_APPROVALS_TRG compiled Trigger OAUTH_SESSIONS_TRG compiled Trigger ORDS_HANDLERS_TRG compiled Trigger ORDS_MODULES_TRG compiled Trigger ORDS_PARAMETERS_TRG compiled Trigger ORDS_SCHEMAS_TRG compiled Trigger ORDS_OBJECTS_TRG compiled Trigger ORDS_TEMPLATES_TRG compiled Trigger ORDS_URL_MAPPINGS_TRG compiled Trigger SEC_AUTHENTICATORS_TRG compiled Trigger SEC_ROLES_TRG compiled Trigger SEC_PRIVILEGES_TRG compiled Trigger SEC_ROLE_MAPPINGS_TRG compiled Trigger SEC_PRIVILEGE_AUTHS_TRG compiled Trigger SEC_PRIVILEGE_ROLES_TRG compiled Trigger SEC_PRIVILEGE_MODULES_TRG compiled Trigger SEC_SESSIONS_TRG compiled Trigger SEC_KEYS_TRG compiled Trigger ORDS_WORKSPACE_SCHEMAS_TRG compiled Trigger SEC_ORIG_ALLOWED_MOD_TRG compiled Trigger SEC_PRIV_MAPS_TRG compiled Trigger OAUTH_CLIENT_ROLES_TRG compiled Trigger ORDS_SCHEMA_VERSION_TRG compiled Trigger CFG_PLSQL_GATEWAYS_TRG compiled Trigger SEC_OBJECT_ALLOW_LIST_TRG compiled Trigger ORDS_PROP_FACTS_TRG compiled Trigger ORDS_PROP_VALUES_TRG compiled Trigger OAUTH_JWT_PROFILE_TRG compiled [*** script: ords_types.sql] Type T_ORDS_VCHAR_TAB compiled Type T_ORDS_NUM_TAB compiled Type T_ORDS_ATTR_SUPPORT_OBJ compiled Type T_ORDS_ATTR_SUPPORT_TAB compiled PL/SQL procedure successfully completed. Type T_ORDS_METADATA_TYPE compiled Type T_ORDS_METADATA_TYPE_LIST compiled Type T_ORDS_MODULE_PRIVILEGE compiled Type Body T_ORDS_MODULE_PRIVILEGE compiled Type T_ORDS_MODULE_ORIGINS_ALLOWED compiled Type Body T_ORDS_MODULE_ORIGINS_ALLOWED compiled Type T_ORDS_PARAMETER compiled Type Body T_ORDS_PARAMETER compiled Type T_ORDS_PARAMETER_LIST compiled Type T_ORDS_HANDLER compiled Type Body T_ORDS_HANDLER compiled Type T_ORDS_HANDLER_LIST compiled Type T_ORDS_TEMPLATE compiled Type Body T_ORDS_TEMPLATE compiled Type T_ORDS_TEMPLATE_LIST compiled Type T_ORDS_MODULE compiled Type Body T_ORDS_MODULE compiled Type T_ORDS_MODULE_LIST compiled [*** script: ords_version.sql] Session altered. PL/SQL procedure successfully completed. [*** script: ords_constants.pls] Package ORDS_CONSTANTS compiled [*** script: ords_util.pls] Package ORDS_UTIL compiled [*** script: ords.pls] Package ORDS compiled [*** script: ords_internal.pls] Package ORDS_INTERNAL compiled [*** script: ords_security.pls] Package ORDS_SECURITY compiled [*** script: ords_services_internal.pls] Package ORDS_SERVICES_INTERNAL compiled [*** script: ords_services.pls] Package ORDS_SERVICES compiled [*** script: ords_oper.pls] Package ORDS_OPER compiled [*** script: oauth_internal.pls] Package OAUTH_INTERNAL compiled [*** script: oauth.pls] Package OAUTH compiled [*** script: ords_export.pls] Package ORDS_EXPORT compiled [*** script: ords_admin_internal.pls] Package ORDS_ADMIN_INTERNAL compiled [*** script: ords_admin.pls] Package ORDS_ADMIN compiled [*** script: ords_self_service_schema.pls] Package ORDS_SELF_SERVICE_SCHEMA compiled [*** script: oauth_admin.pls] Package OAUTH_ADMIN compiled [*** script: ords_http.pls] Package ORDS_HTTP compiled [*** script: ords_util.plb] Package Body ORDS_UTIL compiled [*** script: ords_internal.plb] Package Body ORDS_INTERNAL compiled [*** script: ords_security.plb] Package Body ORDS_SECURITY compiled [*** script: ords_services_internal.plb] Package Body ORDS_SERVICES_INTERNAL compiled [*** script: ords_services.plb] Package Body ORDS_SERVICES compiled [*** script: ords.plb] Package Body ORDS compiled [*** script: ords_oper.plb] Package Body ORDS_OPER compiled [*** script: oauth_internal.plb] Package Body OAUTH_INTERNAL compiled [*** script: oauth.plb] Package Body OAUTH compiled [*** script: ords_export.plb] Package Body ORDS_EXPORT compiled [*** script: ords_admin_internal.plb] Package Body ORDS_ADMIN_INTERNAL compiled [*** script: ords_admin.plb] Package Body ORDS_ADMIN compiled [*** script: ords_self_service_schema.plb] Package Body ORDS_SELF_SERVICE_SCHEMA compiled [*** script: oauth_admin.plb] Package Body OAUTH_ADMIN compiled [*** script: ords_http.plb] Package Body ORDS_HTTP compiled [*** script: ords_database_roles.sql] PL/SQL procedure successfully completed. [*** script: ords_pub_synonyms_grants.sql] PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. Grant succeeded. SYNONYM USER_ORDS_REPOVERSIONS created. PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. [*** script: ords_schema_mapping.sql] INFO: Configuring ORDS_PUBLIC_USER to map APEX Workspaces and ORDS schemas Session altered. Configuring APEX and ORDS schemas for url mapping Made APEX_PUBLIC_USER proxiable from ORDS_PUBLIC_USER Made APEX_REST_PUBLIC_USER proxiable from ORDS_PUBLIC_USER APEX_POOL_CONFIG Synonym exists Created ORDS_METADATA.APEX_WWV_FLOW_POOL_CONFIG as view over APEX_210200.WWV_FLOW_POOL_CONFIG PL/SQL procedure successfully completed. INFO: Completed configuring ORDS_PUBLIC_USER to map APEX Workspaces and ORDS Schemas Session altered. [*** script: ords_app_contexts.sql] PL/SQL procedure successfully completed. [*** script: ords_seed.sql] PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. [*** script: ords_verify_install.sql] Session altered. INFO: 11:16:22 Validating objects for Oracle REST Data Services. VALIDATION: 11:16:22 Starting validation for schema: ORDS_METADATA VALIDATION: 11:16:22 Validating objects VALIDATION: 11:16:23 Validating roles granted to ORDS_METADATA and ORDS_PUBLIC_USER VALIDATION: 11:16:23 Validating ORDS Public Synonyms VALIDATION: 11:16:23 INFO: PUBLIC SYNONYM ORDS_HTTP is not in the validation list. VALIDATION: 11:16:23 INFO: PUBLIC SYNONYM ORDS_VERSION is not in the validation list. VALIDATION: 11:16:23 Total objects: 315, invalid objects: 0, missing objects: 0 VALIDATION: 11:16:23 97 INDEX VALIDATION: 11:16:23 3 LOB VALIDATION: 11:16:23 16 PACKAGE VALIDATION: 11:16:23 15 PACKAGE BODY VALIDATION: 11:16:23 1 PROCEDURE VALIDATION: 11:16:23 55 PUBLIC SYNONYM VALIDATION: 11:16:23 1 SEQUENCE VALIDATION: 11:16:23 34 TABLE VALIDATION: 11:16:23 34 TRIGGER VALIDATION: 11:16:23 16 TYPE VALIDATION: 11:16:23 6 TYPE BODY VALIDATION: 11:16:23 37 VIEW VALIDATION: 11:16:23 Validation completed. INFO: 11:16:23 Completed validation for Oracle REST Data Services. PL/SQL procedure successfully completed. Commit complete. [*** script: ords_version.sql] Session altered. PL/SQL procedure successfully completed. ------------------------------------------------------------ Container Name: XEPDB1 Executing scripts for datamodel ------------------------------------------------------------ [*** script: ords_alter_session_script.sql] PL/SQL procedure successfully completed. [*** script: ords_alter_session_metadata.sql] Session altered. [*** script: dm_grant_privs.sql] INFO: Grant object and system privileges to ORDS owner for datamodel team Grant succeeded. INFO: Completed granting object and system privileges for datamodel team [*** script: dm_types.sql] Type DM_VARCHAR_TABLE compiled Type DM_DDL_DESC compiled Type DM_DDL_ROW compiled Type DM_DDL_TAB compiled [*** script: osddm_dbms_md_ddl.pls] Package OSDDM_DBMS_MD_DDL compiled [*** script: osddm_dbms_md_ddl.plb] Package Body OSDDM_DBMS_MD_DDL compiled [*** script: dm_grants_synonyms.sql] PL/SQL procedure successfully completed. [*** script: ords_verify_install.sql] Session altered. INFO: 11:16:24 Validating objects for Oracle REST Data Services. VALIDATION: 11:16:24 Starting validation for schema: ORDS_METADATA VALIDATION: 11:16:24 Validating objects VALIDATION: 11:16:24 Validating roles granted to ORDS_METADATA and ORDS_PUBLIC_USER VALIDATION: 11:16:24 Validating ORDS Public Synonyms VALIDATION: 11:16:24 INFO: PUBLIC SYNONYM ORDS_HTTP is not in the validation list. VALIDATION: 11:16:24 INFO: PUBLIC SYNONYM ORDS_VERSION is not in the validation list. VALIDATION: 11:16:24 Total objects: 322, invalid objects: 0, missing objects: 0 VALIDATION: 11:16:24 97 INDEX VALIDATION: 11:16:24 3 LOB VALIDATION: 11:16:24 17 PACKAGE VALIDATION: 11:16:24 16 PACKAGE BODY VALIDATION: 11:16:24 1 PROCEDURE VALIDATION: 11:16:24 56 PUBLIC SYNONYM VALIDATION: 11:16:24 1 SEQUENCE VALIDATION: 11:16:24 34 TABLE VALIDATION: 11:16:24 34 TRIGGER VALIDATION: 11:16:24 20 TYPE VALIDATION: 11:16:24 6 TYPE BODY VALIDATION: 11:16:24 37 VIEW VALIDATION: 11:16:24 Validation completed. INFO: 11:16:24 Completed validation for Oracle REST Data Services. PL/SQL procedure successfully completed. Commit complete. ------------------------------------------------------------ Container Name: XEPDB1 Executing scripts for scheduler ------------------------------------------------------------ [*** script: ords_alter_session_script.sql] PL/SQL procedure successfully completed. [*** script: ords_alter_session_metadata.sql] Session altered. [*** script: sch_grant_privs.sql] INFO: Grant object and system privileges to ORDS owner for scheduler team INFO: Completed granting object and system privileges for scheduler team [*** script: ords_sdw_scheduler.pls] Package ORDS_SDW_SCHEDULER compiled [*** script: ords_sdw_sched_jobs.pls] Package ORDS_SDW_SCHED_JOBS compiled [*** script: ords_sdw_sched_rprt.pls] Package ORDS_SDW_SCHED_RPRT compiled [*** script: ords_sdw_scheduler.plb] Package Body ORDS_SDW_SCHEDULER compiled [*** script: ords_sdw_sched_jobs.plb] Package Body ORDS_SDW_SCHED_JOBS compiled [*** script: ords_sdw_sched_rprt.plb] Package Body ORDS_SDW_SCHED_RPRT compiled [*** script: sch_grants_synonyms.sql] PL/SQL procedure successfully completed. [*** script: ords_verify_install.sql] Session altered. INFO: 11:16:25 Validating objects for Oracle REST Data Services. VALIDATION: 11:16:25 Starting validation for schema: ORDS_METADATA VALIDATION: 11:16:25 Validating objects VALIDATION: 11:16:26 Validating roles granted to ORDS_METADATA and ORDS_PUBLIC_USER VALIDATION: 11:16:26 Validating ORDS Public Synonyms VALIDATION: 11:16:26 INFO: PUBLIC SYNONYM ORDS_HTTP is not in the validation list. VALIDATION: 11:16:26 INFO: PUBLIC SYNONYM ORDS_VERSION is not in the validation list. VALIDATION: 11:16:26 Total objects: 331, invalid objects: 0, missing objects: 0 VALIDATION: 11:16:26 97 INDEX VALIDATION: 11:16:26 3 LOB VALIDATION: 11:16:26 20 PACKAGE VALIDATION: 11:16:26 19 PACKAGE BODY VALIDATION: 11:16:26 1 PROCEDURE VALIDATION: 11:16:26 59 PUBLIC SYNONYM VALIDATION: 11:16:26 1 SEQUENCE VALIDATION: 11:16:26 34 TABLE VALIDATION: 11:16:26 34 TRIGGER VALIDATION: 11:16:26 20 TYPE VALIDATION: 11:16:26 6 TYPE BODY VALIDATION: 11:16:26 37 VIEW VALIDATION: 11:16:26 Validation completed. INFO: 11:16:26 Completed validation for Oracle REST Data Services. PL/SQL procedure successfully completed. Commit complete. ------------------------------------------------------------ Container Name: XEPDB1 Executing scripts for mle_js ------------------------------------------------------------ [*** script: ords_alter_session_script.sql] PL/SQL procedure successfully completed. [*** script: ords_alter_session_metadata.sql] Session altered. [*** script: ords_sdw_mle_js.pls] Package ORDS_SDW_MLE_JS compiled [*** script: ords_sdw_mle_js.plb] Package Body ORDS_SDW_MLE_JS compiled [*** script: mle_js_grants_synonyms.sql] PL/SQL procedure successfully completed. [*** script: ords_verify_install.sql] Session altered. INFO: 11:16:26 Validating objects for Oracle REST Data Services. VALIDATION: 11:16:26 Starting validation for schema: ORDS_METADATA VALIDATION: 11:16:26 Validating objects VALIDATION: 11:16:26 Validating roles granted to ORDS_METADATA and ORDS_PUBLIC_USER VALIDATION: 11:16:26 Validating ORDS Public Synonyms VALIDATION: 11:16:26 INFO: PUBLIC SYNONYM ORDS_HTTP is not in the validation list. VALIDATION: 11:16:26 INFO: PUBLIC SYNONYM ORDS_VERSION is not in the validation list. VALIDATION: 11:16:26 Total objects: 334, invalid objects: 0, missing objects: 0 VALIDATION: 11:16:26 97 INDEX VALIDATION: 11:16:26 3 LOB VALIDATION: 11:16:26 21 PACKAGE VALIDATION: 11:16:26 20 PACKAGE BODY VALIDATION: 11:16:26 1 PROCEDURE VALIDATION: 11:16:26 60 PUBLIC SYNONYM VALIDATION: 11:16:26 1 SEQUENCE VALIDATION: 11:16:26 34 TABLE VALIDATION: 11:16:26 34 TRIGGER VALIDATION: 11:16:26 20 TYPE VALIDATION: 11:16:26 6 TYPE BODY VALIDATION: 11:16:26 37 VIEW VALIDATION: 11:16:26 Validation completed. INFO: 11:16:26 Completed validation for Oracle REST Data Services. PL/SQL procedure successfully completed. Commit complete. ------------------------------------------------------------ Container Name: XEPDB1 Executing scripts for apex ------------------------------------------------------------ [*** script: ords_alter_session_script.sql] PL/SQL procedure successfully completed. [*** script: ords_alter_session_metadata.sql] Session altered. [*** script: ords_migrate.pls] Package ORDS_MIGRATE compiled [*** script: ords_apex_repair_internal.pls] Package ORDS_APEX_REPAIR_INTERNAL compiled [*** script: ords_apex_repair.pls] Package ORDS_APEX_REPAIR compiled [*** script: ords_apex_sso.pls] Package ORDS_APEX_SSO compiled [*** script: ords_migrate.plb] Package Body ORDS_MIGRATE compiled [*** script: ords_apex_repair_internal.plb] Package Body ORDS_APEX_REPAIR_INTERNAL compiled [*** script: ords_apex_repair.plb] Package Body ORDS_APEX_REPAIR compiled [*** script: ords_apex_sso.plb] Package Body ORDS_APEX_SSO compiled [*** script: ords_migrate_pub_synonym.sql] Synonym ORDS_MIGRATE created. [*** script: ords_migrate_grant_priv.sql] INFO: Verify if Application Express exists to setup the migration privileges for ORDS. INFO: Completed setting up the APEX REST migration privileges for ORDS. PL/SQL procedure successfully completed. Session altered. [*** script: ords_apex_repair_pub_synonym.sql] Synonym ORDS_APEX_REPAIR created. [*** script: ords_apex_grants.sql] APEX schema APEX_210200 PL/SQL procedure successfully completed. [*** script: allow_apex_entry_points.sql] Found APEX 21.2.0. Migrating APEX entry points to ORDS PL/SQL Procedure Gateway Allow List Procedure WWV_FLOW_LISTENER cannot be resolved and will not be added to allow list. ORDS migrated 38 entry points from APEX to ORDS PL/SQL Procedure Gateway Allow List. PL/SQL procedure successfully completed. [*** script: ords_verify_install.sql] Session altered. INFO: 11:16:27 Validating objects for Oracle REST Data Services. VALIDATION: 11:16:27 Starting validation for schema: ORDS_METADATA VALIDATION: 11:16:27 Validating objects VALIDATION: 11:16:27 Validating roles granted to ORDS_METADATA and ORDS_PUBLIC_USER VALIDATION: 11:16:27 Validating ORDS Public Synonyms VALIDATION: 11:16:27 INFO: PUBLIC SYNONYM ORDS_HTTP is not in the validation list. VALIDATION: 11:16:27 INFO: PUBLIC SYNONYM ORDS_VERSION is not in the validation list. VALIDATION: 11:16:27 Total objects: 344, invalid objects: 0, missing objects: 0 VALIDATION: 11:16:27 97 INDEX VALIDATION: 11:16:27 3 LOB VALIDATION: 11:16:27 25 PACKAGE VALIDATION: 11:16:27 24 PACKAGE BODY VALIDATION: 11:16:27 1 PROCEDURE VALIDATION: 11:16:27 62 PUBLIC SYNONYM VALIDATION: 11:16:27 1 SEQUENCE VALIDATION: 11:16:27 34 TABLE VALIDATION: 11:16:27 34 TRIGGER VALIDATION: 11:16:27 20 TYPE VALIDATION: 11:16:27 6 TYPE BODY VALIDATION: 11:16:27 37 VIEW VALIDATION: 11:16:27 Validation completed. INFO: 11:16:27 Completed validation for Oracle REST Data Services. PL/SQL procedure successfully completed. Commit complete. 2024-02-22T16:16:27.687Z INFO Completed installation for Oracle REST Data Services version 23.4.0.r3461619. Elapsed time: 00:00:12.789 [*** Info: Completed installation for Oracle REST Data Services version 23.4.0.r3461619. Elapsed time: 00:00:12.789 ] ------------------------------------------------------------ Container Name: XEPDB1 ------------------------------------------------------------ [*** script: ords_configure_gateway.sql] Configured PL/SQL Gateway user APEX_PUBLIC_USER to be proxiable from ORDS_PUBLIC_USER PL/SQL procedure successfully completed. 2024-02-22T16:16:27.737Z INFO Completed configuring PL/SQL gateway user for Oracle REST Data Services version 23.4.0.r3461619. Elapsed time: 00:00:00.49 [*** Info: Completed configuring PL/SQL gateway user for Oracle REST Data Services version 23.4.0.r3461619. Elapsed time: 00:00:00.49 ] C:\app\product\ords>