Wednesday, 9 February 2022

Patch : DataPatch internal Information's and location

 DataPatch internal Information's and location 

  • $ORACLE_HOME/OPatch/datapatch
  • $ORACLE_HOME/sqlpatch/
 sqlpatch.pl
 sqlpatch.pm

  • Patch Number : 29517242
29517242_apply.sql
 29517242_rollback.sql

rollback_files
29517242.zip
29517242.xml
  •  rollback_files/
 19.1.0.0.0
 19.3.0.0.0-RU-Release_Update-190410122720

[oracle@srv6 OPatch]$ cat datapatch

#!/bin/sh

#

# $Header: opatch/OPatch/datapatch /main/3 2016/09/16 23:29:40 vkekalo Exp $

#

# t.sh

#

# Copyright (c) 2012, 2016, Oracle and/or its affiliates. All rights reserved.

#

#    NAME

#      datapatch - <one-line expansion of the name>

#

#    DESCRIPTION

#      <short description of component this file declares/defines>

#

#    NOTES

#      <other useful comments, qualifications, etc.>

#

#    MODIFIED   (MM/DD/YY)

#    opatch    09/03/15 - : Update the copyright year

#    opatch      07/12/12 - : Creation


# Call sqlpatch to do the real work

$ORACLE_HOME/sqlpatch/sqlpatch $@


[oracle@srv6 OPatch]$





[oracle@srv6 OPatch]$ cd $ORACLE_HOME/sqlpatch/

[oracle@srv6 sqlpatch]$ ll
total 392
drwxr-xr-x. 4 oracle oinstall   4096 Apr 18  2019 29517242
-rwxr-x---. 1 oracle oinstall  11322 Apr  1  2019 copy_sqlpatch_files.pl
drwxr-xr-x. 8 oracle oinstall   4096 Apr 17  2019 lib
-rwxr-x---. 1 oracle oinstall   2732 Apr  1  2016 sqlpatch
-rw-r--r--. 1 oracle oinstall   2080 Nov  6  2018 sqlpatch_app_begin.sql
-rw-r--r--. 1 oracle oinstall   1578 Nov  6  2018 sqlpatch_app_create.sql
-rw-r--r--. 1 oracle oinstall   2996 Nov  6  2018 sqlpatch_app_end.sql
-rw-r--r--. 1 oracle oinstall  11212 Mar 26  2019 sqlpatch_bootstrap.sql
-rw-r--r--. 1 oracle oinstall   5581 Mar  2  2019 sqlpatch.pl
-rw-r--r--. 1 oracle oinstall 340639 Mar  2  2019 sqlpatch.pm
[oracle@srv6 sqlpatch]$

[oracle@srv6 sqlpatch]$ cat sqlpatch
#!/bin/sh
#
# $Header: rdbms/admin/sqlpatch/sqlpatch /main/9 2016/03/31 19:56:02 surman Exp $
#
#
# Copyright (c) 2012, 2016, Oracle and/or its affiliates. All rights reserved.
#
#    NAME
#      sqlpatch - <one-line expansion of the name>
#
#    DESCRIPTION
#      <short description of component this file declares/defines>
#
#    NOTES
#      <other useful comments, qualifications, etc.>
#
#    MODIFIED   (MM/DD/YY)
#    surman      12/22/15 - 22359063: XML descriptor
#    surman      07/09/14 - 19178851: Library path for different platforms
#    mpradeep    05/15/14 - 18151716: Fix perl issues
#    surman      11/29/12 - 15909914: More portable syntax
#    surman      11/26/12 - 15902847: Add ORACLE_HOME/bin to path
#    surman      11/09/12 - 15857388: Fix LD_LIBRARY_PATH
#    surman      10/31/12 - 14763881: Set ORACLE_HOME
#    surman      10/19/12 - 14787047: CDB support
#    surman      07/12/12 - 14165102: Creation

# 15909914: Ensure /bin and /usr/bin are in the path so we can find dirname
PATH=$PATH:/bin:/usr/bin
export PATH

# Set ORACLE_HOME based on the full path to this script, which is
# $ORACLE_HOME/sqlpatch
CWD=`dirname $0`
ORACLE_HOME=`dirname ${CWD}`
export ORACLE_HOME

