Friday, October 11, 2024

How to create oracle 19c database using dbca silent mode ?

 create oracle 19c database using dbca silent mode


dbca : DBCA stands for Database Configuration Assistant, a tool used to create and configure Oracle databases


Login as oracle user or user used to install the oracle binary 

command :


dbca -silent -createDatabase \

-templateName General_Purpose.dbc \

-gdbName HRDB \

-sid HRDB   \

-sysPassword Hrdb123# \

-systemPassword Hrdb123# \

-emConfiguration NONE \

-datafileDestination /u02/oradata \

-storageType FS \

-characterSet AL32UTF8 \

-sampleSchema true \

-enableArchive true -archiveLogMode auto \

-recoveryAreaDestination /u02/fast_recovery_area \

-databaseType MULTIPURPOSE \

-useOMF true \

-initParams db_unique_name=HRDB, db_recovery_file_dest_size=10G, db_create_file_dest='/u02/oradata/', db_create_online_log_dest_1='/u02/oradata/', db_create_online_log_dest_2='/u02/fast_recovery_area/', dg_broker_start=false \

-ignorePreReqs



[oracle@test ~]$ dbca -silent -createDatabase \

> -templateName General_Purpose.dbc \

> -gdbName HRDB \

> -sid HRDB   \

> -sysPassword Hrdb123# \

> -systemPassword Hrdb123# \

> -emConfiguration NONE \

> -datafileDestination /u02/oradata \

> -storageType FS \

> -characterSet AL32UTF8 \

> -sampleSchema true \

> -enableArchive true -archiveLogMode auto \

> -recoveryAreaDestination /u02/fast_recovery_area \

> -initParams db_unique_name=HRDB, db_recovery_file_dest_size=10G, db_create_file_dest='/u02/oradata/', db_create_online_log_dest_1='/u02/oradata/', db_create_online_log_dest_2='/u02/fast_recovery_area/', dg_broker_start=false \

> -databaseType MULTIPURPOSE \

> -useOMF true \

> -ignorePreReqs

Prepare for db operation

10% complete

Copying database files

40% complete

Creating and starting Oracle instance

42% complete

46% complete

50% complete

54% complete

58% complete

60% complete

Completing Database Creation

66% complete

69% complete

70% complete

Executing Post Configuration Actions

100% complete

Database creation complete. For details check the logfiles at:

 /u01/app/oracle/cfgtoollogs/dbca/HRDB.

Database Information:

Global Database Name:HRDB

System Identifier(SID):HRDB

Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/HRDB/HRDB.log" for further details.

[oracle@test ~]$

Saturday, September 28, 2024

How to Install Oracle Database 23ai on Linux 9 - Future Database

Installing Oracle Database 23ai on Linux 9


Required software & RPM :


*. Login as root 

1. Upgrade All Packages

dnf -y upgrade

 

[root@ip-172-30-5-90 ~]#

[root@ip-172-30-5-90 ~]#

[root@ip-172-30-5-90 ~]# dnf -y upgrade

Updating Subscription Management repositories.

Unable to read consumer identity

 

This system is not registered with an entitlement server. You can use "rhc" or "subscription-manager" to register.

 

Red Hat Enterprise Linux 9 for x86_64 - AppStream from RHUI (RPMs)                             18 kB/s | 4.5 kB     00:00

Red Hat Enterprise Linux 9 for x86_64 - BaseOS from RHUI (RPMs)                                16 kB/s | 4.1 kB     00:00

Red Hat Enterprise Linux 9 Client Configuration                                               6.3 kB/s | 1.5 kB     00:00

Dependencies resolved.

Nothing to do.

Complete!

[root@ip-172-30-5-90 ~]#

[root@ip-172-30-5-90 ~]#

[root@ip-172-30-5-90 ~]#

 

 

2. Selinux Disable or Permissive

 

We can do disabled or permissive

 

vi /etc/selinux/config

 

SELINUX=permissive

 

setenforce Permissive

 

 

3. Firewall Stop and Disable

 

systemctl status firewalld.service

 

systemctl stop firewalld.service

 

systemctl disable firewalld.service

 

 

4. Package Installation

 

[root@ip-172-30-5-90 software]# dnf install wget*

Updating Subscription Management repositories.

Unable to read consumer identity

 

This system is not registered with an entitlement server. You can use "rhc" or "subscription-manager" to register.

 

Last metadata expiration check: 0:03:57 ago on Sat 28 Sep 2024 12:08:47 PM UTC.

Dependencies resolved.

==============================================================================================================================

 Package              Architecture           Version                         Repository                                  Size

==============================================================================================================================

Installing:

 wget                 x86_64                 1.21.1-8.el9_4                  rhel-9-appstream-rhui-rpms                 789 k

 

Transaction Summary

==============================================================================================================================

Install  1 Package

 

Total download size: 789 k

Installed size: 3.1 M

Is this ok [y/N]: y

Downloading Packages:

wget-1.21.1-8.el9_4.x86_64.rpm                                                                 16 MB/s | 789 kB     00:00

------------------------------------------------------------------------------------------------------------------------------

Total                                                                                          10 MB/s | 789 kB     00:00

Running transaction check

Transaction check succeeded.

Running transaction test

Transaction test succeeded.

Running transaction

  Preparing        :                                                                                                      1/1

  Installing       : wget-1.21.1-8.el9_4.x86_64                                                                           1/1

  Running scriptlet: wget-1.21.1-8.el9_4.x86_64                                                                           1/1

  Verifying        : wget-1.21.1-8.el9_4.x86_64                                                                           1/1

Installed products updated.

 

Installed:

  wget-1.21.1-8.el9_4.x86_64

 

Complete!

[root@ip-172-30-5-90 software]#

 

[root@ip-172-30-5-90 software]# wget https://yum.oracle.com/repo/OracleLinux/OL9/appstream/x86_64/getPackage/oracle-database-preinstall-23ai-1.0-2.el9.x86_64.rpm

--2024-09-28 12:13:14--  https://yum.oracle.com/repo/OracleLinux/OL9/appstream/x86_64/getPackage/oracle-database-preinstall-23ai-1.0-2.el9.x86_64.rpm

Resolving yum.oracle.com (yum.oracle.com)... 23.44.73.197, 2600:1406:2e00:896::2a7d, 2600:1406:2e00:8a0::2a7d

Connecting to yum.oracle.com (yum.oracle.com)|23.44.73.197|:443... connected.

HTTP request sent, awaiting response... 200 OK

Length: 35689 (35K) [application/x-rpm]

Saving to: ‘oracle-database-preinstall-23ai-1.0-2.el9.x86_64.rpm’

 

oracle-database-preinstall-23ai 100%[=====================================================>]  34.85K  --.-KB/s    in 0.002s

 

2024-09-28 12:13:14 (22.1 MB/s) - ‘oracle-database-preinstall-23ai-1.0-2.el9.x86_64.rpm’ saved [35689/35689]

 

[root@ip-172-30-5-90 software]#

 

[root@ip-172-30-5-90 software]# ls -lrt

total 36

-rw-r--r--. 1 root root 35689 Apr 27 17:57 oracle-database-preinstall-23ai-1.0-2.el9.x86_64.rpm

[root@ip-172-30-5-90 software]#

 

 

 

 

[root@ip-172-30-5-90 software]# dnf -y install oracle-database-preinstall-23ai-1.0-2.el9.x86_64.rpm

Updating Subscription Management repositories.

Unable to read consumer identity

 

This system is not registered with an entitlement server. You can use "rhc" or "subscription-manager" to register.

 

Last metadata expiration check: 0:05:26 ago on Sat 28 Sep 2024 12:08:47 PM UTC.

Dependencies resolved.

==============================================================================================================================

 Package                                Architecture  Version                         Repository                         Size

