Anuj Singh Oracle DBA

Monday, 2 March 2026

ORA-14693: The MAX_STRING_SIZE parameter must be EXTENDED.

SQL>

ALTER PLUGGABLE DATABASE ORCL19 OPEN UPGRADE;

SQL> ALTER PLUGGABLE DATABASE ORCL19 OPEN UPGRADE

ERROR at line 1:

ORA-14693: The MAX_STRING_SIZE parameter must be EXTENDED.

Help: https://docs.oracle.com/error-help/db/ora-14693/

SQL> SHOW PARAMETER max_string_size;

NAME TYPE VALUE

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

max_string_size string STANDARD

SQL> SHUTDOWN IMMEDIATE;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> ALTER SYSTEM SET max_string_size=EXTENDED SCOPE=SPFILE;

ALTER SYSTEM SET max_string_size=EXTENDED SCOPE=SPFILE

ERROR at line 1:

ORA-01034: The Oracle instance is not available for use. Start the instance.

Process ID: 0

Session ID: 0 Serial number: 0

Help: https://docs.oracle.com/error-help/db/ora-01034/

SQL> STARTUP UPGRADE;

ORACLE instance started.

Total System Global Area 6120784560 bytes

Fixed Size 5022384 bytes

Variable Size 1124073472 bytes

Database Buffers 4982833152 bytes

Redo Buffers 8855552 bytes

Database mounted.

Database opened.

SQL> ALTER SYSTEM SET max_string_size=EXTENDED SCOPE=SPFILE;

System altered.

SQL> @?/rdbms/admin/utl32k.sql

Session altered.

DOC>#######################################################################

DOC> The following statement will cause an "ORA-01722: invalid number"

DOC> error if the database has not been opened for UPGRADE.

DOC>

DOC> Perform a "SHUTDOWN ABORT" and

DOC> restart using UPGRADE.

DOC>#######################################################################

DOC>#

no rows selected

DOC>#######################################################################

DOC> The following statement will cause an "ORA-01722: invalid number"

DOC> error if the database does not have compatible >= 12.0.0

DOC>

DOC> Set compatible >= 12.0.0 and retry.

DOC>#######################################################################

DOC>#

PL/SQL procedure successfully completed.

Session altered.

0 rows updated.

Commit complete.

System altered.

PL/SQL procedure successfully completed.

Commit complete.

System altered.

Session altered.

Table created.

Table truncated.

0 rows created.

PL/SQL procedure successfully completed.

STARTTIME

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

03/02/2026 13:55:45.089424000

PL/SQL procedure successfully completed.

No errors.

PL/SQL procedure successfully completed.

Session altered.

0 rows created.

no rows selected

DOC>#######################################################################

DOC> The following statement will cause an "ORA-01722: invalid number"

DOC> error if we encountered an error while modifying a column to

DOC> account for data type length change as a result of enabling or

DOC> disabling 32k types.

DOC>

DOC> Contact Oracle support for assistance.

DOC>#######################################################################

DOC>#

PL/SQL procedure successfully completed.

Commit complete.

Package altered.

Session altered.

SQL> SHUTDOWN IMMEDIATE;

ORA-00603: ORACLE server session terminated by irrecoverable error

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-01013: User requested cancel of current operation.

Process ID: 5168

Session ID: 625 Serial number: 8539

Help: https://docs.oracle.com/error-help/db/ora-00603/

SQL> SHUTDOWN ABORT;

ORA-24324: service handle not initialized

Help: https://docs.oracle.com/error-help/db/ora-24324/

ORA-01041: internal error. hostdef extension doesn't exist

SQL> Disconnected from Oracle AI Database 26ai Enterprise Edition Release 23.26.1.0.0 - Production

Version 23.26.1.0.0

[oracle@centos9 admin]$ sqlplus / as sysdba

SQL*Plus: Release 23.26.1.0.0 - Production on Mon Mar 2 13:58:56 2026

Version 23.26.1.0.0

Connected to an idle instance.

SQL> SHUTDOWN ABORT;

ORACLE instance shut down.

SQL> starup ;

SP2-0042: unknown command "starup " - rest of line ignored.

Help: https://docs.oracle.com/error-help/db/sp2-0042/

SQL> startup ;

ORACLE instance started.

Total System Global Area 6120784560 bytes

Fixed Size 5022384 bytes

Variable Size 1124073472 bytes

Database Buffers 4982833152 bytes

Redo Buffers 8855552 bytes

Database mounted.

Database opened.

SQL> show parameter max_string_size

NAME TYPE VALUE

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

max_string_size string EXTENDED

upgrade database from 19c to 26ai !!!




upgrade database  from 19c to 26ai !!!

oracle 26ai 192.168.1.148



on 19c 

CREATE USER c##uprgd IDENTIFIED BY oracle DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp CONTAINER=ALL;
GRANT CREATE SESSION, CREATE PLUGGABLE DATABASE, SYSOPER TO c##uprgd CONTAINER = ALL;



on 19c 
cat tnsnames.ora


orclcdb2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.109)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orclcdb)
    )
  )

orclcdb1 =(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.109)(PORT=1521))(CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=orclcdb)))




SQL> show pdbs

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


on 26ai 

SQL> CREATE public DATABASE link clonedb CONNECT TO c##uprgd IDENTIFIED BY oracle USING 'orclcdb1';

Database link created.




orclcdb1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.109)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl19)
    )
  )


===========

19c 
ILE_NAME
--------------------------------------------------------------------------------
   FILE_ID TABLESPACE_NAME                     BYTES     BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT   MAXBYTES  MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_ LOST_WR
------- -------
/u01/app/oracle/oradata/ORCLCDB/orcl/undotbs2.dbf
        15 UNDOTBS2                        209715200      25600 AVAILABLE
          15 YES 3.4360E+10    4194302         6400  208666624       25472
ONLINE  OFF



26ai 
FILE_NAME
--------------------------------------------------------------------------------
   FILE_ID TABLESPACE_NAME                     BYTES     BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT   MAXBYTES  MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_ LOST_WR
------- -------
/u01/app/oracle/oradata/ORCL/orclpdb/users01.dbf
        15 USERS                             7340032        896 AVAILABLE
        1024 YES 3.5184E+13 4294967293          160    1015808         124
ONLINE  OFF

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


orclcdb1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.109)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl19)
    )
  )




SQL> SELECT sys_context('USERENV','CON_NAME') FROM dual@clonedb;

SYS_CONTEXT('USERENV','CON_NAME')
--------------------------------------------------------------------------------
CDB$ROOT


on 26ai!!!

SQL> CREATE PLUGGABLE DATABASE ORCL19 FROM ORCL19@clonedb file_name_convert=('orcl','PDBU');

Pluggable database created.

or

CREATE PLUGGABLE DATABASE PDB19
FROM ORCL19@clonedb
FILE_NAME_CONVERT = (
  '/u01/app/oracle/oradata/ORCLCDB/orcl/',
  '/u01/app/oracle/oradata/ORCLCDB/PDB19/'
);


 show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ORCLPDB                        READ WRITE NO
         4 ORCL19                         MOUNTED
SQL>





ALTER PLUGGABLE DATABASE ORCL19 OPEN UPGRADE;



dbupgrade -c "ORCL19" -l /home/oracle/logs


SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       MOUNTED
         3 ORCLPDB                        MOUNTED
         4 ORCL19                         MOUNTED



SQL> ALTER PLUGGABLE DATABASE ORCL19 OPEN UPGRADE;

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       MOUNTED
         3 ORCLPDB                        MOUNTED
         4 ORCL19                         MIGRATE    YES


SQL> Disconnected from Oracle AI Database 26ai Enterprise Edition Release 23.26.1.0.0 - Production
Version 23.26.1.0.0
[oracle@centos9 admin]$ locate dbupgrade
/u01/app/oracle/product/23.26.0/db_1/bin/dbupgrade

[oracle@centos9 admin]$ dbupgrade -c "ORCL19" -l /home/oracle/logs
Manual upgrade using dbupgrade is desupported as of Oracle Database 23.4. Oracle recommends using AutoUpgrade to upgrade your database. Refer to My Oracle Support Note 2485457.1 for details on AutoUpgrade.

Argument list for [/u01/app/oracle/product/23.26.0/db_1/rdbms/admin/catctl.pl]
For Oracle internal use only A = 0
Run in                       c = ORCL19
Do not run in                C = 0
Input Directory              d = 0
Echo OFF                     e = 1
Simulate                     E = 0
Forced cleanup               F = 0
Log Id                       i = 0
Child Process                I = 0
Log Dir                      l = /home/oracle/logs
Priority List Name           L = 0
Upgrade Mode active          M = 0
SQL Process Count            n = 0
SQL PDB Process Count        N = 0
Open Mode Normal             o = 0
Start Phase                  p = 0
End Phase                    P = 0
Reverse Order                r = 0
AutoUpgrade Resume           R = 0
Script                       s = 0
Serial Run                   S = 0
Classic Upgrade              t = 0
RO User Tablespaces          T = 0
Zip Logs                     w = 0
Upgrade PDBs in Upgrade mode x = 0
Display Phases               y = 0
Debug catcon.pm              z = 0
Debug catctl.pl              Z = 0
Manual upgrade using catctl.pl is desupported as of Oracle Database 23.4. Oracle recommends using AutoUpgrade to upgrade your database.

catctl.pl VERSION: [23.0.0.0.0]
           STATUS: [Production]
            BUILD: [RDBMS_23.26.1.0.0DBRU_LINUX.X64_260116.1]


/u01/app/oracle/product/23.26.0/db_1/rdbms/admin/orahome = [/u01/app/oracle/product/23.26.0/db_1]
/u01/app/oracle/product/23.26.0/db_1/bin/orabasehome = [/u01/app/oracle/product/23.26.0/db_1]
catctlGetOraBaseLogDir = [/u01/app/oracle/product/23.26.0/db_1]

Analyzing file /u01/app/oracle/product/23.26.0/db_1/rdbms/admin/catupgrd.sql

Log file directory = [/home/oracle/logs]

catcon::set_log_file_base_path: ALL catcon-related output will be written to [/home/oracle/logs/catupgrd_catcon_5752.lst]

catcon::set_log_file_base_path: catcon: See [/home/oracle/logs/catupgrd*.log] files for output generated by scripts