# Ensure LD_LIBRARY_PATH includes the right directories
# 19178851: Different flavors of unix use different variables.  This code
# is modeled off of srvctl.
PLATFORM=`uname`
case ${PLATFORM} in
HP-UX)
  LD_LIBRARY_PATH=${ORACLE_HOME}/lib:${LD_LIBRARY_PATH}
  export LD_LIBRARY_PATH
  ;;
AIX)
  LIBPATH=${ORACLE_HOME}/lib:${LIBPATH}
  export LIBPATH
  ;;
Linux)
  LD_LIBRARY_PATH=${ORACLE_HOME}/lib:${LD_LIBRARY_PATH}
  # Linux ( ppc64 || s390x ) => LD_LIBRARY_PATH lib32
  ARCH=`uname -m`;
  if [ "${ARCH}" = "ppc64" -o "${ARCH}" = "s390x" ]
  then
    LD_LIBRARY_PATH=${ORACLE_HOME}/lib32:${LD_LIBRARY_PATH}
  fi
  export LD_LIBRARY_PATH
  ;;
SunOS)
  LD_LIBRARY_PATH_64=${ORACLE_HOME}/lib:${LD_LIBRARY_PATH_64}
  export LD_LIBRARY_PATH_64
  LD_LIBRARY_PATH=${ORACLE_HOME}/lib:${LD_LIBRARY_PATH}
  export LD_LIBRARY_PATH
  ;;
OSF1)
  LD_LIBRARY_PATH=${ORACLE_HOME}/lib:${LD_LIBRARY_PATH}
  export LD_LIBRARY_PATH
  ;;
Darwin)
  DYLD_LIBRARY_PATH=${ORACLE_HOME}/lib:${DYLD_LIBRARY_PATH}
  export DYLD_LIBRARY_PATH
  ;;
*)
  if [ -d ${ORACLE_HOME}/lib32 ];
  then
    LD_LIBRARY_PATH=${ORACLE_HOME}/lib32:${LD_LIBRARY_PATH}
  else
    LD_LIBRARY_PATH=${ORACLE_HOME}/lib:${LD_LIBRARY_PATH}
  fi
  export LD_LIBRARY_PATH
  ;;
esac

# Ensure PATH includes the right directories
PATH=$ORACLE_HOME/bin:$PATH
export PATH

# Just call the Perl under $ORACLE_HOME with the arguments
$ORACLE_HOME/perl/bin/perl -I$ORACLE_HOME/sqlpatch -I$ORACLE_HOME/rdbms/admin -I$ORACLE_HOME/sqlpatch/lib $ORACLE_HOME/sqlpatch/sqlpatch.pl $@

[oracle@srv6 sqlpatch]$


