Anuj Singh Oracle DBA

Search This Blog

Total Pageviews

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

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'

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;

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;

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]$

Monday, 5 January 2026

Oracle database Patch 38291812 - Database Release Update 19.29.0.0

Oracle database Patch 38291812 - Database Release Update 19.29.0.0



Oracle database Patch 38291812 - Database Release Update 19.29.0.0


/home/oracle/38291812

38291812


export PATH=$ORACLE_HOME/OPatch:$PATH

[oracle@ora19 38291812]$ 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/19.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.48
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-01-05_10-09-20AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[oracle@ora19 38291812]$ pwd
/home/oracle/38291812



===========

[oracle@ora19 38291812]$ 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/19.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.48
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-01-05_10-32-06AM_1.log

Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.

OPatch succeeded.
[oracle@ora19 38291812]$


******************
[oracle@ora19 38291812]$ pwd
/home/oracle/38291812
[oracle@ora19 38291812]$ 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/19.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.48
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-01-05_11-47-26AM_1.log

Verifying environment and performing prerequisite checks...

--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...

Oracle Interim Patch Installer version 12.2.0.1.48
Copyright (c) 2026, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/19.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.48
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-01-05_11-49-40AM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   38291812

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/19.0.0/dbhome_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
y

Applying interim patch '38291812' to OH '/u01/app/oracle/product/19.0.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.crypto.rsf, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.precomp.companion, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.pg4mq, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.java.sqlj.sqljruntime, 19.0.0.0.0 ] , [ oracle.datamining, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.ldap.ztk, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ] , [ oracle.jdk, 1.8.0.391.11 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms, 19.0.0.0.0...

Patching component oracle.rdbms.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.util, 19.0.0.0.0...

Patching component oracle.assistants.acf, 19.0.0.0.0...

Patching component oracle.assistants.deconfig, 19.0.0.0.0...

Patching component oracle.assistants.server, 19.0.0.0.0...

Patching component oracle.blaslapack, 19.0.0.0.0...

Patching component oracle.buildtools.rsf, 19.0.0.0.0...

Patching component oracle.ctx, 19.0.0.0.0...

Patching component oracle.dbdev, 19.0.0.0.0...

Patching component oracle.dbjava.ic, 19.0.0.0.0...

Patching component oracle.dbjava.jdbc, 19.0.0.0.0...

Patching component oracle.dbjava.ucp, 19.0.0.0.0...

Patching component oracle.duma, 19.0.0.0.0...

Patching component oracle.javavm.client, 19.0.0.0.0...

Patching component oracle.ldap.client, 19.0.0.0.0...

Patching component oracle.ldap.owm, 19.0.0.0.0...

Patching component oracle.ldap.rsf, 19.0.0.0.0...

Patching component oracle.ldap.security.osdt, 19.0.0.0.0...

Patching component oracle.marvel, 19.0.0.0.0...

Patching component oracle.network.rsf, 19.0.0.0.0...

Patching component oracle.odbc.ic, 19.0.0.0.0...

Patching component oracle.ons, 19.0.0.0.0...

Patching component oracle.ons.ic, 19.0.0.0.0...

Patching component oracle.oracore.rsf, 19.0.0.0.0...

Patching component oracle.perlint, 5.28.1.0.0...

Patching component oracle.precomp.common.core, 19.0.0.0.0...

Patching component oracle.precomp.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.crs, 19.0.0.0.0...

Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...

Patching component oracle.rdbms.deconfig, 19.0.0.0.0...

Patching component oracle.rdbms.install.common, 19.0.0.0.0...

Patching component oracle.rdbms.oci, 19.0.0.0.0...

Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0...

Patching component oracle.rdbms.scheduler, 19.0.0.0.0...

Patching component oracle.rhp.db, 19.0.0.0.0...

Patching component oracle.rsf, 19.0.0.0.0...

Patching component oracle.sdo, 19.0.0.0.0...

Patching component oracle.sdo.locator.jrf, 19.0.0.0.0...

Patching component oracle.sqlplus, 19.0.0.0.0...

Patching component oracle.sqlplus.ic, 19.0.0.0.0...

Patching component oracle.tfa.db, 19.0.0.0.0...

Patching component oracle.wwg.plsql, 19.0.0.0.0...