catcon::set_log_file_base_path: catcon: See [/home/oracle/logs/catupgrd_*.lst] files for spool files, if any


Number of Cpus        = 9
Database Name         = orcl
DataBase Version      = 23.0.0.0.0
Parallel SQL Process Count (PDB)      = 2
Parallel SQL Process Count (CDB$ROOT) = 8
Generated PDB Inclusion:[ORCL19]
CDB$ROOT  Open Mode = [OPEN]
DataBase Version      = 23.0.0.0.0

** Must upgrade either a CDB$ROOT or a Pdb **
Concurrent PDB Upgrades Reset           = 1
Concurrent PDB Upgrades               = 1

Start processing of PDBs (ORCL19)
[/u01/app/oracle/product/23.26.0/db_1/perl/bin/perl /u01/app/oracle/product/23.26.0/db_1/rdbms/admin/catctl.pl -c 'ORCL19' -l /home/oracle/logs -I -i orcl19 -n 2 /u01/app/oracle/product/23.26.0/db_1/rdbms/admin/catupgrd.sql]

Argument list for [/u01/app/oracle/product/23.26.0/db_1/rdbms/admin/catctl.pl]
For Oracle internal use only A = 0
Run in                       c = ORCL19
Do not run in                C = 0
Input Directory              d = 0
Echo OFF                     e = 1
Simulate                     E = 0
Forced cleanup               F = 0
Log Id                       i = orcl19
Child Process                I = 1
Log Dir                      l = /home/oracle/logs
Priority List Name           L = 0
Upgrade Mode active          M = 0
SQL Process Count            n = 2
SQL PDB Process Count        N = 0
Open Mode Normal             o = 0
Start Phase                  p = 0
End Phase                    P = 0
Reverse Order                r = 0
AutoUpgrade Resume           R = 0
Script                       s = 0
Serial Run                   S = 0
Classic Upgrade              t = 0
RO User Tablespaces          T = 0
Zip Logs                     w = 0
Upgrade PDBs in Upgrade mode x = 0
Display Phases               y = 0
Debug catcon.pm              z = 0
Debug catctl.pl              Z = 0
Manual upgrade using catctl.pl is desupported as of Oracle Database 23.4. Oracle recommends using AutoUpgrade to upgrade your database.

catctl.pl VERSION: [23.0.0.0.0]
           STATUS: [Production]
            BUILD: [RDBMS_23.26.1.0.0DBRU_LINUX.X64_260116.1]


/u01/app/oracle/product/23.26.0/db_1/rdbms/admin/orahome = [/u01/app/oracle/product/23.26.0/db_1]
/u01/app/oracle/product/23.26.0/db_1/bin/orabasehome = [/u01/app/oracle/product/23.26.0/db_1]
catctlGetOraBaseLogDir = [/u01/app/oracle/product/23.26.0/db_1]

Analyzing file /u01/app/oracle/product/23.26.0/db_1/rdbms/admin/catupgrd.sql

Log file directory = [/home/oracle/logs]

catcon::set_log_file_base_path: ALL catcon-related output will be written to [/home/oracle/logs/catupgrdorcl19_catcon_5951.lst]

catcon::set_log_file_base_path: catcon: See [/home/oracle/logs/catupgrdorcl19*.log] files for output generated by scripts

catcon::set_log_file_base_path: catcon: See [/home/oracle/logs/catupgrdorcl19_*.lst] files for spool files, if any


Number of Cpus        = 9
Database Name         = orcl
DataBase Version      = 23.0.0.0.0
ORCL19 Open Mode = [MIGRATE]
Generated PDB Inclusion:[ORCL19]
CDB$ROOT  Open Mode = [OPEN]
Components in [ORCL19]
    Installed [APEX APS CATALOG CATJAVA CATPROC CONTEXT DV JAVAVM OLS ORDIM OWM SDO XDB XML XOQ]
Not Installed [EM LCTR MGW ODM RAC WK]
DataBase Version      = 23.0.0.0.0

------------------------------------------------------
        Start Time:[2026_03_02 14:04:09]
Container Lists Inclusion:[ORCL19] Exclusion:[]
------------------------------------------------------




***********   Executing Change Scripts   ***********
Serial   Phase #:0    [ORCL19] Files:1     Time: 29s
***************   Catalog Core SQL   ***************
Serial   Phase #:1    [ORCL19] Files:5     Time: 12s
***********   Catalog Tables and Views   ***********
Parallel Phase #:3    [ORCL19] Files:21     Time: 11s
*************   Catalog Final Scripts   ************
Serial   Phase #:5    [ORCL19] Files:7     Time: 2s
*****************   Catproc Start   ****************
Serial   Phase #:6    [ORCL19] Files:1     Time: 2s
*****************   Catproc Types   ****************
Serial   Phase #:7    [ORCL19] Files:2     Time: 3s
****************   Catproc Tables   ****************
Parallel Phase #:9    [ORCL19] Files:89     Time: 12s
*************   Catproc Package Specs   ************
Serial   Phase #:11   [ORCL19] Files:1     Time: 19s
**************   Catproc Procedures   **************
Parallel Phase #:13   [ORCL19] Files:103     Time: 2s
Parallel Phase #:15   [ORCL19] Files:129     Time: 3s
Serial   Phase #:17   [ORCL19] Files:12     Time: 0s
Parallel Phase #:19   [ORCL19] Files:51     Time: 1s
*****************   Catproc Views   ****************
Parallel Phase #:21   [ORCL19] Files:32     Time: 6s
Serial   Phase #:23   [ORCL19] Files:2     Time: 3s
Parallel Phase #:25   [ORCL19] Files:15     Time: 190s
*****************   Catpdeps PLBs   ****************
Serial   Phase #:28   [ORCL19] Files:14     Time: 0s
Parallel Phase #:31   [ORCL19] Files:12     Time: 24s
Serial   Phase #:33   [ORCL19] Files:13     Time: 3s
***************   Catproc CDB Views   **************
Serial   Phase #:35   [ORCL19] Files:1     Time: 0s
*****************   Catproc PLBs   *****************
Serial   Phase #:39   [ORCL19] Files:321     Time: 3s
Serial   Phase #:42   [ORCL19] Files:44     Time: 1s
***************   Catproc DataPump   ***************
Serial   Phase #:44   [ORCL19] Files:3     Time: 10s
******************   Catproc SQL   *****************
Parallel Phase #:46   [ORCL19] Files:12     Time: 16s
Parallel Phase #:48   [ORCL19] Files:11     Time: 5s
Parallel Phase #:50   [ORCL19] Files:8     Time: 3s
*************   Final Catproc scripts   ************
Serial   Phase #:52   [ORCL19] Files:1     Time: 1s
**************   Final RDBMS scripts   *************
Serial   Phase #:54   [ORCL19] Files:1     Time: 24s
************   Upgrade Component Start   ***********
Serial   Phase #:55   [ORCL19] Files:1     Time: 0s
**********   Upgrading Java and non-Java   *********
Parallel Phase #:57   [ORCL19] Files:2     Time: 197s
Serial   Phase #:59   [ORCL19] Files:1     Time: 1s
*****************   Upgrading XDB   ****************
Serial   Phase #:62   [ORCL19] Files:3     Time: 2s
Serial   Phase #:63   [ORCL19] Files:3     Time: 0s
Parallel Phase #:64   [ORCL19] Files:10     Time: 1s
Parallel Phase #:65   [ORCL19] Files:25     Time: 3s
Serial   Phase #:66   [ORCL19] Files:4     Time: 2s
Serial   Phase #:68   [ORCL19] Files:33     Time: 1s
Parallel Phase #:70   [ORCL19] Files:5     Time: 0s
Serial   Phase #:71   [ORCL19] Files:2     Time: 2s
Serial   Phase #:72   [ORCL19] Files:3     Time: 9s
****************   Upgrading ORDIM   ***************
Serial   Phase #:74   [ORCL19] Files:1     Time: 6s
*****************   Upgrading SDO   ****************
Serial   Phase #:77   [ORCL19] Files:1     Time: 15s
Serial   Phase #:78   [ORCL19] Files:2     Time: 1s
Serial   Phase #:80   [ORCL19] Files:1     Time: 3s
Parallel Phase #:82   [ORCL19] Files:3     Time: 26s
Serial   Phase #:84   [ORCL19] Files:1     Time: 2s
Serial   Phase #:86   [ORCL19] Files:1     Time: 4s
Parallel Phase #:88   [ORCL19] Files:4     Time: 57s
Serial   Phase #:90   [ORCL19] Files:1     Time: 0s
Serial   Phase #:92   [ORCL19] Files:2     Time: 25s
****   Upgrading ODM, WK, EXF, RUL, XOQ, LCTR   ****
Serial   Phase #:94   [ORCL19] Files:1     Time: 0s
***********   Final Component scripts    ***********
Serial   Phase #:96   [ORCL19] Files:1     Time: 1s
*************   Final Upgrade scripts   ************
Serial   Phase #:97   [ORCL19] Files:1     Time: 1s
*******************   Migration   ******************
Serial   Phase #:98   [ORCL19] Files:1     Time: 0s
***   End PDB Application Upgrade Pre-Shutdown   ***
Serial   Phase #:99   [ORCL19] Files:1     Time: 0s
******   Bounce the database post-migration   ******
*****************   Post Upgrade   *****************
****************   Summary report   ****************
Serial   Phase #:103  [ORCL19] Files:1     Time: 1s
***   End PDB Application Upgrade Post-Shutdown   **
Serial   Phase #:104  [ORCL19] Files:2     Time: 0s

Grand Total Time: 797s [ORCL19]

 LOG FILES: (/home/oracle/logs/catupgrdorcl19*.log)

Upgrade Summary Report Located in:
/home/oracle/logs/upg_summary.log

     Time: 802s For PDB(s)

Grand Total Time: 802s

 LOG FILES: (/home/oracle/logs/catupgrd*.log)


Grand Total Upgrade Time:    [0d:0h:13m:22s]




SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       MOUNTED
         3 ORCLPDB                        MOUNTED
         4 ORCL19                         MOUNTED
SQL> alter pluggable database ORCL19 open ;

Pluggable database altered.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       MOUNTED
         3 ORCLPDB                        MOUNTED
         4 ORCL19                         READ WRITE NO
SQL>



