Om Om Om Om Om
Friday, November 22, 2024
Welcome Apple M3
I am Anurag Pandey, working as Cloud Database Architect | Migration & Modernization Expert .
Database Administration and Implementation. Provide technical guidance and work with global team.
Extensive Experience in Database Installation and Configuration, Real Application Cluster (RAC), ASM, Dataguard , Patching, Upgrade, RMAN, Performance Tuning, Backup and Recovery, Azure, Google, AWS Cloud, AWS RDS, MySQL, Database Migration Service(DMS),CloudEndure - MGN, Azure Site Recovery, Azure Migrate, Datapump, terraform automation, Ansible
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 ~]$
I am Anurag Pandey, working as Cloud Database Architect | Migration & Modernization Expert .
Database Administration and Implementation. Provide technical guidance and work with global team.
Extensive Experience in Database Installation and Configuration, Real Application Cluster (RAC), ASM, Dataguard , Patching, Upgrade, RMAN, Performance Tuning, Backup and Recovery, Azure, Google, AWS Cloud, AWS RDS, MySQL, Database Migration Service(DMS),CloudEndure - MGN, Azure Site Recovery, Azure Migrate, Datapump, terraform automation, Ansible
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 :
Red-hat Linux 9
Oracle 23ai rpm (
Free Oracle Database – Quick Start Guide )
*. 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]#
I am Anurag Pandey, working as Cloud Database Architect | Migration & Modernization Expert .
Database Administration and Implementation. Provide technical guidance and work with global team.
Extensive Experience in Database Installation and Configuration, Real Application Cluster (RAC), ASM, Dataguard , Patching, Upgrade, RMAN, Performance Tuning, Backup and Recovery, Azure, Google, AWS Cloud, AWS RDS, MySQL, Database Migration Service(DMS),CloudEndure - MGN, Azure Site Recovery, Azure Migrate, Datapump, terraform automation, Ansible
Subscribe to:
Posts (Atom)