Installing Oracle Database 23ai
Oracle
23ai is now introduced RPM-based
installation which also performs preinstallation checks, extracts the database
software, reassigns ownership of the extracted software to the preconfigured
user and groups, maintains the Oracle inventory, and runs all root operations
required to configure the Oracle Database software for a single-instance Oracle
Database creation and configuration.
The RPM–based
installation process detects when the minimum requirements for an installation
are not met and prompts you to finish these minimum preinstallation
requirements.
Its
required initially 10GB disk space under /opt.
Red Hat Enterprise Linux 8
Preinstall RPM: oracle-database-preinstall-23ai-1.0-2.el8.x86_64.rpm
Installing Oracle Database 23ai Free
Install the latest Preinstallation RPM
At
the command prompt, specify a password for the SYS, SYSTEM, and PDBADMIN administrative
user accounts. Oracle recommends that your password should be at least 8 characters
in length, contain at least 1 upper case character, 1 lower case character and,
1 digit [0-9].
[root@rac134 ~]# dnf install -y
oracle-database-preinstall-23ai
Last metadata expiration
check: 0:20:12 ago on Tue 14 May 2024 05:52:32 PM IST.
Dependencies resolved.
==============================================================================================================
Package Architecture
Version Repository Size
==============================================================================================================
Installing:
oracle-database-preinstall-23ai x86_64
1.0-2.el8
ol8_appstream 30 k
Installing dependencies:
compat-openssl10 x86_64 1:1.0.2o-4.el8_6 ol8_appstream 1.1 M
glibc-devel x86_64 2.28-127.0.1.el8 ol8_baseos_latest 1.0 M
ksh x86_64 20120801-259.0.1.el8 ol8_appstream 923 k
libxcrypt-devel x86_64 4.1.1-4.el8 ol8_baseos_latest 25 k
lm_sensors-libs x86_64 3.4.0-23.20180522git70f7e08.el8 ol8_baseos_latest 59 k
make x86_64 1:4.2.1-11.el8 ol8_baseos_latest 498 k
sysstat x86_64 11.7.3-11.0.1.el8 ol8_appstream 427 k
Transaction Summary
==============================================================================================================
Install 8 Packages
Total download size: 4.1
M
Installed size: 10 M
Downloading Packages:
(1/8):
lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64.rpm 249
kB/s | 59 kB 00:00
(2/8):
make-4.2.1-11.el8.x86_64.rpm 4.3 MB/s | 498 kB 00:00
(3/8):
libxcrypt-devel-4.1.1-4.el8.x86_64.rpm 7.1 kB/s |
25 kB 00:03
(4/8):
ksh-20120801-259.0.1.el8.x86_64.rpm 5.6 MB/s | 923 kB 00:00
(5/8):
compat-openssl10-1.0.2o-4.el8_6.x86_64.rpm 345 kB/s | 1.1 MB 00:03
(6/8):
oracle-database-preinstall-23ai-1.0-2.el8.x86_64.rpm 556 kB/s |
30 kB 00:00
(7/8): sysstat-11.7.3-11.0.1.el8.x86_64.rpm 6.8 MB/s | 427 kB 00:00
(8/8):
glibc-devel-2.28-127.0.1.el8.x86_64.rpm 201 kB/s | 1.0 MB 00:05
-----------------------------------------------------------------------------------------------------
Total
795 kB/s | 4.1 MB 00:05
warning:
/var/cache/dnf/ol8_baseos_latest-e4c6155830ad002c/packages/glibc-devel-2.28-127.0.1.el8.x86_64.rpm:
Header V3 RSA/SHA256
Signature, key ID ad986da3: NOKEY
Oracle Linux 8 BaseOS
Latest (x86_64) 1.3 MB/s | 3.1 kB 00:00
Importing GPG key
0xAD986DA3:
Userid
: "Oracle OSS group (Open Source Software group) <build@oss.oracle.com>"
Fingerprint: 76FD 3DB1 3AB6 7410 B89D B10E
8256 2EA9 AD98 6DA3
From
: /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Key imported
successfully
Running transaction
check
Transaction check
succeeded.
Running transaction test
Transaction test
succeeded.
Running transaction
Preparing :
1/1
Installing :
libxcrypt-devel-4.1.1-4.el8.x86_64 1/8
Installing :
glibc-devel-2.28-127.0.1.el8.x86_64 2/8
Running scriptlet:
glibc-devel-2.28-127.0.1.el8.x86_64 2/8
Installing : make-1:4.2.1-11.el8.x86_64 3/8
Running scriptlet:
make-1:4.2.1-11.el8.x86_64 3/8
Installing : compat-openssl10-1:1.0.2o-4.el8_6.x86_64 4/8
Running scriptlet:
compat-openssl10-1:1.0.2o-4.el8_6.x86_64 4/8
Installing : ksh-20120801-259.0.1.el8.x86_64 5/8
Running scriptlet:
ksh-20120801-259.0.1.el8.x86_64 5/8
Installing :
lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 6/8
Running scriptlet:
lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 6/8
Installing : sysstat-11.7.3-11.0.1.el8.x86_64 7/8
Running scriptlet:
sysstat-11.7.3-11.0.1.el8.x86_64 7/8
Installing : oracle-database-preinstall-23ai-1.0-2.el8.x86_64 8/8
Running scriptlet:
oracle-database-preinstall-23ai-1.0-2.el8.x86_64 8/8
Verifying :
glibc-devel-2.28-127.0.1.el8.x86_64 1/8
Verifying :
libxcrypt-devel-4.1.1-4.el8.x86_64 2/8
Verifying :
lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 3/8
Verifying : make-1:4.2.1-11.el8.x86_64 4/8
Verifying :
compat-openssl10-1:1.0.2o-4.el8_6.x86_64 5/8
Verifying : ksh-20120801-259.0.1.el8.x86_64 6/8
Verifying : oracle-database-preinstall-23ai-1.0-2.el8.x86_64 7/8
Verifying : sysstat-11.7.3-11.0.1.el8.x86_64 8/8
Installed:
compat-openssl10-1:1.0.2o-4.el8_6.x86_64
glibc-devel-2.28-127.0.1.el8.x86_64 ksh-20120801-259.0.1.el8.x86_64
libxcrypt-devel-4.1.1-4.el8.x86_64 lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 make-1:4.2.1-11.el8.x86_64
oracle-database-preinstall-23ai-1.0-2.el8.x86_64 sysstat-11.7.3-11.0.1.el8.x86_64
Complete!
The
installation of the Oracle Database software is now complete.
[root@rac134 ORACLE23ai]# df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 6.7G 0
6.7G 0% /dev
tmpfs 6.7G 0
6.7G 0% /dev/shm
tmpfs 6.7G 9.2M
6.7G 1% /run
tmpfs 6.7G 0
6.7G 0% /sys/fs/cgroup
/dev/mapper/VGExaDB-root 98G
5.1G 88G 6% /
/dev/sda1 1014M 305M
710M 31% /boot
tmpfs 1.4G 1.2M
1.4G 1% /run/user/42
tmpfs 1.4G 0
1.4G 0% /run/user/0
[root@rac134 ORACLE23ai]# ethtool enp0s8
Settings for enp0s8:
Supported ports: [ TP ]
Supported link modes: 10baseT/Half 10baseT/Full
100baseT/Half
100baseT/Full
1000baseT/Full
Supported pause frame use: No
Supports auto-negotiation: Yes
Supported FEC modes: Not reported
Advertised link modes: 10baseT/Half 10baseT/Full
100baseT/Half
100baseT/Full
1000baseT/Full
Advertised pause frame use: No
Advertised auto-negotiation: Yes
Advertised FEC modes: Not reported
Speed: 1000Mb/s
Duplex: Full
Port: Twisted Pair
PHYAD: 0
Transceiver: internal
Auto-negotiation: on
MDI-X: off (auto)
Supports Wake-on: umbg
Wake-on: d
Current message level: 0x00000007 (7)
drv probe link
Link detected: yes
[root@rac134 ORACLE23ai]# systemctl restart
NetworkManager.service
[root@rac134 ORACLE23ai]#
[root@rac134 ORACLE23ai]#
[root@rac134 ORACLE23ai]#
Run the service configuration script
[root@rac134 ~]# cd /SOFTWARE/ORACLE23ai/
[root@rac134 ORACLE23ai]# ls -ltrah
total 1.3G
-rw-r--r-- 1 root root 1.3G May 13 20:29
oracle-database-free-23ai-1.0-1.el8.x86_64.rpm
drwxr-xr-x 3 root root
4.0K May 14 18:17 ..
drwxr-xr-x 2 root root
4.0K May 14 19:19 .
[root@rac134 ORACLE23ai]# chmod +x
oracle-database-free-23ai-1.0-1.el8.x86_64.rpm
[root@rac134
ORACLE23ai]#
[root@rac134
ORACLE23ai]#
[root@rac134 ORACLE23ai]# ls -ltrha
total 1.3G
-rwxr-xr-x 1 root root
1.3G May 13 20:29 oracle-database-free-23ai-1.0-1.el8.x86_64.rpm
drwxr-xr-x 3 root root
4.0K May 14 18:17 ..
drwxr-xr-x 2 root root
4.0K May 14 19:19 .
[root@rac134 ORACLE23ai]# dnf -y localinstall
/SOFTWARE/ORACLE23ai/oracle-database-free-23ai-1.0-1.el8.x86_64.rpm
Last metadata expiration
check: 1:58:35 ago on Tue 14 May 2024 05:52:32 PM IST.
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.6 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:
oracle-database-free-23ai-1.0-1.x86_64
Complete!
Creating and Configuring an Oracle Database
The
configuration script creates a container database (FREE) with one pluggable
database (FREEPDB1) and configures the listener at the default port (1521).
You
can modify the configuration parameters by editing the /etc/sysconfig/oracle-free–23ai.conf file.
The parameters set
in this file are explained in detail in the silent mode installation procedure: Performing
a Silent Installation.
[root@rac134 ~]# more
/etc/sysconfig/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
Creating and Configuring an Oracle Database
The
configuration script creates a container database (FREE) with one pluggable
database (FREEPDB1) and configures the listener at the default port (1521).
You
can modify the configuration parameters by editing the /etc/sysconfig/oracle-free–23ai.conf file.
The parameters set
in this file are explained in detail in the silent mode installation procedure: Performing
a Silent Installation.
Since its new setup, so we are
creating database with the default settings
NOTE:
Here
in this setup configuration will automatically get the password when it will prompt
for SYS/SYSTEM/PDBADMIN account or you can pass the password during execution
when it will prompt. We are using the
same password for all account.
[root@rac134 ~]# export DB_PASSWORD=oracle
[root@rac134 ~]#
[root@rac134 ~]#
[root@rac134 ~]#
[root@rac134 ~]# (echo "${DB_PASSWORD}";
echo "${DB_PASSWORD}";) | /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 u
ppercase 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:
rac134.ora.com/FREEPDB1
Multitenant container database:
rac134.ora.com
The database creation logs are
located under Oracle base in the /opt/oracle/cfgtoollogs/dbca/ subdirectory.
Setting Oracle Database Free Environment Variables
After you install and configure
Oracle Database Free, set the environment before you use Oracle Database Free.
Use the oraenv to set
your environment variables.
[root@rac134 ~]# ps -ef | grep pmon
oracle 27717
1 0 20:20 ? 00:00:00 db_pmon_FREE
root 29936
21271 0 20:25 pts/0 00:00:00 grep --color=auto pmon
[root@rac134 ~]#
[root@rac134 ~]#
[root@rac134 ~]#
[root@rac134 ~]# more /etc/oratab
FREE:/opt/oracle/product/23ai/dbhomeFree:N
[root@rac134 ~]# su -
oracle
[oracle@rac134 ~]$ .
oraenv
ORACLE_SID = [oracle] ?
FREE
The Oracle base has been
set to /opt/oracle
[oracle@rac134 ~]$ sqlplus / as sysdba
SQL*Plus: Release
23.0.0.0.0 - Production on Tue May 14 20:26:11 2024
Version 23.4.0.24.05
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.4.0.24.05
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
----------
------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 FREEPDB1 READ WRITE NO
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> alter
session set container=FREEPDB1 ;
Session altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------
---------- ----------
3 FREEPDB1 READ WRITE NO
SQL> select name, open_mode, version from
v$database, v$instance ;
NAME OPEN_MODE VERSION
---------
-------------------- -----------------
FREE READ WRITE 23.0.0.0.0
SQL>
SQL>
SQL> select table_name from dict where table_name
LIKE '%BANNER%';
TABLE_NAME
--------------------------------------------------------------------------------
ALL_REGISTRY_BANNERS
SQL> SELECT * FROM ALL_REGISTRY_BANNERS ;
SQL> COL BANNER_FULL
FOR A79
SQL> /
BANNER
BANNER_FULL
----------------------------------------------------------------------
------------------------------------------------------------------
Oracle Database Catalog
Views Release 23.0.0.0.0 - Production
Oracle Database Catalog Views Release 23.0.0.0.0 - Production
Version 23.4.0.24.05
Oracle Database Packages
and Types Release 23.0.0.0.0 - Production
Oracle Database Packages and Types Release 23.0.0.0.0 - Production
Version 23.4.0.24.05
Oracle XML Database
Release 23.0.0.0.0 - Production Oracle XML Database Release
23.0.0.0.0 - Production
Version
23.4.0.24.05
Oracle Workspace Manager
Release 23.0.0.0.0 - Production
Oracle Workspace Manager Release 23.0.0.0.0 - Production
Version 23.4.0.24.05
JServer JAVA Virtual
Machine Release 23.0.0.0.0 - Production JServer JAVA Virtual Machine Release
23.0.0.0.0 - Production
Version 23.4.0.24.05
Oracle XDK Release
23.0.0.0.0 - Production Oracle XDK Release
23.0.0.0.0 - Production
Version 23.4.0.24.05
Oracle Database Java
Packages Release 23.0.0.0.0 - Production Oracle Database Java Packages Release
23.0.0.0.0 - Production
Version 23.4.0.24.05
Oracle Text Release
23.0.0.0.0 - Production Oracle Text Release
23.0.0.0.0 - Production
Version 23.4.0.24.05
OLAP Analytic Workspace
Release 23.0.0.0.0 - Production
OLAP Analytic Workspace Release 23.0.0.0.0 - Production
Version
23.4.0.24.05
Oracle OLAP API Release
23.0.0.0.0 - Production
Oracle OLAP API Release 23.0.0.0.0 - Production
Version
23.4.0.24.05
Spatial Release
23.0.0.0.0 - Production Spatial Release
23.0.0.0.0 - Production
Version 23.4.0.24.05
Oracle Label Security
Release 23.0.0.0.0 - Production
Oracle Label Security Release 23.0.0.0.0 - Production
Version 23.4.0.24.05
Oracle Database Vault
Release 23.0.0.0.0 - Production
Oracle Database Vault Release 23.0.0.0.0 - Production
Version 23.4.0.24.05
13 rows selected.
Reference
is oracle documentation at www.oracle.com