==============================================================================================================================

Installing:

 oracle-database-preinstall-23ai        x86_64        1.0-2.el9                       @commandline                       35 k

Installing dependencies:

 avahi-libs                             x86_64        0.8-20.el9                      rhel-9-baseos-rhui-rpms            72 k

 bc                                     x86_64        1.07.1-14.el9                   rhel-9-baseos-rhui-rpms           125 k

 bind-libs                              x86_64        32:9.16.23-18.el9_4.6           rhel-9-appstream-rhui-rpms        1.2 M

 bind-license                           noarch        32:9.16.23-18.el9_4.6           rhel-9-appstream-rhui-rpms         14 k

 bind-utils                             x86_64        32:9.16.23-18.el9_4.6           rhel-9-appstream-rhui-rpms        214 k

 fontconfig                             x86_64        2.14.0-2.el9_1                  rhel-9-appstream-rhui-rpms        301 k

 fstrm                                  x86_64        0.6.1-3.el9                     rhel-9-appstream-rhui-rpms         30 k

 glibc-devel                            x86_64        2.34-100.el9_4.3                rhel-9-appstream-rhui-rpms         37 k

 glibc-headers                          x86_64        2.34-100.el9_4.3                rhel-9-appstream-rhui-rpms        543 k

 gssproxy                               x86_64        0.8.4-6.el9                     rhel-9-baseos-rhui-rpms           114 k

 kernel-headers                         x86_64        5.14.0-427.37.1.el9_4           rhel-9-appstream-rhui-rpms        6.4 M

 keyutils                               x86_64        1.6.3-1.el9                     rhel-9-baseos-rhui-rpms            78 k

 ksh                                    x86_64        3:1.0.6-3.el9                   rhel-9-appstream-rhui-rpms        885 k

 libICE                                 x86_64        1.0.10-8.el9                    rhel-9-appstream-rhui-rpms         73 k

 libSM                                  x86_64        1.2.3-10.el9                    rhel-9-appstream-rhui-rpms         44 k

 libX11                                 x86_64        1.7.0-9.el9                     rhel-9-appstream-rhui-rpms        647 k

 libX11-common                          noarch        1.7.0-9.el9                     rhel-9-appstream-rhui-rpms        209 k

 libX11-xcb                             x86_64        1.7.0-9.el9                     rhel-9-appstream-rhui-rpms         12 k

 libXau                                 x86_64        1.0.9-8.el9                     rhel-9-appstream-rhui-rpms         34 k

 libXcomposite                          x86_64        0.4.5-7.el9                     rhel-9-appstream-rhui-rpms         26 k

 libXext                                x86_64        1.3.4-8.el9                     rhel-9-appstream-rhui-rpms         42 k

 libXi                                  x86_64        1.7.10-8.el9                    rhel-9-appstream-rhui-rpms         41 k

 libXinerama                            x86_64        1.1.4-10.el9                    rhel-9-appstream-rhui-rpms         17 k

 libXmu                                 x86_64        1.1.3-8.el9                     rhel-9-appstream-rhui-rpms         78 k

 libXrandr                              x86_64        1.5.2-8.el9                     rhel-9-appstream-rhui-rpms         30 k

 libXrender                             x86_64        0.9.10-16.el9                   rhel-9-appstream-rhui-rpms         30 k

 libXt                                  x86_64        1.2.0-6.el9                     rhel-9-appstream-rhui-rpms        182 k

 libXtst                                x86_64        1.2.3-16.el9                    rhel-9-appstream-rhui-rpms         23 k

 libXv                                  x86_64        1.0.11-16.el9                   rhel-9-appstream-rhui-rpms         21 k

 libXxf86dga                            x86_64        1.1.5-8.el9                     rhel-9-appstream-rhui-rpms         23 k

 libXxf86vm                             x86_64        1.1.4-18.el9                    rhel-9-appstream-rhui-rpms         21 k

 libaio                                 x86_64        0.3.111-13.el9                  rhel-9-baseos-rhui-rpms            26 k

 libdmx                                 x86_64        1.1.4-12.el9                    rhel-9-appstream-rhui-rpms         19 k

 libev                                  x86_64        4.33-5.el9                      rhel-9-baseos-rhui-rpms            56 k

 libnfsidmap                            x86_64        1:2.5.4-26.el9_4                rhel-9-baseos-rhui-rpms            65 k

 libnsl                                 x86_64        2.34-100.el9_4.3                rhel-9-baseos-rhui-rpms            64 k

 libpkgconf                             x86_64        1.7.3-10.el9                    rhel-9-baseos-rhui-rpms            37 k

 libtirpc                               x86_64        1.3.3-8.el9_4                   rhel-9-baseos-rhui-rpms            96 k

 libuv                                  x86_64        1:1.42.0-2.el9_4                rhel-9-appstream-rhui-rpms        151 k

 libverto-libev                         x86_64        0.3.2-3.el9                     rhel-9-baseos-rhui-rpms            15 k

 libxcb                                 x86_64        1.13.1-9.el9                    rhel-9-appstream-rhui-rpms        247 k

 libxcrypt-devel                        x86_64        4.4.18-3.el9                    rhel-9-appstream-rhui-rpms         32 k

 lm_sensors-libs                        x86_64        3.6.0-10.el9                    rhel-9-appstream-rhui-rpms         44 k

 make                                   x86_64        1:4.3-8.el9                     rhel-9-baseos-rhui-rpms           541 k

 net-tools                              x86_64        2.0-0.62.20160912git.el9        rhel-9-baseos-rhui-rpms           309 k

 nfs-utils                              x86_64        1:2.5.4-26.el9_4                rhel-9-baseos-rhui-rpms           462 k

 pcp-conf                               x86_64        6.2.0-5.el9_4                   rhel-9-appstream-rhui-rpms         32 k

 pcp-libs                               x86_64        6.2.0-5.el9_4                   rhel-9-appstream-rhui-rpms        637 k

 pkgconf                                x86_64        1.7.3-10.el9                    rhel-9-baseos-rhui-rpms            45 k

 pkgconf-m4                             noarch        1.7.3-10.el9                    rhel-9-baseos-rhui-rpms            16 k

 pkgconf-pkg-config                     x86_64        1.7.3-10.el9                    rhel-9-baseos-rhui-rpms            12 k

 protobuf-c                             x86_64        1.3.3-13.el9                    rhel-9-baseos-rhui-rpms            37 k

 quota                                  x86_64        1:4.06-6.el9                    rhel-9-baseos-rhui-rpms           202 k

 quota-nls                              noarch        1:4.06-6.el9                    rhel-9-baseos-rhui-rpms            81 k

 rpcbind                                x86_64        1.2.6-7.el9                     rhel-9-baseos-rhui-rpms            62 k

 smartmontools                          x86_64        1:7.2-9.el9                     rhel-9-baseos-rhui-rpms           561 k

 sssd-nfs-idmap                         x86_64        2.9.4-6.el9_4.1                 rhel-9-baseos-rhui-rpms            44 k

 sysstat                                x86_64        12.5.4-8.el9_4                  rhel-9-appstream-rhui-rpms        486 k

 unzip                                  x86_64        6.0-56.el9                      rhel-9-baseos-rhui-rpms           186 k

 xml-common                             noarch        0.6.3-58.el9                    rhel-9-appstream-rhui-rpms         36 k

 xorg-x11-utils                         x86_64        7.5-40.el9                      rhel-9-appstream-rhui-rpms        115 k

 xorg-x11-xauth                         x86_64        1:1.1-10.el9                    rhel-9-appstream-rhui-rpms         38 k

 

Transaction Summary

==============================================================================================================================

Install  63 Packages

 

Total size: 16 M

Total download size: 16 M

Installed size: 34 M

