This note describes the process used to install and configure Oracle 23c Free Developer Release on Oracle Linux 8 using an RPM file.
Download the RPM for Oracle Linux via the URL below.
https://www.oracle.com/au/database/free/get-started/
Install the oraclelinux-developer-release-el8 package.
[root@db23c ~]# dnf install -y oraclelinux-developer-release-el8 Oracle Linux 8 BaseOS Latest (x86_64) 1.0 MB/s | 64 MB 01:04 Oracle Linux 8 Application Stream (x86_64) 1.2 MB/s | 49 MB 00:41 Latest Unbreakable Enterprise Kernel Release 6 for Oracle Linux 8 (x86_64) 885 kB/s | 78 MB 01:29 Last metadata expiration check: 0:00:11 ago on Sat 30 Sep 2023 10:58:16 PM EDT. Dependencies resolved. ============================================================================================================================================================================================================================================= Package Architecture Version Repository Size ============================================================================================================================================================================================================================================= Installing: oraclelinux-developer-release-el8 x86_64 1.0-7.el8 ol8_baseos_latest 16 k Upgrading: oraclelinux-release-el8 x86_64 1.0-32.el8 ol8_baseos_latest 22 k Transaction Summary ============================================================================================================================================================================================================================================= Install 1 Package Upgrade 1 Package Total download size: 37 k Downloading Packages: (1/2): oraclelinux-release-el8-1.0-32.el8.x86_64.rpm 59 kB/s | 22 kB 00:00 (2/2): oraclelinux-developer-release-el8-1.0-7.el8.x86_64.rpm 40 kB/s | 16 kB 00:00 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 94 kB/s | 37 kB 00:00 warning: /var/cache/dnf/ol8_baseos_latest-e4c6155830ad002c/packages/oraclelinux-developer-release-el8-1.0-7.el8.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ad986da3: NOKEY Oracle Linux 8 BaseOS Latest (x86_64) 763 kB/s | 3.1 kB 00:00 Importing GPG key 0xAD986DA3: Userid : "Oracle OSS group (Open Source Software group) <build@oss.oracle.com>" Fingerprint: 76FD 3DB1 3AB6 7410 B89D B10E 8256 2EA9 AD98 6DA3 From : /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle Key imported successfully Running transaction check Transaction check succeeded. Running transaction test Transaction test succeeded. Running transaction Preparing : 1/1 Upgrading : oraclelinux-release-el8-1.0-32.el8.x86_64 1/3 Running scriptlet: oraclelinux-release-el8-1.0-32.el8.x86_64 1/3 Installing : oraclelinux-developer-release-el8-1.0-7.el8.x86_64 2/3 Cleanup : oraclelinux-release-el8-1.0-11.el8.x86_64 3/3 Verifying : oraclelinux-developer-release-el8-1.0-7.el8.x86_64 1/3 Verifying : oraclelinux-release-el8-1.0-32.el8.x86_64 2/3 Verifying : oraclelinux-release-el8-1.0-11.el8.x86_64 3/3 Upgraded: oraclelinux-release-el8-1.0-32.el8.x86_64 Installed: oraclelinux-developer-release-el8-1.0-7.el8.x86_64 Complete!
Install the Linux RPM oracle-database-free-23c-1.0-1.el8.x86_64.rpm.
[root@db23c sf_software]# yum -y localinstall oracle-database-free-23c-1.0-1.el8.x86_64.rpm Last metadata expiration check: 15:08:21 ago on Sun 01 Oct 2023 04:23:29 AM EDT. Dependencies resolved. ============================================================================================================================================================================================================================================= Package Architecture Version Repository Size ============================================================================================================================================================================================================================================= Installing: oracle-database-free-23c x86_64 1.0-1 @commandline 1.6 G 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 lm_sensors-libs x86_64 3.4.0-23.20180522git70f7e08.el8 ol8_baseos_latest 59 k oracle-database-preinstall-23c x86_64 1.0-1.el8 ol8_developer 30 k sysstat x86_64 11.7.3-9.0.1.el8 ol8_appstream 427 k Transaction Summary ============================================================================================================================================================================================================================================= Install 6 Packages Total size: 1.6 G Total download size: 2.5 M Installed size: 4.0 G Downloading Packages: (1/5): lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64.rpm 48 kB/s | 59 kB 00:01 (2/5): sysstat-11.7.3-9.0.1.el8.x86_64.rpm 263 kB/s | 427 kB 00:01 (3/5): compat-openssl10-1.0.2o-4.el8_6.x86_64.rpm 364 kB/s | 1.1 MB 00:03 (4/5): ksh-20120801-257.0.1.el8.x86_64.rpm 291 kB/s | 929 kB 00:03 (5/5): oracle-database-preinstall-23c-1.0-1.el8.x86_64.rpm 93 kB/s | 30 kB 00:00 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 811 kB/s | 2.5 MB 00:03 Running transaction check Transaction check succeeded. Running transaction test Transaction test succeeded. Running transaction Preparing : 1/1 Installing : ksh-20120801-257.0.1.el8.x86_64 1/6 Running scriptlet: ksh-20120801-257.0.1.el8.x86_64 1/6 Installing : compat-openssl10-1:1.0.2o-4.el8_6.x86_64 2/6 Running scriptlet: compat-openssl10-1:1.0.2o-4.el8_6.x86_64 2/6 /sbin/ldconfig: /etc/ld.so.conf.d/kernel-5.4.17-2011.1.2.el8uek.x86_64.conf:6: hwcap directive ignored Installing : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 3/6 Running scriptlet: lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 3/6 /sbin/ldconfig: /etc/ld.so.conf.d/kernel-5.4.17-2011.1.2.el8uek.x86_64.conf:6: hwcap directive ignored Installing : sysstat-11.7.3-9.0.1.el8.x86_64 4/6 Running scriptlet: sysstat-11.7.3-9.0.1.el8.x86_64 4/6 Installing : oracle-database-preinstall-23c-1.0-1.el8.x86_64 5/6 Running scriptlet: oracle-database-free-23c-1.0-1.x86_64 6/6 Installing : oracle-database-free-23c-1.0-1.x86_64 6/6 Running scriptlet: oracle-database-free-23c-1.0-1.x86_64 6/6 [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. Running scriptlet: oracle-database-preinstall-23c-1.0-1.el8.x86_64 6/6 Running scriptlet: oracle-database-free-23c-1.0-1.x86_64 6/6 /sbin/ldconfig: /etc/ld.so.conf.d/kernel-5.4.17-2011.1.2.el8uek.x86_64.conf:6: hwcap directive ignored Verifying : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 1/6 Verifying : compat-openssl10-1:1.0.2o-4.el8_6.x86_64 2/6 Verifying : ksh-20120801-257.0.1.el8.x86_64 3/6 Verifying : sysstat-11.7.3-9.0.1.el8.x86_64 4/6 Verifying : oracle-database-preinstall-23c-1.0-1.el8.x86_64 5/6 Verifying : oracle-database-free-23c-1.0-1.x86_64 6/6 Installed: compat-openssl10-1:1.0.2o-4.el8_6.x86_64 ksh-20120801-257.0.1.el8.x86_64 lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 oracle-database-free-23c-1.0-1.x86_64 oracle-database-preinstall-23c-1.0-1.el8.x86_64 sysstat-11.7.3-9.0.1.el8.x86_64 Complete! [root@db23c sf_software]#
Note the contents of the /etc/sysconfig/oracle-free-23c.conf file. We will edit the file to customize the Oracle 23c installation.
[root@db23c sf_software]# 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= # 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
Create the directory structure for the Oracle database files and edit the /etc/sysconfig/oracle-free-23c.conf file as required.
[root@db23c /]# mkdir u01 [root@db23c /]# cd /u01 [root@db23c u01]# mkdir oracle [root@db23c u01]# cd oracle [root@db23c oracle]# mkdir oradata [root@db23c oracle]# cd /u01 [root@db23c u01]# chown -fR oracle:oinstall oracle #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=1522 # Character set of the database CHARSET=AL32UTF8 # Database file directory # If not specified, database files are stored under Oracle base/oradata DBFILE_DEST=/u01/oracle/oradata # DB Domain name DB_DOMAIN=localdomain # SKIP Validations, memory, space SKIP_VALIDATIONS=false
Execute the /etc/init.d/oracle-free-23c configure command to create the Oracle 23c container and pluggable database.
[root@db23c oradata]# /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.localdomain
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: db23c.localdomain:1522/FREEPDB1
Multitenant container database: db23c.localdomain:1522
View the database files created in the /u01/oracle/oradata location specified in the /etc/sysconfig/oracle-free-23c.conf file. Note that the Container Database name is FREE and the Pluggable Database name is FREEPDB1.
[root@db23c oradata]# ls -l /u01/oracle/oradata/FREE total 2362188 -rw-r-----. 1 oracle oinstall 18759680 Oct 1 19:55 control01.ctl -rw-r-----. 1 oracle oinstall 18759680 Oct 1 19:55 control02.ctl drwxr-x---. 2 oracle oinstall 104 Oct 1 19:50 FREEPDB1 drwxr-x---. 2 oracle oinstall 85 Oct 1 19:48 pdbseed -rw-r-----. 1 oracle oinstall 209715712 Oct 1 19:54 redo01.log -rw-r-----. 1 oracle oinstall 209715712 Oct 1 19:50 redo02.log -rw-r-----. 1 oracle oinstall 209715712 Oct 1 19:50 redo03.log -rw-r-----. 1 oracle oinstall 587210752 Oct 1 19:50 sysaux01.dbf -rw-r-----. 1 oracle oinstall 1111498752 Oct 1 19:50 system01.dbf -rw-r-----. 1 oracle oinstall 20979712 Oct 1 19:49 temp01.dbf -rw-r-----. 1 oracle oinstall 47194112 Oct 1 19:50 undotbs01.dbf -rw-r-----. 1 oracle oinstall 5251072 Oct 1 19:50 users01.dbf
Connect to the Oracle 23c database as the SYS user
[oracle@db23c oradata]$ . oraenv
ORACLE_SID = [oracle] ? FREE
The Oracle base has been set to /opt/oracle
[oracle@db23c oradata]$ echo $ORACLE_HOME
/opt/oracle/product/23c/dbhomeFree
[oracle@db23c oradata]$ sqlplus sys as sysdba
SQL*Plus: Release 23.0.0.0.0 - Production on Sun Oct 1 19:56:56 2023
Version 23.3.0.23.09
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 23c Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.3.0.23.09
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 FREEPDB1 READ WRITE NO
SQL> select comp_name,version,status from dba_registry;
COMP_NAME VERSION STATUS
---------------------------------------- ------------------------------ -----------
Oracle Database Catalog Views 23.0.0.0.0 VALID
Oracle Database Packages and Types 23.0.0.0.0 VALID
Oracle Real Application Clusters 23.0.0.0.0 OPTION OFF
JServer JAVA Virtual Machine 23.0.0.0.0 VALID
Oracle XDK 23.0.0.0.0 VALID
Oracle Database Java Packages 23.0.0.0.0 VALID
OLAP Analytic Workspace 23.0.0.0.0 VALID
Oracle XML Database 23.0.0.0.0 VALID
Oracle Workspace Manager 23.0.0.0.0 VALID
Oracle Text 23.0.0.0.0 VALID
Oracle OLAP API 23.0.0.0.0 VALID
Spatial 23.0.0.0.0 VALID
Oracle Label Security 23.0.0.0.0 VALID
Oracle Database Vault 23.0.0.0.0 VALID
