APEXのインストールの検証
イントレーション・ガイドのC.2 Oracle Application Expressインストールの妥当性の検証に記載されているSELECT文を実行します。
APEXをインストールしたPDBであるFREEPDB1にSYSで接続し、以下のSELECT文を実行します。
select status from dba_registry where comp_id = 'APEX';[opc@apex ~]$ . oraenv
ORACLE_SID = [opc] ? FREE
ORACLE_BASE environment variable is not being set since this
information is not available for the current user ID opc.
You can set ORACLE_BASE manually if it is required.
Resetting ORACLE_BASE to its previous value or ORACLE_HOME
The Oracle base has been set to /opt/oracle/product/23c/dbhomeFree
[opc@apex ~]$ export NLS_LANG=American_America.AL32UTF8
[opc@apex ~]$ sqlplus sys/oracle@localhost/freepdb1 as sysdba
SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Fri May 19 15:43:40 2023
Version 23.2.0.0.0
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Connected to:
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0
SQL> select status from dba_registry where comp_id = 'APEX';
STATUS
-----------
VALID
SQL>
SQL> select status from dba_registry where comp_id = 'APEX';
STATUS
-----------
VALID
SQL> set serveroutput on
SQL> exec sys.validate_apex
...(15:45:28) Starting validate_apex for APEX_230100
...(15:45:29) Checking missing sys privileges
...(15:45:29) Re-generating APEX_230100.wwv_flow_db_version
... wwv_flow_db_version is up to date
...(15:45:30) Checking invalid public synonyms
...(15:45:30) Key object existence check
...(15:45:30) Setting DBMS Registry for APEX to valid
...(15:45:30) Exiting validate_apex
PL/SQL procedure successfully completed.
SQL>
Oracle REST Data Servicesのインストールの検証
[opc@apex ~]$ export LANG=C
[opc@apex ~]$ ords --config /etc/ords/config install repair
ORDS: Release 23.1 Production on Fri May 19 06:47:24 2023
Copyright (c) 2010, 2023, Oracle.
Configuration:
/etc/ords/config/
The configuration folder /etc/ords/config does not contain any configuration files.
Oracle REST Data Services - Interactive Repair
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]:
Enter the database host name [localhost]:
Enter the database listen port [1521]:
Enter the database service name [FREE]: freepdb1
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.
2023-05-19T06:47:58.290Z INFO Repairing Oracle REST Data Services schema version 23.1.2.r1151944 in FREEPDB1
------------------------------------------------------------
Date : 19 May 2023 06:47:58
Release : Oracle REST Data Services 23.1.2.r1151944
Type : ORDS Repair
Database : Oracle Database 23c Free,
DB Version : 23.2.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_230100.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: allow_apex_entry_points.sql]
Found APEX 23.1.0. Migrating APEX entry points to ORDS PL/SQL Procedure Gateway
Allow List
PL/SQL procedure successfully completed.
[*** script: ords_validate_objects.sql]
INFO: 15:48:02 Validating objects for Oracle REST Data Services.
VALIDATION: 15:48:02 Starting validation for schema: ORDS_METADATA
VALIDATION: 15:48:02 Validating objects
VALIDATION: 15:48:03 Validating roles granted to ORDS_METADATA and
ORDS_PUBLIC_USER
VALIDATION: 15:48:03 Validating ORDS Public Synonyms
VALIDATION: 15:48:04 Total objects: 328, invalid objects: 0, missing objects: 0
VALIDATION: 15:48:04 94 INDEX
VALIDATION: 15:48:04 3 LOB
VALIDATION: 15:48:04 23 PACKAGE
VALIDATION: 15:48:04 22 PACKAGE BODY
VALIDATION: 15:48:04 1 PROCEDURE
VALIDATION: 15:48:04 58 PUBLIC SYNONYM
VALIDATION: 15:48:04 1 SEQUENCE
VALIDATION: 15:48:04 32 TABLE
VALIDATION: 15:48:04 32 TRIGGER
VALIDATION: 15:48:04 20 TYPE
VALIDATION: 15:48:04 6 TYPE BODY
VALIDATION: 15:48:04 36 VIEW
VALIDATION: 15:48:04 Validation completed.
INFO: 15:48:04 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.
2023-05-19T06:48:04.315Z INFO Completed repair for Oracle REST Data Services version 23.1.2.r1151944. Elapsed time: 00:00:05.943
[*** Info: Completed repair for Oracle REST Data Services version 23.1.2.r1151944. Elapsed time: 00:00:05.943
]
[opc@apex ~]$
VALIDATION: 15:48:03 Validating ORDS Public Synonyms
VALIDATION: 15:48:04 Total objects: 328, invalid objects: 0, missing objects: 0