Downloading Packages:

(1/62): libXext-1.3.4-8.el9.x86_64.rpm                                                        900 kB/s |  42 kB     00:00

(2/62): libXtst-1.2.3-16.el9.x86_64.rpm                                                       477 kB/s |  23 kB     00:00

(3/62): libXt-1.2.0-6.el9.x86_64.rpm                                                          3.4 MB/s | 182 kB     00:00

(4/62): libXv-1.0.11-16.el9.x86_64.rpm                                                        2.5 MB/s |  21 kB     00:00

(5/62): libXxf86dga-1.1.5-8.el9.x86_64.rpm                                                    2.6 MB/s |  23 kB     00:00

(6/62): libdmx-1.1.4-12.el9.x86_64.rpm                                                        1.9 MB/s |  19 kB     00:00

(7/62): libXrandr-1.5.2-8.el9.x86_64.rpm                                                      2.9 MB/s |  30 kB     00:00

(8/62): libICE-1.0.10-8.el9.x86_64.rpm                                                        5.1 MB/s |  73 kB     00:00

(9/62): libXi-1.7.10-8.el9.x86_64.rpm                                                         3.6 MB/s |  41 kB     00:00

(10/62): libxcrypt-devel-4.4.18-3.el9.x86_64.rpm                                              3.0 MB/s |  32 kB     00:00

(11/62): xorg-x11-xauth-1.1-10.el9.x86_64.rpm                                                 4.0 MB/s |  38 kB     00:00

(12/62): libSM-1.2.3-10.el9.x86_64.rpm                                                        3.9 MB/s |  44 kB     00:00

(13/62): libXcomposite-0.4.5-7.el9.x86_64.rpm                                                 2.0 MB/s |  26 kB     00:00

(14/62): libXmu-1.1.3-8.el9.x86_64.rpm                                                        6.9 MB/s |  78 kB     00:00

(15/62): libXxf86vm-1.1.4-18.el9.x86_64.rpm                                                   1.9 MB/s |  21 kB     00:00

(16/62): lm_sensors-libs-3.6.0-10.el9.x86_64.rpm                                              4.1 MB/s |  44 kB     00:00

(17/62): xml-common-0.6.3-58.el9.noarch.rpm                                                   3.6 MB/s |  36 kB     00:00

(18/62): fstrm-0.6.1-3.el9.x86_64.rpm                                                         2.8 MB/s |  30 kB     00:00

(19/62): libXau-1.0.9-8.el9.x86_64.rpm                                                        3.0 MB/s |  34 kB     00:00

(20/62): libXinerama-1.1.4-10.el9.x86_64.rpm                                                  1.7 MB/s |  17 kB     00:00

(21/62): libXrender-0.9.10-16.el9.x86_64.rpm                                                  3.0 MB/s |  30 kB     00:00

(22/62): xorg-x11-utils-7.5-40.el9.x86_64.rpm                                                  11 MB/s | 115 kB     00:00

(23/62): libxcb-1.13.1-9.el9.x86_64.rpm                                                        14 MB/s | 247 kB     00:00

(24/62): fontconfig-2.14.0-2.el9_1.x86_64.rpm                                                  21 MB/s | 301 kB     00:00

(25/62): libX11-1.7.0-9.el9.x86_64.rpm                                                         34 MB/s | 647 kB     00:00

(26/62): libX11-common-1.7.0-9.el9.noarch.rpm                                                  17 MB/s | 209 kB     00:00

(27/62): libX11-xcb-1.7.0-9.el9.x86_64.rpm                                                    1.4 MB/s |  12 kB     00:00

(28/62): libuv-1.42.0-2.el9_4.x86_64.rpm                                                       15 MB/s | 151 kB     00:00

(29/62): sysstat-12.5.4-8.el9_4.x86_64.rpm                                                     13 MB/s | 486 kB     00:00

(30/62): bind-license-9.16.23-18.el9_4.6.noarch.rpm                                           1.6 MB/s |  14 kB     00:00

(31/62): bind-libs-9.16.23-18.el9_4.6.x86_64.rpm                                               25 MB/s | 1.2 MB     00:00

(32/62): bind-utils-9.16.23-18.el9_4.6.x86_64.rpm                                              14 MB/s | 214 kB     00:00

(33/62): glibc-devel-2.34-100.el9_4.3.x86_64.rpm                                              4.0 MB/s |  37 kB     00:00

(34/62): glibc-headers-2.34-100.el9_4.3.x86_64.rpm                                             31 MB/s | 543 kB     00:00

(35/62): pcp-conf-6.2.0-5.el9_4.x86_64.rpm                                                    2.3 MB/s |  32 kB     00:00

(36/62): pcp-libs-6.2.0-5.el9_4.x86_64.rpm                                                     29 MB/s | 637 kB     00:00

(37/62): bc-1.07.1-14.el9.x86_64.rpm                                                          7.8 MB/s | 125 kB     00:00

(38/62): libaio-0.3.111-13.el9.x86_64.rpm                                                     2.6 MB/s |  26 kB     00:00

(39/62): libev-4.33-5.el9.x86_64.rpm                                                          5.5 MB/s |  56 kB     00:00

(40/62): libverto-libev-0.3.2-3.el9.x86_64.rpm                                                1.1 MB/s |  15 kB     00:00

(41/62): kernel-headers-5.14.0-427.37.1.el9_4.x86_64.rpm                                       60 MB/s | 6.4 MB     00:00

(42/62): net-tools-2.0-0.62.20160912git.el9.x86_64.rpm                                        7.1 MB/s | 309 kB     00:00

(43/62): quota-4.06-6.el9.x86_64.rpm                                                           17 MB/s | 202 kB     00:00

(44/62): quota-nls-4.06-6.el9.noarch.rpm                                                      6.8 MB/s |  81 kB     00:00

(45/62): unzip-6.0-56.el9.x86_64.rpm                                                           16 MB/s | 186 kB     00:00

(46/62): keyutils-1.6.3-1.el9.x86_64.rpm                                                      6.3 MB/s |  78 kB     00:00

(47/62): libpkgconf-1.7.3-10.el9.x86_64.rpm                                                   3.4 MB/s |  37 kB     00:00

(48/62): pkgconf-1.7.3-10.el9.x86_64.rpm                                                      3.7 MB/s |  45 kB     00:00

(49/62): pkgconf-m4-1.7.3-10.el9.noarch.rpm                                                   1.3 MB/s |  16 kB     00:00

(50/62): pkgconf-pkg-config-1.7.3-10.el9.x86_64.rpm                                           1.2 MB/s |  12 kB     00:00

(51/62): gssproxy-0.8.4-6.el9.x86_64.rpm                                                      9.4 MB/s | 114 kB     00:00

(52/62): ksh-1.0.6-3.el9.x86_64.rpm                                                           3.2 MB/s | 885 kB     00:00

(53/62): protobuf-c-1.3.3-13.el9.x86_64.rpm                                                   2.6 MB/s |  37 kB     00:00

(54/62): avahi-libs-0.8-20.el9.x86_64.rpm                                                     6.5 MB/s |  72 kB     00:00

(55/62): libtirpc-1.3.3-8.el9_4.x86_64.rpm                                                    7.6 MB/s |  96 kB     00:00

(56/62): make-4.3-8.el9.x86_64.rpm                                                             33 MB/s | 541 kB     00:00

(57/62): rpcbind-1.2.6-7.el9.x86_64.rpm                                                       3.9 MB/s |  62 kB     00:00

(58/62): sssd-nfs-idmap-2.9.4-6.el9_4.1.x86_64.rpm                                            4.5 MB/s |  44 kB     00:00

(59/62): libnsl-2.34-100.el9_4.3.x86_64.rpm                                                   6.5 MB/s |  64 kB     00:00

