Oracle Database 23c Free - Developer ReleaseをOracle Linux 8にインストールしてみた

# はじめに
Oracle Database 23c Free - Developer Releaseが利用可能になったので、早速インストールしてみました。

# 1. Oracle Database 23c Free - Developer Releaseのインストール
suコマンドでrootユーザにスイッチします。
```
[opc@oracle23c ~]$ sudo su -
```
チャネルol8_developerを有効化します。
```
[root@oracle23c ~]# dnf config-manager --set-enabled ol8_developer
```
oracle-database-preinstall-23cをインストールします。
```
[root@oracle23c ~]# dnf -y install oracle-database-preinstall-23c
Ksplice for Oracle Linux 8 (x86_64)                         15 MB/s | 2.1 MB     00:00    
MySQL 8.0 for Oracle Linux 8 (x86_64)                      2.4 MB/s | 2.8 MB     00:01    
MySQL 8.0 Tools Community for Oracle Linux 8 (x86_64)      142 kB/s | 426 kB     00:03    
MySQL 8.0 Connectors Community for Oracle Linux 8 (x86_64)  10 kB/s |  28 kB     00:02    
Oracle Software for OCI users on Oracle Linux 8 (x86_64)    18 MB/s |  73 MB     00:04    
Oracle Linux 8 BaseOS Latest (x86_64)                       73 MB/s |  55 MB     00:00    
Oracle Linux 8 Application Stream (x86_64)                  75 MB/s |  43 MB     00:00    
Oracle Linux 8 Addons (x86_64)                              19 MB/s | 6.9 MB     00:00    
Oracle Linux 8 Development Packages (x86_64)                45 MB/s |  78 MB     00:01    
Latest Unbreakable Enterprise Kernel Release 7 for Oracle   45 MB/s |  13 MB     00:00    
Last metadata expiration check: 0:00:01 ago on Tue 04 Apr 2023 12:15:56 AM GMT.
Dependencies resolved.
===========================================================================================
 Package                         Arch    Version                  Repository          Size
===========================================================================================
Installing:
 oracle-database-preinstall-23c  x86_64  1.0-0.5.el8              ol8_developer       30 k
Installing dependencies:
 compat-openssl10                x86_64  1:1.0.2o-4.el8_6         ol8_appstream      1.1 M
 ksh                             x86_64  20120801-257.0.1.el8     ol8_appstream      929 k
 libICE                          x86_64  1.0.9-15.el8             ol8_appstream       74 k
 libSM                           x86_64  1.2.3-1.el8              ol8_appstream       47 k
 libX11-xcb                      x86_64  1.6.8-5.el8              ol8_appstream       14 k
 libXcomposite                   x86_64  0.4.4-14.el8             ol8_appstream       28 k
 libXi                           x86_64  1.7.10-1.el8             ol8_appstream       49 k
 libXinerama                     x86_64  1.1.4-1.el8              ol8_appstream       15 k
 libXmu                          x86_64  1.1.3-1.el8              ol8_appstream       75 k
 libXrandr                       x86_64  1.5.2-1.el8              ol8_appstream       34 k
 libXt                           x86_64  1.1.5-12.el8             ol8_appstream      185 k
 libXtst                         x86_64  1.2.3-7.el8              ol8_appstream       22 k
 libXv                           x86_64  1.0.11-7.el8             ol8_appstream       20 k
 libXxf86dga                     x86_64  1.1.5-1.el8              ol8_appstream       26 k
 libXxf86misc                    x86_64  1.0.4-1.el8              ol8_appstream       23 k
 libXxf86vm                      x86_64  1.1.4-9.el8              ol8_appstream       19 k
 libdmx                          x86_64  1.1.4-3.el8              ol8_appstream       22 k
 libnsl                          x86_64  2.28-211.0.1.el8         ol8_baseos_latest  105 k
 xorg-x11-utils                  x86_64  7.5-28.el8               ol8_appstream      136 k
 xorg-x11-xauth                  x86_64  1:1.0.9-12.el8           ol8_appstream       39 k

Transaction Summary
===========================================================================================
Install  21 Packages

Total download size: 3.0 M
Installed size: 8.0 M
Downloading Packages:
(1/21): libnsl-2.28-211.0.1.el8.x86_64.rpm                 1.1 MB/s | 105 kB     00:00    
(2/21): ksh-20120801-257.0.1.el8.x86_64.rpm                6.7 MB/s | 929 kB     00:00    
(3/21): libICE-1.0.9-15.el8.x86_64.rpm                     954 kB/s |  74 kB     00:00    
(4/21): libSM-1.2.3-1.el8.x86_64.rpm                       868 kB/s |  47 kB     00:00    
(5/21): libX11-xcb-1.6.8-5.el8.x86_64.rpm                  324 kB/s |  14 kB     00:00    
(6/21): compat-openssl10-1.0.2o-4.el8_6.x86_64.rpm         5.0 MB/s | 1.1 MB     00:00    
(7/21): libXcomposite-0.4.4-14.el8.x86_64.rpm              492 kB/s |  28 kB     00:00    
(8/21): libXi-1.7.10-1.el8.x86_64.rpm                      1.1 MB/s |  49 kB     00:00    
(9/21): libXinerama-1.1.4-1.el8.x86_64.rpm                 278 kB/s |  15 kB     00:00    
(10/21): libXmu-1.1.3-1.el8.x86_64.rpm                     1.3 MB/s |  75 kB     00:00    
(11/21): libXrandr-1.5.2-1.el8.x86_64.rpm                  386 kB/s |  34 kB     00:00    
(12/21): libXtst-1.2.3-7.el8.x86_64.rpm                    309 kB/s |  22 kB     00:00    
(13/21): libXt-1.1.5-12.el8.x86_64.rpm                     1.0 MB/s | 185 kB     00:00    
(14/21): libXv-1.0.11-7.el8.x86_64.rpm                     137 kB/s |  20 kB     00:00    
(15/21): libXxf86dga-1.1.5-1.el8.x86_64.rpm                178 kB/s |  26 kB     00:00    
(16/21): libXxf86vm-1.1.4-9.el8.x86_64.rpm                 330 kB/s |  19 kB     00:00    
(17/21): libdmx-1.1.4-3.el8.x86_64.rpm                     355 kB/s |  22 kB     00:00    
(18/21): xorg-x11-utils-7.5-28.el8.x86_64.rpm              2.7 MB/s | 136 kB     00:00    
(19/21): xorg-x11-xauth-1.0.9-12.el8.x86_64.rpm            949 kB/s |  39 kB     00:00    
(20/21): libXxf86misc-1.0.4-1.el8.x86_64.rpm               140 kB/s |  23 kB     00:00    
(21/21): oracle-database-preinstall-23c-1.0-0.5.el8.x86_64 458 kB/s |  30 kB     00:00    
-------------------------------------------------------------------------------------------
Total                                                      4.5 MB/s | 3.0 MB     00:00     
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                   1/1 
  Installing       : libXi-1.7.10-1.el8.x86_64                                        1/21 
  Installing       : libICE-1.0.9-15.el8.x86_64                                       2/21 
  Installing       : libSM-1.2.3-1.el8.x86_64                                         3/21 
  Installing       : libXt-1.1.5-12.el8.x86_64                                        4/21 
  Installing       : libXmu-1.1.3-1.el8.x86_64                                        5/21 
  Installing       : xorg-x11-xauth-1:1.0.9-12.el8.x86_64                             6/21 
  Installing       : libXtst-1.2.3-7.el8.x86_64                                       7/21 
  Installing       : libdmx-1.1.4-3.el8.x86_64                                        8/21 
  Installing       : libXxf86vm-1.1.4-9.el8.x86_64                                    9/21 
  Installing       : libXxf86misc-1.0.4-1.el8.x86_64                                 10/21 
  Installing       : libXxf86dga-1.1.5-1.el8.x86_64                                  11/21 
  Installing       : libXv-1.0.11-7.el8.x86_64                                       12/21 
  Installing       : libXrandr-1.5.2-1.el8.x86_64                                    13/21 
  Installing       : libXinerama-1.1.4-1.el8.x86_64                                  14/21 
  Installing       : libXcomposite-0.4.4-14.el8.x86_64                               15/21 
  Installing       : libX11-xcb-1.6.8-5.el8.x86_64                                   16/21 
  Installing       : xorg-x11-utils-7.5-28.el8.x86_64                                17/21 
  Installing       : ksh-20120801-257.0.1.el8.x86_64                                 18/21 
  Running scriptlet: ksh-20120801-257.0.1.el8.x86_64                                 18/21 
  Installing       : compat-openssl10-1:1.0.2o-4.el8_6.x86_64                        19/21 
  Running scriptlet: compat-openssl10-1:1.0.2o-4.el8_6.x86_64                        19/21 
  Installing       : libnsl-2.28-211.0.1.el8.x86_64                                  20/21 
  Installing       : oracle-database-preinstall-23c-1.0-0.5.el8.x86_64               21/21 
  Running scriptlet: oracle-database-preinstall-23c-1.0-0.5.el8.x86_64               21/21 
  Verifying        : libnsl-2.28-211.0.1.el8.x86_64                                   1/21 
  Verifying        : compat-openssl10-1:1.0.2o-4.el8_6.x86_64                         2/21 
  Verifying        : ksh-20120801-257.0.1.el8.x86_64                                  3/21 
  Verifying        : libICE-1.0.9-15.el8.x86_64                                       4/21 
  Verifying        : libSM-1.2.3-1.el8.x86_64                                         5/21 
  Verifying        : libX11-xcb-1.6.8-5.el8.x86_64                                    6/21 
  Verifying        : libXcomposite-0.4.4-14.el8.x86_64                                7/21 
  Verifying        : libXi-1.7.10-1.el8.x86_64                                        8/21 
  Verifying        : libXinerama-1.1.4-1.el8.x86_64                                   9/21 
  Verifying        : libXmu-1.1.3-1.el8.x86_64                                       10/21 
  Verifying        : libXrandr-1.5.2-1.el8.x86_64                                    11/21 
  Verifying        : libXt-1.1.5-12.el8.x86_64                                       12/21 
  Verifying        : libXtst-1.2.3-7.el8.x86_64                                      13/21 
  Verifying        : libXv-1.0.11-7.el8.x86_64                                       14/21 
  Verifying        : libXxf86dga-1.1.5-1.el8.x86_64                                  15/21 
  Verifying        : libXxf86misc-1.0.4-1.el8.x86_64                                 16/21 
  Verifying        : libXxf86vm-1.1.4-9.el8.x86_64                                   17/21 
  Verifying        : libdmx-1.1.4-3.el8.x86_64                                       18/21 
  Verifying        : xorg-x11-utils-7.5-28.el8.x86_64                                19/21 
  Verifying        : xorg-x11-xauth-1:1.0.9-12.el8.x86_64                            20/21 
  Verifying        : oracle-database-preinstall-23c-1.0-0.5.el8.x86_64               21/21 

Installed:
  compat-openssl10-1:1.0.2o-4.el8_6.x86_64             ksh-20120801-257.0.1.el8.x86_64     
  libICE-1.0.9-15.el8.x86_64                           libSM-1.2.3-1.el8.x86_64            
  libX11-xcb-1.6.8-5.el8.x86_64                        libXcomposite-0.4.4-14.el8.x86_64   
  libXi-1.7.10-1.el8.x86_64                            libXinerama-1.1.4-1.el8.x86_64      
  libXmu-1.1.3-1.el8.x86_64                            libXrandr-1.5.2-1.el8.x86_64        
  libXt-1.1.5-12.el8.x86_64                            libXtst-1.2.3-7.el8.x86_64          
  libXv-1.0.11-7.el8.x86_64                            libXxf86dga-1.1.5-1.el8.x86_64      
  libXxf86misc-1.0.4-1.el8.x86_64                      libXxf86vm-1.1.4-9.el8.x86_64       
  libdmx-1.1.4-3.el8.x86_64                            libnsl-2.28-211.0.1.el8.x86_64      
  oracle-database-preinstall-23c-1.0-0.5.el8.x86_64    xorg-x11-utils-7.5-28.el8.x86_64    
  xorg-x11-xauth-1:1.0.9-12.el8.x86_64                

Complete!
[root@oracle23c ~]# 
```
インストーラのRPMを[こちら](https://www.oracle.com/database/technologies/free-downloads.html)からダウンロードします。
```
[root@oracle23c ~]# wget https://download.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23c-1.0-1.el8.x86_64.rpm
--2023-04-04 00:18:08--  https://download.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23c-1.0-1.el8.x86_64.rpm
Resolving download.oracle.com (download.oracle.com)... 104.111.208.79
Connecting to download.oracle.com (download.oracle.com)|104.111.208.79|:443... connected.
HTTP request sent, awaiting response... 302 Moved Temporarily
Location: https://edelivery.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23c-1.0-1.el8.x86_64.rpm [following]
--2023-04-04 00:18:08--  https://edelivery.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23c-1.0-1.el8.x86_64.rpm
Resolving edelivery.oracle.com (edelivery.oracle.com)... 23.218.31.58, 2600:140b:ac00:297::366, 2600:140b:ac00:298::366
Connecting to edelivery.oracle.com (edelivery.oracle.com)|23.218.31.58|:443... connected.
HTTP request sent, awaiting response... 302 Moved Temporarily
Location: https://download.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23c-1.0-1.el8.x86_64.rpm?AuthParam=1680567609_fcf08eca82b60c063c8f0ded9b3e9ac2 [following]
--2023-04-04 00:18:09--  https://download.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23c-1.0-1.el8.x86_64.rpm?AuthParam=1680567609_fcf08eca82b60c063c8f0ded9b3e9ac2
Connecting to download.oracle.com (download.oracle.com)|104.111.208.79|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1758776440 (1.6G) [application/x-redhat-package-manager]
Saving to: ‘oracle-database-free-23c-1.0-1.el8.x86_64.rpm’

oracle-database-free-2 100%[===========================>]   1.64G   114MB/s    in 14s     

2023-04-04 00:18:23 (118 MB/s) - ‘oracle-database-free-23c-1.0-1.el8.x86_64.rpm’ saved [1758776440/1758776440]

[root@oracle23c ~]#
```
ダウンロードしたRPMをインストールします。
```
[root@oracle23c ~]# dnf -y localinstall oracle-database-free-23c-1.0-1.el8.x86_64.rpm
Last metadata expiration check: 0:02:50 ago on Tue 04 Apr 2023 12:15:56 AM GMT.
Dependencies resolved.
===========================================================================================
 Package                          Architecture   Version        Repository            Size
===========================================================================================
Installing:
 oracle-database-free-23c         x86_64         1.0-1          @commandline         1.6 G

Transaction Summary
===========================================================================================
Install  1 Package

Total size: 1.6 G
Installed size: 5.2 G
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                   1/1 
  Running scriptlet: oracle-database-free-23c-1.0-1.x86_64                             1/1 
  Installing       : oracle-database-free-23c-1.0-1.x86_64                             1/1 
  Running scriptlet: oracle-database-free-23c-1.0-1.x86_64                             1/1 
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure Oracle Database Free, optionally modify the parameters in '/etc/sysconfig/oracle-free-23c.conf' and then run '/etc/init.d/oracle-free-23c configure' as root.

  Verifying        : oracle-database-free-23c-1.0-1.x86_64                             1/1 

Installed:
  oracle-database-free-23c-1.0-1.x86_64                                                    

Complete!
[root@oracle23c ~]# 
```
# 2. データベースの構成

データベースを構成します。

デフォルトでは、FREEという名前のCDBが作成され、その中にFREEPDB1という名前のPDBが作成されます。
また、リスナーの使用するポートは1521に設定されます。

データベースを構成する際の設定ファイルは、/etc/sysconfig/oracle-free-23c.confです。
このファイルを変更することで、リスナーポート、キャラクタセット、データファイルの場所、DBドメイン名、メモリ容量およびディスク容量の妥当性チェック有無の設定をデフォルトから変更することができます。

```text:etc/sysconfig/oracle-free-23c.conf
#This is a configuration file to setup the Oracle Database. 
#It is used when running '/etc/init.d/oracle-free-23c configure'.

# LISTENER PORT used Database listener, Leave empty for automatic port assignment
LISTENER_PORT=

# Character set of the database
CHARSET=AL32UTF8

# Database file directory
# If not specified, database files are stored under Oracle base/oradata
DBFILE_DEST=

# DB Domain name
DB_DOMAIN=

# SKIP Validations, memory, space
SKIP_VALIDATIONS=false
```
/etc/init.d/oracle-free-23c configureでデータベースの構成を実行します。
プロンプトが表示されたら、SYS、SYSTEM、PDBADMINに設定するパスワードを入力します。
```
[root@oracle23c ~]# /etc/init.d/oracle-free-23c configure
Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts:
Confirm the password:
Configuring Oracle Listener.
Listener configuration succeeded.
Configuring Oracle Database FREE.
Enter SYS user password: 
************
Enter SYSTEM user password: 
*************
Enter PDBADMIN User Password: 
**************
Prepare for db operation
7% complete
Copying database files
29% complete
Creating and starting Oracle instance
30% complete
33% complete
36% complete
39% complete
43% complete
Completing Database Creation
47% complete
49% complete
50% complete
Creating Pluggable Databases
54% complete
71% complete
Executing Post Configuration Actions
93% complete
Running Custom Scripts
100% complete
Database creation complete. For details check the logfiles at:
 /opt/oracle/cfgtoollogs/dbca/FREE.
Database Information:
Global Database Name:FREE
System Identifier(SID):FREE
Look at the log file "/opt/oracle/cfgtoollogs/dbca/FREE/FREE.log" for further details.

Connect to Oracle Database using one of the connect strings:
     Pluggable database: oracle23c/FREEPDB1
     Multitenant container database: oracle23c
[root@oracle23c ~]# 
```
rootユーザからログアウトし、suコマンドでoracleユーザにスイッチします。
```
[root@oracle23c ~]# exit
logout
[opc@oracle23c ~]$ su - oracle
```
環境変数を設定します。
~~**※[マニュアル](https://docs.oracle.com/en/database/oracle/oracle-database/23/xeinl/installing-oracle-database-free.html#GUID-A5FCC804-5786-4B4B-B1B4-60E36E80B73F)では、oraenvのパスが
/opt/oracle/product/23c/dbhomeFREE/bin/oraenv
となっていますが、
/opt/oracle/product/23c/dbhomeFree/bin/oraenv
が正しいようです。**~~
（**2023/5/12にマニュアルが修正されました。**）
```
[oracle@oracle23c ~]$ export ORACLE_SID=FREE
[oracle@oracle23c ~]$ export ORAENV_ASK=NO
[oracle@oracle23c ~]$ . /opt/oracle/product/23c/dbhomeFree/bin/oraenv
The Oracle base has been set to /opt/oracle
[oracle@oracle23c ~]$
```
# 3. データベースへの接続

SQL*Plusからsysdbaとしてコンテナ・データベースに接続します。
```
[oracle@oracle23c ~]$ sqlplus / as sysdba

SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Tue Apr 4 00:36:37 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> show con_name

CON_NAME
------------------------------
CDB$ROOT
SQL> 
```
ALTER SESSION SET CONTAINER文でPDB（FREEPDB1）に接続します。
```
SQL> ALTER SESSION SET CONTAINER=FREEPDB1;
Session altered.

SQL> show con_name

CON_NAME
------------------------------
FREEPDB1
SQL> 
SQL> exit
Disconnected from Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0
[oracle@oracle23c ~]$
```

# 4. リスナー構成の確認
lsnrctlコマンドでリスナーの構成内容を確認します。
```
oracle@oracle23c ~]$ lsnrctl status

LSNRCTL for Linux: Version 23.0.0.0.0 - Developer-Release on 04-APR-2023 01:09:20

Copyright (c) 1991, 2023, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle23c.subnet1.vcn1.oraclevcn.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 23.0.0.0.0 - Developer-Release
Start Date                04-APR-2023 00:22:29
Uptime                    0 days 0 hr. 46 min. 50 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           FREE
Listener Parameter File   /opt/oracle/product/23c/dbhomeFree/network/admin/listener.ora
Listener Log File         /opt/oracle/diag/tnslsnr/oracle23c/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle23c.subnet1.vcn1.oraclevcn.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "FREE" has 1 instance(s).
  Instance "FREE", status READY, has 1 handler(s) for this service...
Service "FREEXDB" has 1 instance(s).
  Instance "FREE", status READY, has 1 handler(s) for this service...
Service "f878ba4598e2bb84e0533201000aba65" has 1 instance(s).
  Instance "FREE", status READY, has 1 handler(s) for this service...
Service "freepdb1" has 1 instance(s).
  Instance "FREE", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@oracle23c ~]$ 
```

# 5. 表領域の確認
CDBの表領域
```
SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT
SQL> SELECT file_name, tablespace_name,bytes/1024/1024 MB, autoextensible
  2  FROM dba_data_files;

FILE_NAME					   　　　　　　　　　　　　TABLESPACE	      MB AUT
-------------------------------------------------- ---------- ---------- ---
/opt/oracle/oradata/FREE/system01.dbf              SYSTEM	        1160 YES
/opt/oracle/oradata/FREE/sysaux01.dbf              SYSAUX	         550 YES
/opt/oracle/oradata/FREE/undotbs01.dbf             UNDOTBS1	          25 YES
/opt/oracle/oradata/FREE/users01.dbf               USERS	           5 YES

SQL>
```
PDBの表領域
```
SQL> show con_name

CON_NAME
------------------------------
FREEPDB1
SQL> col file_name for a50
SQL> col tablespace_name for a10
SQL> SELECT file_name, tablespace_name,bytes/1024/1024 MB, autoextensible
  2  FROM dba_data_files;

FILE_NAME					                       TABLESPACE	      MB AUT
-------------------------------------------------- ---------- ---------- ---
/opt/oracle/oradata/FREE/FREEPDB1/system01.dbf	   SYSTEM	         280 YES
/opt/oracle/oradata/FREE/FREEPDB1/sysaux01.dbf	   SYSAUX	         330 YES
/opt/oracle/oradata/FREE/FREEPDB1/undotbs01.dbf    UNDOTBS1	         100 YES
/opt/oracle/oradata/FREE/FREEPDB1/users01.dbf	   USERS	           5 YES

SQL>
```

# 6. 初期化パラメータの確認
```
SQL> show parameter

NAME				     　　　　　　　TYPE	　　　VALUE
------------------------------------ ----------- ------------------------------
DBFIPS_140                           boolean	 FALSE
active_instance_count                integer
adg_account_info_tracking            string      LOCAL
adg_redirect_dml		     　　　   boolean	 FALSE
allow_global_dblinks                 boolean     FALSE
allow_group_access_to_sga            boolean	 FALSE
allow_legacy_reco_protocol           boolean	 TRUE
allow_rowid_column_type              boolean	 FALSE
allow_weak_crypto                    boolean	 TRUE
approx_for_aggregation               boolean	 FALSE
approx_for_count_distinct            boolean	 FALSE
approx_for_percentile                string	     NONE
aq_tm_processes                      integer	 1
archive_lag_target                   integer	 0
asm_diskstring                       string
asm_preferred_read_failure_groups    string
audit_file_dest                      string	     /opt/oracle/admin/FREE/adump
audit_sys_operations                 boolean	 FALSE
audit_syslog_level                   string
audit_trail                          string	     DB
auto_start_pdb_services              boolean	 FALSE
autotask_max_active_pdbs             integer	 2
awr_pdb_autoflush_enabled            boolean	 TRUE
awr_pdb_max_parallel_slaves          integer	 10
awr_snapshot_time_offset             integer	 0
background_core_dump                 string	     partial
background_dump_dest                 string      /opt/oracle/product/23c/dbhomeFree/rdbms/log
backup_tape_io_slaves                boolean	 FALSE
bitmap_merge_area_size               integer	 1048576
blank_trimming                       boolean	 FALSE
blockchain_table_max_no_drop	     integer
blockchain_table_retention_threshold integer	 16
buffer_pool_keep                     string
buffer_pool_recycle                  string
cdb_cluster                          boolean	 FALSE
cdb_cluster_name                     string
cell_offload_compaction              string	     ADAPTIVE
cell_offload_decryption              boolean	 TRUE
cell_offload_parameters              string
cell_offload_plan_display            string	     AUTO
cell_offload_processing              boolean	 TRUE
cell_offloadgroup_name               string
circuits                             integer
client_prefetch_rows                 integer	 0
client_result_cache_lag              big integer 3000
client_result_cache_size             big integer 0
client_statistics_level              string	     TYPICAL
clonedb                              boolean	 FALSE
clonedb_dir                          string
cluster_database                     boolean	 FALSE
cluster_interconnects                string
commit_logging                       string
commit_point_strength                integer	 1
commit_wait                          string
commit_write                         string
common_user_prefix                   string	     C##
compatible                           string	     23.0.0
connection_brokers                   string	     ((TYPE=DEDICATED)(BROKERS=1)),((TYPE=EMON)(BROKERS=1))
container_data                       string	     ALL
containers_parallel_degree           integer	 65535
control_file_record_keep_time	     integer	 7
control_files                        string	     /opt/oracle/oradata/FREE/control01.ctl, /opt/oracle/oradata/FREE/control02.ctl
control_management_pack_access	     string	     NONE
core_dump_dest                       string	     /opt/oracle/diag/rdbms/free/FREE/cdump
cpu_count                            string	     2
cpu_min_count                        string      2
create_bitmap_area_size              integer	 8388608
create_stored_outlines               string
cursor_bind_capture_destination      string	     memory+disk
cursor_invalidation                  string	     IMMEDIATE
cursor_sharing                       string	     EXACT
cursor_space_for_time                boolean	 FALSE
data_guard_max_io_time               integer	 240
data_guard_max_longio_time           integer	 240
data_guard_sync_latency              integer	 0
data_transfer_cache_size             big integer 0
db_16k_cache_size                    big integer 0
db_2k_cache_size                     big integer 0
db_32k_cache_size                    big integer 0
db_4k_cache_size                     big integer 0
db_8k_cache_size                     big integer 0
db_big_table_cache_percent_target    string      0
db_block_buffers                     integer	 0
db_block_checking                    string      FALSE
db_block_checksum                    string      TYPICAL
db_block_size                        integer	 8192
db_cache_advice                      string      ON
db_cache_size                        big integer 0
db_create_file_dest                  string
db_create_online_log_dest_1          string
db_create_online_log_dest_2          string
db_create_online_log_dest_3          string
db_create_online_log_dest_4          string
db_create_online_log_dest_5          string
db_domain                            string
db_file_multiblock_read_count	     integer	 128
db_file_name_convert                 string
db_files                             integer	 200
db_flash_cache_file                  string
db_flash_cache_size                  big integer 0
db_flashback_log_dest                string
db_flashback_log_dest_size           big integer 0
db_flashback_retention_target	     integer	 1440
db_index_compression_inheritance     string	     NONE
db_keep_cache_size                   big integer 0
db_lost_write_protect                string      AUTO
db_name                              string      FREE
db_performance_profile               string
db_recovery_file_dest                string
db_recovery_file_dest_size           big integer 0
db_recycle_cache_size                big integer 0
db_securefile                        string      PREFERRED
db_ultra_safe                        string      OFF
db_unique_name                       string      FREE
db_unrecoverable_scn_tracking	     boolean	 TRUE
db_writer_processes                  integer	 1
dbnest_enable                        string	     NONE
dbnest_pdb_fs_conf                   string
dbwr_io_slaves                       integer	 0
ddl_lock_timeout                     integer	 0
default_credential                   string
default_sharing                      string	     metadata
deferred_segment_creation            boolean	 TRUE
dg_broker_config_file1               string	     /opt/oracle/product/23c/dbhomeFree/dbs/dr1FREE.dat
dg_broker_config_file2               string      /opt/oracle/product/23c/dbhomeFree/dbs/dr2FREE.dat
dg_broker_start                      boolean	 FALSE
diagnostic_dest                      string	     /opt/oracle
diagnostics_control                  string	     IGNORE
disable_pdb_featur                   big integer 0
disk_asynch_io                       boolean	 TRUE
dispatchers                          string      (PROTOCOL=TCP) (SERVICE=FREEXDB)
distributed_lock_timeout             integer	 60
dml_locks                            integer	 2076
dnfs_batch_size                      integer	 4096
drcp_connection_limit                integer	 0
drcp_dedicated_opt                   string	     NO
dst_upgrade_insert_conv              boolean	 TRUE
enable_automatic_maintenance_pdb     boolean	 TRUE
enable_ddl_logging                   boolean	 FALSE
enable_dnfs_dispatcher               boolean	 FALSE
enable_goldengate_replication	     boolean	 FALSE
enable_imc_with_mira                 boolean	 FALSE
enable_per_pdb_drcp                  boolean	 FALSE
enable_pluggable_database            boolean	 TRUE
enabled_PDBs_on_standby              string	     *
encrypt_new_tablespaces              string	     CLOUD_ONLY
event				                 string
external_keystore_credential_location string
fal_client                           string
fal_server                           string
fast_start_io_target                 integer	 0
fast_start_mttr_target               integer	 0
fast_start_parallel_rollback	     string	     LOW
file_mapping                         boolean	 FALSE
fileio_network_adapters              string
filesystemio_options                 string	     none
fixed_date                           string
forward_listener                     string
gcs_server_processes                 integer	 0
global_names                         boolean	 FALSE
global_txn_processes                 integer	 1
group_by_position_enabled            boolean	 FALSE
hash_area_size                       integer	 131072
heartbeat_batch_size                 integer	 5
heat_map                             string	     OFF
hi_shared_memory_address             integer	 0
hs_autoregister                      boolean	 TRUE
http_proxy                           string
hybrid_read_only                     boolean	 FALSE
identity_provider_config             string
identity_provider_type               string      NONE
ifile				                 file
ignore_session_set_param_errors      string
inmemory_adg_enabled                 boolean	 TRUE
inmemory_automatic_level             string      OFF
inmemory_clause_default              string
inmemory_deep_vectorization          boolean	 TRUE
inmemory_expressions_usage           string      ENABLE
inmemory_force                       string      DEFAULT
inmemory_graph_algorithm_execution   string      DEFAULT
inmemory_max_populate_servers	     integer	 0
inmemory_optimized_arithmetic	     string      DISABLE
inmemory_prefer_xmem_memcompress     string
inmemory_prefer_xmem_priority	     string
inmemory_query                       string      ENABLE
inmemory_size                        big integer 0
inmemory_trickle_repopulate_servers_percent integer	 1
inmemory_virtual_columns             string      MANUAL
inmemory_xmem_size                   big integer 0
instance_abort_delay_time            integer	 0
instance_groups                      string
instance_mode                        string      READ-WRITE
instance_name                        string      FREE
instance_number                      integer	 0
instance_type                        string      RDBMS
instant_restore                      boolean	 FALSE
iorm_limit_policy                    string      RM_PLAN
ipddb_enable                         boolean	 FALSE
java_jit_enabled                     boolean	 TRUE
java_max_sessionspace_size           integer	 0
java_pool_size                       big integer 0
java_restrict                        string      none
java_soft_sessionspace_limit	     integer	 0
job_queue_processes                  integer	 40
json_behavior_flags                  string
json_expression_check                string      off
kafka_config_file                    string
large_pool_size                      big integer 0
ldap_directory_access                string      NONE
ldap_directory_sysauth               string      no
license_max_sessions                 integer	 0
license_max_users		             integer	 0
license_sessions_warning	         integer	 0
listener_networks		             string
load_without_compile		         string	     none
lob_signature_enable		         boolean	 FALSE
local_listener			             string      LISTENER_FREE
lock_name_space                      string
lock_sga                             boolean	 FALSE
log_archive_config		             string
log_archive_dest		             string
log_archive_dest_1		             string
log_archive_dest_10		             string
log_archive_dest_11		             string
log_archive_dest_12		             string
log_archive_dest_13		             string
log_archive_dest_14		             string
log_archive_dest_15		             string
log_archive_dest_16		             string
log_archive_dest_17		             string
log_archive_dest_18		             string
log_archive_dest_19		             string
log_archive_dest_2		             string
log_archive_dest_20		             string
log_archive_dest_21		             string
log_archive_dest_22		             string
log_archive_dest_23		             string
log_archive_dest_24		             string
log_archive_dest_25		             string
log_archive_dest_26		             string
log_archive_dest_27		             string
log_archive_dest_28		             string
log_archive_dest_29		             string
log_archive_dest_3		             string
log_archive_dest_30		             string
log_archive_dest_31		             string
log_archive_dest_4		             string
log_archive_dest_5		             string
log_archive_dest_6		             string
log_archive_dest_7		             string
log_archive_dest_8		             string
log_archive_dest_9		             string
log_archive_dest_state_1	         string	     enable
log_archive_dest_state_10	         string	     enable
log_archive_dest_state_11	         string	     enable
log_archive_dest_state_12	         string	     enable
log_archive_dest_state_13	         string	     enable
log_archive_dest_state_14	         string	     enable
log_archive_dest_state_15	         string	     enable
log_archive_dest_state_16	         string	     enable
log_archive_dest_state_17	         string	     enable
log_archive_dest_state_18	         string	     enable
log_archive_dest_state_19	         string	     enable
log_archive_dest_state_2	         string	     enable
log_archive_dest_state_20	         string	     enable
log_archive_dest_state_21	         string	     enable
log_archive_dest_state_22	         string	     enable
log_archive_dest_state_23	         string	     enable
log_archive_dest_state_24	         string	     enable
log_archive_dest_state_25	         string	     enable
log_archive_dest_state_26	         string	     enable
log_archive_dest_state_27	         string	     enable
log_archive_dest_state_28	         string	     enable
log_archive_dest_state_29	         string	     enable
log_archive_dest_state_3	         string	     enable
log_archive_dest_state_30	         string	     enable
log_archive_dest_state_31	         string	     enable
log_archive_dest_state_4	         string	     enable
log_archive_dest_state_5	         string	     enable
log_archive_dest_state_6	         string	     enable
log_archive_dest_state_7	         string	     enable
log_archive_dest_state_8	         string	     enable
log_archive_dest_state_9	         string	     enable
log_archive_duplex_dest 	         string
log_archive_format		             string	     %t_%s_%r.dbf
log_archive_max_processes	         integer	 4
log_archive_min_succeed_dest	     integer	 1
log_archive_trace		             integer	 0
log_buffer			                 big integer 4192K
log_checkpoint_interval 	         integer	 0
log_checkpoint_timeout		         integer	 1800
log_checkpoints_to_alert	         boolean	 FALSE
log_file_name_convert		         string
long_module_action		             boolean	 TRUE
main_workload_type		             string	     OLTP
mandatory_user_profile		         string
max_auth_servers		             integer	 25
max_columns			                 string	     STANDARD
max_datapump_jobs_per_pdb	         string	     AUTO
max_datapump_parallel_per_job	     string	     AUTO
max_dispatchers 		             integer
max_dump_file_size		             string	     32M
max_idle_blocker_time		         integer	 0
max_idle_time			             integer	 0
max_iops			                 integer	 0
max_mbps			                 integer	 0
max_pdbs			                 integer	 254
max_saga_duration		             integer	 86400
max_shared_servers		             integer
max_string_size 		             string	     STANDARD
memoptimize_pool_size		         big integer 0
memoptimize_write_area_size	         big integer 0
memoptimize_writes		             string	     HINT
memory_max_size 		             big integer 0
memory_max_target		             big integer 0
memory_size			                 big integer 0
memory_target			             big integer 0
min_auth_servers		             integer	 1
multilingual_engine		             string	     enable
multishard_query_data_consistency    string	     strong
multishard_query_partial_results     string	     not allowed
native_blockchain_features	         string
nls_calendar			             string
nls_comp			                 string	     BINARY
nls_currency			             string
nls_date_format 		             string
nls_date_language		             string
nls_dual_currency		             string
nls_iso_currency		             string
nls_language			             string	     AMERICAN
nls_length_semantics		         string	     BYTE
nls_nchar_conv_excp		             string	     FALSE
nls_numeric_characters		         string
nls_sort			                 string
nls_territory			             string	     AMERICA
nls_time_format 		             string
nls_time_tz_format		             string
nls_timestamp_format		         string
nls_timestamp_tz_format 	         string
noncdb_compatible		             boolean	 FALSE
object_cache_max_size_percent	     integer	 10
object_cache_optimal_size	         integer	 51200000
ofs_threads			                 integer	 4
olap_page_pool_size		             big integer 0
one_step_plugin_for_pdb_with_tde     boolean	 FALSE
open_cursors			             integer	 300
open_links			                 integer	 4
open_links_per_instance 	         integer	 4
optimizer_adaptive_plans	         boolean	 TRUE
optimizer_adaptive_reporting_only    boolean	 FALSE
optimizer_adaptive_statistics	     boolean	 FALSE
optimizer_capture_sql_plan_baselines boolean	 FALSE
optimizer_capture_sql_quarantine     boolean	 FALSE
optimizer_cross_shard_resiliency     boolean	 FALSE
optimizer_dynamic_sampling	         integer	 2
optimizer_features_enable	         string	     23.1.0
optimizer_ignore_hints		         boolean	 FALSE
optimizer_ignore_parallel_hints      boolean	 FALSE
optimizer_index_caching 	         integer	 0
optimizer_index_cost_adj	         integer	 100
optimizer_inmemory_aware	         boolean	 TRUE
optimizer_mode			             string	     ALL_ROWS
optimizer_real_time_statistics	     boolean	 FALSE
optimizer_secure_view_merging	     boolean	 TRUE
optimizer_session_type		         string	     NORMAL
optimizer_use_invisible_indexes      boolean	 FALSE
optimizer_use_pending_statistics     boolean	 FALSE
optimizer_use_sql_plan_baselines     boolean	 TRUE
optimizer_use_sql_quarantine	     boolean	 TRUE
os_authent_prefix		             string	     ops$
os_roles			                 boolean	 FALSE
outbound_dblink_protocols	         string	     ALL
parallel_adaptive_multi_user	     boolean	 FALSE
parallel_degree_limit		         string	     CPU
parallel_degree_policy		         string	     MANUAL
parallel_execution_message_size      integer	 16384
parallel_force_local		         boolean	 FALSE
parallel_instance_group 	         string
parallel_max_servers		         integer	 1
parallel_min_degree		             string	     1
parallel_min_percent		         integer	 0
parallel_min_servers		         integer	 1
parallel_min_time_threshold	         string	     AUTO
parallel_servers_target 	         integer	 1
parallel_threads_per_cpu	         integer	 1
pdb_file_name_convert		         string
pdb_lockdown			             string
pdb_os_credential		             string
pdb_template			             string
pdc_file_size			             big integer 2052K
permit_92_wrap_format		         boolean	 FALSE
pga_aggregate_limit		             big integer 2G
pga_aggregate_target		         big integer 512M
pkcs11_library_location 	         string
plscope_settings		             string	     IDENTIFIERS:NONE
plsql_ccflags			             string
plsql_code_type 		             string	     INTERPRETED
plsql_debug			                 boolean	 FALSE
plsql_implicit_conversion_bool	     boolean	 FALSE
plsql_optimize_level		         integer	 2
plsql_v2_compatibility		         boolean	 FALSE
plsql_warnings			             string	     DISABLE:ALL
pmem_filestore			             string
pre_page_sga			             boolean	 TRUE
private_temp_table_prefix	         string	     ORA$PTT_
processes			                 integer	 300
processor_group_name		         string
query_rewrite_enabled		         string	     TRUE
query_rewrite_integrity 	         string	     enforced
rdbms_server_dn 		             string
read_only			                 boolean	 FALSE
read_only_open_delayed		         boolean	 FALSE
recovery_parallelism		         integer	 0
recyclebin			                 string	     on
redo_transport_user		             string
remote_dependencies_mode	         string	     TIMESTAMP
remote_listener 		             string
remote_login_passwordfile	         string	     EXCLUSIVE
remote_os_roles 		             boolean	 FALSE
remote_recovery_file_dest	         string
replication_dependency_tracking      boolean	 TRUE
resource_limit			             boolean	 TRUE
resource_manage_goldengate	         boolean	 FALSE
resource_manager_cpu_allocation      integer	 0
resource_manager_cpu_scope	         string	     INSTANCE_ONLY
resource_manager_plan		         string
result_cache_auto_blocklist	         string	     ON
result_cache_execution_threshold     integer	 2
result_cache_integrity		         string	     TRUSTED
result_cache_max_result 	         integer	 5
result_cache_max_size		         big integer 7936K
result_cache_max_temp_result	     integer	 5
result_cache_max_temp_size	         big integer 79360K
result_cache_mode		             string	     MANUAL
result_cache_remote_expiration	     integer	 0
resumable_timeout		             integer	 0
rollback_segments		             string
saga_hist_retention		             integer	 43200
scheduler_follow_pdbtz		         boolean	 FALSE
sec_max_failed_login_attempts	     integer	 3
sec_protocol_error_further_action    string	     (DROP,3)
sec_protocol_error_trace_action      string	     TRACE
sec_return_server_release_banner     boolean	 FALSE
serial_reuse			             string	     disable
service_names			             string	     FREE
session_cached_cursors		         integer	 50
session_exit_on_package_state_error  boolean	 FALSE
session_max_open_files		         integer	 10
sessions			                 integer	 472
sga_max_size			             big integer 1536M
sga_min_size			             big integer 0
sga_target			                 big integer 1536M
shadow_core_dump		             string	     partial
shard_enable_raft_follower_read      boolean	 TRUE
shard_queries_restricted_by_key      boolean	 FALSE
shared_memory_address		         integer	 0
shared_pool_reserved_size	         big integer 25836912
shared_pool_size		             big integer 0
shared_server_sessions		         integer
shared_servers			             integer	 1
shrd_dupl_table_refresh_rate	     integer	 60
skip_unusable_indexes		         boolean	 TRUE
smtp_out_server 		             string
soda_behavior_flags		             string
sort_area_retained_size 	         integer	 0
sort_area_size			             integer	 65536
spatial_vector_acceleration	         boolean	 TRUE
spfile				                 string	     /opt/oracle/product/23c/dbhomeFree/dbs/spfileFREE.ora
sql92_security			             boolean	 TRUE
sql_error_mitigation		         string	     off
sql_history_enabled		             boolean	 FALSE
sql_trace			                 boolean	 FALSE
sql_transpiler			             string	     OFF
sqltune_category		             string	     DEFAULT
ssl_wallet			                 string
standby_db_preserve_states	         string	     NONE
standby_file_management 	         string	     MANUAL
standby_pdb_source_file_dblink	     string
standby_pdb_source_file_directory    string
star_transformation_enabled	         string	     FALSE
statement_redirect_service	         string
statistics_level		             string	     TYPICAL
streams_pool_size		             big integer 0
sysdate_at_dbtimezone		         boolean	 FALSE
tablespace_encryption		         string	     MANUAL_ENABLE
tablespace_encryption_default_algorithm string	 AES256
tape_asynch_io			             boolean	 TRUE
target_pdbs			                 integer	 3
tde_configuration		             string
tde_key_cache			             boolean	 FALSE
temp_undo_enabled		             boolean	 FALSE
thread				                 integer	 0
threaded_execution		             boolean	 FALSE
time_at_dbtimezone		             string	    off
timed_os_statistics		             integer	 0
timed_statistics		             boolean	 TRUE
timezone_version_upgrade_integrity   string	     enforced
timezone_version_upgrade_online      boolean	 FALSE
trace_enabled			             boolean	 TRUE
tracefile_content_classification     string	     DISABLE
tracefile_identifier		         string
transactions			             integer	 519
transactions_per_rollback_segment    integer	 5
true_cache			     boolean	 FALSE
txn_auto_rollback_high_priority_wait_target   integer	 2147483647
txn_auto_rollback_medium_priority_wait_target integer	 2147483647
txn_auto_rollback_mode		         string	     ROLLBACK
txn_priority			             string	     HIGH
undo_management 		             string	     AUTO
undo_retention			             integer	 900
undo_tablespace 		             string	     UNDOTBS1
unified_audit_common_systemlog	     string
unified_audit_systemlog 	         string
uniform_log_timestamp_format	     boolean	 TRUE
use_dedicated_broker		         string	     NONE
use_large_pages 		             string	     TRUE
user_dump_dest			             string	     /opt/oracle/product/23c/dbhomeFree/rdbms/log
wallet_root			                 string
workarea_size_policy		         string	     AUTO
xml_client_side_decoding	         string	     true
xml_db_events			             string	     enable
xml_handling_of_invalid_chars	     string	     raise_error
SQL> 
```



# 参考情報
・[Installing Oracle Database Free](https://docs.oracle.com/en/database/oracle/oracle-database/23/xeinl/installing-oracle-database-free.html#GUID-728E4F0A-DBD1-43B1-9837-C6A460432733)
・[Oracle Database 23c Free - Developer Release Get Started（マニュアル）](https://docs.oracle.com/en/database/oracle/oracle-database/23/index.html)