[oracle@srv6 sqlpatch]$ cat sqlpatch.pl
#!/usr/local/bin/perl
#
# $Header: rdbms/admin/sqlpatch/sqlpatch.pl /st_rdbms_19/4 2019/03/02 09:01:58 sanagara Exp $
#
# sqlpatch.pl
#
# Copyright (c) 2012, 2019, Oracle and/or its affiliates. All rights reserved.
#
#    NAME
#      sqlpatch.pl - <one-line expansion of the name>
#
#    DESCRIPTION
#      <short description of component this file declares/defines>
#      0: Success
#      1: Failure during prereq checks
#      2: Failure during patch application
#
#    NOTES
#      See support note 1585822.1 for full documentation.
#    MODIFIED   (MM/DD/YY)
#    apfwkr      02/03/19 - Backport sanagara_bug-28181021 from main
#    sanagara    01/11/19 - Backport
#                           sanagara_ci_backport_28587723_18.0.0.0.0dbru from
#                           st_rdbms_18.0
#    sanagara    10/23/18 - Backport sanagara_bug-28702188 from main
#    sanagara    10/19/18 - 28181021: add recomp_threshold
#    sanagara    09/27/18 - 28702188: add exclude_pdbs option
#    sanagara    01/09/19 - Backport
#                           sanagara_ci_backport_28587723_18.4.0.0.1adwbp from
#                           st_rdbms_pt-dbcloud18
#    sanagara    10/09/18 - Backport sanagara_bug-28587723 from main
#    sanagara    09/18/18 - 28587723: add skip_sql_state_check
#    surman      09/26/17 - 26281129: Support for new release model
#    surman      04/07/17 - 25507396: Updated requirements for application
#                           patches
#    sanagara    03/21/17 - 24798218: Add allow_pdb_mismatch
#    surman      03/09/17 - 25425451: Intelligent bootstrap
#    surman      09/30/16 - 21503113: JSON orchestration logs
#    surman      06/14/16 - 22694961: Application patches
#    surman      01/25/16 - 22349063: Add -noqi
#    surman      03/04/15 - 18361221: Add -userid
#    surman      12/26/14 - 19883092: Add skip_upgrade_check
#    surman      09/11/14 - 19547370: Much better logging
#    surman      06/24/14 - 19051526: Add period
#    mpradeep    05/13/14 - 17665122 Check if patches need upgrade mode
#    surman      04/21/14 - 17277459: datapatch replaces catbundle
#    mpradeep    04/18/14 - 18411124 - Correct help messages
#    mpradeep    03/24/14 - 17358877 Add a message for multitenant DB's
#    surman      03/19/14 - 17665117: Patch UID
#    surman      03/14/14 - 17898119: Fix -oh
#    surman      03/11/14 - 18355572: Exit if prereqs fail and bundle fixes
#    surman      02/21/14 - Add -bundle_series
#    surman      12/20/13 - 17981677: Add ignorable_errors
#    surman      12/16/13 - 17922172: Handle multiple bundles
#    surman      11/19/13 - 17777061: Better PDB handling
#    surman      09/17/13 - 17442449: Handle RAC better
#    surman      08/06/13 - 17005047: datapatch calls catbundle
#    surman      11/20/12 - 15873839: Check open_mode of PDBs
#    surman      10/30/12 - 14763881: Use db in connect string
#    surman      10/19/12 - 14787047: CDB support
#    surman      09/20/12 - 14624172: Add status column
#    surman      09/07/12 - 14563601: DB name and timestamp for logfile
#    surman      09/05/12 - 14589745: Version to 12.1.0.1.0
#    surman      08/29/12 - 14503324: Pass debug to sqlpatch.pm
#    surman      07/13/12 - 14165102: Creation
#

use strict;
use Getopt::Long;

use sqlpatch;

my $db = '';              # Database to use instead of ORACLE_SID
my $ret;                  # 18355572: Return code
my $prereq_failed;        # 18355572: True if prereq checks failed
my %sqlpatch_parameters;     # 17665117: Hash of all parameters

# Turn on autoflush of output
$| = 1;

my $debug;

# Parse command line into parameters hash
my $parseError =
  GetOptions (\%sqlpatch_parameters,
              'db=s',
              'apply=s',
              'rollback=s',
              'force',
              'prereq',
              'pdbs=s',
              'exclude_pdbs=s',
              'oh=s',
              'verbose',
              'help',
              'debug',
              'ignorable_errors=s',
              'version',
              'upgrade_mode_only',
              'bootstrap',
              'allow_pdb_mismatch',
              'skip_bootstrap',
              'skip_sql_state_check',
              'skip_upgrade_check',
              'userid=s',
              'noqi',
              'app',
              'binary_config=s',
              'orchestration_summary=s',
              'orchestration_progress=s',
              'connect_string=s',
              'recomp_threshold=n',
              'local_inventory');


# Handle parse errors and help options
if (!$parseError || scalar(@ARGV)) {
  sqlpatch::usage();
  $ret = 1;
  goto complete;
}
elsif (defined($sqlpatch_parameters{"help"})) {
  sqlpatch::usage();
  $ret = 0;
  goto complete;
}

if (defined($sqlpatch_parameters{"debug"})) {
  sqlpatch::sqlpatch_log(sqlpatch::LOG_DEBUG, "Command line arguments:\n");
  sqlpatch::sqlpatch_log(sqlpatch::LOG_DEBUG,
                         Data::Dumper->Dumper(%sqlpatch_parameters));
}