(60/62): smartmontools-7.2-9.el9.x86_64.rpm                                                    24 MB/s | 561 kB     00:00

(61/62): libnfsidmap-2.5.4-26.el9_4.x86_64.rpm                                                7.4 MB/s |  65 kB     00:00

(62/62): nfs-utils-2.5.4-26.el9_4.x86_64.rpm                                                   23 MB/s | 462 kB     00:00

------------------------------------------------------------------------------------------------------------------------------

Total                                                                                          32 MB/s |  16 MB     00:00

Running transaction check

Transaction check succeeded.

Running transaction test

Transaction test succeeded.

Running transaction

  Preparing        :                                                                                                      1/1

  Installing       : libtirpc-1.3.3-8.el9_4.x86_64                                                                       1/63

  Installing       : libnfsidmap-1:2.5.4-26.el9_4.x86_64                                                                 2/63

  Installing       : protobuf-c-1.3.3-13.el9.x86_64                                                                      3/63

  Installing       : libuv-1:1.42.0-2.el9_4.x86_64                                                                       4/63

  Installing       : libXau-1.0.9-8.el9.x86_64                                                                           5/63

  Installing       : libxcb-1.13.1-9.el9.x86_64                                                                          6/63

  Installing       : libICE-1.0.10-8.el9.x86_64                                                                          7/63

  Installing       : libSM-1.2.3-10.el9.x86_64                                                                           8/63

  Running scriptlet: rpcbind-1.2.6-7.el9.x86_64                                                                          9/63

  Installing       : rpcbind-1.2.6-7.el9.x86_64                                                                          9/63

  Running scriptlet: rpcbind-1.2.6-7.el9.x86_64                                                                          9/63

Created symlink /etc/systemd/system/multi-user.target.wants/rpcbind.service → /usr/lib/systemd/system/rpcbind.service.

Created symlink /etc/systemd/system/sockets.target.wants/rpcbind.socket → /usr/lib/systemd/system/rpcbind.socket.

 

  Installing       : libnsl-2.34-100.el9_4.3.x86_64                                                                     10/63

  Installing       : smartmontools-1:7.2-9.el9.x86_64                                                                   11/63

  Running scriptlet: smartmontools-1:7.2-9.el9.x86_64                                                                   11/63

Created symlink /etc/systemd/system/multi-user.target.wants/smartd.service → /usr/lib/systemd/system/smartd.service.

 

  Installing       : make-1:4.3-8.el9.x86_64                                                                            12/63

  Installing       : avahi-libs-0.8-20.el9.x86_64                                                                       13/63

  Installing       : pkgconf-m4-1.7.3-10.el9.noarch                                                                     14/63

  Installing       : libpkgconf-1.7.3-10.el9.x86_64                                                                     15/63

  Installing       : pkgconf-1.7.3-10.el9.x86_64                                                                        16/63

  Installing       : pkgconf-pkg-config-1.7.3-10.el9.x86_64                                                             17/63

  Installing       : keyutils-1.6.3-1.el9.x86_64                                                                        18/63

  Installing       : unzip-6.0-56.el9.x86_64                                                                            19/63

  Installing       : quota-nls-1:4.06-6.el9.noarch                                                                      20/63

  Installing       : quota-1:4.06-6.el9.x86_64                                                                          21/63

  Installing       : net-tools-2.0-0.62.20160912git.el9.x86_64                                                          22/63

  Running scriptlet: net-tools-2.0-0.62.20160912git.el9.x86_64                                                          22/63

  Installing       : libev-4.33-5.el9.x86_64                                                                            23/63

  Installing       : libverto-libev-0.3.2-3.el9.x86_64                                                                  24/63

  Installing       : gssproxy-0.8.4-6.el9.x86_64                                                                        25/63

  Running scriptlet: gssproxy-0.8.4-6.el9.x86_64                                                                        25/63

  Running scriptlet: nfs-utils-1:2.5.4-26.el9_4.x86_64                                                                  26/63

  Installing       : nfs-utils-1:2.5.4-26.el9_4.x86_64                                                                  26/63

  Running scriptlet: nfs-utils-1:2.5.4-26.el9_4.x86_64                                                                  26/63

  Installing       : libaio-0.3.111-13.el9.x86_64                                                                       27/63

  Installing       : bc-1.07.1-14.el9.x86_64                                                                            28/63

  Installing       : kernel-headers-5.14.0-427.37.1.el9_4.x86_64                                                        29/63

  Installing       : pcp-conf-6.2.0-5.el9_4.x86_64                                                                      30/63

  Installing       : pcp-libs-6.2.0-5.el9_4.x86_64                                                                      31/63

  Installing       : glibc-headers-2.34-100.el9_4.3.x86_64                                                              32/63

  Installing       : glibc-devel-2.34-100.el9_4.3.x86_64                                                                33/63

  Installing       : libxcrypt-devel-4.4.18-3.el9.x86_64                                                                34/63

  Installing       : bind-license-32:9.16.23-18.el9_4.6.noarch                                                          35/63

  Installing       : libX11-xcb-1.7.0-9.el9.x86_64                                                                      36/63

  Installing       : libX11-common-1.7.0-9.el9.noarch                                                                   37/63

  Installing       : libX11-1.7.0-9.el9.x86_64                                                                          38/63

  Installing       : libXext-1.3.4-8.el9.x86_64                                                                         39/63

  Installing       : libXi-1.7.10-8.el9.x86_64                                                                          40/63

  Installing       : libXrender-0.9.10-16.el9.x86_64                                                                    41/63

  Installing       : libXrandr-1.5.2-8.el9.x86_64                                                                       42/63

  Installing       : libXtst-1.2.3-16.el9.x86_64                                                                        43/63

  Installing       : libXv-1.0.11-16.el9.x86_64                                                                         44/63

  Installing       : libXxf86dga-1.1.5-8.el9.x86_64                                                                     45/63

  Installing       : libdmx-1.1.4-12.el9.x86_64                                                                         46/63

  Installing       : libXxf86vm-1.1.4-18.el9.x86_64                                                                     47/63

  Installing       : libXinerama-1.1.4-10.el9.x86_64                                                                    48/63

  Installing       : libXt-1.2.0-6.el9.x86_64                                                                           49/63

  Installing       : libXmu-1.1.3-8.el9.x86_64                                                                          50/63

  Installing       : xorg-x11-xauth-1:1.1-10.el9.x86_64                                                                 51/63

  Installing       : libXcomposite-0.4.5-7.el9.x86_64                                                                   52/63

  Installing       : xorg-x11-utils-7.5-40.el9.x86_64                                                                   53/63

  Installing       : ksh-3:1.0.6-3.el9.x86_64                                                                           54/63

  Running scriptlet: ksh-3:1.0.6-3.el9.x86_64                                                                           54/63

  Installing       : fstrm-0.6.1-3.el9.x86_64                                                                           55/63

  Installing       : bind-libs-32:9.16.23-18.el9_4.6.x86_64                                                             56/63

  Installing       : bind-utils-32:9.16.23-18.el9_4.6.x86_64                                                            57/63

  Running scriptlet: xml-common-0.6.3-58.el9.noarch                                                                     58/63

  Installing       : xml-common-0.6.3-58.el9.noarch                                                                     58/63

  Installing       : fontconfig-2.14.0-2.el9_1.x86_64                                                                   59/63

  Running scriptlet: fontconfig-2.14.0-2.el9_1.x86_64                                                                   59/63

  Installing       : lm_sensors-libs-3.6.0-10.el9.x86_64                                                                60/63

  Installing       : sysstat-12.5.4-8.el9_4.x86_64                                                                      61/63

  Running scriptlet: sysstat-12.5.4-8.el9_4.x86_64                                                                      61/63