$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'ORCL19' -e -b utlrp -d $ORACLE_HOME/rdbms/admin utlrp.sql

$ORACLE_HOME/rdbms/admin utlrp.sql



$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'ORCL19' -e -b utlrp -d $ORACLE_HOME/rdbms/admin utlrp.sql
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/u01/app/oracle/product/23.26.0/db_1/network/admin/utlrp_catcon_6792.lst]

catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/23.26.0/db_1/network/admin/utlrp*.log] files for output generated by scripts

catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/23.26.0/db_1/network/admin/utlrp_*.lst] files for spool files, if any




catcon.pl: completed successfully



$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'ORCL19' -l /home/oracle/logs -b utltz_upg_check -d $ORACLE_HOME/rdbms/admin utltz_upg_check.sql


$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'ORCL19' -l /home/oracle/logs -b utltz_upg_check -d $ORACLE_HOME/rdbms/admin utltz_upg_check.sql
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/home/oracle/logs/utltz_upg_check_catcon_6962.lst]

catcon::set_log_file_base_path: catcon: See [/home/oracle/logs/utltz_upg_check*.log] files for output generated by scripts

catcon::set_log_file_base_path: catcon: See [/home/oracle/logs/utltz_upg_check_*.lst] files for spool files, if any

catcon.pl: completed successfully
[oracle@centos9 admin]$


alter system set "_exclude_seed_cdb_view"=false scope=both;
select value$, con_id from containers(SYS.PROPS$) where NAME='DST_PRIMARY_TT_VERSION' order by 2;







SQL> alter session set container=ORCL19 ;

Session altered.

SQL> SET SERVEROUTPUT ON
DECLARE
  l_failures   PLS_INTEGER;
BEGIN
  DBMS_DST.upgrade_database(l_failures);
  DBMS_OUTPUT.put_line('DBMS_DST.upgrade_database : l_failures=' || l_failures);
  DBMS_DST.end_upgrade(l_failures);
SQL>   2    3    4    5    6    7    DBMS_OUTPUT.put_line('DBMS_DST.end_upgrade : l_failures=' || l_failures);
  8  END;
  9  /
DECLARE
*
ERROR at line 1:
ORA-56928: upgrade window does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DST", line 927
ORA-06512: at "SYS.DBMS_DST", line 1254
ORA-06512: at line 4
Help: https://docs.oracle.com/error-help/db/ora-56928/


SQL> shutdown immediate ;
Pluggable Database closed.
SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         4 ORCL19                         MOUNTED
SQL> STARTUP UPGRADE;
Pluggable Database opened.
SQL> SET SERVEROUTPUT ON
DECLARE
  l_tz_version PLS_INTEGER;
BEGIN
  SELECT DBMS_DST.get_latest_timezone_version
  INTO   l_tz_version
  FROM   dual;

  DBMS_OUTPUT.put_line('l_tz_version=' || l_tz_version);
  DBMS_DST.begin_upgrade(l_tz_version);
END;
/SQL>   2    3    4    5    6    7    8    9   10   11
l_tz_version=43
An upgrade window has been successfully started.

PL/SQL procedure successfully completed.

SQL> SET SERVEROUTPUT ON
DECLARE
  l_failures   PLS_INTEGER;
BEGIN
  DBMS_DST.upgrade_database(l_failures);
  DBMS_OUTPUT.put_line('DBMS_DST.upgrade_database : l_failures=' || l_failures);
  DBMS_DST.end_upgrade(l_failures);
  DBMS_OUTPUT.put_line('DBMS_DST.end_upgrade : l_failures=' || l_failures);
END;
/SQL>   2    3    4    5    6    7    8    9
DECLARE
*
ERROR at line 1:
ORA-56930: database must be restarted before performing upgrade of user tables
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DST", line 933
ORA-06512: at "SYS.DBMS_DST", line 1254
ORA-06512: at line 4
Help: https://docs.oracle.com/error-help/db/ora-56930/


SQL> SHUTDOWN IMMEDIATE;
Pluggable Database closed.
SQL> STARTUP;
Pluggable Database opened.
SQL> SET SERVEROUTPUT ON
DECLARE
  l_failures   PLS_INTEGER;
BEGIN
  DBMS_DST.upgrade_database(l_failures);
  DBMS_OUTPUT.put_line('DBMS_DST.upgrade_database : l_failures=' || l_failures);
  DBMS_DST.end_upgrade(l_failures);
  DBMS_OUTPUT.put_line('DBMS_DST.end_upgrade : l_failures=' || l_failures);
END;
/SQL>   2    3    4    5    6    7    8    9
Table list: "MDSYS"."SDO_DIAG_MESSAGES_TABLE"
Number of failures: 0
Table list: "CTXSYS"."DR$EVENT_STATS"
Number of failures: 0
Table list: "DBSNMP"."MGMT_DB_FEATURE_LOG"
Number of failures: 0
Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_S"
Number of failures: 0
Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_L"
Number of failures: 0
Table list: "WMSYS"."WM$MP_PARENT_WORKSPACES_TABLE$"
Number of failures: 0
Table list: "WMSYS"."AQ$_WM$EVENT_QUEUE_TABLE_S"
Number of failures: 0
Table list: "WMSYS"."AQ$_WM$EVENT_QUEUE_TABLE_L"
Number of failures: 0
Table list: "WMSYS"."WM$WORKSPACES_TABLE$"
Number of failures: 0
Table list: "WMSYS"."WM$WORKSPACE_SAVEPOINTS_TABLE$"
Number of failures: 0
Table list: "WMSYS"."WM$METADATA_MAP_TBL"
Number of failures: 0
Table list: "DVSYS"."AUDIT_TRAIL$"
Number of failures: 0
Table list: "DVSYS"."SIMULATION_LOG$"
Number of failures: 0
Table list: "APEX_190100"."WWV_FLOW_WORKSHEET_NOTIFY"
Number of failures: 0
Table list: "APEX_190100"."WWV_FLOW_FEEDBACK"
Number of failures: 0
Table list: "APEX_190100"."WWV_FLOW_FEEDBACK_FOLLOWUP"
Number of failures: 0
Table list: "APEX_190100"."WWV_FLOW_ACTIVITY_LOG1$"
Number of failures: 0
Table list: "APEX_190100"."WWV_FLOW_ACTIVITY_LOG2$"
Number of failures: 0
Table list: "APEX_190100"."WWV_FLOW_DEBUG_MESSAGES"
Number of failures: 0
Table list: "APEX_190100"."WWV_FLOW_DEBUG_MESSAGES2"
Number of failures: 0
Table list: "APEX_190100"."WWV_QS_RANDOM_NAMES"
Number of failures: 0
Table list: "IX"."AQ$_ORDERS_QUEUETABLE_S"
Number of failures: 0
Table list: "IX"."AQ$_ORDERS_QUEUETABLE_L"
Number of failures: 0
Table list: "IX"."AQ$_STREAMS_QUEUE_TABLE_S"
Number of failures: 0
Table list: "IX"."AQ$_STREAMS_QUEUE_TABLE_L"
Number of failures: 0
Table list: "XFILES"."XFILES_RESULT_CACHE"
Number of failures: 0
Table list: "VECSYS"."VECTOR_TABLE_METADATA"
Number of failures: 0
DBMS_DST.upgrade_database : l_failures=0
An upgrade window has been successfully ended.
DBMS_DST.end_upgrade : l_failures=0

PL/SQL procedure successfully completed.

SQL> COLUMN owner FORMAT A30
SQL> COLUMN table_name FORMAT A30

SELECT con_id,
       owner,
       table_name,
       upgrade_in_progress
FROM   cdb_tstz_tables
ORDER BY 1,2,3;

-- Non-CDB
COLUMN owner FORMAT A30
COLUMN table_name FORMAT A30

SELECT owner,
       table_name,
       upgrade_in_progress
FROM   dba_tstz_tables
ORDER BY 1,2;SQL> SQL>   2    3    4    5    6
    CON_ID OWNER                          TABLE_NAME                     UPG
---------- ------------------------------ ------------------------------ ---
         4 APEX_190100                    WWV_FLOW_ACTIVITY_LOG1$        NO
         4 APEX_190100                    WWV_FLOW_ACTIVITY_LOG2$        NO
         4 APEX_190100                    WWV_FLOW_DEBUG_MESSAGES        NO
         4 APEX_190100                    WWV_FLOW_DEBUG_MESSAGES2       NO
         4 APEX_190100                    WWV_FLOW_FEEDBACK              NO
         4 APEX_190100                    WWV_FLOW_FEEDBACK_FOLLOWUP     NO
         4 APEX_190100                    WWV_FLOW_WORKSHEET_NOTIFY      NO
         4 APEX_190100                    WWV_QS_RANDOM_NAMES            NO
         4 CTXSYS                         DR$EVENT_STATS                 NO
         4 DBSNMP                         MGMT_DB_FEATURE_LOG            NO
         4 DVSYS                          AUDIT_TRAIL$                   NO

    CON_ID OWNER                          TABLE_NAME                     UPG
---------- ------------------------------ ------------------------------ ---
         4 DVSYS                          SIMULATION_LOG$                NO
         4 GSMADMIN_INTERNAL              AQ$_CHANGE_LOG_QUEUE_TABLE_L   NO
         4 GSMADMIN_INTERNAL              AQ$_CHANGE_LOG_QUEUE_TABLE_S   NO
         4 IX                             AQ$_ORDERS_QUEUETABLE_L        NO
         4 IX                             AQ$_ORDERS_QUEUETABLE_S        NO
         4 IX                             AQ$_STREAMS_QUEUE_TABLE_L      NO
         4 IX                             AQ$_STREAMS_QUEUE_TABLE_S      NO
         4 MDSYS                          SDO_DIAG_MESSAGES_TABLE        NO
         4 SYS                            AC$CONFIG_PARAMS               NO
         4 SYS                            ACCHK_EVENTS                   NO
         4 SYS                            ACCHK_METADATA                 NO

    CON_ID OWNER                          TABLE_NAME                     UPG