# 14763881: If -db is specified, set $ORACLE_SID to it
if (defined($sqlpatch_parameters{"db"})) {
  $ENV{ORACLE_SID} = $sqlpatch_parameters{"db"};
  if (defined($sqlpatch_parameters{"debug"})) {
    sqlpatch::sqlpatch_log(sqlpatch::LOG_DEBUG,
      "-db specified, set ORACLE_SID to $ENV{ORACLE_SID}\n");
  }
}

# Initialize sqlpatch parameters
$ret = sqlpatch::initialize(\%sqlpatch_parameters);
if ($ret) {
  goto complete;
}

# Complete patching based on initialized parameters
$ret = sqlpatch::patch();

# And we're done

complete:

# 17277459: Clean up before exiting
sqlpatch::finalize();

exit($ret);

[oracle@srv6 sqlpatch]$

[oracle@srv6 sqlpatch]$ cd 29517242/
[oracle@srv6 29517242]$ ll
total 8
drwxr-xr-x. 3 oracle oinstall 4096 Apr 18  2019 22861793
drwxr-xr-x. 3 oracle oinstall 4096 Aug  2  2021 22862832
[oracle@srv6 29517242]$ cd 22861793/
[oracle@srv6 22861793]$ ll
total 4
drwxr-xr-x. 2 oracle oinstall 4096 Apr 18  2019 patch_level_files
[oracle@srv6 22861793]$ cd patch_level_files/
[oracle@srv6 patch_level_files]$ ll
total 124
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_assistants_acf_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_assistants_deconfig_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_buildtools_rsf_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_ctx_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_ctx_rsf_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_dbjava_ic_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_dbjava_jdbc_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_dbjava_ucp_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_duma_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_network_client_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_network_listener_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_network_rsf_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_nlsrtl_rsf_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_odbc_ic_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_ons_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_ovm_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_precomp_common_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_precomp_lang_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_rdbms_dbscripts_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_rdbms_deconfig_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_rdbms_dv_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_rdbms_install_plugins_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_rdbms_oci_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_rdbms_rman_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_rdbms_rsf_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_rdbms_util_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_sdo_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_sdo_locator_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_sqlplus_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_sqlplus_ic_29517242.txt
-rwxr-xr-x. 1 oracle oinstall 9 Apr 18  2019 metadata_oracle_xdk_rsf_29517242.txt

[oracle@srv6 File]$ cd ..
[oracle@srv6 lib]$ cd ..
[oracle@srv6 sqlpatch]$ ll
total 392
drwxr-xr-x. 4 oracle oinstall   4096 Apr 18  2019 29517242
-rwxr-x---. 1 oracle oinstall  11322 Apr  1  2019 copy_sqlpatch_files.pl
drwxr-xr-x. 8 oracle oinstall   4096 Apr 17  2019 lib
-rwxr-x---. 1 oracle oinstall   2732 Apr  1  2016 sqlpatch
-rw-r--r--. 1 oracle oinstall   2080 Nov  6  2018 sqlpatch_app_begin.sql
-rw-r--r--. 1 oracle oinstall   1578 Nov  6  2018 sqlpatch_app_create.sql
-rw-r--r--. 1 oracle oinstall   2996 Nov  6  2018 sqlpatch_app_end.sql
-rw-r--r--. 1 oracle oinstall  11212 Mar 26  2019 sqlpatch_bootstrap.sql
-rw-r--r--. 1 oracle oinstall   5581 Mar  2  2019 sqlpatch.pl
-rw-r--r--. 1 oracle oinstall 340639 Mar  2  2019 sqlpatch.pm
[oracle@srv6 sqlpatch]$ cd 29517242/
[oracle@srv6 29517242]$ ll
total 8
drwxr-xr-x. 3 oracle oinstall 4096 Apr 18  2019 22861793
drwxr-xr-x. 3 oracle oinstall 4096 Aug  2  2021 22862832
[oracle@srv6 29517242]$ cd 22862832/
[oracle@srv6 22862832]$ ll
total 3792
-rw-r--r--. 1 oracle oinstall   10512 Apr 18  2019 29517242_apply.sql
-rw-r--r--. 1 oracle oinstall   10527 Apr 18  2019 29517242_rollback.sql
-rw-r--r--. 1 oracle oinstall    6998 Apr 18  2019 29517242.xml
-rw-r-----. 1 oracle oinstall 3842294 Aug  2  2021 29517242.zip
drwxr-xr-x. 4 oracle oinstall    4096 Apr 18  2019 rollback_files
[oracle@srv6 22862832]$ cat 29517242_apply.sql
SET SERVEROUTPUT ON