Created symlink /etc/systemd/system/multi-user.target.wants/sysstat.service → /usr/lib/systemd/system/sysstat.service.

Created symlink /etc/systemd/system/sysstat.service.wants/sysstat-collect.timer → /usr/lib/systemd/system/sysstat-collect.timer.

Created symlink /etc/systemd/system/sysstat.service.wants/sysstat-summary.timer → /usr/lib/systemd/system/sysstat-summary.timer.

 

  Installing       : oracle-database-preinstall-23ai-1.0-2.el9.x86_64                                                   62/63

  Installing       : sssd-nfs-idmap-2.9.4-6.el9_4.1.x86_64                                                              63/63

  Running scriptlet: fontconfig-2.14.0-2.el9_1.x86_64                                                                   63/63

  Running scriptlet: oracle-database-preinstall-23ai-1.0-2.el9.x86_64                                                   63/63

  Running scriptlet: sssd-nfs-idmap-2.9.4-6.el9_4.1.x86_64                                                              63/63

  Verifying        : libXext-1.3.4-8.el9.x86_64                                                                          1/63

  Verifying        : libXt-1.2.0-6.el9.x86_64                                                                            2/63

  Verifying        : libXtst-1.2.3-16.el9.x86_64                                                                         3/63

  Verifying        : libXv-1.0.11-16.el9.x86_64                                                                          4/63

  Verifying        : libXxf86dga-1.1.5-8.el9.x86_64                                                                      5/63

  Verifying        : libdmx-1.1.4-12.el9.x86_64                                                                          6/63

  Verifying        : libXrandr-1.5.2-8.el9.x86_64                                                                        7/63

  Verifying        : libICE-1.0.10-8.el9.x86_64                                                                          8/63

  Verifying        : libXi-1.7.10-8.el9.x86_64                                                                           9/63

  Verifying        : libxcrypt-devel-4.4.18-3.el9.x86_64                                                                10/63

  Verifying        : xorg-x11-xauth-1:1.1-10.el9.x86_64                                                                 11/63

  Verifying        : libSM-1.2.3-10.el9.x86_64                                                                          12/63

  Verifying        : libXcomposite-0.4.5-7.el9.x86_64                                                                   13/63

  Verifying        : libXmu-1.1.3-8.el9.x86_64                                                                          14/63

  Verifying        : libXxf86vm-1.1.4-18.el9.x86_64                                                                     15/63

  Verifying        : lm_sensors-libs-3.6.0-10.el9.x86_64                                                                16/63

  Verifying        : xml-common-0.6.3-58.el9.noarch                                                                     17/63

  Verifying        : fstrm-0.6.1-3.el9.x86_64                                                                           18/63

  Verifying        : libXau-1.0.9-8.el9.x86_64                                                                          19/63

  Verifying        : libXinerama-1.1.4-10.el9.x86_64                                                                    20/63

  Verifying        : libXrender-0.9.10-16.el9.x86_64                                                                    21/63

  Verifying        : libxcb-1.13.1-9.el9.x86_64                                                                         22/63

  Verifying        : xorg-x11-utils-7.5-40.el9.x86_64                                                                   23/63

  Verifying        : fontconfig-2.14.0-2.el9_1.x86_64                                                                   24/63

  Verifying        : libX11-1.7.0-9.el9.x86_64                                                                          25/63

  Verifying        : ksh-3:1.0.6-3.el9.x86_64                                                                           26/63

  Verifying        : libX11-common-1.7.0-9.el9.noarch                                                                   27/63

  Verifying        : libX11-xcb-1.7.0-9.el9.x86_64                                                                      28/63

  Verifying        : libuv-1:1.42.0-2.el9_4.x86_64                                                                      29/63

  Verifying        : sysstat-12.5.4-8.el9_4.x86_64                                                                      30/63

  Verifying        : bind-libs-32:9.16.23-18.el9_4.6.x86_64                                                             31/63

  Verifying        : bind-license-32:9.16.23-18.el9_4.6.noarch                                                          32/63

  Verifying        : bind-utils-32:9.16.23-18.el9_4.6.x86_64                                                            33/63

  Verifying        : glibc-devel-2.34-100.el9_4.3.x86_64                                                                34/63

  Verifying        : glibc-headers-2.34-100.el9_4.3.x86_64                                                              35/63

  Verifying        : pcp-conf-6.2.0-5.el9_4.x86_64                                                                      36/63

  Verifying        : pcp-libs-6.2.0-5.el9_4.x86_64                                                                      37/63

  Verifying        : kernel-headers-5.14.0-427.37.1.el9_4.x86_64                                                        38/63

  Verifying        : bc-1.07.1-14.el9.x86_64                                                                            39/63

  Verifying        : libaio-0.3.111-13.el9.x86_64                                                                       40/63

  Verifying        : libev-4.33-5.el9.x86_64                                                                            41/63

  Verifying        : libverto-libev-0.3.2-3.el9.x86_64                                                                  42/63

  Verifying        : net-tools-2.0-0.62.20160912git.el9.x86_64                                                          43/63

  Verifying        : quota-1:4.06-6.el9.x86_64                                                                          44/63

  Verifying        : quota-nls-1:4.06-6.el9.noarch                                                                      45/63

  Verifying        : unzip-6.0-56.el9.x86_64                                                                            46/63

  Verifying        : keyutils-1.6.3-1.el9.x86_64                                                                        47/63

  Verifying        : libpkgconf-1.7.3-10.el9.x86_64                                                                     48/63

  Verifying        : pkgconf-1.7.3-10.el9.x86_64                                                                        49/63

  Verifying        : pkgconf-m4-1.7.3-10.el9.noarch                                                                     50/63

  Verifying        : pkgconf-pkg-config-1.7.3-10.el9.x86_64                                                             51/63

  Verifying        : gssproxy-0.8.4-6.el9.x86_64                                                                        52/63

  Verifying        : protobuf-c-1.3.3-13.el9.x86_64                                                                     53/63

  Verifying        : avahi-libs-0.8-20.el9.x86_64                                                                       54/63

  Verifying        : libtirpc-1.3.3-8.el9_4.x86_64                                                                      55/63

  Verifying        : make-1:4.3-8.el9.x86_64                                                                            56/63

  Verifying        : rpcbind-1.2.6-7.el9.x86_64                                                                         57/63

  Verifying        : smartmontools-1:7.2-9.el9.x86_64                                                                   58/63

  Verifying        : sssd-nfs-idmap-2.9.4-6.el9_4.1.x86_64                                                              59/63

  Verifying        : libnsl-2.34-100.el9_4.3.x86_64                                                                     60/63

  Verifying        : libnfsidmap-1:2.5.4-26.el9_4.x86_64                                                                61/63

  Verifying        : nfs-utils-1:2.5.4-26.el9_4.x86_64                                                                  62/63

  Verifying        : oracle-database-preinstall-23ai-1.0-2.el9.x86_64                                                   63/63

Installed products updated.

 

