Create our first 23c instance: FREE

After installing our RPM packages for 23c Oracle database, we are going to create our first Instance named FREE

https://wadhahdaouehi.tn/2023/04/install-23c-oracle-database-free-version/

Install 23c Oracle Database: Free Version

The configuration file: oracle-free-23c.conf

# cat  /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=1521
 Character set of the database
 CHARSET=AL32UTF8
 Database file directory
 If not specified, database files are stored under Oracle base/oradata
 DBFILE_DEST=/u01/app/oracle/oradata
 DB Domain name
 DB_DOMAIN=
 SKIP Validations, memory, space
 SKIP_VALIDATIONS=false

We need to specify the Listener port and the character set and destination of Oracle data files.

# /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: ol19u18/FREEPDB1
      Multitenant container database: ol19u18
 [root@ol19u18 ~]# 

Note: Specify your common PASSWORD.

Note: After the creation we have:

• Database container name: FREE
• One PDB: FREEPDB1
• SID: FREE

Enjoy you PDB database.