APEX-SERTのインストール手順は以下に記載されています。
% sql -version
SQLcl: リリース24.4.3.0 Production ビルド: 24.4.3.070.2106
%
git clone https://github.com/oracle-samples/apex-sert.git
フォルダapex-sertが作成され、インストールに必要なファイルが配置されます。
% git clone https://github.com/oracle-samples/apex-sert.git
Cloning into 'apex-sert'...
remote: Enumerating objects: 1543, done.
remote: Counting objects: 100% (1543/1543), done.
remote: Compressing objects: 100% (603/603), done.
remote: Total 1543 (delta 963), reused 1464 (delta 897), pack-reused 0 (from 0)
Receiving objects: 100% (1543/1543), 7.63 MiB | 20.56 MiB/s, done.
Resolving deltas: 100% (963/963), done.
%
% cd product/sert/pre-install
pre-install %
sql sys/[パスワード]@localhost/freepdb1 as sysdba
% sql sys/********@localhost/freepdb1 as sysdba
SQLcl: 木 4月 24 15:34:56 2025のリリース24.4 Production
Copyright (c) 1982, 2025, Oracle. All rights reserved.
接続先:
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.7.0.25.01
SQL>
スクリプトcreate_acdc_schema.sqlを実行します。
SQL> @create_acdc_schema.sql ACDC [パスワード] USERS
--
-- Create install schema
--
-- Schema name
ACDC
-- Check schema name
Completed.
User "ACDC" created
PL/SQLプロシージャが正常に完了しました。
--
-- Grants for install schema
--
-- Schema name
ACDC
-- Check schema name
Completed.
-- Grant roles
Completed.
-- Grant object privileges
Completed.
-- Grant system privileges
Completed.
WARNING: "ACDC" did not recieve all defined grants.
This is usually not cause for concern; some privileges are not available in ADB
or cannot be granted to non-ADMIN schemas
-- Failed grants
TYPE | GRANT | REASON
----------------------------------------------------------------------
OBJECT | execute on c##cloud$service.dbms_cloud | Object does not exist
PL/SQLプロシージャが正常に完了しました。
--
-- Revoke any existing privileges for schema
--
-- Schema name
ACDC
-- Check schema name
Completed.
-- Revoke privileges
Completed.
-- Revoke object privileges
Completed.
-- Revoke system privileges
Completed.
All grant revocations completed.
PL/SQLプロシージャが正常に完了しました。
--
-- Additional setup for schema
--
-- Schema name
ACDC
-- Check schema name
Completed.
-- Add ORA_APP_PROFILE profile to schema
Profile "ORA_APP_PROFILE" does not exist or is already assigned.
PL/SQLプロシージャが正常に完了しました。
Granting OCI resource principal access to ACDC...
WARNING: Unable to grant resource principal; probably not ADB
PL/SQLプロシージャが正常に完了しました。
PL/SQLプロシージャが正常に完了しました。
View ACDC.ACDC_RELEASE_Vは作成されました。
Synonym ACDC.ACDC_RELEASEは作成されました。
ACDC_RELEASE not set; assuming manual execution.
ACDC release table will be updated with today's date
PL/SQLプロシージャが正常に完了しました。
ACDC release set to:
RELEASE_TAG
____________________
2025.04.24_manual
1行が選択されました。
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.7.0.25.01から切断されました
pre-install %
フォルダapex-sertに戻ります。
########################################################################
# SERT Properties File
########################################################################
sert_apex_workspace = sert
sert_admin_user = sert_admin
sert_app_id = 2100
sert_admin_id = 2101
#sert_aop_url = https://xgbu-ace-aop.sniadprshared1.gbucdsint02iad.oraclevcn.com
sert_admin_email_address = michael.potter@oracle.com
sert_email_from = noreply@oracle.com
sert_mode = standalone
# if you leave the tablespace properties BLANK, installer will attempt to identify default tablespaces
# this is fine for ADB and some PDBs that are well configured, but for deployment one should
# explicitly define the tablespaces you install into. This only have effect on first install
sert_data_tablespace =
sert_temp_tablespace =apex-sert % sql acdc@localhost/freepdb1
SQLcl: 木 4月 24 15:36:56 2025のリリース24.4 Production
Copyright (c) 1982, 2025, Oracle. All rights reserved.
パスワード (**********?) ************
Last Successful login time: 木 4月 24 2025 15:37:01 +09:00
接続先:
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.7.0.25.01
SQL> set define off
SQL> @install
--Starting Liquibase at 2025-04-24T15:37:24.494777 (version 4.25.0 #4.25.1 built at 2025-01-21 15:25+0000)
Running Changeset: product/sert/pre-install/base_schema.sql::sert_core_create::mipotter
Running Changeset: product/sert/pre-install/base_schema.sql::set-user-quota-default::SERT
Running Changeset: product/sert/pre-install/base_schema.sql::set-user-custom-tablespace::SERT
Running Changeset: product/sert/pre-install/base_schema.sql::set-user-custom-temp-tablespace::SERT
UPDATE SUMMARY
Run: 4
Previously run: 0
Filtered out: 0
-------------------------------
Total change sets: 4
Liquibase: Update has been successful. Rows affected: 4
操作が正常に完了しました。
--Starting Liquibase at 2025-04-24T15:37:25.475348 (version 4.25.0 #4.25.1 built at 2025-01-21 15:25+0000)
Running Changeset: product/sert/_dba/create_users.sql::sert_core_create::mipotter
Running Changeset: product/sert/_dba/create_users.sql::set-user-quota-default::SERT
Running Changeset: product/sert/_dba/create_users.sql::set-user-custom-tablespace::SERT
Running Changeset: product/sert/_dba/create_users.sql::set-user-custom-temp-tablespace::SERT
Running Changeset: product/sert/_dba/create_users.sql::sert_pub_create::mipotter
Running Changeset: product/sert/sert_core/table/builder_urls.sql::create_table_sert_core.builder_urls_1721795986865::mipotter
Running Changeset: product/sert/sert_core/table/builder_urls.sql::alter_table_sert_core.builder_urls_add_constraint_builder_urls_un_1721796960845::mipotter
Running Changeset: product/sert/sert_core/table/categories.sql::create_table_sert_core.categories_1721796023931::mipotter
Running Changeset: product/sert/sert_core/table/categories.sql::alter_table_sert_core.categories_add_constraint_categories_un_1721796977977::mipotter
Running Changeset: product/sert/sert_core/table/comments.sql::create_table_sert_core.comments_1721796087167::mipotter
[中略]
Running Changeset: product/sert/post_install/1500_migrate_exceptions.sql::migrate_exceptions_sert_2024::mzimon
Running Changeset: product/sert/post_install/setup_builder_menu_entries.sql::post_install_builder_remove_apex_sert_menu_entry::mipotter
Running Changeset: product/sert/post_install/setup_builder_menu_entries.sql::post_install_builder_add_menu_entry::mipotter
Running Changeset: product/sert/post_install/setup_builder_menu_entries.sql::post_install_setup_builder_extension_grants::mipotter
apex_instance_admin.grant_extension_workspace( p_from_workspace => :from_workspace, p_to_workspace => upper(:to_workspace), p_read_access => true, p_menu_label => 'APEX SERT');
Running Changeset: product/sert/post_install/upgrade_sert_apex_version.sql::check_upgrade_sert_apex_version::mipotter
UPDATE SUMMARY
Run: 432
Previously run: 0
Filtered out: 0
-------------------------------
Total change sets: 432
Liquibase: Update has been successful. Rows affected: 432
操作が正常に完了しました。
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.7.0.25.01から切断されました
apex-sert %
以上でAPEX-SERTのインストールは完了です。