Patching component oracle.xdk.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.locator, 19.0.0.0.0...

Patching component oracle.network.aso, 19.0.0.0.0...

Patching component oracle.ctx.atg, 19.0.0.0.0...

Patching component oracle.ovm, 19.0.0.0.0...

Patching component oracle.rdbms.lbac, 19.0.0.0.0...

Patching component oracle.ctx.rsf, 19.0.0.0.0...

Patching component oracle.ldap.rsf.ic, 19.0.0.0.0...

Patching component oracle.rdbms.rman, 19.0.0.0.0...

Patching component oracle.network.client, 19.0.0.0.0...

Patching component oracle.xdk.xquery, 19.0.0.0.0...

Patching component oracle.nlsrtl.rsf.core, 19.0.0.0.0...

Patching component oracle.oraolap, 19.0.0.0.0...

Patching component oracle.xdk.server, 19.0.0.0.0...

Patching component oracle.rdbms.install.plugins, 19.0.0.0.0...

Patching component oracle.odbc, 19.0.0.0.0...

Patching component oracle.oraolap.api, 19.0.0.0.0...

Patching component oracle.xdk.parser.java, 19.0.0.0.0...

Patching component oracle.oraolap.dbscripts, 19.0.0.0.0...

Patching component oracle.rdbms.rat, 19.0.0.0.0...

Patching component oracle.install.deinstalltool, 19.0.0.0.0...

Patching component oracle.dbtoolslistener, 19.0.0.0.0...

Patching component oracle.rdbms.hsodbc, 19.0.0.0.0...

Patching component oracle.rdbms.drdaas, 19.0.0.0.0...

Patching component oracle.ldap.ssl, 19.0.0.0.0...

Patching component oracle.xdk, 19.0.0.0.0...

Patching component oracle.rdbms.dm, 19.0.0.0.0...

Patching component oracle.nlsrtl.rsf, 19.0.0.0.0...

Patching component oracle.nlsrtl.rsf.core, 19.0.0.0.0...

Patching component oracle.nlsrtl.rsf.ic, 19.0.0.0.0...

Patching component oracle.sqlj.sqljruntime, 19.0.0.0.0...

Patching component oracle.javavm.server, 19.0.0.0.0...

Patching component oracle.nlsrtl.rsf.lbuilder, 19.0.0.0.0...

Patching component oracle.mgw.common, 19.0.0.0.0...

Patching component oracle.network.listener, 19.0.0.0.0...

Patching component oracle.rdbms.dv, 19.0.0.0.0...

Patching component oracle.sdo.locator, 19.0.0.0.0...

Patching component oracle.rdbms.hs_common, 19.0.0.0.0...

Patching component oracle.precomp.common, 19.0.0.0.0...

Patching component oracle.precomp.lang, 19.0.0.0.0...

Patching component oracle.jdk, 1.8.0.201.0...
Patch 38291812 successfully applied.
Sub-set patch [37960098] has become inactive due to the application of a super-set patch [38291812].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-01-05_11-49-40AM_1.log

OPatch succeeded.
[oracle@ora19 38291812]$ y
bash: y: command not found...
[oracle@ora19 38291812]$


*****************************************************************************************************

[oracle@ora19 38291812]$ sqlme

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jan 5 12:02:56 2026
Version 19.29.0.0.0

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

Connected to an idle instance.

SQL> startup ;
ORACLE instance started.

Total System Global Area  910160856 bytes
Fixed Size                  9184216 bytes
Variable Size             578813952 bytes
Database Buffers          314572800 bytes
Redo Buffers                7589888 bytes
Database mounted.
Database opened.
SQL>  alter pluggable database all open;

Pluggable database altered.

SQL>


SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 VIHAAN27                       READ WRITE NO
SQL>


 cd $ORACLE_HOME/OPatch

[oracle@ora19 OPatch]$ pwd
/u01/app/oracle/product/19.0.0/dbhome_1/OPatch
[oracle@ora19 OPatch]$