Installed:

  avahi-libs-0.8-20.el9.x86_64                                      bc-1.07.1-14.el9.x86_64

  bind-libs-32:9.16.23-18.el9_4.6.x86_64                            bind-license-32:9.16.23-18.el9_4.6.noarch

  bind-utils-32:9.16.23-18.el9_4.6.x86_64                           fontconfig-2.14.0-2.el9_1.x86_64

  fstrm-0.6.1-3.el9.x86_64                                          glibc-devel-2.34-100.el9_4.3.x86_64

  glibc-headers-2.34-100.el9_4.3.x86_64                             gssproxy-0.8.4-6.el9.x86_64

  kernel-headers-5.14.0-427.37.1.el9_4.x86_64                       keyutils-1.6.3-1.el9.x86_64

  ksh-3:1.0.6-3.el9.x86_64                                          libICE-1.0.10-8.el9.x86_64

  libSM-1.2.3-10.el9.x86_64                                         libX11-1.7.0-9.el9.x86_64

  libX11-common-1.7.0-9.el9.noarch                                  libX11-xcb-1.7.0-9.el9.x86_64

  libXau-1.0.9-8.el9.x86_64                                         libXcomposite-0.4.5-7.el9.x86_64

  libXext-1.3.4-8.el9.x86_64                                        libXi-1.7.10-8.el9.x86_64

  libXinerama-1.1.4-10.el9.x86_64                                   libXmu-1.1.3-8.el9.x86_64

  libXrandr-1.5.2-8.el9.x86_64                                      libXrender-0.9.10-16.el9.x86_64

  libXt-1.2.0-6.el9.x86_64                                          libXtst-1.2.3-16.el9.x86_64

  libXv-1.0.11-16.el9.x86_64                                        libXxf86dga-1.1.5-8.el9.x86_64

  libXxf86vm-1.1.4-18.el9.x86_64                                    libaio-0.3.111-13.el9.x86_64

  libdmx-1.1.4-12.el9.x86_64                                        libev-4.33-5.el9.x86_64

  libnfsidmap-1:2.5.4-26.el9_4.x86_64                               libnsl-2.34-100.el9_4.3.x86_64

  libpkgconf-1.7.3-10.el9.x86_64                                    libtirpc-1.3.3-8.el9_4.x86_64

  libuv-1:1.42.0-2.el9_4.x86_64                                     libverto-libev-0.3.2-3.el9.x86_64

  libxcb-1.13.1-9.el9.x86_64                                        libxcrypt-devel-4.4.18-3.el9.x86_64

  lm_sensors-libs-3.6.0-10.el9.x86_64                               make-1:4.3-8.el9.x86_64

  net-tools-2.0-0.62.20160912git.el9.x86_64                         nfs-utils-1:2.5.4-26.el9_4.x86_64

  oracle-database-preinstall-23ai-1.0-2.el9.x86_64                  pcp-conf-6.2.0-5.el9_4.x86_64

  pcp-libs-6.2.0-5.el9_4.x86_64                                     pkgconf-1.7.3-10.el9.x86_64

  pkgconf-m4-1.7.3-10.el9.noarch                                    pkgconf-pkg-config-1.7.3-10.el9.x86_64

  protobuf-c-1.3.3-13.el9.x86_64                                    quota-1:4.06-6.el9.x86_64

  quota-nls-1:4.06-6.el9.noarch                                     rpcbind-1.2.6-7.el9.x86_64

  smartmontools-1:7.2-9.el9.x86_64                                  sssd-nfs-idmap-2.9.4-6.el9_4.1.x86_64

  sysstat-12.5.4-8.el9_4.x86_64                                     unzip-6.0-56.el9.x86_64

  xml-common-0.6.3-58.el9.noarch                                    xorg-x11-utils-7.5-40.el9.x86_64

  xorg-x11-xauth-1:1.1-10.el9.x86_64

 

Complete!

[root@ip-172-30-5-90 software]#

 

 

 

[root@ip-172-30-5-90 software]#

[root@ip-172-30-5-90 software]# reboot

[root@ip-172-30-5-90 software]#

 

 

[root@ip-172-30-5-90 ~]# cat /etc/sysctl.conf

# sysctl settings are defined through files in

# /usr/lib/sysctl.d/, /run/sysctl.d/, and /etc/sysctl.d/.

#

# Vendors settings live in /usr/lib/sysctl.d/.

# To override a whole file, create a new file with the same in

# /etc/sysctl.d/ and put new settings there. To override

# only specific settings, add a file with a lexically later

# name in /etc/sysctl.d/ and put new settings there.

#

# For more information, see sysctl.conf(5) and sysctl.d(5).

 

# oracle-database-preinstall-23ai setting for fs.file-max is 6815744

fs.file-max = 6815744

 

# oracle-database-preinstall-23ai setting for kernel.sem is '250 32000 100 128'

kernel.sem = 250 32000 100 128

 

# oracle-database-preinstall-23ai setting for kernel.shmmni is 4096

kernel.shmmni = 4096

 

# oracle-database-preinstall-23ai setting for kernel.shmall is 1073741824 on x86_64

kernel.shmall = 1073741824

 

# oracle-database-preinstall-23ai setting for kernel.shmmax is 4398046511104 on x86_64

kernel.shmmax = 4398046511104

 

# oracle-database-preinstall-23ai setting for kernel.panic_on_oops is 1 per Orabug 19212317

kernel.panic_on_oops = 1

 

# oracle-database-preinstall-23ai setting for net.core.rmem_default is 262144

net.core.rmem_default = 262144

 

# oracle-database-preinstall-23ai setting for net.core.rmem_max is 4194304

net.core.rmem_max = 4194304

 

# oracle-database-preinstall-23ai setting for net.core.wmem_default is 262144

net.core.wmem_default = 262144

 

# oracle-database-preinstall-23ai setting for net.core.wmem_max is 1048576

net.core.wmem_max = 1048576

 

# oracle-database-preinstall-23ai setting for net.ipv4.conf.all.rp_filter is 2

net.ipv4.conf.all.rp_filter = 2

 

# oracle-database-preinstall-23ai setting for net.ipv4.conf.default.rp_filter is 2

net.ipv4.conf.default.rp_filter = 2

 

# oracle-database-preinstall-23ai setting for fs.aio-max-nr is 1048576

fs.aio-max-nr = 1048576

 

# oracle-database-preinstall-23ai setting for net.ipv4.ip_local_port_range is 9000 65500

net.ipv4.ip_local_port_range = 9000 65535

 

# oracle-database-preinstall-23ai setting special parameters BEGIN

# oracle-database-preinstall-23ai setting for kernel.panic is 10

kernel.panic = 10

 

# oracle-database-preinstall-23ai setting special parameters END

[root@ip-172-30-5-90 ~]#

 

 

 

 

[root@ip-172-30-5-90 oracle-database-preinstall-23ai]# cat /etc/sysctl.conf | grep -v "#"

 

fs.file-max = 6815744

 

kernel.sem = 250 32000 100 128

 

kernel.shmmni = 4096

 

kernel.shmall = 1073741824

 

kernel.shmmax = 4398046511104

 

kernel.panic_on_oops = 1

 

net.core.rmem_default = 262144

 

net.core.rmem_max = 4194304

 

net.core.wmem_default = 262144

 

net.core.wmem_max = 1048576

 

net.ipv4.conf.all.rp_filter = 2

 

net.ipv4.conf.default.rp_filter = 2

 

fs.aio-max-nr = 1048576

 

net.ipv4.ip_local_port_range = 9000 65535

 

kernel.panic = 10

 

[root@ip-172-30-5-90 oracle-database-preinstall-23ai]#

 

 

 

 

 

 

5. Downlaod oracle database rpm file

 

[root@ip-172-30-5-90 software]# ls -lrt

total 36

-rw-r--r--. 1 root root 35689 Apr 27 17:57 oracle-database-preinstall-23ai-1.0-2.el9.x86_64.rpm

[root@ip-172-30-5-90 software]#

[root@ip-172-30-5-90 software]# wget https://download.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23ai-1.0-1.el9.x86_64.rpm

--2024-09-28 12:19:20--  https://download.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23ai-1.0-1.el9.x86_64.rpm

Resolving download.oracle.com (download.oracle.com)... 23.44.72.116

Connecting to download.oracle.com (download.oracle.com)|23.44.72.116|:443... connected.

HTTP request sent, awaiting response... 302 Moved Temporarily

Location: https://edelivery.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23ai-1.0-1.el9.x86_64.rpm [following]