---------- ------------------------------ ------------------------------ ---
         4 SYS                            ACCHK_SESSION                  NO
         4 SYS                            ACCHK_STATISTICS               NO
         4 SYS                            ACLMVREFSTAT$                  NO
         4 SYS                            AC_AUTOTASK_STATUS$            NO
         4 SYS                            AC_JOURNAL$                    NO
         4 SYS                            ALERT_QT                       NO
         4 SYS                            AQ$_ALERT_QT_L                 NO
         4 SYS                            AQ$_ALERT_QT_S                 NO
         4 SYS                            AQ$_AQ$_MEM_MC_L               NO
         4 SYS                            AQ$_AQ$_MEM_MC_S               NO
         4 SYS                            AQ$_AQ_PROP_TABLE_L            NO

    CON_ID OWNER                          TABLE_NAME                     UPG
---------- ------------------------------ ------------------------------ ---
         4 SYS                            AQ$_AQ_PROP_TABLE_S            NO
         4 SYS                            AQ$_DEQUEUE_LOG_PARTITION_MAP  NO
         4 SYS                            AQ$_DURABLE_SUBS               NO
         4 SYS                            AQ$_MIGRATION_STATUS           NO
         4 SYS                            AQ$_ORA$PREPLUGIN_BACKUP_QTB_L NO
         4 SYS                            AQ$_ORA$PREPLUGIN_BACKUP_QTB_S NO
         4 SYS                            AQ$_PDB_MON_EVENT_QTABLE$_L    NO
         4 SYS                            AQ$_PDB_MON_EVENT_QTABLE$_S    NO
         4 SYS                            AQ$_QUEUE_PARTITION_ASSIGNMENT NO
                                          _TABLE


    CON_ID OWNER                          TABLE_NAME                     UPG
---------- ------------------------------ ------------------------------ ---
         4 SYS                            AQ$_QUEUE_PARTITION_MAP        NO
         4 SYS                            AQ$_SCHEDULER$_EVENT_QTAB_L    NO
         4 SYS                            AQ$_SCHEDULER$_EVENT_QTAB_S    NO
         4 SYS                            AQ$_SCHEDULER$_REMDB_JOBQTAB_L NO
         4 SYS                            AQ$_SCHEDULER$_REMDB_JOBQTAB_S NO
         4 SYS                            AQ$_SCHEDULER_FILEWATCHER_QT_L NO
         4 SYS                            AQ$_SCHEDULER_FILEWATCHER_QT_S NO
         4 SYS                            AQ$_SUBSCRIBER_LWM             NO
         4 SYS                            AQ$_SUBSCRIBER_TABLE           NO
         4 SYS                            AQ$_SYS$SERVICE_METRICS_TAB_L  NO
         4 SYS                            AQ$_SYS$SERVICE_METRICS_TAB_S  NO

    CON_ID OWNER                          TABLE_NAME                     UPG
---------- ------------------------------ ------------------------------ ---
         4 SYS                            ATSK$_SCHEDULE_CONTROL         NO
         4 SYS                            AUTOCL_TASK_STATUS$            NO
         4 SYS                            AUTOCL_VER_STATE$              NO
         4 SYS                            AVTUNE_AV_ARCHIVE_INST$        NO
         4 SYS                            AVTUNE_AV_CACHES$              NO
         4 SYS                            AVTUNE_AV_TUNING$              NO
         4 SYS                            AVTUNE_DIM_CACHES$             NO
         4 SYS                            AVTUNE_QUERY_LOG_ARCHIVE$      NO
         4 SYS                            BLOCKCHAIN_TABLE$              NO
         4 SYS                            BLOCKCHAIN_TABLE_CHAIN$        NO
         4 SYS                            BLOCKCHAIN_TABLE_DROPPED$      NO

    CON_ID OWNER                          TABLE_NAME                     UPG
---------- ------------------------------ ------------------------------ ---
         4 SYS                            BLOCKCHAIN_TABLE_EPOCH$        NO
         4 SYS                            BLOCKCHAIN_TABLE_ROW_VERSION_V NO
                                          ALUES$

         4 SYS                            DBMS_KAFKA_LOAD_METRICS        NO
         4 SYS                            DIAG$_SQL_ERROR                NO
         4 SYS                            DIAG$_SQL_ERROR_MITIGATION     NO
         4 SYS                            EXTERNAL_TAB_CACHE$            NO
         4 SYS                            EXTERNAL_TAB_CACHE_LOCATION$   NO
         4 SYS                            EXTERNAL_TAB_CACHE_USAGE$      NO
         4 SYS                            FGR$_FILE_GROUPS               NO

    CON_ID OWNER                          TABLE_NAME                     UPG
---------- ------------------------------ ------------------------------ ---
         4 SYS                            FGR$_FILE_GROUP_FILES          NO
         4 SYS                            FGR$_FILE_GROUP_VERSIONS       NO
         4 SYS                            FW_ALLOW_LIST$                 NO
         4 SYS                            FW_CAPTURE$                    NO
         4 SYS                            FW_STATUS$                     NO
         4 SYS                            GV_$UNIFIED_AUDIT_TRAIL_TBL    NO
         4 SYS                            IMPDP_STATS                    NO
         4 SYS                            KET$_AUTOTASK_STATUS           NO
         4 SYS                            KET$_CLIENT_CONFIG             NO
         4 SYS                            KET$_CLIENT_TASKS              NO
         4 SYS                            LTXID_TRANS                    NO

    CON_ID OWNER                          TABLE_NAME                     UPG
---------- ------------------------------ ------------------------------ ---
         4 SYS                            NOTIFICATION$                  NO
         4 SYS                            NOTIFICATIONS$                 NO
         4 SYS                            OPTSTAT_HIST_CONTROL$          NO
         4 SYS                            OPTSTAT_SNAPSHOT$              NO
         4 SYS                            OPTSTAT_USER_PREFS$            NO
         4 SYS                            RADM_FPTM$                     NO
         4 SYS                            REG$                           NO
         4 SYS                            REGISTRY$LOG                   NO
         4 SYS                            SAGA$                          NO
         4 SYS                            SAGA_DETAILS$                  NO
         4 SYS                            SAGA_ERRORS$                   NO

    CON_ID OWNER                          TABLE_NAME                     UPG
---------- ------------------------------ ------------------------------ ---
         4 SYS                            SAGA_PARTICIPANT_SET$          NO
         4 SYS                            SAGA_SECRETS$                  NO
         4 SYS                            SCHEDULER$_CONSTRAINTS_STATS   NO
         4 SYS                            SCHEDULER$_EVENT_LOG           NO
         4 SYS                            SCHEDULER$_EVENT_QTAB          NO
         4 SYS                            SCHEDULER$_FILEWATCHER_HISTORY NO
         4 SYS                            SCHEDULER$_FILEWATCHER_RESEND  NO
         4 SYS                            SCHEDULER$_FILE_WATCHER        NO
         4 SYS                            SCHEDULER$_GLOBAL_ATTRIBUTE    NO
         4 SYS                            SCHEDULER$_JOB                 NO
         4 SYS                            SCHEDULER$_JOB_DESTINATIONS    NO

    CON_ID OWNER                          TABLE_NAME                     UPG
---------- ------------------------------ ------------------------------ ---
         4 SYS                            SCHEDULER$_JOB_OUT_ARGS        NO
         4 SYS                            SCHEDULER$_JOB_RUN_DETAILS     NO
         4 SYS                            SCHEDULER$_LIGHTWEIGHT_JOB     NO
         4 SYS                            SCHEDULER$_REMDB_JOBQTAB       NO
         4 SYS                            SCHEDULER$_REMOTE_JOB_STATE    NO
         4 SYS                            SCHEDULER$_SCHEDULE            NO
         4 SYS                            SCHEDULER$_STEP_STATE          NO
         4 SYS                            SCHEDULER$_WINDOW              NO
         4 SYS                            SCHEDULER$_WINDOW_DETAILS      NO
         4 SYS                            SCHEDULER_FILEWATCHER_QT       NO
         4 SYS                            SESSION_LOG$                   NO

    CON_ID OWNER                          TABLE_NAME                     UPG
---------- ------------------------------ ------------------------------ ---
         4 SYS                            STATS_TARGET$                  NO
         4 SYS                            TAB_STATS$                     NO
         4 SYS                            TSM_DST$                       NO
         4 SYS                            TSM_SRC$                       NO
         4 SYS                            UMF$_ATSK_HIST                 NO
         4 SYS                            UMF$_EVENTLOG                  NO
         4 SYS                            UMF$_HUB_FBS_HIST              NO
         4 SYS                            UMF$_HUB_MPK_HIST              NO
         4 SYS                            VIOLATION_LOG$                 NO
         4 SYS                            WRI$_ADV_AI_COL_USAGE          NO
         4 SYS                            WRI$_ADV_AUTOCL_RECOMMENDATION NO

    CON_ID OWNER                          TABLE_NAME                     UPG
---------- ------------------------------ ------------------------------ ---
                                          S

         4 SYS                            WRI$_ALERT_HISTORY             NO
         4 SYS                            WRI$_ALERT_OUTSTANDING         NO
         4 SYS                            WRI$_OPTSTAT_AUX_HISTORY       NO
         4 SYS                            WRI$_OPTSTAT_HISTGRM_HISTORY   NO
         4 SYS                            WRI$_OPTSTAT_HISTHEAD_HISTORY  NO
         4 SYS                            WRI$_OPTSTAT_IND_HISTORY       NO
         4 SYS                            WRI$_OPTSTAT_OPR               NO
         4 SYS                            WRI$_OPTSTAT_OPR_TASKS         NO
         4 SYS                            WRI$_OPTSTAT_TAB_HISTORY       NO

    CON_ID OWNER                          TABLE_NAME                     UPG
---------- ------------------------------ ------------------------------ ---
         4 SYS                            WRI$_OPTSTAT_TAB_MODEL         NO
         4 SYS                            WRM$_DATABASE_INSTANCE         NO
         4 SYS                            WRM$_PDB_INSTANCE              NO
         4 SYS                            WRM$_PDB_IN_SNAP               NO
         4 SYS                            WRM$_PDB_IN_SNAP_BL            NO
         4 SYS                            WRM$_SNAPSHOT                  NO
         4 SYS                            WRM$_SNAPSHOT_BL               NO
         4 SYS                            WRMS$_SNAPSHOT                 NO
         4 SYS                            WRR$_REPLAY_DIVERGENCE         NO
         4 SYS                            WRW$_AHUB_EXP_HIST             NO
         4 SYS                            WRW$_AHUB_IMP_HIST             NO

    CON_ID OWNER                          TABLE_NAME                     UPG
