APEXのインストールの検証
イントレーション・ガイドのC.2 APEXインストールの妥当性の検証に記載されているSELECT文を実行します。
APEXをインストールしたPDBであるFREEPDB1にSYSで接続し、以下のSELECT文を実行します。
select status from dba_registry where comp_id = 'APEX';[oracle@apex-arm ~]$ . oraenv
ORACLE_SID = [oracle] ? FREE
The Oracle base has been set to /opt/oracle
[oracle@apex-arm ~]$ export NLS_LANG=American_America.AL32UTF8
[oracle@apex-arm ~]$ sqlplus sys/********@localhost/freepdb1 as sysdba
SQL*Plus: Release 23.26.0.0.0 - Production on Wed Jan 28 19:30:07 2026
Version 23.26.0.0.0
Copyright (c) 1982, 2025, Oracle. All rights reserved.
Connected to:
Oracle AI Database 26ai Free Release 23.26.0.0.0 - Develop, Learn, and Run for Free
Version 23.26.0.0.0
SQL> select status from dba_registry where comp_id = 'APEX';
STATUS
-----------
VALID
SQL>
SQL> set serveroutput on
SQL> exec sys.validate_apex
...(19:30:54) Starting validate_apex for APEX_240200
...(19:30:54) Checking missing privileges for APEX_240200
...(19:30:55) Checking missing privileges for APEX_GRANTS_FOR_NEW_USERS_ROLE
...(19:30:55) Re-generating APEX_240200.wwv_flow_db_version
... wwv_flow_db_version is up to date
...(19:30:55) Checking for sys.wwv_flow_cu_constraints
...(19:30:55) Checking invalid public synonyms
...(19:30:55) Key object existence check
...(19:30:55) Post-ORDS updates
...(19:30:55) calling wwv_util_apex_240200.post_ords_upgrade
...enabled_schema
...define_module
...define_template
...define_handler
...(19:30:55) Setting DBMS Registry for APEX to valid
...(19:30:55) Exiting validate_apex
PL/SQL procedure successfully completed.
SQL>
Oracle REST Data Servicesのインストールの検証
[oracle@apex-arm ~]$ export LANG=C
[oracle@apex-arm ~]$ ords --config /etc/ords/config install repair
ORDS: Release 25.4 Production on Wed Jan 28 10:33:24 2026
Copyright (c) 2010, 2026, Oracle.
Configuration:
/etc/ords/config
Oracle REST Data Services - Interactive Repair
Enter a number to select the database pool to use or specify the database connection
[1] default jdbc:oracle:thin:@//localhost:1521/freepdb1
[S] Specify the database connection
Choose [1]:
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:@//localhost:1521/freepdb1
Retrieving information.
Oracle REST Data Services will be validated.
2026-01-28T10:33:44.262Z INFO Created folder /home/oracle/logs
2026-01-28T10:33:44.264Z INFO The log file is defaulted to the current working directory located at /home/oracle/logs
2026-01-28T10:33:44.379Z INFO Repairing Oracle REST Data Services schema version 25.4.0.r3641739 in FREEPDB1
2026-01-28T10:33:48.856Z INFO Completed repair for Oracle REST Data Services version 25.4.0.r3641739. Elapsed time: 00:00:04.450
2026-01-28T10:33:48.858Z INFO Log file written to /home/oracle/logs/ords_repair_2026-01-28_103344_26447.log
[oracle@apex-arm ~]$
[oracle@apex-arm ~]$ cat /home/oracle/logs/ords_repair_2026-01-28_103344_26447.log
------------------------------------------------------------
Date : 28 Jan 2026 10:33:44
Release : Oracle REST Data Services 25.4.0.r3641739
Type : ORDS Repair
Database : Oracle AI Database 26ai Free
DB Version : 23.26.0.0.0
------------------------------------------------------------
Container Name: FREEPDB1
------------------------------------------------------------
[*** script: ords_alter_session_script.sql]
PL/SQL procedure successfully completed.
[*** script: ords_version.sql]
Session altered.
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
APEX_REST_PUBLIC_USER does not exist
APEX_POOL_CONFIG Synonym exists
Created ORDS_METADATA.APEX_WWV_FLOW_POOL_CONFIG as view over APEX_240200.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_repair_proxy_connect.sql]
INFO: Checking ords enabled schemas and its proxy user
Session altered.
PL/SQL procedure successfully completed.
[*** script: ords_alter_schema_no_auth.sql]
PL/SQL procedure successfully completed.
[*** 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_grants.sql]
APEX schema APEX_240200
PL/SQL procedure successfully completed.
[*** script: allow_apex_entry_points.sql]
Found APEX 24.2.0. Migrating APEX entry points to ORDS PL/SQL Procedure Gateway Allow List
Invoking APEX API...
PL/SQL procedure successfully completed.
[*** script: ords_plsql_gateway_config.sql]
Gateway Mode: proxied
INFO: APEX schema: APEX_240200
PL/SQL procedure successfully completed.
[*** script: ords_validate_objects.sql]
INFO: 19:33:47 Validating objects for Oracle REST Data Services.
VALIDATION: 19:33:47 Starting validation for schema: ORDS_METADATA
VALIDATION: 19:33:47 Validating objects
VALIDATION: 19:33:48 Validating roles granted to ORDS_METADATA and ORDS_PUBLIC_USER
VALIDATION: 19:33:48 Validating ORDS Public Synonyms
VALIDATION: 19:33:48 Total objects: 441, invalid objects: 0, missing objects: 0
VALIDATION: 19:33:48 107 INDEX
VALIDATION: 19:33:48 1 JOB
VALIDATION: 19:33:48 5 LOB
VALIDATION: 19:33:48 39 PACKAGE
VALIDATION: 19:33:48 38 PACKAGE BODY
VALIDATION: 19:33:48 1 PROCEDURE
VALIDATION: 19:33:48 89 PUBLIC SYNONYM
VALIDATION: 19:33:48 1 SEQUENCE
VALIDATION: 19:33:48 37 TABLE
VALIDATION: 19:33:48 37 TRIGGER
VALIDATION: 19:33:48 20 TYPE
VALIDATION: 19:33:48 6 TYPE BODY
VALIDATION: 19:33:48 60 VIEW
VALIDATION: 19:33:48 Validation completed.
INFO: 19:33:48 Completed validating objects for Oracle REST Data Services.
PL/SQL procedure successfully completed.
[*** script: ords_alter_session_script.sql]
PL/SQL procedure successfully completed.
[*** script: ords_version.sql]
Session altered.
PL/SQL procedure successfully completed.
[*** Info: Completed repair for Oracle REST Data Services version 25.4.0.r3641739. Elapsed time: 00:00:04.450
]
[oracle@apex-arm ~]$
VALIDATION: 19:33:48 Validating ORDS Public Synonyms
VALIDATION: 19:33:48 Total objects: 441, invalid objects: 0, missing objects: 0