[oracle@ora19 OPatch]$ ls -ltr data*
-rwxr-x--- 1 oracle oinstall 589 Oct  7 15:11 datapatch
[oracle@ora19 OPatch]$ ./datapatch -sanity_checks
SQL Patching sanity checks version 19.29.0.0.0 on Mon 05 Jan 2026 12:07:36 GMT
Copyright (c) 2021, 2026, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sanity_checks_20260105_120736_9801/sanity_checks_20260105_120736_9801.log

Running checks
JSON report generated in /u01/app/oracle/cfgtoollogs/sqlpatch/sanity_checks_20260105_120736_9801/sqlpatch_sanity_checks_summary.json file
Checks completed. Printing report:

Check: Database component status - INFO
  There should be no INVALID components prior patching due to risk of potential errors.
  Listed components have a non-valid status.
  For INVALID components: Run '?/rdbms/admin/utlrp.sql' (per container) to try recompiling invalid objects and restore component status.
  For other non-valid status, depending on patch content warnings may be returned.
  VIHAAN27:
    | COMPONENT | STATUS  |
    |-----------+---------|
    |    SDO    | LOADING |
    |-----------+---------|
Check: PDB Violations - OK
Check: Invalid System Objects - OK
Check: Tablespace Status - ERROR
  Temp tablespaces must have sufficient space for patching. Minimum recommended space is 2GB.
  Tablespace is above 80% of used space or it has less than 2GB of space left.
  Ensure there is adequate tablespace for patching. Note suggested quantities are an estimated minimum size value, it is strongly recommended to adjust the data file maximum size as needed based on testing. Refer to the section "Managing Data Files and Temp Files" in the Oracle Database Administrator's Guide for details on managing data file operations.
  VIHAAN27:
    | TABLESPACE_NAME  | AUTO_EXTENSIBLE | TABLESPACE_SIZE | FREE_TABLESPACE | USAGE |
    |------------------+-----------------+-----------------+-----------------+-------|
    | ODITEST_ODI_TEMP |       YES       |      1000       |       999       |  .1   |
    |------------------+-----------------+-----------------+-----------------+-------|
Check: Backup jobs - OK
Check: Temp file exists - OK
Check: Temp file online - OK
Check: Data Pump running - OK
Check: Container status - OK
Check: Oracle Database Keystore - OK
Check: Dictionary statistics gathering - WARNING
  Patching the database without recent data dictionary statistics gathered may lead to performance issues.
  Data dictionary statistics are older than 7 days.
  Run the following queries to start gathering the dictionary statistics:
    EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;
    EXEC DBMS_SYSTEM.GATHER_FIXED_OBJECTS_STATS;
  Refer to MOS 457926.1 for more details.
  PDB$SEED:
    |     LATEST      |        OPERATION        |  STATUS   |
    |-----------------+-------------------------+-----------|
    | 25-JUN-25 10:56 | gather_dictionary_stats | COMPLETED |
    |-----------------+-------------------------+-----------|
Check: Scheduled Jobs - OK
Check: GoldenGate triggers - OK
Check: Logminer DDL triggers - OK
Check: Check sys public grants - OK
Check: Statistics gathering running - OK
Check: Optim dictionary upgrade parameter - OK
Check: Symlinks on oracle home path - OK
Check: Central Inventory - OK
Check: Java Virtual Machine Enable - OK
Check: Oracle Database Vault Enabled - OK
Check: Queryable Inventory database directories - OK
Check: Queryable Inventory locks - OK
Check: Queryable Inventory package - OK
Check: Queryable Inventory external table - OK
Check: Imperva processes - OK
Check: Guardium processes - OK
Check: Locale - OK

Refer to MOS Note 2975965.1 and debug log
/u01/app/oracle/cfgtoollogs/sqlpatch/sanity_checks_20260105_120736_9801/sanity_checks_debug_20260105_120736_9801.log

SQL Patching sanity checks completed on Mon 05 Jan 2026 12:07:42 GMT
[oracle@ora19 OPatch]$


**************************************************


[oracle@ora19 OPatch]$ ./datapatch -verbose
SQL Patching tool version 19.29.0.0.0 Production on Mon Jan  5 12:08:29 2026
Copyright (c) 2012, 2025, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_9824_2026_01_05_12_08_29/sqlpatch_invocation.log

Connecting to database...OK
Gathering database info...done