---------- ------------------------------ ------------------------------ ---
         4 SYS                            XS$PRIN                        NO
         4 SYS                            XS$ROLE_GRANT                  NO
         4 VECSYS                         VECTOR_TABLE_METADATA          NO
         4 WMSYS                          AQ$_WM$EVENT_QUEUE_TABLE_L     NO
         4 WMSYS                          AQ$_WM$EVENT_QUEUE_TABLE_S     NO
         4 WMSYS                          WM$METADATA_MAP_TBL            NO
         4 WMSYS                          WM$MP_PARENT_WORKSPACES_TABLE$ NO
         4 WMSYS                          WM$WORKSPACES_TABLE$           NO
         4 WMSYS                          WM$WORKSPACE_SAVEPOINTS_TABLE$ NO
         4 XFILES                         XFILES_RESULT_CACHE            NO

158 rows selected.



SQL> alter system set "_exclude_seed_cdb_view"=false scope=both;

System altered.

col value$ for a15
 select value$, con_id from containers(SYS.PROPS$) where NAME='DST_PRIMARY_TT_VERSION' order by 2

VALUE$              CON_ID
--------------- ----------
43                       1
43                       4






$ORACLE_HOME/perl/bin/perl \
    -I$ORACLE_HOME/perl/lib \
    -I$ORACLE_HOME/rdbms/admin \
    $ORACLE_HOME/rdbms/admin/catcon.pl \
    -l /tmp/ \
    -b upgrade_tzf \
    -C 'CDB$ROOT' \
    /tmp/upgrade_tzf.sql




From Oracle 21c onward we can issue to the following command to allow time zone files to be updated without switching the database to upgrade mode. This allows the time zone file to be upgraded without any downtime.

alter system set timezone_version_upgrade_online=true;

How to Rename a Pluggable Database

How to Rename a Pluggable Database (PDB) in Oracle 19c

Renaming a PDB involves switching to a restricted mode, updating the global name, and restarting the PDB to register the new service names with the listener.

Prerequisites

Access to the CDB as a user with SYSDBA privileges.
A brief maintenance window (the PDB must be closed/opened in restricted mode).

Step 1: Check Current PDB Status

First, verify the current name and state of your PDBs.

SQL
SQL> show pdbs;

Step 2: Close and Reopen in Restricted Mode

You cannot rename a PDB while it is open for general use. Close it and then reopen it in RESTRICTED mode.

SQL
SQL> alter pluggable database ORCL close;
SQL> alter pluggable database ORCL open restricted;

Step 3: Switch Container and Rename

Switch your session context to the PDB you wish to rename and execute the rename global_name command.

SQL
SQL> alter session set container=ORCL;
SQL> alter pluggable database rename global_name to ORCL19;

Step 4: Verify the Change

Run the show pdbs command again to confirm the name change. Note that the PDB will still be in restricted mode at this stage.

SQL
SQL> show pdbs;
-- Result: ORCL19 | READ WRITE | YES

Step 5: Restart the PDB to Update Services

To ensure the Oracle Listener recognizes the new service name and to lift the restricted status, restart the PDB.

SQL
SQL> alter pluggable database close immediate;
SQL> alter pluggable database open;

Step 6: Verify Listener Services

Finally, check that the new service is registered with the listener using the lsnrctl utility.

ALTER SYSTEM REGISTER;

SQL> !lsnrctl services

Key Takeaways for Your Readers:
Service Names: When you rename a PDB, the default service name changes to match the new PDB name.
Connectivity: Ensure you update your tnsnames.ora or connection strings on the application side to reflect the new name (ORCL19).
Metadata: This process updates the control file and the data dictionary of the PDB.

Friday, 27 February 2026

Oracle database patch 38632161 >>>>> 19.30.0.0.0

 

Old Post !!!!
https://anuj-singh.blogspot.com/search?q=patch+Info


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.30.0.0.0  <<< patch no 38632161


[oracle@localhost db_1]$
 
p38632161_190000_Linux-x86-64.zip  2.2gb !!!

patch size !!!

[root@localhost media]# du -sh */
4.8G    38632161/

export PATH=$ORACLE_HOME/OPatch:$PATH
/u01/app/oracle/product/version/db_1

mv OPatch OPatch.`date +"%Y"-"%m"-"%d"`

unzip -oq /home/oracle/p6880880_190000_Linux-x86-64.zip

[oracle@localhost db_1]$ ls -ld OPatch*
drwxr-x--- 15 oracle oinstall 4096 Jan  6 05:30 OPatch
drwxr-x--- 14 oracle oinstall 4096 Feb 27 05:27 OPatch.2026-02-27

opatch version
OPatch Version: 12.2.0.1.49  --- check the version!!!!

OPatch succeeded.



===========

[oracle@localhost 38632161]$ $ORACLE_HOME/OPatch/opatch lsinventory | grep -E "(^Patch.*applied)|(^Sub-patch)"
Patch  29585399     : applied on Thu Apr 18 03:21:33 EDT 2019
Patch  29517242     : applied on Thu Apr 18 03:21:17 EDT 2019
[oracle@localhost 38632161]$

===========


cd /media/38632161
opatch prereq CheckConflictAgainstOHWithDetail -ph ./


[oracle@localhost 38632161]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.49
Copyright (c) 2026, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/19.0.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.49
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2026-02-27_05-56-31AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[oracle@localhost 38632161]$


--- Shutdown !!!
SQL> shutdown immediate ;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production


[oracle@localhost 38632161]$ pwd
/media/38632161


[oracle@localhost 38632161]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.49
Copyright (c) 2026, Oracle Corporation.  All rights reserved.



Oracle Home       : /u01/app/oracle/product/19.0.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.49
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2026-02-27_06-14-04AM_1.log

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

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/db_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '38632161' to OH '/u01/app/oracle/product/19.0.0/db_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.datamining, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.pg4mq, 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.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.network.cman, 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.xdk.companion, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.ldap.ztk, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 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.rsf, 19.0.0.0.0...
Patching component oracle.rdbms, 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.sqlj.sqljruntime, 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.xdk.parser.java, 19.0.0.0.0...
Patching component oracle.rdbms.lbac, 19.0.0.0.0...
Patching component oracle.ldap.ssl, 19.0.0.0.0...
Patching component oracle.network.aso, 19.0.0.0.0...
Patching component oracle.xdk, 19.0.0.0.0...
Patching component oracle.nlsrtl.rsf.core, 19.0.0.0.0...
Patching component oracle.odbc, 19.0.0.0.0...
Patching component oracle.rdbms.rat, 19.0.0.0.0...
Patching component oracle.rdbms.dv, 19.0.0.0.0...
Patching component oracle.oraolap.dbscripts, 19.0.0.0.0...
Patching component oracle.rdbms.hs_common, 19.0.0.0.0...
Patching component oracle.ldap.rsf.ic, 19.0.0.0.0...
Patching component oracle.oraolap, 19.0.0.0.0...
Patching component oracle.install.deinstalltool, 19.0.0.0.0...
Patching component oracle.mgw.common, 19.0.0.0.0...
Patching component oracle.rdbms.rman, 19.0.0.0.0...
Patching component oracle.xdk.server, 19.0.0.0.0...
Patching component oracle.oraolap.api, 19.0.0.0.0...
Patching component oracle.rdbms.hsodbc, 19.0.0.0.0...
Patching component oracle.ctx.atg, 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.wwg.plsql, 19.0.0.0.0...
Patching component oracle.network.client, 19.0.0.0.0...
Patching component oracle.dbtoolslistener, 19.0.0.0.0...
Patching component oracle.rdbms.install.plugins, 19.0.0.0.0...
Patching component oracle.ctx.rsf, 19.0.0.0.0...
Patching component oracle.nlsrtl.rsf.lbuilder, 19.0.0.0.0...
Patching component oracle.rdbms.drdaas, 19.0.0.0.0...
Patching component oracle.sdo.locator, 19.0.0.0.0...
Patching component oracle.rdbms.locator, 19.0.0.0.0...
Patching component oracle.network.listener, 19.0.0.0.0...
Patching component oracle.ovm, 19.0.0.0.0...
Patching component oracle.javavm.server, 19.0.0.0.0...
Patching component oracle.xdk.xquery, 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 38632161 successfully applied.
Sub-set patch [29517242] has become inactive due to the application of a super-set patch [38632161].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2026-02-27_06-14-04AM_1.log

OPatch succeeded.


before 
[oracle@localhost 38632161]$ $ORACLE_HOME/OPatch/opatch lsinventory | grep -E "(^Patch.*applied)|(^Sub-patch)"
Patch  29585399     : applied on Thu Apr 18 03:21:33 EDT 2019
Patch  29517242     : applied on Thu Apr 18 03:21:17 EDT 2019
[oracle@localhost 38632161]$

after 
[oracle@localhost 38632161]$ $ORACLE_HOME/OPatch/opatch lsinventory | grep -E "(^Patch.*applied)|(^Sub-patch)"
Patch  38632161     : applied on Fri Feb 27 06:37:40 EST 2026
Patch  29585399     : applied on Thu Apr 18 03:21:33 EDT 2019


===
[oracle@localhost 38632161]$ sqlplus /nolog

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Feb 27 06:54:45 2026
Version 19.30.0.0.0

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

SQL> Connect / as sysdba
Connected to an idle instance.

SQL> startup;
ORACLE instance started.

Total System Global Area  838856872 bytes
Fixed Size                  9183400 bytes
Variable Size             230686720 bytes
Database Buffers          595591168 bytes
Redo Buffers                3395584 bytes
Database mounted.
Database opened.



SQL> alter pluggable database all open;
Pluggable database altered.





SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ORCL                           READ WRITE NO
	
cd $ORACLE_HOME/OPatch
	
./datapatch -sanity_checks (optional)


[oracle@localhost OPatch]$ ./datapatch -sanity_checks   ----<<<<<<<<<<<<<<<<<   
SQL Patching sanity checks version 19.30.0.0.0 on Fri 27 Feb 2026 06:57:55 AM EST
Copyright (c) 2021, 2026, Oracle.  All rights reserved.

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

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

Check: Database component status - OK
Check: PDB Violations - OK
Check: Invalid System Objects - OK
Check: Tablespace Status - OK
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 - OK
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

