Create FREE 23ai Database

After installation of the Oracle database 23ai RPM, we are going to create the FREE database instance:

Oracle Database 23ai installation RPM

In the configuration, we can specify datafiles destination

Default configration file: /etc/sysconfig/oracle-free-23ai.conf

# cat /etc/sysconfig/oracle-free-23ai.conf
LISTENER_PORT=
CHARSET=AL32UTF8
DBFILE_DEST=/oradata
DB_DOMAIN=
CONFIGURE_TDE=false
ENCRYPT_TABLESPACES=
SKIP_VALIDATIONS=false

Create the FREE database, as root

# /etc/init.d/oracle-free-23ai configure
Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 chatain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used fADMIN 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: ol-9u4/FREEPDB1
     Multitenant container database: ol-9u4
[root@ol-9u4 ~]#

As a result, and default destination:

• ORACLE_HOME= /opt/oracle/product/23ai/dbhomeFree
• ORACLE_BASE= /opt/oracle
• LISTENER=1521
• CDB Name: FREE
• PDB Name: freepdb1

Enjoy!