Note:  Datapatch will only apply or rollback SQL fixes for PDBs
       that are in an open state, no patches will be applied to closed PDBs.
       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
       (Doc ID 1585822.1)

Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of interim SQL patches:
  No interim patches found

Current state of release update SQL patches:
  Binary registry:
    19.29.0.0.0 Release_Update 251002005342: Installed
  PDB CDB$ROOT:
    Applied 19.28.0.0.0 Release_Update 250705030417 successfully on 04-JAN-26 17.28.02.803708
  PDB PDB$SEED:
    Applied 19.28.0.0.0 Release_Update 250705030417 successfully on 04-JAN-26 17.33.02.268396
  PDB VIHAAN27:
    Applied 19.28.0.0.0 Release_Update 250705030417 successfully on 04-JAN-26 17.32.54.258125

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED VIHAAN27
    No interim patches need to be rolled back
    Patch 38291812 (Database Release Update : 19.29.0.0.251021 (38291812)):
      Apply from 19.28.0.0.0 Release_Update 250705030417 to 19.29.0.0.0 Release_Update 251002005342
    No interim patches need to be applied

Installing patches...
Patch installation complete.  Total patches installed: 3

Validating logfiles...done
Patch 38291812 apply (pdb CDB$ROOT): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/38291812/28130960/38291812_apply_VIHAAN_CDBROOT_2026Jan05_12_11_57.log (no errors)
Patch 38291812 apply (pdb PDB$SEED): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/38291812/28130960/38291812_apply_VIHAAN_PDBSEED_2026Jan05_12_13_00.log (no errors)
Patch 38291812 apply (pdb VIHAAN27): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/38291812/28130960/38291812_apply_VIHAAN_VIHAAN27_2026Jan05_12_13_00.log (no errors)
SQL Patching tool complete on Mon Jan  5 12:13:50 2026

[oracle@ora19 OPatch]$



 sqlme

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jan 5 12:22:48 2026
Version 19.29.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.29.0.0.0  <<<<<<





set lines 132  verify  off head off  feedback on  long 1000
select distinct
'======================================================'	||chr(10)||
'INSTALL ID.................: '||INSTALL_ID 			||Chr(10)||
'PATCH_ID...................: '||PATCH_ID 			||Chr(10)||
'PATCH UID..................: '||PATCH_UID   			||Chr(10)||
'PATCH TYPE.................: '||PATCH_TYPE  			||Chr(10)||
'ACTION.....................: '||ACTION   			||Chr(10)||
'STATUS.....................: '||STATUS   			||Chr(10)||
'ACTION TIME................: '||ACTION_TIME    		||Chr(10)||
'DESCRIPTION................: '||DESCRIPTION    		||Chr(10)||
'FLAGS......................: '||FLAGS   			||Chr(10)||
'SOURCE VERSION.............: '||SOURCE_VERSION 		||Chr(10)||
'SOURCE BUILD_DESCRIPTION...: '||SOURCE_BUILD_DESCRIPTION    	||Chr(10)||
'SOURCE BUILD_TIMESTAMP.....: '||SOURCE_BUILD_TIMESTAMP  	||Chr(10)||
'TARGET VERSION.............: '||TARGET_VERSION   	 	||Chr(10)||
'TARGET BUILD DESCRIPTION...: '||TARGET_BUILD_DESCRIPTION    	||Chr(10)||
'TARGET BUILD TIMESTAMP.....: '||TARGET_BUILD_TIMESTAMP         ||Chr(10)
--'LOGFILE....................: '||LOGFILE  			||Chr(10)||
--'RU LOGFILE.................: '||RU_LOGFILE   		||Chr(10)
from dba_registry_sqlpatch  
order by 1




======================================================
INSTALL ID.................: 1
PATCH_ID...................: 37642901
PATCH UID..................: 27123174
PATCH TYPE.................: RU
ACTION.....................: APPLY
STATUS.....................: SUCCESS
ACTION TIME................: 14-JUN-25 11.00.09.198524
DESCRIPTION................: Database Release Update : 19.27.0.0.250415 (37642901)
FLAGS......................: N
SOURCE VERSION.............: 19.1.0.0.0
SOURCE BUILD_DESCRIPTION...: Feature Release
SOURCE BUILD_TIMESTAMP.....:

TARGET VERSION.............: 19.27.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 06-APR-25 13.11.39.000000

======================================================
INSTALL ID.................: 2
PATCH_ID...................: 37960098
PATCH UID..................: 27635722
PATCH TYPE.................: RU
ACTION.....................: APPLY
STATUS.....................: SUCCESS
ACTION TIME................: 04-JAN-26 17.28.02.803708
DESCRIPTION................: Database Release Update : 19.28.0.0.250715 (37960098)

FLAGS......................: N
SOURCE VERSION.............: 19.27.0.0.0
SOURCE BUILD_DESCRIPTION...: Release_Update
SOURCE BUILD_TIMESTAMP.....: 06-APR-25 13.11.39.000000
TARGET VERSION.............: 19.28.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 05-JUL-25 03.04.17.000000

======================================================
INSTALL ID.................: 3
PATCH_ID...................: 38291812
PATCH UID..................: 28130960
PATCH TYPE.................: RU

ACTION.....................: APPLY
STATUS.....................: SUCCESS
ACTION TIME................: 05-JAN-26 12.12.44.490435
DESCRIPTION................: Database Release Update : 19.29.0.0.251021 (38291812)
FLAGS......................: N
SOURCE VERSION.............: 19.28.0.0.0
SOURCE BUILD_DESCRIPTION...: Release_Update
SOURCE BUILD_TIMESTAMP.....: 05-JUL-25 03.04.17.000000
TARGET VERSION.............: 19.29.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 02-OCT-25 00.53.42.000000


3 rows selected.



set lines 132  verify  off head off  feedback on  long 1000
select distinct
'======================================================'	||chr(10)||
'INSTALL ID.................: '||INSTALL_ID 			||Chr(10)||
'PATCH_ID...................: '||PATCH_ID 			||Chr(10)||
'PATCH UID..................: '||PATCH_UID   			||Chr(10)||
'PATCH TYPE.................: '||PATCH_TYPE  			||Chr(10)||
'ACTION.....................: '||ACTION   			||Chr(10)||
'STATUS.....................: '||STATUS   			||Chr(10)||
'ACTION TIME................: '||ACTION_TIME    		||Chr(10)||
'DESCRIPTION................: '||DESCRIPTION    		||Chr(10)||
'FLAGS......................: '||FLAGS   			||Chr(10)||
'SOURCE VERSION.............: '||SOURCE_VERSION 		||Chr(10)||
'SOURCE BUILD_DESCRIPTION...: '||SOURCE_BUILD_DESCRIPTION    	||Chr(10)||
'SOURCE BUILD_TIMESTAMP.....: '||SOURCE_BUILD_TIMESTAMP  	||Chr(10)||
'TARGET VERSION.............: '||TARGET_VERSION   	 	||Chr(10)||
'TARGET BUILD DESCRIPTION...: '||TARGET_BUILD_DESCRIPTION    	||Chr(10)||
'TARGET BUILD TIMESTAMP.....: '||TARGET_BUILD_TIMESTAMP         ||Chr(10)||
'CON_ID.....................: '||CON_ID
--'LOGFILE....................: '||LOGFILE  			||Chr(10)||
--'RU LOGFILE.................: '||RU_LOGFILE   		||Chr(10)
from cdb_registry_sqlpatch
 order by 1



======================================================
INSTALL ID.................: 1
PATCH_ID...................: 37642901
PATCH UID..................: 27123174
PATCH TYPE.................: RU
ACTION.....................: APPLY
STATUS.....................: SUCCESS
ACTION TIME................: 14-JUN-25 11.00.09.198524
DESCRIPTION................: Database Release Update : 19.27.0.0.250415 (37642901)
FLAGS......................: N
SOURCE VERSION.............: 19.1.0.0.0
SOURCE BUILD_DESCRIPTION...: Feature Release
SOURCE BUILD_TIMESTAMP.....:

TARGET VERSION.............: 19.27.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 06-APR-25 13.11.39.000000
CON_ID.....................: 1

======================================================
INSTALL ID.................: 1
PATCH_ID...................: 37642901
PATCH UID..................: 27123174
PATCH TYPE.................: RU
ACTION.....................: APPLY
STATUS.....................: WITH ERRORS
ACTION TIME................: 14-JUN-25 11.05.28.279212