SQL Patching sanity checks completed on Fri 27 Feb 2026 07:00:18 AM EST


======
	
./datapatch -verbose



=====

if required !!!

alert log !!!

  Current log# 2 seq# 8 mem# 0: /u01/app/oracle/oradata/ORCLCDB/redo02.log
2026-02-27T07:24:22.313401-05:00
ARC3 (PID:13432): Archived Log entry 14 added for B-1124854827.T-1.S-7 LOS:0x0000000000412871 NXS:0x0000000000423ff8 NAB:356004 ID 0xac9b7a55 LAD:1
2026-02-27T07:25:37.932436-05:00
PL/SQL package SYS.DBMS_BACKUP_RESTORE version  is not current
PL/SQL package SYS.DBMS_RCVMAN version 19.03.00.00 is too old
2026-02-27T07:30:04.307939-05:00


sys user in the CDB$ROOT.
SQL> @$ORACLE_HOME/rdbms/admin/dbmsrman.sql
SQL> @$ORACLE_HOME/rdbms/admin/dbmsbkrs.sql
SQL> @$ORACLE_HOME/rdbms/admin/prvtrmns.plb
SQL> @$ORACLE_HOME/rdbms/admin/prvtbkrs.plb



alert log !!!

ORA-12012: error on auto execute of job "SYS"."CLEANUP_ONLINE_IND_BUILD"

select owner,job_name,start_date,repeat_interval,state 
from dba_scheduler_jobs where job_name = 'CLEANUP_ONLINE_IND_BUILD';



export PATH=$PATH:$ORACLE_HOME/bin
cd $ORACLE_HOME/rdbms/admin
$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -e -b utlrp -d $ORACLE_HOME/rdbms/admin utlrp.sql

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

README file

Patch 38632161 - Database Release Update 19.30.0.0.0(REL-JAN260130)


