Oracle Database 23ai Freeは、VirutalBoxの仮想マシンでも提供されています。米国オラクル本社所属のデータベース・ツールのPM、Jeff Smithさんが彼のブログにて、提供されているVirutalBoxについて詳しく紹介されています。
- Oracle Linux 8.8
- Oracle Database 23ai Free
- Oracle REST Data Services 24.1.0
- Oracle SQLcl 24.1.0
- Oracle APEX 23.2
% ssh -p 2223 oracle@localhost
oracle@localhost's password: *********
Activate the web console with: systemctl enable --now cockpit.socket
Last login: Wed May 15 01:19:58 2024 from 10.0.2.2
[oracle@localhost ~]$
cd temp
curl -OL https://download.oracle.com/otn_software/apex/apex_23.2.zip
[oracle@localhost ~]$ mkdir temp
[oracle@localhost ~]$ cd temp
[oracle@localhost temp]$ curl -OL https://download.oracle.com/otn_software/apex/apex_23.2.zip
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 261M 100 261M 0 0 9588k 0 0:00:27 0:00:27 --:--:-- 9018k
[oracle@localhost temp]$
unzip apex_23.2.zip
[oracle@localhost temp]$ unzip apex_23.2.zip
Archive: apex_23.2.zip
inflating: META-INF/MANIFEST.MF
inflating: META-INF/ORACLE_C.SF
inflating: META-INF/ORACLE_C.RSA
creating: apex/
inflating: apex/apxremov2.sql
inflating: apex/apxrtins_cdb.sql
[中略]
inflating: apex/utilities/readme.txt
inflating: apex/utilities/apxrekey.sql
inflating: apex/apexins_cdb.sql
[oracle@localhost temp]$
[oracle@localhost temp]$ cd apex
[oracle@localhost apex]$ . oraenv
ORACLE_SID = [oracle] ? FREE
The Oracle base remains unchanged with value /opt/oracle
[oracle@localhost apex]$ export NLS_LANG=American_America.AL32UTF8
[oracle@localhost apex]$ sqlplus sys/oracle@localhost/freepdb1 as sysdba
SQL*Plus: Release 23.0.0.0.0 - Production on Wed May 15 02:00:54 2024
Version 23.4.0.24.05
Copyright (c) 1982, 2024, Oracle. All rights reserved.
Connected to:
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.4.0.24.05
SQL> @load_trans JAPANESE
PL/SQL procedure successfully completed.
Installing Oracle APEX translation - JAPANESE
. ORACLE
.
. Application Express Hosted Development Service Installation.
..............................................................
PL/SQL procedure successfully completed.
--application/set_environment
API Last Extended:20231031
Your Current Version:20231031
This import is compatible with version: 20231031
COMPATIBLE (You should be able to run this import without issues.)
ID offset during import: 0
New ID offset for application: 0
APPLICATION 4420 - Oracle APEX Builder, Wizard Messages and Native Plug-Ins
--application/delete_application
--application/create_application
--application/user_interfaces
--application/shared_components/navigation/lists/spotlight_custom_entries_global
--application/shared_components/navigation/lists/spotlight_custom_entries_app_level
[中略]
--application/pages/page_00205
--application/pages/page_00206
--application/end_environment
... elapsed: 4.72 sec
...done
Adjust instance settings
PL/SQL procedure successfully completed.
SQL>
SQL> @apxchpwd
...set_appun.sql
================================================================================
This script can be used to change the password of an Oracle APEX
instance administrator. If the user does not yet exist, a user record will be
created.
================================================================================
Enter the administrator's username [ADMIN]
User "ADMIN" exists.
Enter ADMIN's email [ADMIN]
Enter ADMIN's password [] ***********
Changed password of instance administrator ADMIN.
SQL>