--2024-09-28 12:19:20--  https://edelivery.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23ai-1.0-1.el9.x86_64.rpm

Resolving edelivery.oracle.com (edelivery.oracle.com)... 23.47.181.220, 2600:1406:3a00:284::366, 2600:1406:3a00:28d::366

Connecting to edelivery.oracle.com (edelivery.oracle.com)|23.47.181.220|:443... connected.

HTTP request sent, awaiting response... 302 Moved Temporarily

Location: https://download.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23ai-1.0-1.el9.x86_64.rpm?AuthParam=1727526081_e61213bb75af097b5649a1241676ab84 [following]

--2024-09-28 12:19:21--  https://download.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23ai-1.0-1.el9.x86_64.rpm?AuthParam=1727526081_e61213bb75af097b5649a1241676ab84

Connecting to download.oracle.com (download.oracle.com)|23.44.72.116|:443... connected.

HTTP request sent, awaiting response... 200 OK

Length: 1365375132 (1.3G) [application/x-redhat-package-manager]

Saving to: ‘oracle-database-free-23ai-1.0-1.el9.x86_64.rpm’

 

oracle-database-free-23ai-1.0-1 100%[=====================================================>]   1.27G  94.5MB/s    in 13s

 

2024-09-28 12:19:33 (102 MB/s) - ‘oracle-database-free-23ai-1.0-1.el9.x86_64.rpm’ saved [1365375132/1365375132]

 

[root@ip-172-30-5-90 software]# ls -lrt

total 1333412

-rw-r--r--. 1 root root      35689 Apr 27 17:57 oracle-database-preinstall-23ai-1.0-2.el9.x86_64.rpm

-rw-r--r--  1 root root 1365375132 Aug 14 11:03 oracle-database-free-23ai-1.0-1.el9.x86_64.rpm

[root@ip-172-30-5-90 software]#

 

 

[root@ip-172-30-5-90 software]# id oracle

uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)

[root@ip-172-30-5-90 software]#

[root@ip-172-30-5-90 software]#

 

[root@ip-172-30-5-90 oracle-database-preinstall-23ai]# cat /etc/passwd | grep -i oracle

oracle:x:54321:54321::/home/oracle:/bin/bash

[root@ip-172-30-5-90 oracle-database-preinstall-23ai]#

 

 

[root@ip-172-30-5-90 oracle-database-preinstall-23ai]# cat /etc/group | egrep -i "oinstall|dba"

oinstall:x:54321:oracle

dba:x:54322:oracle

backupdba:x:54324:oracle

dgdba:x:54325:oracle

kmdba:x:54326:oracle

racdba:x:54330:oracle

[root@ip-172-30-5-90 oracle-database-preinstall-23ai]#

 

 

 

6. Change oracle User Password

 

When we ran dnf -y install oracle-database-preinstall-23ai-1.0-2.el9.x86_64.rpm, oracle user created. now we can give a password for using ssh connection.

 

passwd oracle

 

 

 

 

[root@ip-172-30-5-90 oracle-database-preinstall-23ai]#

[root@ip-172-30-5-90 oracle-database-preinstall-23ai]# pwd

/etc/sysconfig/oracle-database-preinstall-23ai

[root@ip-172-30-5-90 oracle-database-preinstall-23ai]#

[root@ip-172-30-5-90 oracle-database-preinstall-23ai]# ls -lrt

total 72

-rwx------. 1 root root 55822 Apr 27 17:54 oracle-database-preinstall-23ai-verify

-rw-------. 1 root root  4806 Apr 27 17:54 oracle-database-preinstall-23ai.param

-rwx------. 1 root root  1310 Apr 27 17:54 oracle-database-preinstall-23ai-firstboot

-rw-r--r--. 1 root root    39 Sep 28 12:14 oracle-database-preinstall-23ai.conf

[root@ip-172-30-5-90 oracle-database-preinstall-23ai]#

 

 

 

 

 

[root@ip-172-30-5-90 software]#

[root@ip-172-30-5-90 software]# dnf -y install oracle-database-free-23ai-1.0-1.el9.x86_64.rpm

Updating Subscription Management repositories.

Unable to read consumer identity

 

This system is not registered with an entitlement server. You can use "rhc" or "subscription-manager" to register.

 

Last metadata expiration check: 0:24:16 ago on Sat 28 Sep 2024 12:14:18 PM UTC.

Dependencies resolved.

==============================================================================================================================

 Package                                   Architecture           Version                  Repository                    Size

==============================================================================================================================

Installing:

 oracle-database-free-23ai                 x86_64                 1.0-1                    @commandline                 1.3 G

 

Transaction Summary

==============================================================================================================================

Install  1 Package

 

Total size: 1.3 G

Installed size: 3.5 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-23ai-1.0-1.x86_64                                                               1/1

  Installing       : oracle-database-free-23ai-1.0-1.x86_64                                                               1/1

  Running scriptlet: oracle-database-free-23ai-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-23ai.conf' and then run '/etc/init.d/oracle-free-23ai configure' as root.

 

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

Installed products updated.

 

Installed:

  oracle-database-free-23ai-1.0-1.x86_64

 

Complete!

[root@ip-172-30-5-90 software]#

 

 

 

7. Let's Verify

 

 

[root@ip-172-30-5-90 software]# rpm -qa | grep -i database

oracle-database-preinstall-23ai-1.0-2.el9.x86_64

oracle-database-free-23ai-1.0-1.x86_64

[root@ip-172-30-5-90 software]#

[root@ip-172-30-5-90 software]#

 

[root@ip-172-30-5-90 oracle]# pwd

/opt/oracle

[root@ip-172-30-5-90 oracle]# ls -lrt

total 4

drwxr-xr-x  3 oracle oinstall   18 Sep 28 12:38 product

drwxrwx---  4 oracle oinstall   78 Sep 28 12:41 oraInventory

drwxrwxr-x 25 oracle oinstall 4096 Sep 28 12:41 diag

[root@ip-172-30-5-90 oracle]# cd product/23ai/dbhomeFree/

[root@ip-172-30-5-90 dbhomeFree]# ls

addnode      css        diagnostics    inventory  LICENSE  olap         oss      R              sdk       ucp

assistants   ctx        dv             javavm     log      oml4py       oui      racg           slax      usm

bin          cv         env.ora        jdbc       md       OPatch       perl     rdbms          sqlcl     utl

cfgtoollogs  data       has            jdk        mgw      opmn         plsql    relnotes       sqlj      xdk

clone        dbs        hs             jlib       network  oracore      precomp  root.sh        sqlpatch

crs          deinstall  install        ldap       nls      oraInst.loc  python   runInstaller   sqlplus

crypto       demo       instantclient  lib        odbc     ord          QOpatch  schagent.conf  srvm

[root@ip-172-30-5-90 dbhomeFree]#

 

 

8. Oracle Database 23ai Creation and Configuration

 

The configuration script creates a container database "FREE" with one pluggable database "FREEPDB1" and configures the listener "LISTENER" at the default port "1521".

You can modify the configuration parameters by editing the /etc/sysconfig/oracle-free–23ai.conf file

 

 

[root@ip-172-30-5-90 sysconfig]# more oracle-free-23ai.conf

#This is a configuration file to setup the Oracle Database.

#It is used when running '/etc/init.d/oracle-free-23ai 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=

 

# Configure TDE

CONFIGURE_TDE=false

 

# Encrypt Tablespaces list, Leave empty for user tablespace alone or provide ALL for encrypting all tablespaces

# For specific tablespaces use SYSTEM:true,SYSAUX:false

ENCRYPT_TABLESPACES=

 

# SKIP Validations, memory, space

SKIP_VALIDATIONS=false

[root@ip-172-30-5-90 sysconfig]# pwd

/etc/sysconfig