This document is accurate at the time of release. For any changes and additional information regarding Database Release Update 19.30.0.0.260120, see these related documents that are available at My Oracle Support (http://support.oracle.com/):
Document KB860153 Oracle DB/GI/OJVM Update/Revision R19 Jan 2026 Known Issues
Document KB188772 Oracle Database 19c and Oracle AI Database 26ai Important Recommended One-off Patches
Document KB106822 Primary Note for Database Quarterly Release Updates
Document KA19 19c Database Upgrade - Self Guided Assistance with Best Practices
This document includes the following sections:
Section 1, "Patch Information"
Section 2, "Prerequisites"
Section 3, "Installation"
Section 4, "Deinstallation"
Section 5, "Known Issues"
Section 6, "References"
Section 7, "Bugs Fixed by This Patch"
Section 8, "Documentation Accessibility"
1 Patch Information
Database Release Update 19.30.0.0.260120 patches are cumulative. That is, the content of all previous Database bundles is included in the latest Database bundle patch.
To install the Database Release Update 19.30.0.0.260120 patch, the Oracle home must have Oracle Database release 19c installed.
This patch is Oracle RAC Rolling Installable.
This patch is Database Vault installable. See My Oracle Support document KB653211 Primary Note For Oracle Database Vault for details on how to apply this patch to a Database Vault environment.
This patch is Data Guard Standby-First Installable. See My Oracle Support document KB137118 Oracle Patch Assurance - Data Guard Standby-First Patch Apply for details on how to remove risk and reduce downtime when applying this patch.
This patch includes the JDK fixes released in the prior cycle and will update the JDK in the Oracle home. For the most recent JDK fixes, a separate patch is available and needs to be installed in addition to this patch. See My Oracle Support document KB106822 Primary Note for Database Quarterly Release Updates for the JDK patch number.
Beginning with 19.27 Apr2025 DBRU, Small Pages are not allowed for RDBMS SGA in Exadata. See My Oracle Support Document KB174916 for more details.
Beginning with 19.21 Oct2023 RU, the UTL_URI.ESCAPE function is now compliant with RFC 3896 and will treat "#" as a reserved character. See My Oracle Support Document PALRT1208 for more details.
Beginning with 19.22 Jan2024 RU, the 19c database is now certified on Oracle Linux 9.x and RHEL9.x.
Beginning with 19.18 Jan2023 RU, the DBRU contains the CORE DST Time Zone patches. Applying this Release Update (RU) does not change the DST version in any of your databases. The DST patches are only copied into $ORACLE_HOME/oracore/zoneinfo and no DST upgrade is performed. You can decide to upgrade the DST version in your database to a newer DST version independently of applying the RU at any time. Be aware that this incurs downtime.
You can decide to upgrade the DST version in your database to a newer DST version independently of applying the RU at any time. Be aware that this incurs downtime.
If you plan to adjust the DST version of your databases, Oracle recommends adjusting it to the latest available DST version. Follow the instructions in the Oracle 19c Oracle Database Upgrade Guide. For more information on various DST patch releases, see My Oracle Support document KB151444 Primary Note DST FAQ: Updated DST Transitions and New Time Zones in Oracle RDBMS and OJVM Time Zone File Patches.
This DBRU contains the following CORE DST patches:
Patch Numbers Patches
28852325 DSTV33 UPDATE - TZDATA2018G
29997937 DSTV34 UPDATE - TZDATA2019B
31335037 DSTV35 UPDATE - TZDATA2020A
32327201 DSTV36 UPDATE - TZDATA2020E
33613829 DSTV37 UPDATE - TZDATA2021E
34006614 DSTV38 UPDATE - TZDATA2022A
34533061 DSTV39 UPDATE - TZDATA2022C
34698179 DSTV40 UPDATE - TZDATA2022E
35099667 DSTV41 UPDATE - TZDATA2022G
35220732 DSTV42 UPDATE - TZDATA2023C
36260493 DSTV43 UPDATE - TZDATA2024A
37537949 DSTV44 UPDATE - TZDATA2025A
Any new or changed database initialization parameters that might be included into a quarterly patch bundle would be documented in the Oracle Database Reference manual section on initialization parameters. For Oracle Database 19c, see Oracle Database Reference.
For the latest Update with Security Fixes that should be used on Client-Only installations, see the Critical Patch Update (CPU) Program Patch Availability Document (PAD) section on the Oracle Database, for the cycle in which you are interested.
Applying Database Release Update Database Release Update 19.30.0.0.260120 with Oracle JavaVM 19.x Updates
For customers who want to install both patches together during a single downtime window, follow one of the Patching Options listed in the My Oracle Support document:KB139124 - Oracle Recommended Patches - "Oracle JavaVM Component Database PSU and Update" (OJVM PSU and OJVM Update) Patches.
The Oracle JavaVM 19.x Release Update is available as a separate patch. That separate patch has some additional requirements if it is to be installed in a RAC Rolling fashion, as detailed in My Oracle Support document:KB137197 - RAC Rolling Install Process for the "Oracle JavaVM Component Database PSU/RU" (OJVM PSU/RU) Patches.
2 Prerequisites
It is highly recommended to take a backup of the Oracle_Home binaries and Central Inventory prior to applying patches. For further information, see My Oracle Support document KB137807 How to Perform ORACLE_HOME Backup?.
For SUSE Linux Enterprise Server (SLES) 15 SP3, and above, install the compat-libpthread-nonshared package. See section 5.5.12 in SUSE's release notes (for SLES 15 SP3) and Note KB117927.
This section includes the following section:
Section 2.1, "OPatch Utility"
2.1 OPatch Utility
You must use the OPatch utility version 12.2.0.1.48 or later to apply this patch. Oracle recommends that you use the latest released OPatch version for 19c, which is available for download from My Oracle Support patch 6880880 by selecting "OPatch for DB 19.0.0.0.0" from the Select a Release dropdown. It is recommended that you download the OPatch utility and the patch in a shared location to be able to access them from any node in the cluster for the patch application on each node.
When patching the GI home, a shared locaton on Oracle ACFS only needs to be unmounted on the node where the GI home is being patched.
The new OPatch utility should be updated in all of the Oracle RAC database homes and the GI home that are being patched.
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 KB104015 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 KB133615 Primary Note For OPatch.
3 Installation
These instructions are for all Oracle Database installations.
Section 3.1, "Patch Pre-Installation Instructions"
Section 3.2, "Patch Installation Instructions"
Section 3.3, "Patch Post-Installation Instructions"
Section 3.4, "Patch Post-Installation Instructions for Databases Created or Upgraded after Installation of this patch in the Oracle Home"
3.1 Patch Pre-Installation Instructions
Before you install Database Release Update 19.30.0.0.260120, perform the following actions to check the environment and to detect and resolve any interim patch conflicts.
3.1.1 Environments with Grid Infrastructure
This patch is not to be installed to an environment that has a Grid Infrastructure home. See the following My Oracle Support document KB106822 to determine the appropriate Grid infrastructure patch to be installed.
3.1.2 Environment Checks
Ensure that the $PATH definition has the following executables: make, ar, ld, and nm.
The location of these executables depends on your operating system. On many operating systems, they are located in /usr/ccs/bin, in which case you can set your PATH definition as follows:
export PATH=$PATH:/usr/ccs/bin
3.1.3 Interim Patch Conflict Detection and Resolution
The fastest and easiest way to determine whether you have interim patches in the Oracle home that conflict with Database Release Update 19.30.0.0.260120, and to get the necessary conflict resolution patches, is to use the Patch Recommendations and Patch Plans features on the Patches & Updates tab in My Oracle Support.
However, if you are not using My Oracle Support Patch Plans, the My Oracle Support Conflict Checker tool enables you to upload an OPatch inventory and check the patches that you want to apply to your environment for conflicts.
If no conflicts are found, you can download the patches. If conflicts are found, the tool finds an existing resolution to download. If no resolution is found, it will automatically request a resolution, which you can monitor in the Plans and Patch Requests region of the Patches & Updates tab.
For more information, see Knowledge Document KB135057 How to Use the My Oracle Support Conflict Checker Tool for Patches Installed with OPatch.
Or, use the following steps to manually discover conflicts and resolutions:
Determine whether any currently installed interim patches conflict with the patch being installed, 38632161:
Step Command
1. unzip p38632161_<version>_<platform>.zip
2. cd 38632161
3. opatch prereq CheckConflictAgainstOHWithDetail -ph ./
The report indicates the patches that conflict and the patches that are a superset.
Use My Oracle Support document KB145571 Database Patch Conflict Resolution to determine, for each conflicting patch, whether a conflict resolution patch is already available, and if you need to request a new conflict resolution patch or if the conflict may be ignored.
When all the interim patches that you have requested are available at My Oracle Support, proceed with Section 3.2, "Patch Installation Instructions".
3.2 Patch Installation Instructions
Follow these steps:
If you are using a Data Guard Physical Standby database, you must install this patch on both the primary database and the physical standby database, as described by My Oracle Support document KB147888 How To Apply DBRU in a Data Guard Physical Standby Configuration (Non Standby-First Installable).
If this is an Oracle RAC environment, install this patch using the OPatch rolling (no downtime) installation method as this patch is rolling RAC installable. See My Oracle Support document KB139091 Rolling Patch - OPatch Support for RAC.
If this is not a RAC environment, shut down all instances and listeners associated with the Oracle home that you are updating. For more information, see Oracle Database Administrator's Guide.
Set your current directory to the directory where the patch is located and then run the OPatch utility by entering the following Command:
Step Command
1. unzip -d <PATCH_TOP_DIR> p38632161_<version>_<platform>.zip
2. cd <PATCH_TOP_DIR> 38632161
3. opatch apply
If there are errors, refer to Section 5, "Known Issues".
3.3 Patch Post-Installation Instructions
On Oracle Database server, after installing the patch, perform the following actions. This is not required on Oracle Database client.
3.3.1 Apply Conflict Resolution Patches
Apply the patch conflict resolution interim patches that were determined to be needed when you performed the steps in Section 3.1.4, "Interim Patch Conflict Detection and Resolution".
3.3.2 Load Modified SQL Files into the Database
The following steps load modified SQL files into the database. For an Oracle RAC environment, perform these steps on only one node.
Datapatch is run to complete the post-install SQL deployment for the patch being installed. For further details about Datapatch, including Known Issues and workarounds to common problems, see My Oracle Support document KB148594 Datapatch: Database 12c or later Post Patch SQL Automation and My Oracle Support document KB123801 Datapatch User Guide.
For each separate database running on the same shared Oracle home being patched, run the datapatch utility as described in Table 2.
Table 2 Steps to Run the Datapatch Utility for Non-CDB or Non-PDB Database Versus Multitenant (CDB or PDB) Oracle Database
Steps Non-CDB or Non-PDB Database Steps Multitenant (CDB/PDB) Oracle Database
1 sqlplus /nolog 1 sqlplus /nolog
2 SQL> Connect / as sysdba 2 SQL> Connect / as sysdba
3 SQL> startup 3 SQL> startup
4 SQL> quit 4 SQL> alter pluggable database all open;^{Foot 1}
5 cd $ORACLE_HOME/OPatch 5 SQL> quit
6 ./datapatch -sanity_checks (optional) 6 cd $ORACLE_HOME/OPatch
7 ./datapatch -verbose 7 ./datapatch -sanity_checks (optional)


8 ./datapatch -verbose
^{Footnote 1} It is recommended the Post Install step be run on all pluggable databases; however, the following command (SQL> alter pluggable database PDB_NAME open ) could be substituted to only open certain PDBs in the single or multitenant database. Doing so will result in the Post Install step only being run on the CDB and opened PDB's. To update a pluggable database at a later date (skipped or newly plugged in), open the database using the alter pluggable database command mentioned previously and rerun the datapatch utility.
See My Oracle Support document KB150931 Multitenant Unplug/Plug Best Practices for more information about the procedure for unplugging/plugging with different patch releases (in both directions).
Recommended: The datapatch -sanity_checks optional step runs a series of environment and database checks to validate if conditions are optimal for patching. Results are shown on screen with severity and potential actions to take.
For more information, see My Oracle Support document KB123801 Datapatch User Guide for additional information and actions. Oracle highly recommends that you perform this step.
The datapatch utility runs the necessary apply scripts to load the modified SQL files into the database. An entry is added to the dba_registry_sqlpatch view reflecting the patch application. In the dba_registry_sqlpatch view, verify that the status for the APPLY is SUCCESS.
For any other status, see My Oracle Support document KA1374 Troubleshooting Assistant: 12c Datapatch Issues for additional information and actions.
Check the following log files in $ORACLE_BASE/cfgtoollogs/sqlpatch/38632161/<unique patch ID> for errors:
38632161_apply_<database SID>_<CDB name>_<timestamp>.log
where database SID is the database SID, CDB name is the name of the multitenant container database, and timestamp is of the form YYYYMMMDD_HH_MM_SS.
Any (pluggable) database that has invalid objects after the execution of datapatch should have catcon.pl run to revalidate those objects. For example:
Step Command
1. export PATH=$PATH:$ORACLE_HOME/bin
2. cd $ORACLE_HOME/rdbms/admin
3. $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -e -b utlrp -d $ORACLE_HOME/rdbms/admin utlrp.sql
3.3.3 Upgrade Oracle Recovery Manager Catalog
If you are using the Oracle Recovery Manager, the catalog needs to be upgraded. Enter the following command to upgrade it. The UPGRADE CATALOG command must be entered twice to confirm the upgrade.
Step Command
1. $ rman catalog username/password@alias
2. RMAN> UPGRADE CATALOG;
3. RMAN> UPGRADE CATALOG;
4. RMAN> EXIT;
3.3.4 Bug Fixes That May Change an Existing Optimizer Execution Plan
At the successful conclusion of the patching event, none of the database bug fixes that may change an existing optimizer execution plan are delivered with the bug fix disabled by default. The status of any module bug fixes (which cause an execution plan change) that were in an enabled state prior to starting the patching event are preserved, but no new module bug fixes (which cause an execution plan change) are activated automatically.
Details on this, including the commands to explicitly enable such bug fixes are present in My Oracle Support document KB148297 Managing "installed but disabled" bug fixes in Database Release Updates using DBMS_OPTIM_BUNDLE.
3.3.5 Update Permissions for extjob
Database release update patch installation involves relinking of libraries and executables to be updated. This can sometimes result in permissions changing and needing to be updated. Execute the following as root user:
Step Command
1. # chown root $ORACLE_HOME/bin/extjob
2. # chmod 4750 $ORACLE_HOME/bin/extjob
3.4 Patch Post-Installation Instructions for Databases Created or Upgraded after Installation of this patch in the Oracle Home
On Oracle Database server, you must execute the steps in Section 3.3.2, "Load Modified SQL Files into the Database" for any new database. There are no actions required for databases that have been upgraded. This is not required on Oracle Database client.
4 Deinstallation
These instructions apply if you need to deinstall the patch.
Section 4.1, "Patch Deinstallation Instructions for a Non-RAC Environment"
Section 4.2, "Patch Post-Deinstallation Instructions for a Non-RAC Environment"
Section 4.3, "Patch Deinstallation Instructions for Oracle RAC Environment"
Section 4.4, "Patch Post-Deinstallation Instructions for Oracle RAC Environment"
4.1 Patch Deinstallation Instructions for a Non-RAC Environment
Follow these steps:
Shut down all instances and listeners associated with the Oracle home that you are updating. For more information, see Oracle Database Administrator's Guide.
Run the OPatch utility specifying the rollback argument as follows.
opatch rollback -id 38632161
If there are errors, refer to Section 5, "Known Issues".
4.2 Patch Post-Deinstallation Instructions for a Non-RAC Environment
On Oracle Database server, after deinstalling the patch, perform the following actions. This is not required on Oracle Database client.
Rollback SQL changes from the the Database, as explained in Section 4.2.1.
Upgrade Oracle Recovery Manager Catalog, as explained in Section 4.2.2.
4.2.1 Load Modified SQL Files into the Database
Datapatch is run to complete the post-deinstall SQL deployment for the patch being deinstalled. For further details about Datapatch, including Known Issues and workarounds to common problems, see My Oracle Support document KB148594 Datapatch: Database 12c or later Post Patch SQL Automation and My Oracle Support document KB123801 Datapatch User Guide.
Follow these steps:
For each separate database running on the same shared Oracle home being patched, run the datapatch utility as described in Table 3. If this is Oracle RAC, run datapatch on only one instance.
Table 3 Steps to Run the datapatch Utility for Non-CDB or Non-PDB Database Versus Multitenant (CDB or PDB) Database
Steps Non-CDB or Non-PDB Database Steps Multitenant (CDB/PDB) Oracle Database
1 sqlplus /nolog 1 sqlplus /nolog
2 SQL> Connect / as sysdba 2 SQL> Connect / as sysdba
3 SQL> startup 3 SQL> startup
4 SQL> quit 4 SQL> alter pluggable database all open^{Foot 1}
5 cd $ORACLE_HOME/OPatch 5 SQL> quit
6 ./datapatch -sanity_checks (optional) 6 cd $ORACLE_HOME/OPatch
7 ./datapatch -verbose 7 ./datapatch -sanity_checks (optional)


8 ./datapatch -verbose
^{Footnote 1} It is recommended the Post Install step be run on all pluggable databases; however, the following command (SQL> alter pluggable database PDB_NAME open ) could be substituted to only open certain PDBs in the single/multitenant database. Doing so will result in the Post Install step only being run on the CDB and opened PDB's. To update a pluggable database at a later date (skipped or newly plugged in), open the database using the alter pluggable database command mentioned previously and rerun the datapatch utility.
See My Oracle Support document KB150931 Multitenant Unplug/Plug Best Practices for more information about the procedure for unplugging/plugging with different patch releases (in both directions).
Recommended: The datapatch -sanity_checks optional step runs a series of environment and database checks to validate if conditions are optimal for patching. Results are shown on screen with severity and potential actions to take.
For more information, see the My Oracle Support document KB123801 Datapatch User Guide for additional information and actions. Oracle highly recommends that you perform this step.
The datapatch utility runs the necessary rollback scripts. An entry is added to the dba_registry_sqlpatch view reflecting the patch application. In the dba_registry_sqlpatch view, verify the Status for the ROLLBACK is SUCCESS.
For any other status, see My Oracle Support document KA1374 Troubleshooting Assistant: 12c Datapatch Issues for additional information and actions.
Check the following log files in $ORACLE_BASE/cfgtoollogs/sqlpatch/38632161/<unique patch ID> for errors:
38632161_rollback_<database SID>_<CDB name>_<timestamp>.log
where database SID is the database SID, CDB name is the name of the multitenant container database, and timestamp is of the form YYYYMMMDD_HH_MM_SS.
Any (pluggable) database that has invalid objects after the execution of datapatch should have catcon.pl run to revalidate those objects. For example:
Step Command
1. cd $ORACLE_HOME/rdbms/admin
2. $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -e -b utlrp -d $ORACLE_HOME/rdbms/admin utlrp.sql
4.2.2 Upgrade Oracle Recovery Manager Catalog
If you are using the Oracle Recovery Manager, the catalog needs to be upgraded. Enter the following command to upgrade it. The UPGRADE CATALOG command must be entered twice to confirm the upgrade.
Step Command
1. $ rman catalog username/password@alias
2. RMAN> UPGRADE CATALOG;
3. RMAN> UPGRADE CATALOG;
4. RMAN> EXIT;
4.3 Patch Deinstallation Instructions for Oracle RAC Environment
Patch deinstallation instructions for Oracle RAC includes these environments:
Follow these steps for each node in the cluster, one node at a time.
Shut down the instance on the node.
Run the OPatch utility specifying the rollback argument as follows.
opatch rollback -id 38632161
If there are errors, refer to Section 5, "Known Issues".
Start the instance on the node as follows:
srvctl start instance
4.4 Patch Post-Deinstallation Instructions for Oracle RAC Environment
On Oracle Database server, follow the instructions listed in Section Section 4.2, "Patch Post-Deinstallation Instructions for a Non-RAC Environment" only on the node for which the steps in Section 3.3.2, "Load Modified SQL Files into the Database" were executed during the patch application. This is not required on Oracle Database client.
All other instances can be started and accessed as usual while you are executing the deinstallation steps.
5 Known Issues
For information about OPatch issues, see My Oracle Support document KB133615 Primary Note For OPatch.
For issues documented after the release of this patch, see My Oracle Support document KB860153 Oracle DB/GI/OJVM Update/Revision R19 Jan 2026 Known Issues
Other issues are as follows.
Issue 1
The following ignorable errors may be encountered while running the datapatch/catbundle.sql script or its rollback script:
ORA-00942: table or view does not exist
ORA-00955: name is already used by an existing object
ORA-01430: column being added already exists in table
ORA-01432: public synonym to be dropped does not exist
ORA-01434: private synonym to be dropped does not exist
ORA-01435: user does not exist
ORA-01917: user or role 'XDB' does not exist
ORA-01920: user name '<user-name>' conflicts with another user or role name
ORA-01921: role name '<role name>' conflicts with another user or role name
ORA-01927: cannot REVOKE privileges you did not grant
ORA-01952: system privileges not granted to 'WKSYS'
ORA-02289: sequence does not exist 
ORA-02303: cannot drop or replace a type with type or table dependents
ORA-02443: Cannot drop constraint - nonexistent constraint
ORA-04043: object <object-name> does not exist
ORA-06512: at line <line number>. If this error follow any of above errors, then can be safely ignored.
ORA-14452: attempt to create, alter or drop an index on temporary table already in use
ORA-29809: cannot drop an operator with dependent objects
ORA-29830: operator does not exist
ORA-29832: cannot drop or replace an indextype with dependent indexes
ORA-29844: duplicate operator name specified 
ORA-29931: specified association does not exist
6 References
The following documents are references for this patch.
Document 38632161 Database Release Update 19.30.0.0.0(REL-JAN260130)
Document KA19 19c Database Upgrade - Self Guided Assistance with Best Practices
Document KB106822 Primary Note for Database Quarterly Release Updates
Document KB148594 Datapatch: Database 12c or later Post Patch SQL Automation
Document KB133615 Primary Note for OPatch
Document KB151444 Primary Note DST FAQ: Updated DST Transitions and New Time Zones in Oracle RDBMS and OJVM Time Zone File Patches
Document KB145571 Database Patch Conflict Resolution
Document KB850150 Database 19 Release Updates and Revisions Bugs Fixed Lists
Document KA1376 Troubleshooting Assistant: Patching Oracle Database/Client
7 Bugs Fixed by This Patch
See My Oracle Support document KB850150 Database 19 Release Updates and Revisions Bugs Fixed Lists for the list of bugs fixed in this patch.
8 Documentation Accessibility
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id-docacc.
Access to Oracle Support
Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.
Patch 38632161 - Database Release Update 19.30.0.0.0(REL-JAN260130)
Copyright © 2026, Oracle and/or its affiliates.
This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.
If this is software, software documentation, data (as defined in the Federal Acquisition Regulation), or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software, any programs embedded, installed, or activated on delivered hardware, and modifications of such programs) and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Government end users are "commercial computer software," "commercial computer software documentation," or "limited rights data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, reproduction, duplication, release, display, disclosure, modification, preparation of derivative works, and/or adaptation of i) Oracle programs (including any operating system, integrated software, any programs embedded, installed, or activated on delivered hardware, and modifications of such programs), ii) Oracle computer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in the license contained in the applicable contract. The terms governing the U.S. Government's use of Oracle cloud services are defined by the applicable contract for such services. No other rights are granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.
Oracle®, Java, MySQL, and NetSuite are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc, and the AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Steps	Non-CDB or Non-PDB Database	Steps	Multitenant (CDB/PDB) Oracle Database
1	`sqlplus /nolog`	1	`sqlplus /nolog`
2	`SQL> Connect / as sysdba`	2	`SQL> Connect / as sysdba`
3	`SQL> startup`	3	`SQL> startup`
4	`SQL> quit`	4	`SQL> alter pluggable database all` `open;`^{Foot 1}
5	`cd $ORACLE_HOME/OPatch`	5	`SQL> quit`
6	`./datapatch -sanity_checks (optional)`	6	`cd $ORACLE_HOME/OPatch`
7	`./datapatch -verbose`	7	`./datapatch -sanity_checks (optional)`
		8	`./datapatch -verbose`

