How to Install Oracle Database 23ai on Oracle Linux 9 in 10 Step?

Hello Everyone,

In this blog post, I will give you information about Oracle 23ai features and how to install it. We need Oracle Linux 9 to perform these operations.

1. We will edit the “/etc/selinux/config” file SELINUX=disabled:

[root@oracle ~]# cat /etc/selinux/config
[root@oracle ~]# vi /etc/selinux/config

2. We will stop/disable firewall service and check firewall status:

[root@oracle ~]# systemctl status firewalld 
[root@oracle ~]# systemctl stop firewalld 
[root@oracle ~]# systemctl disable firewalld 
[root@oracle ~]# systemctl status firewalld

3. Adding server name for the server:

[root@oracle ~]# cat /etc/hosts 
[root@oracle ~]# vi /etc/hosts

4. It should be checked whether the virtual machine has internet access:

[root@oracle ~]# ping google.com

5. Version check:

[root@oracle ~]# cat /etc/os-release

6. Logging as “root” user if not:

[sevay@oracle ~]$ su - 
Password: 
[root@oracle ~]# 

7. Install the Oracle Database Preinstallation RPM:

[root@oracle ~]# dnf -y install oracle-database-preinstall-23ai

8. Install the Oracle Database 23ai Software for Oracle Linux 9:

[root@oracle ~]# cd /tmp 
[root@oracle tmp]# dnf -y install https://download.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23ai-1.0-1.el9.x86_64.rpm

Review the RPM log files to determine the system configuration changes. For example, review /var/log/oracle-database-preinstall-23ai/results/orakernel.log .

The path of ORACLE_HOME for the software installation is /opt/oracle/product/23ai/dbhomeFree”.
The installation of the Oracle Database software is now complete.

9. Creating and Configuring an Oracle Database

The configuration script creates a container database (( FREEPDB1 FREE ) with one pluggable database ) and configures the listener at the default port (1521).
You can modify the configuration parameters by editing the oraclefree–23ai.conf file.

[root@oracle tmp]# cat /etc/sysconfig/oracle-free-23ai.conf

To create the database with the default settings:
Run the service configuration script:

[root@oracle tmp]# /etc/init.d/oracle-free-23ai configure

The password will not appear on the screen:
Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts:

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

After the configuration completes, the database and listener are started.

Default .bash_profile parameter, we will edit this file using “vi” editor:

[oracle@oracle ~]$ vi .bash_profile 
# .bash_profile 

# Get the aliases and functions 
if [ -f ~/.bashrc ]; 
then 
. ~/.bashrc 
fi 

# User specific environment and startup programs 
export ORACLE_SID=FREE 
export ORACLE_HOME=/opt/oracle/product/23ai/dbhomeFree
export ORAENV_ASK=NO
export PATH=$ORACLE_HOME/bin:$PATH

[oracle@oracle ~]$ . .bash_profile 

10. Connecting to Database:

Connect to PDB (Pluggable Database) with SYS user:

sqlplus sys@localhost:1521/FREEPDB1 as sysdba

Connect to CDB (Container Database) with SYS user:

sqlplus sys@localhost:1521/FREE as sysdba

DBMASTER BİLGİ TEKNOLOJİLERİ A.Ş.
www.dbmaster.com.tr

SEVAY YILMAZ
Database Operations Manager