[root@ip-172-30-5-90 sysconfig]#

 

 

 

 

[INFO] Oracle home installed successfully and ready to be configured.

To configure Oracle Database Free, optionally modify the parameters in '/etc/sysconfig/oracle-free-23ai.conf' and then run '/etc/init.d/oracle-free-23ai configure' as root.

 

/etc/init.d/oracle-free-23ai configure

 

[root@ip-172-30-5-90 sysconfig]# ls -ltr /etc/init.d/oracle-free-23ai

-r-xr-xr-x 1 root root 20518 Aug 10 22:48 /etc/init.d/oracle-free-23ai

[root@ip-172-30-5-90 sysconfig]#

 

[root@ip-172-30-5-90 sysconfig]#

[root@ip-172-30-5-90 sysconfig]# /etc/init.d/oracle-free-23ai status

Status of the Oracle FREE 23ai service:

 

LISTENER status: NOT CONFIGURED

FREE Database status:   NOT CONFIGURED

[root@ip-172-30-5-90 sysconfig]#

 

9.Create & configure oracle database and listener

 

[root@ip-172-30-5-90 sysconfig]#

[root@ip-172-30-5-90 sysconfig]#

[root@ip-172-30-5-90 sysconfig]#

[root@ip-172-30-5-90 sysconfig]# /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: ip-172-30-5-90.us-west-1.compute.internal/FREEPDB1

     Multitenant container database: ip-172-30-5-90.us-west-1.compute.internal

[root@ip-172-30-5-90 sysconfig]#

[root@ip-172-30-5-90 sysconfig]#

 

 

[root@ip-172-30-5-90 sysconfig]#

[root@ip-172-30-5-90 sysconfig]# /etc/init.d/oracle-free-23ai status

Status of the Oracle FREE 23ai service:

 

LISTENER status: RUNNING

FREE Database status:   RUNNING

[root@ip-172-30-5-90 sysconfig]#

 

 

 

10. Verify & validate database installation and configuration

 

 

[root@ip-172-30-5-90 sysconfig]#

[root@ip-172-30-5-90 sysconfig]# ps -ef | grep -i pmon

oracle      3645       1  0 12:58 ?        00:00:00 db_pmon_FREE

root        4130    1128  0 13:01 pts/0    00:00:00 grep --color=auto -i pmon

[root@ip-172-30-5-90 sysconfig]#

[root@ip-172-30-5-90 sysconfig]#

 

 

 

[root@ip-172-30-5-90 sysconfig]#

[root@ip-172-30-5-90 sysconfig]#  ps -ef | grep tns

root           6       2  0 12:34 ?        00:00:00 [netns]

oracle      1616       1  0 12:53 ?        00:00:00 /opt/oracle/product/23ai/dbhomeFree/bin/tnslsnr LISTENER -inherit

root        4134    1128  0 13:02 pts/0    00:00:00 grep --color=auto tns

[root@ip-172-30-5-90 sysconfig]#

[root@ip-172-30-5-90 sysconfig]#

 

 

11. Login as oracle user

 

[oracle@ip-172-30-5-90 ~]$

[oracle@ip-172-30-5-90 ~]$ cat /etc/oratab

#

 

 

 

# This file is used by ORACLE utilities.  It is created by root.sh

# and updated by either Database Configuration Assistant while creating

# a database or ASM Configuration Assistant while creating ASM instance.

 

# A colon, ':', is used as the field terminator.  A new line terminates

# the entry.  Lines beginning with a pound sign, '#', are comments.

#

# Entries are of the form:

#   $ORACLE_SID:$ORACLE_HOME:<N|Y>:

#

# The first and second fields are the system identifier and home

# directory of the database respectively.  The third field indicates

# to the dbstart utility that the database should , "Y", or should not,

# "N", be brought up at system boot time.

#

# Multiple entries with the same $ORACLE_SID are not allowed.

#

#

FREE:/opt/oracle/product/23ai/dbhomeFree:N

[oracle@ip-172-30-5-90 ~]$

 

 

 

[oracle@ip-172-30-5-90 ~]$

[oracle@ip-172-30-5-90 ~]$ . oraenv

ORACLE_SID = [oracle] ? FREE

The Oracle base has been set to /opt/oracle

[oracle@ip-172-30-5-90 ~]$

 

12. Login as sysdba to oracle database

 

[oracle@ip-172-30-5-90 ~]$

[oracle@ip-172-30-5-90 ~]$

[oracle@ip-172-30-5-90 ~]$ sqlplus "/as sysdba"

 

SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Sat Sep 28 13:03:24 2024

Version 23.5.0.24.07

 

Copyright (c) 1982, 2024, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free

Version 23.5.0.24.07

 

SQL>  select name,open_mode,database_role,log_mode from v$database;

 

NAME      OPEN_MODE            DATABASE_ROLE    LOG_MODE

--------- -------------------- ---------------- ------------

FREE      READ WRITE           PRIMARY          NOARCHIVELOG

 

SQL>

 

SQL> select banner from v$version;

 

BANNER

--------------------------------------------------------------------------------

Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free

 

SQL>

SQL>

SQL> show pdbs

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 FREEPDB1                       READ WRITE NO

SQL>

SQL>

 

 

 

[oracle@ip-172-30-5-90 ~]$

[oracle@ip-172-30-5-90 ~]$ lsnrctl status

 

LSNRCTL for Linux: Version 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on 28-SEP-2024 13:04:33

 

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

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ip-172-30-5-90.us-west-1.compute.internal)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 23.0.0.0.0 - for Oracle Cloud and Engineered Systems

Start Date                28-SEP-2024 12:53:23

Uptime                    0 days 0 hr. 11 min. 10 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Default Service           FREE

Listener Parameter File   /opt/oracle/product/23ai/dbhomeFree/network/admin/listener.ora

Listener Log File         /opt/oracle/diag/tnslsnr/ip-172-30-5-90/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ip-172-30-5-90.us-west-1.compute.internal)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Services Summary...

Service "232e865c6dc60f02e0635a051eacd131" has 1 instance(s).

  Instance "FREE", status READY, has 1 handler(s) for this service...

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 "freepdb1" has 1 instance(s).

  Instance "FREE", status READY, has 1 handler(s) for this service...

The command completed successfully

[oracle@ip-172-30-5-90 ~]$

 

 

 

 

===============================

Minimum 1 GB memory is required

================================

 

[root@ip-172-30-5-90 software]#

[root@ip-172-30-5-90 software]# dnf -y install oracle-database-free-23ai-1.0-1.el9.x86_64.rpm

Updating Subscription Management repositories.

Unable to read consumer identity

 

This system is not registered with an entitlement server. You can use "rhc" or "subscription-manager" to register.

 

Last metadata expiration check: 0:15:57 ago on Sat 28 Sep 2024 12:14:18 PM UTC.

Dependencies resolved.

==============================================================================================================================

 Package                                   Architecture           Version                  Repository                    Size

==============================================================================================================================

Installing:

 oracle-database-free-23ai                 x86_64                 1.0-1                    @commandline                 1.3 G

 

Transaction Summary

==============================================================================================================================

Install  1 Package

 

Total size: 1.3 G

Installed size: 3.5 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-23ai-1.0-1.x86_64                                                               1/1

[SEVERE] Oracle Database 23ai Free requires a minimum of 1GB of physical

memory (RAM).  This system has 957 MB of RAM and does not meet minimum

requirements.

 

error: %prein(oracle-database-free-23ai-1.0-1.x86_64) scriptlet failed, exit status 1

 

Error in PREIN scriptlet in rpm package oracle-database-free-23ai

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

Installed products updated.

 

Failed:

  oracle-database-free-23ai-1.0-1.x86_64

 

Error: Transaction failed

[root@ip-172-30-5-90 software]#