Steps	Non-CDB or Non-PDB Database	Steps	Multitenant (CDB/PDB) Oracle Database
1	`sqlplus /nolog`	1	`sqlplus /nolog`
2	`SQL> Connect / as sysdba`	2	`SQL> Connect / as sysdba`
3	`SQL> startup`	3	`SQL> startup`
4	`SQL> quit`	4	`SQL> alter pluggable database all open`^{Foot 1}
5	`cd $ORACLE_HOME/OPatch`	5	`SQL> quit`
6	`./datapatch -sanity_checks (optional)`	6	`cd $ORACLE_HOME/OPatch`
7	`./datapatch -verbose`	7	`./datapatch -sanity_checks (optional)`
		8	`./datapatch -verbose`

Patch Numbers	Patches
28852325	DSTV33 UPDATE - TZDATA2018G
29997937	DSTV34 UPDATE - TZDATA2019B
31335037	DSTV35 UPDATE - TZDATA2020A
32327201	DSTV36 UPDATE - TZDATA2020E
33613829	DSTV37 UPDATE - TZDATA2021E
34006614	DSTV38 UPDATE - TZDATA2022A
34533061	DSTV39 UPDATE - TZDATA2022C
34698179	DSTV40 UPDATE - TZDATA2022E
35099667	DSTV41 UPDATE - TZDATA2022G
35220732	DSTV42 UPDATE - TZDATA2023C
36260493	DSTV43 UPDATE - TZDATA2024A
37537949	DSTV44 UPDATE - TZDATA2025A

Step	Command
1.	unzip p38632161_<version>_<platform>.zip
2.	cd 38632161
3.	opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Step	Command
1.	unzip -d <PATCH_TOP_DIR> p38632161_<version>_<platform>.zip
2.	cd <PATCH_TOP_DIR> 38632161
3.	opatch apply

Step	Command
1.	export PATH=$PATH:$ORACLE_HOME/bin
2.	cd $ORACLE_HOME/rdbms/admin
3.	$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -e -b utlrp -d $ORACLE_HOME/rdbms/admin utlrp.sql

Step	Command
1.	$ rman catalog username/password@alias
2.	RMAN> UPGRADE CATALOG;
3.	RMAN> UPGRADE CATALOG;
4.	RMAN> EXIT;

Step	Command
1.	# chown root $ORACLE_HOME/bin/extjob
2.	# chmod 4750 $ORACLE_HOME/bin/extjob

Anuj Singh Oracle DBA

Search This Blog

Total Pageviews

Monday, 2 March 2026

ORA-14693: The MAX_STRING_SIZE parameter must be EXTENDED.

upgrade database from 19c to 26ai !!!

How to Rename a Pluggable Database

How to Rename a Pluggable Database (PDB) in Oracle 19c

Prerequisites

Step 1: Check Current PDB Status

Step 2: Close and Reopen in Restricted Mode

Step 3: Switch Container and Rename

Step 4: Verify the Change

Step 5: Restart the PDB to Update Services

Step 6: Verify Listener Services

Key Takeaways for Your Readers:

Friday, 27 February 2026

Oracle database patch 38632161 >>>>> 19.30.0.0.0

1 Patch Information

2 Prerequisites

2.1 OPatch Utility

3 Installation

3.1 Patch Pre-Installation Instructions

3.1.1 Environments with Grid Infrastructure

3.1.2 Environment Checks

3.1.3 Interim Patch Conflict Detection and Resolution

3.2 Patch Installation Instructions

3.3 Patch Post-Installation Instructions

3.3.1 Apply Conflict Resolution Patches

3.3.2 Load Modified SQL Files into the Database

3.3.3 Upgrade Oracle Recovery Manager Catalog

3.3.4 Bug Fixes That May Change an Existing Optimizer Execution Plan

3.3.5 Update Permissions for extjob

3.4 Patch Post-Installation Instructions for Databases Created or Upgraded after Installation of this patch in the Oracle Home

4 Deinstallation

4.1 Patch Deinstallation Instructions for a Non-RAC Environment

4.2 Patch Post-Deinstallation Instructions for a Non-RAC Environment

4.2.1 Load Modified SQL Files into the Database

4.2.2 Upgrade Oracle Recovery Manager Catalog

4.3 Patch Deinstallation Instructions for Oracle RAC Environment

4.4 Patch Post-Deinstallation Instructions for Oracle RAC Environment

5 Known Issues

6 References

7 Bugs Fixed by This Patch

8 Documentation Accessibility

Oracle DBA

anuj blog Archive