DESCRIPTION................: Database Release Update : 19.27.0.0.250415 (37642901)
FLAGS......................: N
SOURCE VERSION.............: 19.1.0.0.0
SOURCE BUILD_DESCRIPTION...: Feature Release
SOURCE BUILD_TIMESTAMP.....:
TARGET VERSION.............: 19.27.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 06-APR-25 13.11.39.000000
CON_ID.....................: 3

======================================================
INSTALL ID.................: 2
PATCH_ID...................: 37642901

PATCH UID..................: 27123174
PATCH TYPE.................: RU
ACTION.....................: APPLY
STATUS.....................: SUCCESS
ACTION TIME................: 25-JUN-25 11.12.32.980376
DESCRIPTION................: Database Release Update : 19.27.0.0.250415 (37642901)
FLAGS......................: N
SOURCE VERSION.............: 19.1.0.0.0
SOURCE BUILD_DESCRIPTION...: Feature Release
SOURCE BUILD_TIMESTAMP.....:
TARGET VERSION.............: 19.27.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 06-APR-25 13.11.39.000000

CON_ID.....................: 3

======================================================
INSTALL ID.................: 2
PATCH_ID...................: 37960098
PATCH UID..................: 27635722
PATCH TYPE.................: RU
ACTION.....................: APPLY
STATUS.....................: SUCCESS
ACTION TIME................: 04-JAN-26 17.28.02.803708
DESCRIPTION................: Database Release Update : 19.28.0.0.250715 (37960098)
FLAGS......................: N
SOURCE VERSION.............: 19.27.0.0.0

SOURCE BUILD_DESCRIPTION...: Release_Update
SOURCE BUILD_TIMESTAMP.....: 06-APR-25 13.11.39.000000
TARGET VERSION.............: 19.28.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 05-JUL-25 03.04.17.000000
CON_ID.....................: 1

======================================================
INSTALL ID.................: 3
PATCH_ID...................: 37960098
PATCH UID..................: 27635722
PATCH TYPE.................: RU
ACTION.....................: APPLY

STATUS.....................: SUCCESS
ACTION TIME................: 04-JAN-26 17.32.54.258125
DESCRIPTION................: Database Release Update : 19.28.0.0.250715 (37960098)
FLAGS......................: N
SOURCE VERSION.............: 19.27.0.0.0
SOURCE BUILD_DESCRIPTION...: Release_Update
SOURCE BUILD_TIMESTAMP.....: 06-APR-25 13.11.39.000000
TARGET VERSION.............: 19.28.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 05-JUL-25 03.04.17.000000
CON_ID.....................: 3

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

INSTALL ID.................: 3
PATCH_ID...................: 38291812
PATCH UID..................: 28130960
PATCH TYPE.................: RU
ACTION.....................: APPLY
STATUS.....................: SUCCESS
ACTION TIME................: 05-JAN-26 12.12.44.490435
DESCRIPTION................: Database Release Update : 19.29.0.0.251021 (38291812)
FLAGS......................: N
SOURCE VERSION.............: 19.28.0.0.0
SOURCE BUILD_DESCRIPTION...: Release_Update
SOURCE BUILD_TIMESTAMP.....: 05-JUL-25 03.04.17.000000
TARGET VERSION.............: 19.29.0.0.0

TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 02-OCT-25 00.53.42.000000
CON_ID.....................: 1

======================================================
INSTALL ID.................: 4
PATCH_ID...................: 38291812
PATCH UID..................: 28130960
PATCH TYPE.................: RU
ACTION.....................: APPLY
STATUS.....................: SUCCESS
ACTION TIME................: 05-JAN-26 12.13.29.590889
DESCRIPTION................: Database Release Update : 19.29.0.0.251021 (38291812)

FLAGS......................: N
SOURCE VERSION.............: 19.28.0.0.0
SOURCE BUILD_DESCRIPTION...: Release_Update
SOURCE BUILD_TIMESTAMP.....: 05-JUL-25 03.04.17.000000
TARGET VERSION.............: 19.29.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 02-OCT-25 00.53.42.000000
CON_ID.....................: 3


7 rows selected.


Oracle DBA

anuj blog Archive