REM Apply script for patch 29517242/22862832
DEFINE logfiledir = &1

COLUMN sqlpatch_logfile NEW_VALUE full_logfile

SELECT '&logfiledir' || '29517242_apply_' ||
       CASE WHEN (sys_context('userenv', 'cdb_name') IS NULL)
            THEN name
            ELSE name || '_' || replace(sys_context('userenv', 'con_name'), '$')
             END || TO_CHAR(systimestamp, '_YYYYMonDD_HH24_MI_SS',
             'NLS_DATE_LANGUAGE=AMERICAN') ||'.log' AS sqlpatch_logfile
  FROM v$database;

SPOOL &full_logfile

SET PAGESIZE 0
SELECT 'Starting apply for patch 29517242/22862832 on ' ||
       SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

BEGIN
    dbms_sqlpatch.patch_initialize(p_patch_id      => 29517242,
                                   p_patch_uid     => 22862832,
                                   p_logfile       => '&full_logfile');
END;
/


COLUMN install_file NEW_VALUE sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/backport_files/bug_29032457_apply.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/backport_files/bug_29032457_apply.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/catcdbviews.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/catcdbviews.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/cdcore_mig.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/cdcore_mig.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/catappcontainer.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/catappcontainer.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/catawrrtvw.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/catawrrtvw.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/catawrpdbvw.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/catawrpdbvw.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/catawrvw.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/catawrvw.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/dbmssqlu.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/dbmssqlu.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/dbmssqlt.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/dbmssqlt.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvsash.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvsash.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvsspmi.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvsspmi.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/dbmsgwm.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/dbmsgwm.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/catost.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/catost.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/dbmsrman.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/dbmsrman.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/catadv.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/catadv.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/cataivw.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/cataivw.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtemxi.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtemxi.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtemx_dbhome.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtemx_dbhome.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtsrv.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtsrv.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtash.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtash.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtsqlt.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtsqlt.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtaii.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtaii.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvthdm.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvthdm.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtsqlu.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtsqlu.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtspmi.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtspmi.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtspm.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtspm.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtstai.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtstai.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtsqlqi.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtsqlqi.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtrmns.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtrmns.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/execsmb.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/execsmb.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtgwm.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtgwm.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling md/admin/catmdloc.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('md/admin/catmdloc.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling md/admin/prvtcs.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('md/admin/prvtcs.plb') AS install_file
  FROM dual;
@@&sql_script



BEGIN dbms_sqlpatch.patch_finalize; END;
/

SET PAGESIZE 0
SELECT 'Finished apply for patch 29517242/22862832 on' ||
       SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

SPOOL off

[oracle@srv6 22862832]$ cd ..
[oracle@srv6 29517242]$ ll
total 8
drwxr-xr-x. 3 oracle oinstall 4096 Apr 18  2019 22861793
drwxr-xr-x. 3 oracle oinstall 4096 Aug  2  2021 22862832
[oracle@srv6 29517242]$ pwd
/u01/app/oracle/product/19.3/db_home/sqlpatch/29517242
[oracle@srv6 29517242]$ ll
total 8
drwxr-xr-x. 3 oracle oinstall 4096 Apr 18  2019 22861793
drwxr-xr-x. 3 oracle oinstall 4096 Aug  2  2021 22862832
[oracle@srv6 29517242]$ cd 22862832/
[oracle@srv6 22862832]$ ll
total 3792
-rw-r--r--. 1 oracle oinstall   10512 Apr 18  2019 29517242_apply.sql
-rw-r--r--. 1 oracle oinstall   10527 Apr 18  2019 29517242_rollback.sql
-rw-r--r--. 1 oracle oinstall    6998 Apr 18  2019 29517242.xml
-rw-r-----. 1 oracle oinstall 3842294 Aug  2  2021 29517242.zip
drwxr-xr-x. 4 oracle oinstall    4096 Apr 18  2019 rollback_files
[oracle@srv6 22862832]$ cat 29517242.xml
<?xml version="1.0" encoding="utf-8"?>
<sqlPatch ID="29517242" uniquePatchID="22862832" applicationPatch="NO" jvm="NO" startupMode="normal" estimatedApplyTime="5" estimatedRollbackTime="5" buildTimestamp="190410122720" buildDescription="Release_Update" patchType="RU" featureVersion="19" ruVersion="19.3.0.0.0">

<patchDescription>Database Release Update : 19.3.0.0.190416 (29517242)</patchDescription>

<!-- All components contained in this patch -->
<components>
  <component sequence="1">CATALOG</component>
  <component sequence="2">CATPROC</component>
  <component sequence="3">ORDIM</component>
  <component sequence="4">XDB</component>
</components>

<!--  All files contained in this patch -->
<sqlFiles>
    <file mode="apply" new="yes" estimatedTime="5" component="CATALOG" sequence="1">rdbms/admin/backport_files/bug_29032457_apply.sql</file>
    <file mode="rollback" new="yes" estimatedTime="5" component="CATALOG" sequence="2">rdbms/admin/backport_files/bug_29032457_rollback.sql</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATALOG" sequence="3">rdbms/admin/catcdbviews.sql</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATALOG" sequence="4">rdbms/admin/cdcore_mig.sql</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="5">rdbms/admin/catappcontainer.sql</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="6">rdbms/admin/catawrrtvw.sql</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="7">rdbms/admin/catawrpdbvw.sql</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="8">rdbms/admin/catawrvw.sql</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="9">rdbms/admin/dbmssqlu.sql</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="10">rdbms/admin/dbmssqlt.sql</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="11">rdbms/admin/prvsash.plb</file>
    <file mode="apply,rollback,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="12">rdbms/admin/prvsspmi.plb</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="13">rdbms/admin/dbmsgwm.sql</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="14">rdbms/admin/catost.sql</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="15">rdbms/admin/dbmsrman.sql</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="16">rdbms/admin/catadv.sql</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="17">rdbms/admin/cataivw.sql</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="18">rdbms/admin/prvtemxi.plb</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="19">rdbms/admin/prvtemx_dbhome.plb</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="20">rdbms/admin/prvtsrv.plb</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="21">rdbms/admin/prvtash.plb</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="22">rdbms/admin/prvtsqlt.plb</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="23">rdbms/admin/prvtaii.plb</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="24">rdbms/admin/prvthdm.plb</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="25">rdbms/admin/prvtsqlu.plb</file>
    <file mode="apply,rollback,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="26">rdbms/admin/prvtspmi.plb</file>
    <file mode="apply,rollback,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="27">rdbms/admin/prvtspm.plb</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="28">rdbms/admin/prvtstai.plb</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="29">rdbms/admin/prvtsqlqi.plb</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="30">rdbms/admin/prvtrmns.plb</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="CATPROC" sequence="31">rdbms/admin/execsmb.sql</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="ORDIM" sequence="32">md/admin/catmdloc.sql</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="ORDIM" sequence="33">md/admin/prvtcs.plb</file>
    <file mode="apply,rollback" new="no" estimatedTime="5" component="XDB" sequence="34">rdbms/admin/prvtgwm.sql</file>
</sqlFiles>

<!-- Release Update Data for this patch -->
<ruData>
    <ru version="19.3.0.0.0" ruType="RU" buildTimestamp="190410122720" buildDescription="Release_Update">
      <file>rdbms/admin/backport_files/bug_29032457_apply.sql</file>
      <file>rdbms/admin/backport_files/bug_29032457_rollback.sql</file>
      <file>rdbms/admin/catcdbviews.sql</file>
      <file>rdbms/admin/cdcore_mig.sql</file>
      <file>rdbms/admin/catappcontainer.sql</file>
      <file>rdbms/admin/catawrrtvw.sql</file>
      <file>rdbms/admin/catawrpdbvw.sql</file>
      <file>rdbms/admin/catawrvw.sql</file>
      <file>rdbms/admin/dbmssqlu.sql</file>
      <file>rdbms/admin/dbmssqlt.sql</file>
      <file>rdbms/admin/prvsash.plb</file>
      <file>rdbms/admin/prvsspmi.plb</file>
      <file>rdbms/admin/dbmsgwm.sql</file>
      <file>rdbms/admin/catost.sql</file>
      <file>rdbms/admin/dbmsrman.sql</file>
      <file>rdbms/admin/catadv.sql</file>
      <file>rdbms/admin/cataivw.sql</file>
      <file>rdbms/admin/prvtemxi.plb</file>
      <file>rdbms/admin/prvtemx_dbhome.plb</file>
      <file>rdbms/admin/prvtsrv.plb</file>
      <file>rdbms/admin/prvtash.plb</file>
      <file>rdbms/admin/prvtsqlt.plb</file>
      <file>rdbms/admin/prvtaii.plb</file>
      <file>rdbms/admin/prvthdm.plb</file>
      <file>rdbms/admin/prvtsqlu.plb</file>
      <file>rdbms/admin/prvtspmi.plb</file>
      <file>rdbms/admin/prvtspm.plb</file>
      <file>rdbms/admin/prvtstai.plb</file>
      <file>rdbms/admin/prvtsqlqi.plb</file>
      <file>rdbms/admin/prvtrmns.plb</file>
      <file>rdbms/admin/execsmb.sql</file>
      <file>md/admin/catmdloc.sql</file>
      <file>md/admin/prvtcs.plb</file>
      <file>rdbms/admin/prvtgwm.sql</file>
    </ru>
  </ruData>

 <!-- Contents of rollback_files for this patch -->
<rollbackFilesData>
    <rollbackVersion>19.1.0.0.0</rollbackVersion>
    <rollbackVersion>19.3.0.0.0-RU-Release_Update-190410122720</rollbackVersion>
</rollbackFilesData>

</sqlPatch>
[oracle@srv6 22862832]$ cat 29517242_apply.sql
SET SERVEROUTPUT ON

REM Apply script for patch 29517242/22862832
DEFINE logfiledir = &1

COLUMN sqlpatch_logfile NEW_VALUE full_logfile

SELECT '&logfiledir' || '29517242_apply_' ||
       CASE WHEN (sys_context('userenv', 'cdb_name') IS NULL)
            THEN name
            ELSE name || '_' || replace(sys_context('userenv', 'con_name'), '$')
             END || TO_CHAR(systimestamp, '_YYYYMonDD_HH24_MI_SS',
             'NLS_DATE_LANGUAGE=AMERICAN') ||'.log' AS sqlpatch_logfile
  FROM v$database;

SPOOL &full_logfile

SET PAGESIZE 0
SELECT 'Starting apply for patch 29517242/22862832 on ' ||
       SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

BEGIN
    dbms_sqlpatch.patch_initialize(p_patch_id      => 29517242,
                                   p_patch_uid     => 22862832,
                                   p_logfile       => '&full_logfile');
END;
/


COLUMN install_file NEW_VALUE sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/backport_files/bug_29032457_apply.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/backport_files/bug_29032457_apply.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/catcdbviews.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/catcdbviews.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/cdcore_mig.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/cdcore_mig.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/catappcontainer.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/catappcontainer.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/catawrrtvw.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/catawrrtvw.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/catawrpdbvw.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/catawrpdbvw.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/catawrvw.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/catawrvw.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/dbmssqlu.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/dbmssqlu.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/dbmssqlt.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/dbmssqlt.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvsash.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvsash.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvsspmi.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvsspmi.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/dbmsgwm.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/dbmsgwm.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/catost.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/catost.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/dbmsrman.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/dbmsrman.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/catadv.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/catadv.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/cataivw.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/cataivw.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtemxi.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtemxi.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtemx_dbhome.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtemx_dbhome.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtsrv.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtsrv.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtash.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtash.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtsqlt.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtsqlt.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtaii.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtaii.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvthdm.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvthdm.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtsqlu.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtsqlu.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtspmi.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtspmi.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtspm.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtspm.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtstai.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtstai.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtsqlqi.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtsqlqi.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtrmns.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtrmns.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/execsmb.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/execsmb.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtgwm.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtgwm.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling md/admin/catmdloc.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('md/admin/catmdloc.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling md/admin/prvtcs.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('md/admin/prvtcs.plb') AS install_file
  FROM dual;
@@&sql_script



BEGIN dbms_sqlpatch.patch_finalize; END;
/

SET PAGESIZE 0
SELECT 'Finished apply for patch 29517242/22862832 on' ||
       SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

SPOOL off

[oracle@srv6 22862832]$ cat 29517242_rollback.sql
SET SERVEROUTPUT ON

REM Apply script for patch 29517242/22862832
DEFINE logfiledir = &1

COLUMN sqlpatch_logfile NEW_VALUE full_logfile

SELECT '&logfiledir' || '29517242_rollback_' ||
       CASE WHEN (sys_context('userenv', 'cdb_name') IS NULL)
            THEN name
            ELSE name || '_' || replace(sys_context('userenv', 'con_name'), '$')
             END || TO_CHAR(systimestamp, '_YYYYMonDD_HH24_MI_SS',
             'NLS_DATE_LANGUAGE=AMERICAN') ||'.log' AS sqlpatch_logfile
  FROM v$database;

SPOOL &full_logfile

SET PAGESIZE 0
SELECT 'Starting rollback for patch 29517242/22862832 on ' ||
       SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

BEGIN
    dbms_sqlpatch.patch_initialize(p_patch_id      => 29517242,
                                   p_patch_uid     => 22862832,
                                   p_logfile       => '&full_logfile');
END;
/


COLUMN install_file NEW_VALUE sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/backport_files/bug_29032457_rollback.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/backport_files/bug_29032457_rollback.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/catcdbviews.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/catcdbviews.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/cdcore_mig.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/cdcore_mig.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/catappcontainer.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/catappcontainer.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/catawrrtvw.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/catawrrtvw.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/catawrpdbvw.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/catawrpdbvw.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/catawrvw.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/catawrvw.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/dbmssqlu.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/dbmssqlu.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/dbmssqlt.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/dbmssqlt.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvsash.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvsash.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvsspmi.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvsspmi.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/dbmsgwm.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/dbmsgwm.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/catost.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/catost.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/dbmsrman.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/dbmsrman.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/catadv.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/catadv.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/cataivw.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/cataivw.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtemxi.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtemxi.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtemx_dbhome.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtemx_dbhome.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtsrv.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtsrv.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtash.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtash.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtsqlt.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtsqlt.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtaii.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtaii.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvthdm.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvthdm.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtsqlu.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtsqlu.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtspmi.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtspmi.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtspm.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtspm.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtstai.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtstai.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtsqlqi.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtsqlqi.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtrmns.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtrmns.plb') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/execsmb.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/execsmb.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling rdbms/admin/prvtgwm.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('rdbms/admin/prvtgwm.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling md/admin/catmdloc.sql on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('md/admin/catmdloc.sql') AS install_file
  FROM dual;
@@&sql_script


ALTER SESSION SET CURRENT_SCHEMA = SYS;

SET PAGESIZE 0
SELECT 'Calling md/admin/prvtcs.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

PROMPT IGNORABLE ERRORS: NONE

SELECT dbms_sqlpatch.install_file('md/admin/prvtcs.plb') AS install_file
  FROM dual;
@@&sql_script



BEGIN dbms_sqlpatch.patch_finalize; END;
/

SET PAGESIZE 0
SELECT 'Finished rollback for patch 29517242/22862832 on' ||
       SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

SPOOL off

[oracle@srv6 22862832]$

[oracle@srv6 22862832]$ ll
total 3792
-rw-r--r--. 1 oracle oinstall   10512 Apr 18  2019 29517242_apply.sql
-rw-r--r--. 1 oracle oinstall   10527 Apr 18  2019 29517242_rollback.sql
-rw-r--r--. 1 oracle oinstall    6998 Apr 18  2019 29517242.xml
-rw-r-----. 1 oracle oinstall 3842294 Aug  2  2021 29517242.zip
drwxr-xr-x. 4 oracle oinstall    4096 Apr 18  2019 rollback_files

[oracle@srv6 22862832]$ cd rollback_files/
[oracle@srv6 rollback_files]$ ll
total 8
drwxr-xr-x. 4 oracle oinstall 4096 Apr 18  2019 19.1.0.0.0
drwxr-xr-x. 4 oracle oinstall 4096 Apr 18  2019 19.3.0.0.0-RU-Release_Update-190410122720
[oracle@srv6 rollback_files]$


Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)