alter session set tracefile_identifier='control'; alter database backup controlfile to trace; alter database backup controlfile to trace noresetlogs; Generate the trace file of control file. alter database backup controlfile to trace as '/tmp/control.txt' ; grep "CREATE CONTROLFILE" * col name for a60 select v.*, round(block_size*file_size_blks/1024/1024, 2) MB from v$controlfile v; select v.*, round(record_size*records_total/1024/1024, 2) MB from v$controlfile_record_section v order by MB desc; set linesize 300 col DISPLAY_VALUE for a20 col DEFAULT_VALUE for a20 col DESCRIPTION for a20 col VALUE for a15 col UPDATE_COMMENT for a20 col NAME for a30 select * from v$parameter where name = 'control_file_record_keep_time';
Monday, 9 February 2026
Control file info
<
Wednesday, 28 January 2026
Oracle download 26ai and install on CentOS Stream release 9
Oracle AI Database 26ai for Linux x86-64 on-premises platforms
Download ----
https://www.oracle.com/database/technologies/oracle-database-software-downloads.html#db_ee
-rw-r--r--. 1 oracle oinstall 2406058543 Jan 28 12:54 LINUX.X64_2326100_db_home.zip [root@centos9 ~]# cat /etc/redhat-release CentOS Stream release 9
[root@centos9 ~]# uname -r 5.14.0-654.el9.x86_64
install rpm dnf install -y \ bc \ binutils \ compat-openssl11 \ elfutils-libelf \ fontconfig \ glibc \ glibc-devel \ glibc-headers \ ksh \ libaio \ libasan \ liblsan \ libX11 \ libXau \ libXi \ libXrender \ libXtst \ libxcrypt-compat \ libgcc \ libibverbs \ librdmacm \ libstdc++ \ libxcb \ libvirt-libs \ make \ policycoreutils \ policycoreutils-python-utils \ smartmontools \ sysstat Last metadata expiration check: 0:25:02 ago on Wed 28 Jan 2026 09:43:16 AM GMT. Package bc-1.07.1-14.el9.x86_64 is already installed. Package binutils-2.35.2-69.el9.x86_64 is already installed. Package elfutils-libelf-0.194-1.el9.x86_64 is already installed. Package fontconfig-2.14.0-2.el9.x86_64 is already installed. Package glibc-2.34-245.el9.x86_64 is already installed. Package libaio-0.3.111-13.el9.x86_64 is already installed. Package libX11-1.8.12-1.el9.x86_64 is already installed. Package libXau-1.0.9-8.el9.x86_64 is already installed. Package libXi-1.7.10-8.el9.x86_64 is already installed. Package libXrender-0.9.10-16.el9.x86_64 is already installed. Package libXtst-1.2.3-16.el9.x86_64 is already installed. Package libxcrypt-compat-4.4.18-3.el9.x86_64 is already installed. Package libgcc-11.5.0-14.el9.x86_64 is already installed. Package libibverbs-57.0-2.el9.x86_64 is already installed. Package libstdc++-11.5.0-14.el9.x86_64 is already installed. Package libxcb-1.13.1-9.el9.x86_64 is already installed. Package policycoreutils-3.6-3.el9.x86_64 is already installed. Package policycoreutils-python-utils-3.6-3.el9.noarch is already installed. Package smartmontools-1:7.2-9.el9.x86_64 is already installed. Dependencies resolved. ===================================================================================================================================================================== Package Architecture Version Repository Size ===================================================================================================================================================================== Installing: compat-openssl11 x86_64 1:1.1.1k-5.el9.1 appstream 1.5 M glibc-devel x86_64 2.34-245.el9 appstream 37 k glibc-headers x86_64 2.34-245.el9 appstream 546 k ksh x86_64 3:1.0.6-14.el9 appstream 876 k libasan x86_64 11.5.0-14.el9 appstream 407 k liblsan x86_64 11.5.0-14.el9 appstream 184 k librdmacm x86_64 61.0-2.el9 baseos 73 k libvirt-libs x86_64 11.10.0-2.el9 appstream 5.5 M make x86_64 1:4.3-8.el9 baseos 536 k sysstat x86_64 12.5.4-9.el9 appstream 482 k Upgrading: libibverbs x86_64 61.0-2.el9 baseos 480 k policycoreutils x86_64 3.6-4.el9 baseos 238 k policycoreutils-python-utils noarch 3.6-4.el9 appstream 75 k python3-policycoreutils noarch 3.6-4.el9 appstream 2.1 M Installing dependencies: kernel-headers x86_64 5.14.0-665.el9 appstream 2.4 M libxcrypt-devel x86_64 4.4.18-3.el9 appstream 29 k lm_sensors-libs x86_64 3.6.0-10.el9 appstream 42 k pcp-conf x86_64 6.3.7-6.el9 appstream 31 k pcp-libs x86_64 6.3.7-6.el9 appstream 647 k Transaction Summary ===================================================================================================================================================================== Install 15 Packages Upgrade 4 Packages Total download size: 16 M Downloading Packages: (1/19): compat-openssl11-1.1.1k-5.el9.1.x86_64.rpm 2.2 MB/s | 1.5 MB 00:00 (2/19): librdmacm-61.0-2.el9.x86_64.rpm 111 kB/s | 73 kB 00:00 (3/19): make-4.3-8.el9.x86_64.rpm 814 kB/s | 536 kB 00:00 (4/19): glibc-devel-2.34-245.el9.x86_64.rpm 174 kB/s | 37 kB 00:00 (5/19): ksh-1.0.6-14.el9.x86_64.rpm 2.8 MB/s | 876 kB 00:00 (6/19): kernel-headers-5.14.0-665.el9.x86_64.rpm 4.4 MB/s | 2.4 MB 00:00 (7/19): glibc-headers-2.34-245.el9.x86_64.rpm 944 kB/s | 546 kB 00:00 (8/19): liblsan-11.5.0-14.el9.x86_64.rpm 1.3 MB/s | 184 kB 00:00 (9/19): libasan-11.5.0-14.el9.x86_64.rpm 2.2 MB/s | 407 kB 00:00 (10/19): lm_sensors-libs-3.6.0-10.el9.x86_64.rpm 220 kB/s | 42 kB 00:00 (11/19): libxcrypt-devel-4.4.18-3.el9.x86_64.rpm 118 kB/s | 29 kB 00:00 (12/19): pcp-conf-6.3.7-6.el9.x86_64.rpm 694 kB/s | 31 kB 00:00 (13/19): pcp-libs-6.3.7-6.el9.x86_64.rpm 3.6 MB/s | 647 kB 00:00 (14/19): sysstat-12.5.4-9.el9.x86_64.rpm 2.6 MB/s | 482 kB 00:00 (15/19): policycoreutils-3.6-4.el9.x86_64.rpm 1.3 MB/s | 238 kB 00:00 (16/19): policycoreutils-python-utils-3.6-4.el9.noarch.rpm 696 kB/s | 75 kB 00:00 (17/19): libibverbs-61.0-2.el9.x86_64.rpm 1.1 MB/s | 480 kB 00:00 (18/19): libvirt-libs-11.10.0-2.el9.x86_64.rpm 5.5 MB/s | 5.5 MB 00:00 (19/19): python3-policycoreutils-3.6-4.el9.noarch.rpm 6.3 MB/s | 2.1 MB 00:00 --------------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 4.0 MB/s | 16 MB 00:03 CentOS Stream 9 - BaseOS 1.6 MB/s | 1.6 kB 00:00 Importing GPG key 0x8483C65D: Userid : "CentOS (CentOS Official Signing Key) <security@centos.org>" Fingerprint: 99DB 70FA E1D7 CE22 7FB6 4882 05B5 55B3 8483 C65D From : /etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial Key imported successfully Running transaction check Transaction check succeeded. Running transaction test Transaction test succeeded. Running transaction Preparing : 1/1 Upgrading : policycoreutils-3.6-4.el9.x86_64 1/23 Running scriptlet: policycoreutils-3.6-4.el9.x86_64 1/23 Upgrading : python3-policycoreutils-3.6-4.el9.noarch 2/23 Upgrading : libibverbs-61.0-2.el9.x86_64 3/23 Installing : pcp-conf-6.3.7-6.el9.x86_64 4/23 Installing : pcp-libs-6.3.7-6.el9.x86_64 5/23 Installing : lm_sensors-libs-3.6.0-10.el9.x86_64 6/23 Installing : kernel-headers-5.14.0-665.el9.x86_64 7/23 Installing : glibc-headers-2.34-245.el9.x86_64 8/23 Installing : libxcrypt-devel-4.4.18-3.el9.x86_64 9/23 Installing : glibc-devel-2.34-245.el9.x86_64 10/23 Installing : sysstat-12.5.4-9.el9.x86_64 11/23 Running scriptlet: sysstat-12.5.4-9.el9.x86_64 11/23 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 : librdmacm-61.0-2.el9.x86_64 12/23 Upgrading : policycoreutils-python-utils-3.6-4.el9.noarch 13/23 Installing : libvirt-libs-11.10.0-2.el9.x86_64 14/23 Installing : liblsan-11.5.0-14.el9.x86_64 15/23 Installing : libasan-11.5.0-14.el9.x86_64 16/23 Installing : ksh-3:1.0.6-14.el9.x86_64 17/23 Running scriptlet: ksh-3:1.0.6-14.el9.x86_64 17/23 Installing : compat-openssl11-1:1.1.1k-5.el9.1.x86_64 18/23 Installing : make-1:4.3-8.el9.x86_64 19/23 Cleanup : policycoreutils-python-utils-3.6-3.el9.noarch 20/23 Cleanup : python3-policycoreutils-3.6-3.el9.noarch 21/23 Running scriptlet: policycoreutils-3.6-3.el9.x86_64 22/23 Cleanup : policycoreutils-3.6-3.el9.x86_64 22/23 Cleanup : libibverbs-57.0-2.el9.x86_64 23/23 Running scriptlet: libibverbs-57.0-2.el9.x86_64 23/23 Verifying : librdmacm-61.0-2.el9.x86_64 1/23 Verifying : make-1:4.3-8.el9.x86_64 2/23 Verifying : compat-openssl11-1:1.1.1k-5.el9.1.x86_64 3/23 Verifying : glibc-devel-2.34-245.el9.x86_64 4/23 Verifying : glibc-headers-2.34-245.el9.x86_64 5/23 Verifying : kernel-headers-5.14.0-665.el9.x86_64 6/23 Verifying : ksh-3:1.0.6-14.el9.x86_64 7/23 Verifying : libasan-11.5.0-14.el9.x86_64 8/23 Verifying : liblsan-11.5.0-14.el9.x86_64 9/23 Verifying : libvirt-libs-11.10.0-2.el9.x86_64 10/23 Verifying : libxcrypt-devel-4.4.18-3.el9.x86_64 11/23 Verifying : lm_sensors-libs-3.6.0-10.el9.x86_64 12/23 Verifying : pcp-conf-6.3.7-6.el9.x86_64 13/23 Verifying : pcp-libs-6.3.7-6.el9.x86_64 14/23 Verifying : sysstat-12.5.4-9.el9.x86_64 15/23 Verifying : libibverbs-61.0-2.el9.x86_64 16/23 Verifying : libibverbs-57.0-2.el9.x86_64 17/23 Verifying : policycoreutils-3.6-4.el9.x86_64 18/23 Verifying : policycoreutils-3.6-3.el9.x86_64 19/23 Verifying : policycoreutils-python-utils-3.6-4.el9.noarch 20/23 Verifying : policycoreutils-python-utils-3.6-3.el9.noarch 21/23 Verifying : python3-policycoreutils-3.6-4.el9.noarch 22/23 Verifying : python3-policycoreutils-3.6-3.el9.noarch 23/23 Upgraded: libibverbs-61.0-2.el9.x86_64 policycoreutils-3.6-4.el9.x86_64 policycoreutils-python-utils-3.6-4.el9.noarch python3-policycoreutils-3.6-4.el9.noarch Installed: compat-openssl11-1:1.1.1k-5.el9.1.x86_64 glibc-devel-2.34-245.el9.x86_64 glibc-headers-2.34-245.el9.x86_64 kernel-headers-5.14.0-665.el9.x86_64 ksh-3:1.0.6-14.el9.x86_64 libasan-11.5.0-14.el9.x86_64 liblsan-11.5.0-14.el9.x86_64 librdmacm-61.0-2.el9.x86_64 libvirt-libs-11.10.0-2.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 pcp-conf-6.3.7-6.el9.x86_64 pcp-libs-6.3.7-6.el9.x86_64 sysstat-12.5.4-9.el9.x86_64 Complete!
[root@centos9 ~]# yum install nfs-utils-2.5.4
Last metadata expiration check: 0:07:11 ago on Wed 28 Jan 2026 01:30:17 PM GMT.
Dependencies resolved.
============================================================================================================
Package Architecture Version Repository Size
============================================================================================================
Installing:
nfs-utils x86_64 1:2.5.4-41.el9 baseos 460 k
Installing dependencies:
gssproxy x86_64 0.8.4-7.el9 baseos 110 k
libev x86_64 4.33-6.el9 baseos 52 k
libnfsidmap x86_64 1:2.5.4-41.el9 baseos 62 k
libverto-libev x86_64 0.3.2-3.el9 baseos 14 k
rpcbind x86_64 1.2.6-7.el9 baseos 58 k
sssd-nfs-idmap x86_64 2.9.7-5.el9 baseos 37 k
Transaction Summary
============================================================================================================
Install 7 Packages
Total download size: 793 k
Installed size: 1.9 M
Is this ok [y/N]: y
Downloading Packages:
(1/7): libnfsidmap-2.5.4-41.el9.x86_64.rpm 147 kB/s | 62 kB 00:00
(2/7): gssproxy-0.8.4-7.el9.x86_64.rpm 253 kB/s | 110 kB 00:00
(3/7): libev-4.33-6.el9.x86_64.rpm 115 kB/s | 52 kB 00:00
(4/7): libverto-libev-0.3.2-3.el9.x86_64.rpm 111 kB/s | 14 kB 00:00
(5/7): rpcbind-1.2.6-7.el9.x86_64.rpm 330 kB/s | 58 kB 00:00
(6/7): sssd-nfs-idmap-2.9.7-5.el9.x86_64.rpm 202 kB/s | 37 kB 00:00
(7/7): nfs-utils-2.5.4-41.el9.x86_64.rpm 1.0 MB/s | 460 kB 00:00
------------------------------------------------------------------------------------------------------------
Total 554 kB/s | 793 kB 00:01
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : libnfsidmap-1:2.5.4-41.el9.x86_64 1/7
Running scriptlet: rpcbind-1.2.6-7.el9.x86_64 2/7
Installing : rpcbind-1.2.6-7.el9.x86_64 2/7
Running scriptlet: rpcbind-1.2.6-7.el9.x86_64 2/7
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 : libev-4.33-6.el9.x86_64 3/7
Installing : libverto-libev-0.3.2-3.el9.x86_64 4/7
Installing : gssproxy-0.8.4-7.el9.x86_64 5/7
Running scriptlet: gssproxy-0.8.4-7.el9.x86_64 5/7
Running scriptlet: nfs-utils-1:2.5.4-41.el9.x86_64 6/7
Installing : nfs-utils-1:2.5.4-41.el9.x86_64 6/7
Running scriptlet: nfs-utils-1:2.5.4-41.el9.x86_64 6/7
Installing : sssd-nfs-idmap-2.9.7-5.el9.x86_64 7/7
Running scriptlet: sssd-nfs-idmap-2.9.7-5.el9.x86_64 7/7
Verifying : gssproxy-0.8.4-7.el9.x86_64 1/7
Verifying : libev-4.33-6.el9.x86_64 2/7
Verifying : libnfsidmap-1:2.5.4-41.el9.x86_64 3/7
Verifying : libverto-libev-0.3.2-3.el9.x86_64 4/7
Verifying : nfs-utils-1:2.5.4-41.el9.x86_64 5/7
Verifying : rpcbind-1.2.6-7.el9.x86_64 6/7
Verifying : sssd-nfs-idmap-2.9.7-5.el9.x86_64 7/7
Installed:
gssproxy-0.8.4-7.el9.x86_64 libev-4.33-6.el9.x86_64 libnfsidmap-1:2.5.4-41.el9.x86_64
libverto-libev-0.3.2-3.el9.x86_64 nfs-utils-1:2.5.4-41.el9.x86_64 rpcbind-1.2.6-7.el9.x86_64
sssd-nfs-idmap-2.9.7-5.el9.x86_64
Complete!
[root@centos9 ~]#
Create group
groupadd -g 54320 oper
groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 backupdba
groupadd -g 54324 dgdba
groupadd -g 54325 kmdba
groupadd -g 54326 racdba
groupadd -g 54327 asmdba
groupadd -g 54328 asmoper
groupadd -g 54329 asmadmin
Group Purposes:
oinstall: Oracle Inventory group (primary)
dba: Database Administrator (SYSDBA)
oper: Database Operator (SYSOPER)
backupdba: Backup and Recovery (SYSBACKUP)
dgdba: Data Guard (SYSDG)
kmdba: Encryption Key Management (SYSKM)
racdba: Real Application Clusters
useradd -u 54321 -g oinstall -G dba,backupdba,dgdba,kmdba,racdba,oper,asmdba oracle
useradd -u 54321 -g oinstall -G dba,backupdba,dgdba,kmdba,racdba,oper,asmdba oracle
[root@centos9 ~]# passwd oracle
Changing password for user oracle.
New password:
BAD PASSWORD: The password is shorter than 8 characters
Retype new password:
passwd: all authentication tokens updated successfully.
[root@centos9 ~]#
[root@centos9 ~]# id -a oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54320(oper),54322(dba),54323(backupdba),54324(dgdba),54325(kmdba),54326(racdba),54327(asmdba)
[root@centos9 ~]#
tee -a /etc/security/limits.conf << 'EOF'
# Oracle Database resource limits
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
oracle soft memlock 28835840
oracle hard memlock 28835840
EOF
===
check the values
cat /etc/security/limits.conf
# Oracle Database resource limits
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
oracle soft memlock 28835840
oracle hard memlock 28835840
[root@centos9 /]# pwd
/
[root@centos9 ~]# mkdir -p /u01/app/oracle/product/23.26.0/db_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01
cd /home/oracle/
SQL> !ls -ltr /home/oracle
-rw-r--r--. 1 oracle oinstall 2406058543 Jan 28 12:54 LINUX.X64_2326100_db_home.zip
-rw-r--r--. 1 oracle oinstall 19862 Jan 28 13:40 dbca26.rsp
[root@centos9 ~]# cd /u01/app/oracle/product/23.26.0/db_1
unzip -q /home/oracle/LINUX.X64_2326100_db_home.zip
[oracle@centos9 db_1]$ ./runInstaller &
/u01/app/oracle/product/23.26.0/db_1/root.sh6.0/db_1/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/23.26.0/db_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Connected to:
Oracle AI Database 26ai Enterprise Edition Release 23.26.1.0.0 - Production
Version 23.26.1.0.0
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB READ WRITE NO
SQL> !echo $ORACLE_HOME
/u01/app/oracle/product/23.26.0/db_1
[oracle@centos9 admin]$ pwd
/u01/app/oracle/product/23.26.0/db_1/network/admin
[oracle@centos9 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/23.26.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = centos9.lan)(PORT = 1521))
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = centos9.lan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
[oracle@centos9 admin]$
SQL> show parameter local
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string LISTENER_ORCL
parallel_force_local boolean FALSE
SQL> !tnsping LISTENER_ORCL
TNS Ping Utility for Linux: Version 23.26.1.0.0 - Production on 28-JAN-2026 14:14:18
Copyright (c) 1997, 2026, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/23.26.0/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (ADDRESS = (PROTOCOL = TCP)(HOST = centos9.lan)(PORT = 1521))
OK (10 msec)
SQL>
*********************************************************************************
-rw-r--r--. 1 oracle oinstall 19862 Jan 28 13:40 dbca26.rsp
[root@centos9 oracle]# cat dbca26.rsp
#################################################################### ## Copyright(c) Oracle Corporation 1998,2025. All rights reserved.## ## ## ## Specify values for the variables listed below to customize ## ## your installation. ## ## ## ## Each variable is associated with a comment. The comment ## ## can help to populate the variables with the appropriate ## ## values. ## ## ## ## IMPORTANT NOTE: This file contains plain text passwords and ## ## should be secured to have read permission only by oracle user ## ## or db administrator who owns this installation. ## ## ## #################################################################### #------------------------------------------------------------------------------ # Do not change the following system generated value. #------------------------------------------------------------------------------ oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v23.0.0 #------------------------------------------------------------------------------- # Specify the installation option. # It can be one of the following: # - INSTALL_DB_SWONLY # - INSTALL_DB_AND_CONFIG # # Deprecated: oracle.install.option #------------------------------------------------------------------------------- installOption=INSTALL_DB_AND_CONFIG #------------------------------------------------------------------------------- # Specify the Unix group to be set for the inventory directory. #------------------------------------------------------------------------------- UNIX_GROUP_NAME=oinstall #------------------------------------------------------------------------------- # Specify the location which holds the inventory files. # This is an optional parameter if installing on # Windows based Operating System. #------------------------------------------------------------------------------- INVENTORY_LOCATION=/u01/app/oraInventory #------------------------------------------------------------------------------- # Specify the complete path of the Oracle Base. #------------------------------------------------------------------------------- ORACLE_BASE=/u01/app/oracle #------------------------------------------------------------------------------- # Specify the installation edition of the component. # # The value should contain only one of these choices. # - EE : Enterprise Edition # # Deprecated: oracle.install.db.InstallEdition #------------------------------------------------------------------------------- installEdition=EE ############################################################################### # # # PRIVILEGED OPERATING SYSTEM GROUPS # # ------------------------------------------ # # Provide values for the OS groups to which SYSDBA and SYSOPER privileges # # needs to be granted. If the install is being performed as a member of the # # group "dba", then that will be used unless specified otherwise below. # # # # The value to be specified for OSDBA and OSOPER group is only for UNIX based # # Operating System. # # # ############################################################################### #------------------------------------------------------------------------------ # The OSDBA is the OS group which is to be granted SYSDBA privileges. # # Deprecated: oracle.install.db.OSDBA_GROUP #------------------------------------------------------------------------------- OSDBA=dba #------------------------------------------------------------------------------ # The OSOPER is the OS group which is to be granted SYSOPER privileges. # The value to be specified for OSOPER group is optional. # # Deprecated: oracle.install.db.OSOPER_GROUP #------------------------------------------------------------------------------ OSOPER= #------------------------------------------------------------------------------ # The OSBACKUPDBA is the OS group which is to be granted SYSBACKUP privileges. # # Deprecated: oracle.install.db.OSBACKUPDBA_GROUP #------------------------------------------------------------------------------ OSBACKUPDBA=backupdba #------------------------------------------------------------------------------ # The OSDGDBA is the OS group which is to be granted SYSDG privileges. # # Deprecated: oracle.install.db.OSDGDBA_GROUP #------------------------------------------------------------------------------ OSDGDBA=dgdba #------------------------------------------------------------------------------ # The OSKMDBA is the OS group which is to be granted SYSKM privileges. # # Deprecated: oracle.install.db.OSKMDBA_GROUP #------------------------------------------------------------------------------ OSKMDBA=kmdba #------------------------------------------------------------------------------ # The OSRACDBA is the OS group which is to be granted SYSRAC privileges. # # Deprecated: oracle.install.db.OSRACDBA_GROUP #------------------------------------------------------------------------------ OSRACDBA=racdba ################################################################################ # # # Root script execution configuration # # # ################################################################################ #------------------------------------------------------------------------------------------------------- # Specify the root script execution mode. # # - true : To run the root script automatically by using the appropriate configuration methods. # - false : To run the root script manually. # # If this option is selected, password should be specified on the console. # # Deprecated: oracle.install.db.rootconfig.executeRootScript #------------------------------------------------------------------------------------------------------- executeRootScript= #-------------------------------------------------------------------------------------- # Specify the configuration method to be used for automatic root script execution. # # Following are the possible choices: # - ROOT # - SUDO # # Deprecated: oracle.install.db.rootconfig.configMethod #-------------------------------------------------------------------------------------- configMethod= #-------------------------------------------------------------------------------------- # Specify the absolute path of the sudo program. # # Applicable only when SUDO configuration method was chosen. # # Deprecated: oracle.install.db.rootconfig.sudoPath #-------------------------------------------------------------------------------------- sudoPath= #-------------------------------------------------------------------------------------- # Specify the name of the user who is in the sudoers list. # Applicable only when SUDO configuration method was chosen. # Note:For Single Instance database installations,the sudo user name must be the username of the user installing the database. # # Deprecated: oracle.install.db.rootconfig.sudoUserName #-------------------------------------------------------------------------------------- sudoUserName= ############################################################################### # # # Grid Options # # # ############################################################################### #------------------------------------------------------------------------------ # Value is required only if the specified install option is INSTALL_DB_SWONLY # # Specify the cluster nodes to deploy Enterprise Edition Real Application # Cluster Database Oracle Home software. # # Example : clusterNodes=node1,node2 # # Deprecated: oracle.install.db.CLUSTER_NODES #------------------------------------------------------------------------------ clusterNodes= ############################################################################### # # # Database Configuration Options # # # ############################################################################### #------------------------------------------------------------------------------- # Specify the type of database to create. # It can be one of the following: # - GENERAL_PURPOSE # - DATA_WAREHOUSE # GENERAL_PURPOSE: A starter database designed for general purpose use or transaction-heavy applications. # DATA_WAREHOUSE : A starter database optimized for data warehousing applications. # # Deprecated: oracle.install.db.config.starterdb.type #------------------------------------------------------------------------------- dbType=GENERAL_PURPOSE #------------------------------------------------------------------------------- # Specify the Starter Database Global Database Name. # # Deprecated: oracle.install.db.config.starterdb.globalDBName #------------------------------------------------------------------------------- gdbName=orcl #------------------------------------------------------------------------------- # Specify the Starter Database SID. # # Deprecated: oracle.install.db.config.starterdb.SID #------------------------------------------------------------------------------- dbSID=orcl #------------------------------------------------------------------------------- # Specify the Pluggable Database name for the pluggable database in Container Database. # # Deprecated: oracle.install.db.config.PDBName #------------------------------------------------------------------------------- pdbName=orclpdb #------------------------------------------------------------------------------- # Specify the Starter Database character set. # # One of the following # AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2, # EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257, # BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6, # AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8, # IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE, # KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950, # ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258 # # Deprecated: oracle.install.db.config.starterdb.characterSet #------------------------------------------------------------------------------- charSet=AL32UTF8 #------------------------------------------------------------------------------ # This variable should be set to true if Automatic Memory Management # in Database is desired. # If Automatic Memory Management is not desired, and memory allocation # is to be done manually, then set it to false. # # Deprecated: oracle.install.db.config.starterdb.memoryOption #------------------------------------------------------------------------------ enableAutoMemoryManagement=false #------------------------------------------------------------------------------- # Specify the total memory allocation for the database. Value(in MB) should be # at least 256 MB, and should not exceed the total physical memory available # on the system. # Example: memoryLimit=512 # # Deprecated: oracle.install.db.config.starterdb.memoryLimit #------------------------------------------------------------------------------- memoryLimit=7778 ############################################################################### # # # Passwords can be supplied for the following four system accounts in the # # starter database: # # SYS # # SYSTEM # # DBSNMP (used by Enterprise Manager) # # PDBADMIN # # # # Same password can be used for all accounts (not recommended) # # or different passwords for each account can be provided (recommended) # # # ############################################################################### #------------------------------------------------------------------------------ # This variable holds the password that is to be used for all schemas in the # starter database. # # Deprecated: oracle.install.db.config.starterdb.password.ALL #------------------------------------------------------------------------------- allSchemaPassword= #------------------------------------------------------------------------------- # Specify the SYS password for the starter database. # # Deprecated: oracle.install.db.config.starterdb.password.SYS #------------------------------------------------------------------------------- sysPassword= #------------------------------------------------------------------------------- # Specify the SYSTEM password for the starter database. # # Deprecated: oracle.install.db.config.starterdb.password.SYSTEM #------------------------------------------------------------------------------- systemPassword= #------------------------------------------------------------------------------- # Specify the DBSNMP password for the starter database. # Applicable only when managementOption=CLOUD_CONTROL # # Deprecated: oracle.install.db.config.starterdb.password.DBSNMP #------------------------------------------------------------------------------- dbsnmpPassword= #------------------------------------------------------------------------------- # Specify the PDBADMIN password required for creation of Pluggable Database in the Container Database. # # Deprecated: oracle.install.db.config.starterdb.password.PDBADMIN #------------------------------------------------------------------------------- pdbadminPassword= #------------------------------------------------------------------------------- # Specify the management option to use for managing the database. # Options are: # 1. CLOUD_CONTROL - If you want to manage your database with Enterprise Manager Cloud Control. # 2. NONE -If you do not want to manage your database with Enterprise Manager Cloud Control. # # Deprecated: oracle.install.db.config.starterdb.managementOption #------------------------------------------------------------------------------- managementOption=DEFAULT #------------------------------------------------------------------------------- # Specify the OMS host to connect to Cloud Control. # Applicable only when managementOption=CLOUD_CONTROL # # Deprecated: oracle.install.db.config.starterdb.omsHost #------------------------------------------------------------------------------- omsHost= #------------------------------------------------------------------------------- # Specify the OMS port to connect to Cloud Control. # Applicable only when managementOption=CLOUD_CONTROL # # Deprecated: oracle.install.db.config.starterdb.omsPort #------------------------------------------------------------------------------- omsPort=0 #------------------------------------------------------------------------------- # Specify the EM Admin user name to use to connect to Cloud Control. # Applicable only when managementOption=CLOUD_CONTROL # # Deprecated: oracle.install.db.config.starterdb.emAdminUser #------------------------------------------------------------------------------- emAdminUser= #------------------------------------------------------------------------------- # Specify the EM Admin password to use to connect to Cloud Control. # Applicable only when managementOption=CLOUD_CONTROL # # Deprecated: oracle.install.db.config.starterdb.emAdminPassword #------------------------------------------------------------------------------- emAdminPassword= ############################################################################### # # # SPECIFY RECOVERY OPTIONS # # ------------------------------------ # # Recovery options for the database can be mentioned using the entries below # # # ############################################################################### #------------------------------------------------------------------------------ # This variable is to be set to false if database recovery is not required. Else # this can be set to true. # # Deprecated: oracle.install.db.config.starterdb.enableRecovery #------------------------------------------------------------------------------- enableRecovery=false #------------------------------------------------------------------------------- # Specify the type of storage to use for the database. # It can be one of the following: # - FILE_SYSTEM_STORAGE # - ASM_STORAGE # # Deprecated: oracle.install.db.config.starterdb.storageType #------------------------------------------------------------------------------- storageType=FILE_SYSTEM_STORAGE #------------------------------------------------------------------------------- # Specify the database file location which is a directory for datafiles, control # files, redo logs. # # Applicable only when storageType=FILE_SYSTEM_STORAGE # # Deprecated: oracle.install.db.config.starterdb.fileSystemStorage.dataLocation #------------------------------------------------------------------------------- dataLocation=/u01/app/oracle/oradata #------------------------------------------------------------------------------- # Specify the recovery location. # # Applicable only when storageType=FILE_SYSTEM_STORAGE # # Deprecated: oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation #------------------------------------------------------------------------------- recoveryLocation= #------------------------------------------------------------------------------- # Specify the existing ASM disk groups to be used for storage. # # Applicable only when storageType=ASM_STORAGE # # Deprecated: oracle.install.db.config.asm.diskGroup #------------------------------------------------------------------------------- diskGroup= #------------------------------------------------------------------------------- # Specify the password for ASMSNMP user of the ASM instance. # # Applicable only when storageType=ASM_STORAGE # # Deprecated: oracle.install.db.config.asm.ASMSNMPPassword #------------------------------------------------------------------------------- asmsnmpPassword=[root@centos9 oracle]#
Tuesday, 13 January 2026
Oracle SCN Verification & Recovery
Oracle SCN Verification & Recovery
1. Problem Identification
The following error occurs when attempting to bring a datafile online or open the database:
ORA-01113: file 2 needs media recovery
ORA-01110: data file 2: '+DATA/UGARY/DATAFILE/sysaux.3716.1204521933'
ORA-01110: data file 2: '+DATA/UGARY/DATAFILE/sysaux.3716.1204521933'
2. Diagnostic Analysis (Control File Dump)
To identify the exact SCN status from the control file, generate a trace file:
SQL> ALTER SESSION SET EVENTS 'immediate trace name controlf level 3';
=========================
to find diag dir
====================================
set linesize 300 pagesize 300
col name form a25
col value form a80 wrap
select * from v$diag_info
where 1=1
and NAME='Diag Trace'
order by name
/
=============
find /u01/app/oracle/diag/rdbms/ugary/ugary/trace -type f -exec grep -il "Controlfile Checkpointed" {} \;
/u01/app/oracle/diag/rdbms/ugary/ugary/trace/ugary_ora_14641.trc <<<<<<< file name
cat ugary_ora_14641.trc| grep -i -A7 -A7 "DATA FILE"
====
If the Stop SCN is 0xffff.ffffffff, the database is in a consistent state and ready to be opened.
However, if the Stop SCN is any other value,you must convert it from Hexadecimal to Decimal to determine the specific SCN required for recovery.
DATA FILE RECORDS
***************************************************************************
(size = 520, compat size = 520, section max = 200, section in-use = 3,
last-recid= 34, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 7, numrecs = 200)
DATA FILE #1:
name #4: +DATA/UGARY/DATAFILE/system.3761.1204521925
creation size=384000 block size=8192 status=0xe flg=0x1 head=4 tail=4 dup=1
pdb_id 0, tablespace 0, index=1 krfil=1 prev_file_in_ts=0 prev_file_in_pdb=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:175 scn: 0x0000.0067aa14 01/08/2026 08:46:53
Stop scn: 0xffff.ffffffff 01/08/2026 06:47:19
Creation Checkpointed at scn: 0x0000.00000008 01/25/2022 05:22:48
--
DATA FILE #2:
name #5: +DATA/UGARY/DATAFILE/sysaux.3716.1204521933
creation size=256000 block size=8192 status=0xe flg=0x1 head=5 tail=5 dup=1
pdb_id 0, tablespace 1, index=2 krfil=2 prev_file_in_ts=0 prev_file_in_pdb=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:175 scn: 0x0000.0067aa14 01/08/2026 08:46:53
Stop scn: 0xffff.ffffffff 01/08/2026 06:47:19
Creation Checkpointed at scn: 0x0000.00000a8b 01/25/2022 05:22:51
--
DATA FILE #3:
name #6: +DATA/UGARY/DATAFILE/undotbs1.4734.1204521933
creation size=38400 block size=8192 status=0xe flg=0x1 head=6 tail=6 dup=1
pdb_id 0, tablespace 2, index=3 krfil=3 prev_file_in_ts=0 prev_file_in_pdb=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:175 scn: 0x0000.0067aa14 01/08/2026 08:46:53
Stop scn: 0xffff.ffffffff 01/08/2026 06:47:19
Creation Checkpointed at scn: 0x0000.00000de6 01/25/2022 05:22:52
Trace File Indicators:
- Stop Scn: 0xffff.ffffffff STILL FUZZY - Database crashed or is currently open. Recovery Required.
- Stop Scn: 0x0000.003A58D9 CLEAN - Database shut down normally. Ready to open.
3. SCN Conversion Table
Use these methods to convert Hexadecimal SCNs from trace files into Decimal values for recovery analysis.
| Method | Command | Example Result |
|---|---|---|
| SQL*Plus | SELECT TO_NUMBER('3A58D9', 'XXXXXXXXXXXX') FROM DUAL; |
3823833 |
| Unix/Linux | echo "ibase=16; 3A58D9" | bc |
3823833 |
| Online | BinaryHexConverter.com | 3823833 |
4. RMAN Recovery Procedure
Execute these commands in the RMAN prompt to resolve ORA-01113:
# Connect to RMAN
$ rman target /
# Run Recovery
RMAN> RECOVER DATAFILE 2;
# Bring File Online
RMAN> ALTER DATABASE DATAFILE 2 ONLINE;
$ rman target /
# Run Recovery
RMAN> RECOVER DATAFILE 2;
# Bring File Online
RMAN> ALTER DATABASE DATAFILE 2 ONLINE;
5. Automated Monitoring Query
Run this query to check the consistency of all datafiles at once:
==================================
SET PAGESIZE 100 LINESIZE 300 FEEDBACK OFF
COLUMN name FORMAT a50
COLUMN status FORMAT a20
SELECT CON_ID, file#, name, checkpoint_change#, last_change#,
CASE
WHEN last_change# IS NULL THEN 'STILL FUZZY/OPEN'
ELSE 'CLEAN SHUTDOWN'
END AS status
FROM v$datafile; ----- ==================================
--Identifying the Required Archive Logs If RMAN asks for a specific log, you can use the Decimal SCN you calculated earlier (3823833) to find which log is needed: SQL SELECT THREAD#, SEQUENCE#, FIRST_CHANGE#, NEXT_CHANGE# FROM V$ARCHIVED_LOG WHERE 3823833 BETWEEN FIRST_CHANGE# AND NEXT_CHANGE#; Complete Database Recovery (Alternative) If multiple files are "Fuzzy" (as seen in your v$datafile query), it is often better to recover the whole database: SQL # From RMAN target / STARTUP MOUNT; RECOVER DATABASE; ALTER DATABASE OPEN; set linesize 200 pagesize 200
column member format a50
column first_change# format 99999999999999999999
column next_change# format 99999999999999999999
select l.thread#,
lf.group#,
lf.member,
trunc(l.bytes/1024/1024) as size_mb,
l.status,
l.archived,
lf.type,
lf.is_recovery_dest_file as rdf,
l.sequence#,
l.first_change#,
l.next_change#
from v$logfile lf , v$log l
where l.group# = lf.group#
order by l.thread#,lf.group#, lf.member;
SET PAGESIZE 100 LINESIZE 300 FEEDBACK OFF
COLUMN name FORMAT a50
COLUMN status FORMAT a20
SELECT CON_ID, file#, name, checkpoint_change#, last_change#,
CASE
WHEN last_change# IS NULL THEN 'STILL FUZZY/OPEN'
ELSE 'CLEAN SHUTDOWN'
END AS status
FROM v$datafile; ----- ==================================
--Identifying the Required Archive Logs If RMAN asks for a specific log, you can use the Decimal SCN you calculated earlier (3823833) to find which log is needed: SQL SELECT THREAD#, SEQUENCE#, FIRST_CHANGE#, NEXT_CHANGE# FROM V$ARCHIVED_LOG WHERE 3823833 BETWEEN FIRST_CHANGE# AND NEXT_CHANGE#; Complete Database Recovery (Alternative) If multiple files are "Fuzzy" (as seen in your v$datafile query), it is often better to recover the whole database: SQL # From RMAN target / STARTUP MOUNT; RECOVER DATABASE; ALTER DATABASE OPEN; set linesize 200 pagesize 200
column member format a50
column first_change# format 99999999999999999999
column next_change# format 99999999999999999999
select l.thread#,
lf.group#,
lf.member,
trunc(l.bytes/1024/1024) as size_mb,
l.status,
l.archived,
lf.type,
lf.is_recovery_dest_file as rdf,
l.sequence#,
l.first_change#,
l.next_change#
from v$logfile lf , v$log l
where l.group# = lf.group#
order by l.thread#,lf.group#, lf.member;
Internal Database Documentation - Generated for UGARY Environment
Monday, 12 January 2026
oracle impdp example for pdb
expdp with password !!!! $expdp anuj directory=DP_EXP_DIR dumpfile=emp.dmp logfile=emp.log encryption=all encryption_mode=password encryption_password=vihaan123 tables=anuj.emp Export: Release 12.2.0.1.0 - Production on Tue Jan 20 07:17:17 2026 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. Password: Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production Starting "ANUJ"."SYS_EXPORT_TABLE_01": anuj/******** directory=DP_EXP_DIR dumpfile=emp.dmp logfile=emp.log encryption=all encryption_mode=password encryption_password=******** tables=anuj.emp Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER Processing object type TABLE_EXPORT/TABLE/TABLE Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT . . exported "ANUJ"."EMP" 145.2 MB 3670016 rows Master table "ANUJ"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded ****************************************************************************** Dump file set for ANUJ.SYS_EXPORT_TABLE_01 is: /dumps/dp_exp_dir/emp.dmp Job "ANUJ"."SYS_EXPORT_TABLE_01" successfully completed at Tue Jan 20 07:21:50 2026 elapsed 0 00:04:21 =====
only metadata
expdp \'/as sysdba\' directory=DP_EXP_DIR dumpfile=expdp_TST_FULL_DDL_%U.dmp logfile=expdp_TST_FULL_DDL.log FULL=Y CONTENT=METADATA_ONLY PARALLEL=4 EXCLUDE=STATISTICS EXCLUDE=TABLE_STATISTICS,INDEX_STATISTICS EXCLUDE=AUDIT_TRAILS Export: Release 12.2.0.1.0 - Production on Tue Jan 20 08:56:28 2026 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production Starting "SYS"."SYS_EXPORT_FULL_01": "/******** AS SYSDBA" directory=DP_EXP_DIR dumpfile=expdp_TST_FULL_DDL_%U.dmp logfile=expdp_TST_FULL_DDL.log FULL=Y CONTENT=METADATA_ONLY PARALLEL=4 EXCLUDE=STATISTICS EXCLUDE=TABLE_STATISTICS,INDEX_STATISTICS EXCLUDE=AUDIT_TRAILS Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER Processing object type DATABASE_EXPORT/PROFILE Processing object type DATABASE_EXPORT/SYS_USER/USER Processing object type DATABAS
Master table "SYS"."SYS_EXPORT_FULL_01" successfully loaded/unloaded ****************************************************************************** Dump file set for SYS.SYS_EXPORT_FULL_01 is: /dumps/dp_exp_dir/expdp_TST_FULL_DDL_01.dmp /dumps/dp_exp_dir/expdp_TST_FULL_DDL_02.dmp /dumps/dp_exp_dir/expdp_TST_FULL_DDL_03.dmp /dumps/dp_exp_dir/expdp_TST_FULL_DDL_04.dmp Job "SYS"."SYS_EXPORT_FULL_01" successfully completed at Tue Jan 20 09:05:26 2026 elapsed 0 00:08:52
====
[oracle@ibrac01:~] $impdp \'/as sysdba\' directory=DP_EXP_DIR dumpfile=expdp_TST_FULL_DDL_%U.dmp logfile=impdp_TST_FULL_DDL.log sqlfile=full.sql Import: Release 12.2.0.1.0 - Production on Tue Jan 20 09:30:05 2026 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production Master table "SYS"."SYS_SQL_FILE_FULL_01" successfully loaded/unloaded Starting "SYS"."SYS_SQL_FILE_FULL_01": "/******** AS SYSDBA" directory=DP_EXP_DIR dumpfile=expdp_TST_FULL_DDL_%U.dmp logfile=impdp_TST_FULL_DDL.log sqlfile=full.sql Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER Processing object type DATABASE_EXPORT/TABLESPACE P
===
PDB nohup impdp system/vihaan@TESTORC1 directory=DATA_PUMP_EXP1 dumpfile=ANUJ_JAN071125.dmp logfile=impdp_CHECK_12JAN2025_.log REMAP_TABLESPACE=USERS:ANUJTB schemas=ANUJ CLUSTER=N full=N status=10 metrics=Y TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y EXCLUDE=STATISTICS &
Wednesday, 7 January 2026
GI RELEASE UPDATE 21.20.0.0.0
KA958
Oracle Database Release Updates (RUs)
database grid !!!
OCT2025 (21.20.0.0.0) 38371122 38370812 38273738
Tuesday, 6 January 2026
Patch 38068980 - Database Release Update 21.19.0.0.250715
Patch 38068980 - Database Release Update 21.19.0.0.250715 Patch 38068980 Simple Search Advanced Search Quick Links Saved Searches Description DATABASE RELEASE UPDATE 21.19.0.0.0 Product Oracle Database Family Release Oracle Database 21.0.0.0.0 Platform or Language Click for more information about this option Linux x86-64 Last Updated 15-JUL-2025 Size 1.5G (1607637461 bytes) For each Oracle RAC database home and the GI home that are being patched, as the home owner, extract the OPatch utility. For exact instructions to install OPatch, follow the OPatch readme. A new feature has been added to OPatch to increase performance by deleting inactive patches. See My Oracle Support document 2942102.1 OPatch 12.2.0.1.37+ Introduces a New Feature to Delete Inactive Patches in the ORACLE_HOME/.patch_storage directory. For information about OPatch documentation, including any known issues, see My Oracle Support document 293369.1 Primary Note For OPatch. unzip p38068980__ .zip cd 38068980 opatch prereq CheckConflictAgainstOHWithDetail -ph ./ ****************************************************** [oracle@oragrid 38068980]$ date Tue 6 Jan 10:27:19 GMT 2026 /home/oracle/38068980 [oracle@oragrid 38068980]$ pwd /home/oracle/38068980 opatch prereq CheckConflictAgainstOHWithDetail -ph ./ opatch prereq CheckSystemSpace -ph ./ [oracle@oragrid 38068980]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 12.2.0.1.48 Copyright (c) 2026, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/21.0.0/dbhome1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/21.0.0/dbhome1/oraInst.loc OPatch version : 12.2.0.1.48 OUI version : 12.2.0.9.0 Log file location : /u01/app/oracle/product/21.0.0/dbhome1/cfgtoollogs/opatch/opatch2026-01-06_10-25-39AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@oragrid 38068980]$ [oracle@oragrid 38068980]$ date Tue 6 Jan 10:27:19 GMT 2026 [oracle@oragrid 38068980]$ opatch prereq CheckSystemSpace -ph ./ Oracle Interim Patch Installer version 12.2.0.1.48 Copyright (c) 2026, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/21.0.0/dbhome1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/21.0.0/dbhome1/oraInst.loc OPatch version : 12.2.0.1.48 OUI version : 12.2.0.9.0 Log file location : /u01/app/oracle/product/21.0.0/dbhome1/cfgtoollogs/opatch/opatch2026-01-06_10-28-09AM_1.log Invoking prereq "checksystemspace" Prereq "checkSystemSpace" passed. OPatch succeeded. [oracle@oragrid ~]$ cd 38068980 [oracle@oragrid 38068980]$ pwd /home/oracle/38068980 [oracle@oragrid 38068980]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 12.2.0.1.48 Copyright (c) 2026, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/21.0.0/dbhome1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/21.0.0/dbhome1/oraInst.loc OPatch version : 12.2.0.1.48 OUI version : 12.2.0.9.0 Log file location : /u01/app/oracle/product/21.0.0/dbhome1/cfgtoollogs/opatch/opatch2026-01-06_10-25-39AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@oragrid 38068980]$ date Tue 6 Jan 10:27:19 GMT 2026 [oracle@oragrid 38068980]$ opatch prereq CheckSystemSpace -ph ./ Oracle Interim Patch Installer version 12.2.0.1.48 Copyright (c) 2026, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/21.0.0/dbhome1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/21.0.0/dbhome1/oraInst.loc OPatch version : 12.2.0.1.48 OUI version : 12.2.0.9.0 Log file location : /u01/app/oracle/product/21.0.0/dbhome1/cfgtoollogs/opatch/opatch2026-01-06_10-28-09AM_1.log Invoking prereq "checksystemspace" Prereq "checkSystemSpace" passed. OPatch succeeded. [oracle@oragrid 38068980]$ [oracle@oragrid 38068980]$ opatch apply Oracle Interim Patch Installer version 12.2.0.1.48 Copyright (c) 2026, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/21.0.0/dbhome1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/21.0.0/dbhome1/oraInst.loc OPatch version : 12.2.0.1.48 OUI version : 12.2.0.9.0 Log file location : /u01/app/oracle/product/21.0.0/dbhome1/cfgtoollogs/opatch/opatch2026-01-06_10-29-03AM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 38068980 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/oracle/product/21.0.0/dbhome1') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying interim patch '38068980' to OH '/u01/app/oracle/product/21.0.0/dbhome1' ApplySession: Optional component(s) [ oracle.network.gsm, 21.0.0.0.0 ] , [ oracle.tfa, 21.0.0.0.0 ] , [ oracle.network.cman, 21.0.0.0.0 ] , [ oracle.precomp.companion, 21.0.0.0.0 ] , [ oracle.sdo.companion, 21.0.0.0.0 ] , [ oracle.rdbms.tg4ifxm, 21.0.0.0.0 ] , [ oracle.duma, 21.0.0.0.0 ] , [ oracle.rdbms.ic, 21.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 21.0.0.0.0 ] , [ oracle.pg4appc, 21.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 21.0.0.0.0 ] , [ oracle.sysman.ccr.client, 21.0.0.0.0 ] , [ oracle.oraolap.mgmt, 21.0.0.0.0 ] , [ oracle.net.cman, 21.0.0.0.0 ] , [ oracle.ons.cclient, 21.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 21.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 21.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 21.0.0.0.0 ] , [ oracle.oid.client, 21.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 21.0.0.0.0 ] , [ oracle.jdk, 1.8.0.271.00 ] , [ oracle.pg4mq, 21.0.0.0.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.rdbms, 21.0.0.0.0... Patching component oracle.network.rsf, 21.0.0.0.0... Patching component oracle.rdbms.rsf, 21.0.0.0.0... Patching component oracle.rdbms.util, 21.0.0.0.0... Patching component oracle.blaslapack, 21.0.0.0.0... Patching component oracle.buildtools.rsf, 21.0.0.0.0... Patching component oracle.ctx, 21.0.0.0.0... Patching component oracle.dbdev, 21.0.0.0.0... Patching component oracle.dbjava.ic, 21.0.0.0.0... Patching component oracle.dbjava.jdbc, 21.0.0.0.0... Patching component oracle.dbjava.ucp, 21.0.0.0.0... Patching component oracle.has.common.cvu, 21.0.0.0.0... Patching component oracle.javavm.server, 21.0.0.0.0... Patching component oracle.javavm.server.core, 21.0.0.0.0... Patching component oracle.ldap.owm, 21.0.0.0.0... Patching component oracle.ldap.rsf, 21.0.0.0.0... Patching component oracle.ldap.rsf.ic, 21.0.0.0.0... Patching component oracle.ldap.security.osdt, 21.0.0.0.0... Patching component oracle.nlsrtl.rsf, 21.0.0.0.0... Patching component oracle.oraml.server, 21.0.0.0.0... Patching component oracle.perlint, 5.32.0.0.0... Patching component oracle.python, 3.9.5.0.0... Patching component oracle.rdbms.crs, 21.0.0.0.0... Patching component oracle.rdbms.dbscripts, 21.0.0.0.0... Patching component oracle.rdbms.deconfig, 21.0.0.0.0... Patching component oracle.rdbms.install.plugins, 21.0.0.0.0... Patching component oracle.rdbms.rman, 21.0.0.0.0... Patching component oracle.rdbms.rsf.ic, 21.0.0.0.0... Patching component oracle.sdo, 21.0.0.0.0... Patching component oracle.sdo.locator.jrf, 21.0.0.0.0... Patching component oracle.sqlplus, 21.0.0.0.0... Patching component oracle.tfa.db, 21.0.0.0.0... Patching component oracle.rdbms.hs_common, 21.0.0.0.0... Patching component oracle.ons.ic, 21.0.0.0.0... Patching component oracle.xdk.xquery, 21.0.0.0.0... Patching component oracle.assistants.deconfig, 21.0.0.0.0... Patching component oracle.xdk.rsf, 21.0.0.0.0... Patching component oracle.ons, 21.0.0.0.0... Patching component oracle.network.listener, 21.0.0.0.0... Patching component oracle.xdk, 21.0.0.0.0... Patching component oracle.xdk.parser.java, 21.0.0.0.0... Patching component oracle.precomp.rsf, 21.0.0.0.0... Patching component oracle.ovm, 21.0.0.0.0... Patching component oracle.assistants.acf, 21.0.0.0.0... Patching component oracle.assistants.server, 21.0.0.0.0... Patching component oracle.rdbms.hsodbc, 21.0.0.0.0... Patching component oracle.rdbms.oci, 21.0.0.0.0... Patching component oracle.ctx.rsf, 21.0.0.0.0... Patching component oracle.ctx.atg, 21.0.0.0.0... Patching component oracle.odbc, 21.0.0.0.0... Patching component oracle.ldap.client, 21.0.0.0.0... Patching component oracle.oracore.rsf, 21.0.0.0.0... Patching component oracle.sqlplus.ic, 21.0.0.0.0... Patching component oracle.usm.deconfig, 21.0.0.0.0... Patching component oracle.rdbms.lbac, 21.0.0.0.0... Patching component oracle.rdbms.dv, 21.0.0.0.0... Patching component oracle.ldap.ssl, 21.0.0.0.0... Patching component oracle.sdo.locator, 21.0.0.0.0... Patching component oracle.rdbms.scheduler, 21.0.0.0.0... Patching component oracle.precomp.lang, 21.0.0.0.0... Patching component oracle.precomp.common, 21.0.0.0.0... Patching component oracle.jdk, 1.8.0.291.09... Patching component oracle.precomp.common.core, 21.0.0.0.0... Patching component oracle.rdbms.install.common, 21.0.0.0.0... Patch 38068980 successfully applied. Log file location: /u01/app/oracle/product/21.0.0/dbhome1/cfgtoollogs/opatch/opatch2026-01-06_10-29-03AM_1.log OPatch succeeded. [oracle@oragrid 38068980]$ SQL> alter pluggable database all open; cd $ORACLE_HOME/OPatch cd $ORACLE_HOME/OPatch ./datapatch -verbose ./datapatch -sanity_checks (optional)
Oracle 21c dbca
dbca create database !!!!
Update Kernel Parameters (as root)
Open /etc/sysctl.conf and set the following values. These are calculated to allow
Oracle to use up to 16GB of your 18GB for shared memory (SGA):
kernel.shmmax: 17179869184 (16GB in bytes)
kernel.shmall: 4194304 (16GB / 4096 page size)
Bash
# Apply these commands as root or with sudo
echo "kernel.shmmax = 17179869184" >> /etc/sysctl.conf
echo "kernel.shmall = 4194304" >> /etc/sysctl.conf
echo "kernel.shmmni = 4096" >> /etc/sysctl.conf
# Load the changes
sysctl -p
[root@oragrid ~]# ssh -X oracle@192.168.1.106
oracle@192.168.1.106's password:
Activate the web console with: systemctl enable --now cockpit.socket
Last login: Tue Jan 6 10:59:47 2026 from 192.168.1.106
[oracle@oragrid ~]$ /u01/app/oracle/product/21.0.0/dbhome1/bin/dbca -CreateDatabase -silent \
> -gdbName v16mpc -sid v16mpc -sysPassword sys \
> -systemPassword sys -createAsContainerDatabase true \
> -numberofPDBs 1 -pdbname v16mpcpdb -pdbAdminUserName pdba \
> -pdbAdminPassword password -emConfiguration LOCAL \
> -dbsnmpPassword dbsnmp123 -storageType ASM -datafiledestination +DATA \
> -recoveryAreaDestination +DATA -databaseType MULTIPURPOSE -responseFile NO_VALUE \
> -totalmemory 26096 -characterset AL32UTF8 -nationalcharacterset AL16UTF16 \
> -automaticmemorymanagement FALSE \
> -templateName /u01/app/oracle/product/21.0.0/dbhome1/assistants/dbca/templates/General_Purpose.dbc
[WARNING] [DBT-11209] Current available memory is less than the required available memory (26,096MB) for creating the database.
CAUSE: Following nodes do not have required available memory :
Node:oragrid Available memory:13.6285GB (1.429052E7KB)
****************
reduce the sga !!!
/u01/app/oracle/product/21.0.0/dbhome1/bin/dbca -CreateDatabase -silent \
> -gdbName v16mpc -sid v16mpc -sysPassword sys \
> -systemPassword sys -createAsContainerDatabase true \
> -numberofPDBs 1 -pdbname v16mpcpdb -pdbAdminUserName pdba \
> -pdbAdminPassword password -emConfiguration LOCAL \
> -dbsnmpPassword dbsnmp123 -storageType ASM -datafiledestination +DATA \
> -recoveryAreaDestination +DATA -databaseType MULTIPURPOSE -responseFile NO_VALUE \
> -totalmemory 26096 -characterset AL32UTF8 -nationalcharacterset AL16UTF16 \
> -automaticmemorymanagement FALSE \
> -templateName /u01/app/oracle/product/19.0.0/dbhome1/assistants/dbca/templates/General_Purpose.dbc
[oracle@oragrid ~]$ /u01/app/oracle/product/21.0.0/dbhome1/bin/dbca -CreateDatabase -silent -gdbName v16mpc -sid v16mpc -sysPassword sys -systemPassword sys -createAsContainerDatabase true -numberofPDBs 1 -pdbname v16mpcpdb -pdbAdminUserName pdba -pdbAdminPassword password -emConfiguration LOCAL -dbsnmpPassword dbsnmp123 -storageType ASM -datafiledestination +DATA -recoveryAreaDestination +DATA -databaseType MULTIPURPOSE -responseFile NO_VALUE -totalmemory 4096 -characterset AL32UTF8 -nationalcharacterset AL16UTF16 -automaticmemorymanagement FALSE -templateName /u01/app/oracle/product/21.0.0/dbhome1/assistants/dbca/templates/General_Purpose.dbc
[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.
CAUSE:
a. 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].
b.The password entered is a keyword that Oracle does not recommend to be used as password
ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.
CAUSE:
a. 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].
b.The password entered is a keyword that Oracle does not recommend to be used as password
ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'PDBADMIN' password entered does not conform to the Oracle recommended standards.
CAUSE:
a. 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].
b.The password entered is a keyword that Oracle does not recommend to be used as password
ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
Prepare for db operation
7% complete
Registering database with Oracle Restart
11% complete
Copying database files
33% complete
Creating and starting Oracle instance
35% complete
38% complete
45% complete
48% complete
Completing Database Creation
53% complete
55% complete
56% complete
Creating Pluggable Databases
60% complete
78% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/u01/app/oracle/cfgtoollogs/dbca/v16mpc.
Data
a.
[oracle@oragrid trace]$ sqlplus / as sysdba
SQL*Plus: Release 21.0.0.0.0 - Production on Tue Jan 6 12:35:09 2026
Version 21.19.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.19.0.0.0
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/V16MPC/PARAMETERFILE/spf
ile.377.1221826957
SQL>
ile.377.1221826957
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 V16MPCPDB READ WRITE NO
SQL>
[oracle@oragrid oracle]$ cd homes/
[oracle@oragrid homes]$ pwd
/u01/app/oracle/homes
[oracle@oragrid homes]$ ls -ltr
total 0
drwxr-x--- 14 oracle oinstall 172 Dec 24 2024 OraDB21Home1
[oracle@oragrid homes]$ cd OraDB21Home1/
[oracle@oragrid OraDB21Home1]$ ls -ltr
total 0
drwxr-x--- 4 oracle oinstall 30 Dec 24 2024 rdbms
drwxr-x--- 5 oracle oinstall 43 Dec 24 2024 network
drwxr-x--- 3 oracle oinstall 19 Dec 24 2024 mgw
drwxr-x--- 2 oracle oinstall 6 Dec 24 2024 install
drwxr-x--- 3 oracle oinstall 19 Dec 24 2024 hs
drwxr-x--- 3 oracle oinstall 19 Dec 24 2024 drdaas
drwxr-x--- 3 oracle oinstall 18 Dec 24 2024 assistants
drwxr-x--T 4 oracle oinstall 33 Dec 24 2024 log
drwxr-x--- 3 oracle oinstall 22 Dec 24 2024 cfgtoollogs
drwxr-x--- 2 oracle oinstall 6 Dec 30 2024 dbs
drwxr-x--- 3 oracle oinstall 22 Jan 6 11:58 sqlpatch
drwxr-xr-x 5 oracle asmadmin 49 Jan 6 12:24 admin
[oracle@oragrid OraDB21Home1]$
drwxr-x--- 4 oracle oinstall 30 Dec 24 2024 rdbms
drwxr-x--- 5 oracle oinstall 43 Dec 24 2024 network
drwxr-x--- 3 oracle oinstall 19 Dec 24 2024 mgw
drwxr-x--- 2 oracle oinstall 6 Dec 24 2024 install
drwxr-x--- 3 oracle oinstall 19 Dec 24 2024 hs
drwxr-x--- 3 oracle oinstall 19 Dec 24 2024 drdaas
drwxr-x--- 3 oracle oinstall 18 Dec 24 2024 assistants
drwxr-x--T 4 oracle oinstall 33 Dec 24 2024 log
drwxr-x--- 3 oracle oinstall 22 Dec 24 2024 cfgtoollogs
drwxr-x--- 2 oracle oinstall 6 Dec 30 2024 dbs
drwxr-x--- 3 oracle oinstall 22 Jan 6 11:58 sqlpatch
drwxr-xr-x 5 oracle asmadmin 49 Jan 6 12:24 admin
[oracle@oragrid OraDB21Home1]$
[oracle@oragrid OraDB21Home1]$ pwd
/u01/app/oracle/homes/OraDB21Home1
[oracle@oragrid OraDB21Home1]$
Subscribe to:
Comments (Atom)
