Using RMAN backup restore 12c database from one host to another host on Linux Open suse12 SP1

Scenario Preview:

Using RMAN backup restore SMRPATCH7 database from one host to another host.


 Face some oracle error.

ORA Error  Found:

ORA-00392: log 1 of thread 1 is being cleared, operation not allowed

ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/SMRPATCH7/redo01.log'

Source OS : SUSE 12 SP4 | sgdcpl02
Destination OS : SUSE 12 SP1 |sgdcpl08

•  Command to check existing data files and log files.

RMAN> set pagesize  200 linesize 200

select 'set newname for datafile ' || a.FILE# || ' to "' || a.NAME || '";'

  from v$datafile a

union all

select 'set newname for tempfile ' || a.FILE# || ' to "' || a.NAME || '";'

  from v$tempfile a

union all

SELECT 'SQL "ALTER DATABASE RENAME FILE ''''' || a.MEMBER || '''''  to  ''''' ||

       a.MEMBER || ''''' ";'

  FROM v$logfile a;

RMAN> 2> 3> 4> 5> 6> 7> 8> 9>

'SETNEWNAMEFORDATAFILE'||A.FILE#||'TO"'||A.NAME||'";'

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

set newname for datafile 1 to "/u01/app/oracle/oradata/SMRPATCH7/system01.dbf";

set newname for datafile 2 to "/u01/app/oracle/oradata/SMRPATCH7/idata01.DBF";

set newname for datafile 3 to "/u01/app/oracle/oradata/SMRPATCH7/ilog01.DBF";

set newname for datafile 4 to "/u01/app/oracle/oradata/SMRPATCH7/sysaux01.dbf";

set newname for datafile 5 to "/u01/app/oracle/oradata/SMRPATCH7/undotbs01.dbf";

set newname for datafile 6 to "/u01/app/oracle/oradata/SMRPATCH7/users01.dbf";

set newname for datafile 7 to "/u01/app/oracle/oradata/SMRPATCH7/indx01.DBF";

set newname for tempfile 1 to "/u01/app/oracle/oradata/SMRPATCH7/temp01.dbf";

SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPATCH7/redo03.log''  to  ''/u04/MasterDB/oradata/SMRPATCH7/redo03.log'' ";

SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPATCH7/redo02.log''  to  ''/u04/MasterDB/oradata/SMRPATCH7/redo02.log'' ";

SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPATCH7/redo01.log''  to  ''/u04/MasterDB/oradata/SMRPATCH7/redo01.log'' ";

11 rows selected

RMAN>

RMAN> run
2> {
3> allocate channel c1 device type disk format '/u04/MasterDB/rmanbkp_SMRPATCH7/Backup_%d_DB_%u_%s_%p_%T';
4> allocate channel c2 device type disk format '/u04/MasterDB/rmanbkp_SMRPATCH7/Backup_%d_DB_%u_%s_%p_%T';
5> allocate channel c3 device type disk format '/u04/MasterDB/rmanbkp_SMRPATCH7/Backup_%d_DB_%u_%s_%p_%T';
6> allocate channel c4 device type disk format '/u04/MasterDB/rmanbkp_SMRPATCH7/Backup_%d_DB_%u_%s_%p_%T';
7> crosscheck backup;
8> crosscheck archivelog all;
9> report obsolete;
10> delete noprompt obsolete;
11> sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
12> BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 0 tag='FULL_BACKUP_Daily' DATABASE INCLUDE CURRENT CONTROLFILE FILESPERSET 1;
13> BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL;
14> #delete noprompt archivelog all backed up 1 times to disk;
15> copy current controlfile to '/u04/MasterDB/rmanbkp_SMRPATCH7/control01_SMRPATCH7_%d_%u_%T.bak';
16> release channel c1;
17> release channel c2;
18> release channel c3;
19> release channel c4;
20> }

#################################################################################

• oracle@sgdcpl08:/u02/rman_backup> . oraenv

ORACLE_SID = [SMRPATCH7] ?

The Oracle base remains unchanged with value /u01/app/oracle

oracle@sgdcpl08:/u02/rman_backup> sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Dec 11 11:13:18 2019

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

Connected to an idle instance.

• SQL> startup nomount;

ORACLE instance started.

Total System Global Area 1593835520 bytes

Fixed Size                  2924880 bytes

Variable Size            1207963312 bytes

Database Buffers          369098752 bytes

Redo Buffers               13848576 bytes

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

oracle@sgdcpl08:/u02/rman_backup> rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Wed Dec 11 11:13:42 2019

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to target database: SMRPATCH (not mounted)

• RMAN> restore controlfile from '/u02/rman_backup/control01_SMRPATCH7_SMRPATCH_91uj5a59_20191211.bak';

Starting restore at 11-DEC-2019 11:14:10

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=807 device type=DISK

channel ORA_DISK_1: copied control file copy

output file name=/u01/app/oracle/oradata/SMRPATCH7/control01.ctl

output file name=/u01/app/oracle/fast_recovery_area/SMRPATCH7/control02.ctl

Finished restore at 11-DEC-2019 11:14:12

• RMAN> alter database mount;

Statement processed

released channel: ORA_DISK_1

• RMAN> catalog start with '/u02/rman_backup/';

searching for all files that match the pattern /u02/rman_backup/

List of Files Unknown to the Database

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

File Name: /u02/rman_backup/rman_SMRPATCH7.log

Do you really want to catalog the above files (enter YES or NO)? YES

cataloging files...

no files cataloged

List of Files Which Were Not Cataloged

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

File Name: /u02/rman_backup/rman_SMRPATCH7.log

  RMAN-07517: Reason: The file header is corrupted

RMAN> RUN

{

set newname for datafile 1 to "/u01/app/oracle/oradata/SMRPATCH7/system01.dbf";

set newname for datafile 3 to "/u01/app/oracle/oradata/SMRPATCH7/ilog01.DBF";

set newname for datafile 4 to "/u01/app/oracle/oradata/SMRPATCH7/sysaux01.dbf";

set newname for datafile 5 to "/u01/app/oracle/oradata/SMRPATCH7/undotbs01.dbf";

set newname for datafile 2 to "/u01/app/oracle/oradata/SMRPATCH7/idata01.DBF";

set newname for datafile 6 to "/u01/app/oracle/oradata/SMRPATCH7/users01.dbf";

set newname for datafile 7 to "/u01/app/oracle/oradata/SMRPATCH7/indx01.DBF";

2> 3> 4> 5> 6> set newname for tempfile 1 to "/u01/app/oracle/oradata/SMRPATCH7/temp01.dbf";

RESTORE DATABASE;

SWITCH DATAFILE ALL;

SWITCH TEMPFILE ALL;

recover database;

}7> 8> 9> 10> 11> 12> 13> 14> 15>

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 11-DEC-2019 11:17:09

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/SMRPATCH7/idata01.DBF

channel ORA_DISK_1: reading from backup piece /u02/rman_backup/Backup_SMRPATCH_DB_8luj59vt_277_1_20191211

channel ORA_DISK_1: piece handle=/u02/rman_backup/Backup_SMRPATCH_DB_8luj59vt_277_1_20191211 tag=FULL_BACKUP_DAILY

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:07

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/SMRPATCH7/indx01.DBF

channel ORA_DISK_1: reading from backup piece /u02/rman_backup/Backup_SMRPATCH_DB_8muj59vt_278_1_20191211

channel ORA_DISK_1: piece handle=/u02/rman_backup/Backup_SMRPATCH_DB_8muj59vt_278_1_20191211 tag=FULL_BACKUP_DAILY

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:07

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/SMRPATCH7/sysaux01.dbf

channel ORA_DISK_1: reading from backup piece /u02/rman_backup/Backup_SMRPATCH_DB_8ouj59vu_280_1_20191211

channel ORA_DISK_1: piece handle=/u02/rman_backup/Backup_SMRPATCH_DB_8ouj59vu_280_1_20191211 tag=FULL_BACKUP_DAILY

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/SMRPATCH7/users01.dbf

channel ORA_DISK_1: reading from backup piece /u02/rman_backup/Backup_SMRPATCH_DB_8quj5a01_282_1_20191211

channel ORA_DISK_1: piece handle=/u02/rman_backup/Backup_SMRPATCH_DB_8quj5a01_282_1_20191211 tag=FULL_BACKUP_DAILY

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/SMRPATCH7/system01.dbf

channel ORA_DISK_1: reading from backup piece /u02/rman_backup/Backup_SMRPATCH_DB_8nuj59vu_279_1_20191211

channel ORA_DISK_1: piece handle=/u02/rman_backup/Backup_SMRPATCH_DB_8nuj59vu_279_1_20191211 tag=FULL_BACKUP_DAILY

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:25

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/SMRPATCH7/ilog01.DBF

channel ORA_DISK_1: reading from backup piece /u02/rman_backup/Backup_SMRPATCH_DB_8kuj59vt_276_1_20191211

channel ORA_DISK_1: piece handle=/u02/rman_backup/Backup_SMRPATCH_DB_8kuj59vt_276_1_20191211 tag=FULL_BACKUP_DAILY

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:35

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/SMRPATCH7/undotbs01.dbf

channel ORA_DISK_1: reading from backup piece /u02/rman_backup/Backup_SMRPATCH_DB_8juj59vt_275_1_20191211

channel ORA_DISK_1: piece handle=/u02/rman_backup/Backup_SMRPATCH_DB_8juj59vt_275_1_20191211 tag=FULL_BACKUP_DAILY

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:01:55

Finished restore at 11-DEC-2019 11:20:21

datafile 1 switched to datafile copy

input datafile copy RECID=27 STAMP=1026732021 file name=/u01/app/oracle/oradata/SMRPATCH7/system01.dbf

datafile 2 switched to datafile copy

input datafile copy RECID=28 STAMP=1026732021 file name=/u01/app/oracle/oradata/SMRPATCH7/idata01.DBF

datafile 3 switched to datafile copy

input datafile copy RECID=29 STAMP=1026732021 file name=/u01/app/oracle/oradata/SMRPATCH7/ilog01.DBF

datafile 4 switched to datafile copy

input datafile copy RECID=30 STAMP=1026732021 file name=/u01/app/oracle/oradata/SMRPATCH7/sysaux01.dbf

datafile 5 switched to datafile copy

input datafile copy RECID=31 STAMP=1026732021 file name=/u01/app/oracle/oradata/SMRPATCH7/undotbs01.dbf

datafile 6 switched to datafile copy

input datafile copy RECID=32 STAMP=1026732021 file name=/u01/app/oracle/oradata/SMRPATCH7/users01.dbf

datafile 7 switched to datafile copy

input datafile copy RECID=33 STAMP=1026732021 file name=/u01/app/oracle/oradata/SMRPATCH7/indx01.DBF

Starting recover at 11-DEC-2019 11:20:21

using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 1401 is already on disk as file /u02/rman_backup/o1_mf_1_1401_gz1gt84c_.arc

archived log file name=/u02/rman_backup/o1_mf_1_1401_gz1gt84c_.arc thread=1 sequence=1401

unable to find archived log

archived log thread=1 sequence=1402

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 12/11/2019 11:20:22

RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 1402 and starting SCN of 36001430

• RMAN> select member from v$logfile;

MEMBER

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

/u04/MasterDB/oradata/SMRPATCH7/redo03.log

/u04/MasterDB/oradata/SMRPATCH7/redo02.log

/u04/MasterDB/oradata/SMRPATCH7/redo01.log

/u04/MasterDB/oradata/SMRPATCH7/redo04.log

/u04/MasterDB/oradata/SMRPATCH7/redo05.log

/u04/MasterDB/oradata/SMRPATCH7/redo06.log

############################################################################

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPATCH7/redo01.log''  to ''/u01/app/oracle/oradata/SMRPATCH7/redo01.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPATCH7/redo01.log''  to ''/u01/app/oracle/oradata/SMRPATCH7/redo01.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPATCH7/redo02.log''  to  ''/u01/app/oracle/oradata/SMRPATCH7/redo02.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPATCH7/redo02.log''  to  ''/u01/app/oracle/oradata/SMRPATCH7/redo02.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPATCH7/redo03.log''  to  ''/u01/app/oracle/oradata/SMRPATCH7/redo03.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPATCH7/redo03.log''  to  ''/u01/app/oracle/oradata/SMRPATCH7/redo03.log''

RMAN> select member from v$logfile;

MEMBER

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

/u01/app/oracle/oradata/SMRPATCH7/redo03.log

/u01/app/oracle/oradata/SMRPATCH7/redo02.log

/u01/app/oracle/oradata/SMRPATCH7/redo01.log

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of sql statement command at 12/11/2019 11:35:28

ORA-00392: log 1 of thread 1 is being cleared, operation not allowed

ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/SMRPATCH7/redo01.log'

RMAN>  alter database open resetlogs;

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of sql statement command at 12/11/2019 11:35:43

ORA-00392: log 1 of thread 1 is being cleared, operation not allowed

ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/SMRPATCH7/redo01.log'

RMAN> select group#,thread#,status from v$log;

    GROUP#    THREAD# STATUS

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

         1          1 CLEARING_CURRENT

         3          1 CLEARING

         2          1 CLEARING

RMAN> alter database clear logfile group 1;

Statement processed

RMAN> select group#,thread#,status from v$log;

    GROUP#    THREAD# STATUS

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

         1          1 CURRENT

         3          1 CLEARING

         2          1 CLEARING

RMAN> alter database clear logfile group 2;

Statement processed

RMAN> alter database clear logfile group 3;

Statement processed

RMAN> select group#,thread#,status from v$log;

    GROUP#    THREAD# STATUS

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

         1          1 CURRENT

         3          1 UNUSED

         2          1 UNUSED

RMAN> alter database open resetlogs;

Statement processed

RMAN> select name,open_mode,database_role from v$database;

NAME      OPEN_MODE            DATABASE_ROLE

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

SMRPATCH  READ WRITE           PRIMARY

OPATCH Conflict : The patch(es) has conflicts with other patches installed patches have conflicts 27595973, 29494060

Scenario Preview:

While applying PSU Patch found conflict  with earlier patch 27595973. 

• Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches : 27595973, 29494060

Solution : Rollback patch  27595973 and then apply patch 29494060

Patch Number : PSU DB JULY 2019 - p29494060_121020_Linux-x86-64

#############################################################################

solution- Scenario Preview:

• Set oracle Environment variable :

oracle@sgdcpl08:/u02/29494060> export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1

oracle@sgdcpl08:/u02/29494060> export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin

oracle@sgdcpl08:/u02/29494060> export PATH=$ORACLE_HOME/perl/bin:$PATH

• Check Pre -Requestories

oracle@sgdcpl08:/u02/29494060> opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-12-03_14-34-59PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

ZOP-40: The patch(es) has conflicts with other patches installed in the Oracle Home (or) among themselves.

Prereq "checkConflictAgainstOHWithDetail" failed.

Summary of Conflict Analysis:

There are no patches that can be applied now.

Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :
27595973, 29494060

Whole composite patch Conflicts/Supersets are:

Composite Patch : 29494060

        Conflict with 27595973

Detail Conflicts/Supersets for each patch are:

Sub-Patch : 21359755

        Conflict with 27595973
        Conflict details:
        /u01/app/oracle/product/12.1.0/dbhome_1/lib/libserver12.a:qksbg.o

Sub-Patch : 22291127

        Conflict with 27595973
        Conflict details:
        /u01/app/oracle/product/12.1.0/dbhome_1/lib/libserver12.a:qkscr.o
        /u01/app/oracle/product/12.1.0/dbhome_1/lib/libserver12.a:qksbg.o
        /u01/app/oracle/product/12.1.0/dbhome_1/lib/libserver12.a:qksfm.o

Sub-Patch : 27338041

        Conflict with 27595973
        Conflict details:
        /u01/app/oracle/product/12.1.0/dbhome_1/lib/libserver12.a:qkscr.o
        /u01/app/oracle/product/12.1.0/dbhome_1/lib/libserver12.a:qksbg.o
        /u01/app/oracle/product/12.1.0/dbhome_1/lib/libserver12.a:qksfm.o

OPatch succeeded.
oracle@sgdcpl08:/u02/29494060>

• Check with Opatch lsinventory

oracle@sgdcpl08:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> ./opatch lsinventory

Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-12-03_14-52-02PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2019-12-03_14-52-02PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: sgdcpl08.smr.motherson.com
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c                                                  12.1.0.2.0
There are 1 products installed in this Oracle Home.


Interim patches (1) :

Patch  27595973     : applied on Fri Nov 29 14:23:10 CET 2019
Unique Patch ID:  22019623
   Created on 9 Mar 2018, 23:06:29 hrs PST8PDT
   Bugs fixed:
     27595973



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

OPatch succeeded.

• Rollback using id below

oracle@sgdcpl08:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> ./opatch rollback -id 27595973

Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-12-03_14-52-58PM_1.log


Patches will be rolled back in the following order:
   27595973
The following patch(es) will be rolled back: 27595973

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.1.0/dbhome_1')


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

Rolling back patch 27595973...

RollbackSession rolling back interim patch '27595973' from OH '/u01/app/oracle/product/12.1.0/dbhome_1'

Patching component oracle.rdbms, 12.1.0.2.0...
RollbackSession removing interim patch '27595973' from inventory
Log file location: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-12-03_14-52-58PM_1.log

OPatch succeeded.


oracle@sgdcpl08:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch>

• FOR Safe Zone take tar backup : tar -cvzf dbhome_1.tar.gz dbhome_1
• Datapatch -verbose is optional we can ignore

oracle@sgdcpl08:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> ./datapatch -verbose

SQL Patching tool version 12.2.0.0.0 on Tue Dec  3 14:56:05 2019

Copyright (c) 2014, Oracle.  All rights reserved.

Connecting to database...OK

Determining current state...done

Current state of SQL patches:

Adding patches to installation queue and performing prereq checks...

Installation queue:

  Nothing to roll back

  Nothing to apply

SQL Patching tool complete on Tue Dec  3 14:56:08 2019

oracle@sgdcpl08:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch>

oracle@sgdcpl08:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch>

• Check with Opatch lsinventory

oracle@sgdcpl08:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> ./opatch lsinventory

Oracle Interim Patch Installer version 12.2.0.1.17

Copyright (c) 2019, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc

OPatch version    : 12.2.0.1.17

OUI version       : 12.1.0.2.0

Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-12-03_15-32-42PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2019-12-03_15-32-42PM.txt

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

Local Machine Information::

Hostname: sgdcpl08.smr.motherson.com

ARU platform id: 226

ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c                                                  12.1.0.2.0

There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

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

• Set Oracle Path

export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1

export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin

export PATH=$ORACLE_HOME/perl/bin:$PATH

opatch prereq CheckConflictAgainstOHWithDetail -ph ./

• Opatch Pre- Requestory

oracle@sgdcpl08:/u02/29494060> opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Oracle Interim Patch Installer version 12.2.0.1.17

Copyright (c) 2019, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc

OPatch version    : 12.2.0.1.17

OUI version       : 12.1.0.2.0

Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-12-03_15-33-48PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

OPatch succeeded.

oracle@sgdcpl08:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch>

• Apply Patch

oracle@sgdcpl08:/u02/29494060> opatch apply

Oracle Interim Patch Installer version 12.2.0.1.17

Copyright (c) 2019, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc

OPatch version    : 12.2.0.1.17

OUI version       : 12.1.0.2.0

Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-12-04_07-21-43AM_1.log

Verifying environment and performing prerequisite checks...

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

Start OOP by Prereq process.

Launch OOP...

Oracle Interim Patch Installer version 12.2.0.1.17

Copyright (c) 2019, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc

OPatch version    : 12.2.0.1.17

OUI version       : 12.1.0.2.0

Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-12-04_07-21-49AM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches:   19769480  20299023  20831110  21359755  21948354  22291127  23054246  24006101  24732082  25171037  25755742  26609783  26713565  26925311  27338041  27547329  28259833  28729169  29141015  29494060

Do you want to proceed? [y|n]

Y (auto-answered by -silent)

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

Is the local system ready for patching? [y|n]

Y (auto-answered by -silent)

User Responded with: Y

Backing up files...

Applying sub-patch '19769480' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.xdk, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.util, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

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

Patching component oracle.oraolap, 12.1.0.2.0...

Patching component oracle.xdk.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

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

Applying sub-patch '20299023' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'

ApplySession: Optional component(s) [ oracle.has.crs, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

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

Patching component oracle.ldap.rsf, 12.1.0.2.0...

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

Applying sub-patch '20831110' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.oraolap.dbscripts, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Applying sub-patch '21359755' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'

Patching component oracle.assistants.server, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Applying sub-patch '21948354' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.xdk, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

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

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.xdk.rsf, 12.1.0.2.0...

Applying sub-patch '22291127' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'

ApplySession: Optional component(s) [ oracle.oid.client, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.ldap.client, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.oraolap, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.oraolap.dbscripts, 12.1.0.2.0...

Applying sub-patch '23054246' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'

Patching component oracle.rdbms.dv, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.install.deinstalltool, 12.1.0.2.0...

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

Patching component oracle.oracore.rsf, 12.1.0.2.0...

Patching component oracle.ctx, 12.1.0.2.0...

Patching component oracle.xdk, 12.1.0.2.0...

Patching component oracle.nlsrtl.rsf, 12.1.0.2.0...

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

Patching component oracle.ctx.atg, 12.1.0.2.0...

Applying sub-patch '24006101' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'

Patching component oracle.sqlplus, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.network.listener, 12.1.0.2.0...

Patching component oracle.network.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.dv, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.sqlplus.ic, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Applying sub-patch '24732082' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'

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

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Applying sub-patch '25171037' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'

Patching component oracle.sqlplus.ic, 12.1.0.2.0...

Patching component oracle.sqlplus, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.ordim.client, 12.1.0.2.0...

Patching component oracle.ordim.client, 12.1.0.2.0...

Patching component oracle.ordim.jai, 12.1.0.2.0...

Patching component oracle.ordim.server, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

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

Patching component oracle.javavm.containers, 12.1.0.2.0...

Applying sub-patch '25755742' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'

ApplySession: Optional component(s) [ oracle.oid.client, 12.1.0.2.0 ] , [ oracle.has.crs, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.network.rsf, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.ldap.client, 12.1.0.2.0...

Patching component oracle.oracore.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.network.listener, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Applying sub-patch '26609783' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.oracore.rsf, 12.1.0.2.0...

Applying sub-patch '26713565' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'

ApplySession: Optional component(s) [ oracle.oid.client, 12.1.0.2.0 ] , [ oracle.has.crs, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.ldap.client, 12.1.0.2.0...

Patching component oracle.rdbms.crs, 12.1.0.2.0...

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.xdk, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

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

Patching component oracle.xdk.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Applying sub-patch '26925311' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'

Patching component oracle.network.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Applying sub-patch '27338041' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'

ApplySession: Optional component(s) [ oracle.assistants.asm, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.network.rsf, 12.1.0.2.0...

Patching component oracle.assistants.server, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.sqlplus.rsf, 12.1.0.2.0...

Applying sub-patch '27547329' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'

Patching component oracle.network.rsf, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.ctx.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.oracore.rsf, 12.1.0.2.0...

Patching component oracle.ctx, 12.1.0.2.0...

Patching component oracle.nlsrtl.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Applying sub-patch '28259833' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'

ApplySession: Optional component(s) [ oracle.has.crs, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.oracore.rsf, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms.crs, 12.1.0.2.0...

Applying sub-patch '28729169' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Applying sub-patch '29141015' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'

ApplySession: Optional component(s) [ oracle.has.crs, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.crs, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Applying sub-patch '29494060' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'

ApplySession: Optional component(s) [ oracle.has.crs, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.network.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.ctx, 12.1.0.2.0...

Patching component oracle.sqlplus.ic, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

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

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms.crs, 12.1.0.2.0...

Patching component oracle.oracore.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.sqlplus, 12.1.0.2.0...

Patching component oracle.ctx.rsf, 12.1.0.2.0...

OPatch found the word "error" in the stderr of the make command.

Please look at this stderr. You can re-run this make command.

Stderr output:

chmod: changing permissions of ‘/u01/app/oracle/product/12.1.0/dbhome_1/bin/extjobO’: Operation not permitted

make: [iextjob] Error 1 (ignored)

Composite patch 29494060 successfully applied.

OPatch Session completed with warnings.

Log file location: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-12-04_07-21-49AM_1.log

OPatch completed with warnings.

oracle@sgdcpl08:/u02/29494060>

Note :We can ignore above error, for further check with DOC ID

Applying Proactive Bundle / PSU Patch fails with Error: "chmod: changing permissions of `$ORACLE_HOME/bin/extjobO': Operation not permitted" (Doc ID 2265726.1)

#######################################################

• oracle@sgdcpl08:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> ./datapatch -verbose

SQL Patching tool version 12.1.0.2.0 Production on Wed Dec  4 07:34:00 2019

Copyright (c) 2012, 2016, Oracle.  All rights reserved.

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

Connecting to database...OK

Bootstrapping registry and package to current versions...done

Determining current state...done

Current state of SQL patches:

Bundle series PSU:

  ID 190716 in the binary registry and not installed in the SQL registry

Adding patches to installation queue and performing prereq checks...

Installation queue:

  Nothing to roll back

  The following patches will be applied:

    29494060 (DATABASE PATCH SET UPDATE 12.1.0.2.190716)

Installing patches...

Patch installation complete.  Total patches installed: 1

Validating logfiles...

Patch 29494060 apply: SUCCESS

  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/29494060/22993235/29494060_apply_SMRTESTE_2019Dec04_07_34_11.log (no errors)

SQL Patching tool complete on Wed Dec  4 07:34:42 2019

oracle@sgdcpl08:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch>

##############################################################

• oracle@sgdcpl08:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> ./opatch lsinventory

Oracle Interim Patch Installer version 12.2.0.1.17

Copyright (c) 2019, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc

OPatch version    : 12.2.0.1.17

OUI version       : 12.1.0.2.0

Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-12-04_07-36-26AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2019-12-04_07-36-26AM.txt

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

Local Machine Information::

Hostname: sgdcpl08.smr.motherson.com

ARU platform id: 226

ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c                                                  12.1.0.2.0

There are 1 products installed in this Oracle Home.

Interim patches (1) :

Patch  29494060     : applied on Wed Dec 04 07:23:21 CET 2019

Unique Patch ID:  22993235

Patch description:  "Database Patch Set Update : 12.1.0.2.190716 (29494060)"

   Created on 28 Jun 2019, 07:47:40 hrs PST8PDT

Sub-patch  29141015; "Database Patch Set Update : 12.1.0.2.190416 (29141015)"

Sub-patch  28729169; "Database Patch Set Update : 12.1.0.2.190115 (28729169)"

Sub-patch  28259833; "Database Patch Set Update : 12.1.0.2.181016 (28259833)"

Sub-patch  27547329; "Database Patch Set Update : 12.1.0.2.180717 (27547329)"

Sub-patch  27338041; "Database Patch Set Update : 12.1.0.2.180417 (27338041)"

Sub-patch  26925311; "Database Patch Set Update : 12.1.0.2.180116 (26925311)"

Sub-patch  26713565; "Database Patch Set Update : 12.1.0.2.171017 (26713565)"

Sub-patch  26609783; "Database Patch Set Update : 12.1.0.2.170814 (26609783)"

Sub-patch  25755742; "Database Patch Set Update : 12.1.0.2.170718 (25755742)"

Sub-patch  25171037; "Database Patch Set Update : 12.1.0.2.170418 (25171037)"

Sub-patch  24732082; "Database Patch Set Update : 12.1.0.2.170117 (24732082)"

Sub-patch  24006101; "Database Patch Set Update : 12.1.0.2.161018 (24006101)"

Sub-patch  23054246; "Database Patch Set Update : 12.1.0.2.160719 (23054246)"

Sub-patch  22291127; "Database Patch Set Update : 12.1.0.2.160419 (22291127)"

Sub-patch  21948354; "Database Patch Set Update : 12.1.0.2.160119 (21948354)"

Sub-patch  21359755; "Database Patch Set Update : 12.1.0.2.5 (21359755)"

Sub-patch  20831110; "Database Patch Set Update : 12.1.0.2.4 (20831110)"

Sub-patch  20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)"

Sub-patch  19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"

   Bugs fixed:

     19309466, 19902195, 18250893, 25437699, 19383839, 19781326, 16756406

     18456643, 26546664, 22364044, 18845653, 19915271, 20172151, 18417036

     19516448, 23713236, 24907917, 24796092, 23140259, 19243521, 19658708

     18272672, 21153266, 19174430, 22243719, 19548064, 26556014, 20493163

     20688221, 21387964, 13542050, 22250006, 22734547, 22243983, 21623164

     19012119, 19932634, 19869255, 22232606, 18681056, 23324000, 25427662

     22068305, 24589081, 19439759, 19303936, 22916353, 24835538, 22353346

     19790243, 21106027, 26444887, 23088803, 22529728, 26256131, 19134173

     24303148, 20447445, 21101873, 21188584, 19390567, 26513709, 25780343

     19769480, 21097043, 21225209, 26245237, 20677396, 19284031, 19450314

     19016730, 22517782, 20919320, 22205263, 22075064, 22551446, 22721409

     18440095, 22496904, 16439813, 18354830, 20596234, 22022760, 20936905

     23197103, 22515353, 21514877, 19809171, 21186167, 26111842, 18990023

     13787015, 22492533, 20173897, 24624166, 17210525, 21260431, 20181030

     25056052, 19370504, 21868720, 23068169, 19124589, 21383171, 19402853

     22690648, 19888853, 24341675, 17722075, 25107334, 20882568, 25653109

     23026585, 18604692, 20717081, 25546608, 27370965, 19081128, 20768076

     22173980, 25722055, 23514710, 19178851, 20951038, 22168163, 25161298

     20569094, 24308635, 19791377, 19050649, 20920911, 22475617, 19189525

     19469538, 27052607, 20598042, 22458049, 18988834, 21159665, 23302839

     25307368, 25699321, 17409174, 22729345, 22842151, 19238590, 25051465

     16941434, 20387265, 24397438, 29378913, 20673810, 23108128, 20356733

     22380919, 18436647, 23065323, 20825533, 19124336, 22294260, 24790914

     20284155, 23571055, 25539063, 17365043, 25914276, 20952966, 22961508

     19176223, 21300341, 23237313, 18288842, 27223075, 22353199, 20011515

     22083366, 27634991, 25670786, 21419850, 26898563, 27986817, 19577410

     26248143, 23294548, 23101501, 24737064, 19931709, 25423453, 25547060

     23533807, 27726780, 24600330, 25600421, 18122373, 20043616, 23124895

     18856999, 21450666, 18893947, 26633558, 20076781, 26029780, 21196809

     21354456, 22533631, 23725036, 20464614, 19562381, 27375542, 24808595

     19189317, 25669791, 18307021, 21917884, 19708632, 27213224, 25633101

     29006527, 20711718, 18973548, 25982666, 19718981, 23567857, 22826718

     25655390, 20684983, 21773465, 20250147, 20144019, 19197175, 26263721

     19597439, 21387128, 22007324, 19180770, 18818069, 21566639, 19879746

     21785691, 20424183, 24285405, 21425496, 26544823, 20322560, 22228324

     23172924, 22520320, 27751755, 21575362, 25058080, 22365117, 22645009

     25165496, 28950969, 18774543, 20124446, 21429602, 26153977, 29189889

     19371175, 21863727, 18940497, 19074147, 22923409, 25489342, 21380789

     19154375, 19044962, 25417056, 19532017, 19662635, 22374754, 20560611

     25654936, 21492036, 18705806, 28420042, 19578247, 22024071, 22238921

     22809871, 21184223, 19995869, 23089357, 19404068, 18921743, 19065677

     19018447, 19018206, 18308268, 19777862, 29027694, 22223463, 19304354

     22519146, 19445860, 26654363, 27199245, 22977256, 20890311, 27445727

     21142837, 20869721, 24555417, 22179537, 21756699, 20217801, 18819908

     22760595, 25483815, 23628685, 23007241, 19593445, 21080143, 27351628

     20582405, 24966594, 20031873, 25489367, 18618122, 24737581, 21698350

     26784509, 24739928, 18966843, 19077215, 20704450, 19068970, 20543011

     19023822, 24713381, 20432873, 21756677, 22836801, 20328248, 18674047

     18849537, 20087383, 25459958, 20315311, 22897344, 27534509, 25178179

     19308965, 18948177, 19468991, 20868862, 21780146, 23315153, 20466628

     21756661, 20397490, 19706965, 20302006, 24831514, 23240358, 22178855

     19032777, 20862087, 19329654, 18974476, 20603378, 20859910, 19307662

     26203182, 21847223, 20281121, 22568797, 19075256, 19076343, 18866977

     28026866, 29511611, 22808310, 25635149, 20844426, 20904530, 20441797

     21442094, 25079710, 24674955, 18840932, 18740837, 20294666, 25602488

     21517440, 22062517, 19180394, 27337759, 19174942, 20671094, 21889720

     19450116, 18411216, 20117253, 24386767, 20641666, 19931367, 25264559

     19930276, 22092979, 25616268, 21625179, 20879709, 23003979, 20165574

     28578164, 19272708, 19547370, 22624709, 23084507, 23184263, 20228093

     21281532, 25093872, 19805359, 26324206, 19461270, 19434529, 18799063

     20354900, 20378086, 29388020, 17008068, 21246723, 20831538, 20424899

     20361671, 18674024, 19689979, 24411921, 19873610, 16619249, 20562898

     21641414, 21091431, 19440586, 20001168, 22757364, 22175564, 20725343

     21241052, 19561643, 20736227, 19399918, 19195895, 20830459, 20017509

     18475439, 25790353, 21828126, 21665897, 25555252, 20746251, 22568177

     25764020, 25612095, 25357142, 23096938, 19067244, 18043064, 21329301

     18885870, 26243698, 26187943, 20324049, 19536415, 23709062, 28174827

     20446883, 27314206, 21299490, 25313154, 18628388, 21744290, 18254023

     25047724, 20591183, 27847259, 19185876, 18548433, 27207110, 22465352

     24385625, 24326444, 20402832, 19627012, 29200700, 20468401, 27441326

     27620950, 16863642, 19639483, 19315691, 27567477, 21479753, 19174521

     23177923, 20401975, 18306996, 18851894, 27034890, 20581111, 20318889

     20936731, 21060755, 25240188, 26828994, 22256560, 19188927, 23328639

     27229389, 20766180, 20229001, 24570598, 25475853, 21172913, 17655240

     21266085, 19028800, 29379978, 19035573, 19366375, 24523374, 25599425

     25034396, 19289642, 21502702, 21291274, 18007682, 23521523, 20475845

     29408136, 22148226, 22528741, 25417958, 24652769, 26088426, 19326908

     19597583, 17414008, 23019710, 20897759, 26822620, 22046677, 19663176

     20938170, 19891090, 24825843, 26318627, 21960504, 24509056, 19054077

     26262953, 22657942, 20428621, 21899588, 23326313, 19723336, 19835133

     17532734, 25300427, 19333670, 17495022, 21842017, 19285025, 21373473

     23260854, 23061453, 19687159, 14643995, 20977794, 20734332, 17551063

     27548131, 21977392, 24461826, 28612674, 19676012, 20588502, 23315889

     19520602, 23053606, 19841800, 20245930, 19001359, 21476308, 26546754

     19393542, 23533524, 21099555, 27995248, 25429959, 19141838, 19644859

     21915719, 19908836, 21421886, 19358317, 19524158, 23548817, 25861398

     20803014, 23025340, 19335438, 19058490, 23642282, 19207117, 18799993

     25919622, 26569225, 25986062, 20835241, 24662775, 19475971, 18967382

     20347562, 20348653, 19896336, 24812585, 20048359, 21896069, 20468490

     19524384, 25392535, 21147908, 21695575, 20440930, 25789277, 19171086

     24718260, 17867700, 19791273, 27397048, 21241829, 19591608, 22707244

     18419520, 22296366, 22654475, 18914624, 19571367, 28636676, 21522582

     19501299, 26007010, 19529868, 20425790, 19708342, 27997875, 16870214

     18202441, 24415926, 18743542, 19001390, 21157728, 20657411, 19332396

     21875360, 22606521, 25091141, 28000269, 19149990, 20382309, 22855193

     16777441, 19606174, 20848335, 25495682, 19382851, 20528052, 22762046

     24563422, 23125826, 22503297, 28993590, 25192729, 23338911, 22730454

     19354794, 20757079, 19176326, 20298413, 19048007, 22018363, 18849970

     21532755, 20860659, 22905130, 26121990, 21263635, 27710072, 22160989

     23209741, 18499088, 22894949, 21059919, 18952989, 27348081, 22518784

     25856821, 24457597, 25484507, 20794034, 21061354, 20554364, 19468347

     17533661, 19883092, 20657441, 24401351, 21285458, 28023399, 18051556

     25330273, 26412540, 19699191, 24437510, 16875041, 20669434, 18964978

     22972770, 20828947, 21373076, 25492379, 25551676, 14283239, 25766822

     21967197, 22922076, 25575628, 19601762, 26110259, 20368850, 21239530

     20437153, 24848928, 20880215, 20798891, 25606091, 19013183, 25042823

     21133343, 22695831, 24365589, 25248384, 25634317, 20134113, 19587324

     20273319, 28501075, 18542562, 19017309, 26758193, 21063322, 22062026

     20134339, 22077517, 22815955, 23854396, 24690216, 22507210, 16354467

     20101006, 21795111, 27938623, 23501901, 18797519, 25997810, 25879984

     21260397, 25029423, 19354335, 19730508, 22366558, 26658759, 25822410

     6599380, 20717359, 24321547, 27097854, 21297872, 18964939, 19871910

     29437712, 26366517, 21913183, 22366322, 20171986, 25695903, 20603431

     21132297, 25957038, 21542577, 22507234, 23170620, 24719736, 25600342

     18868646, 28587723, 29142109, 26637824, 20627866, 18110491, 16923858

     24642295, 19518079, 19339555, 20466322, 25823754, 25110233, 20169408

     24908321, 20842388, 17274537, 26575788, 20474192, 21644640, 28849751

     21794615, 18899974, 20471920, 22806698, 19052488, 26198757, 19503821

     24350620, 20074391, 19157754, 21220620, 22495062, 24316947, 19865345

     19065556, 22816287, 25947799, 20878790, 23492665, 21322887, 22305887

     20879889, 24350831, 19578350, 28022101, 26439748, 21893235, 19363645

     21072646, 20898391, 19291380, 27060167, 18382302, 27086138, 22536802

     22087683, 21197626, 21656630, 20373598, 19248799, 22707866, 28432129

     19155797, 19279273, 18886413, 25490238, 20922010, 19990037, 25150925

     20509482, 27255377, 24717859, 20703000, 22862134, 21526048, 28683167

     24929210, 24560906, 20144308, 21620471, 19670108, 19068610, 20267166

     25123585, 20476175, 18549238, 19297917, 22950945, 19385656, 23528412

     19684504, 19330795, 21174504, 28357401, 20899461, 20557786, 21911701

     19143550, 20118035, 19024808, 25760195, 20009833, 19604659, 16359751

     26039623, 22820579, 19928926, 23314180, 20212067, 24737403, 20480209

     18904062, 29030780, 26430737, 20856766, 17258582, 27169796, 21668627

     20877664, 23272045, 19487147, 23149541, 24577566, 19430401, 19676905

     20925795, 26482376, 21296029, 21629064, 23229229, 22865673, 20708701

     25353983, 19280225, 21315084, 20613079, 19375649, 19213447, 19989009

     18191823, 27314390, 26336977, 25775213, 24393981, 25639019, 17319928

     14705949, 19703301, 28390273, 21626377, 20122715, 6418158, 23105538

     26198926, 19258504, 21188532, 23151677, 24792678, 17890099, 21649497

     26446098, 16887946, 26024732, 18791688, 19721304, 27012701, 19490948

     19619732, 21164318, 23148260, 18090142, 21641760, 19818513, 23002524

     20139391, 24693382, 19978542, 23543183, 22165897, 19373893, 22359063

     19409212, 18373438, 23035249, 20677974, 18990693, 20470877, 21422580

     21632821, 22351572, 20235511, 23220453, 18742258, 18604493, 23008056

     22901797, 18610915, 20978259, 20832516, 24801152, 26089440, 20907061

     19523462, 20505778, 19183343, 21787056, 21273804, 22782647, 25093739

     17835294, 28708023, 24413809, 27846298, 18371441, 26714910, 24385983

     20413820, 24421668, 28986231, 25897615, 25643931, 23195445, 21281607

     20513399, 20558005, 20093776, 18909599, 20618595, 23572982, 19211433

     20331945, 19512341, 22256431, 19637186, 19022470, 18607546, 26875822

     24573817, 23115139, 19649152, 19201867, 21294938, 20898997, 18510194

     21842740, 22454326, 24683149, 19534363, 25489607, 23061702

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

OPatch succeeded.

oracle@sgdcpl08:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch>

oracle@sgdcpl08:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch> ./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 Production on Thu Jan  9 09:05:14 2020
Copyright (c) 2012, 2016, Oracle.  All rights reserved.

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

Connecting to database...OK
Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of SQL patches:
Bundle series PSU:
  ID 190716 in the binary registry and not installed in the SQL registry

Adding patches to installation queue and performing prereq checks...
Installation queue:
  Nothing to roll back
  The following patches will be applied:
    29494060 (DATABASE PATCH SET UPDATE 12.1.0.2.190716)

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

Validating logfiles...
Patch 29494060 apply: SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/29494060/22993235/29494060_apply_SMRPATCH_2020Jan09_09_13_16.log (no errors)
SQL Patching tool complete on Thu Jan  9 09:13:45 2020

• select * from sys.registry$history;

• SQL> select patch_id,status,action,description from dba_registry_sqlpatch;

  PATCH_ID STATUS          ACTION          DESCRIPTION

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

  29494060 SUCCESS         APPLY           DATABASE PATCH SET UPDATE 12.1.0.2.190716

RMAN 12c error :RMAN-00554,RMAN-03000,RMAN-06001,RMAN-01009,RMAN-01008,RMAN-01007

Scenario Preview:

RMAN-00554: initialization of internal recovery manager package failed
RMAN-03000: recovery manager compiler component initialization failed
RMAN-06001: error parsing job step library
RMAN-01009: syntax error: found "identifier": expecting one of: ""
RMAN-01008: the bad identifier was: baschemaversion
RMAN-01007: at line 17 column 1 file: ?/rdbms/admin/recover.bsq


Solution: Provide correct path in .bash_profile 

/u01/app/oracle/product/12.1.0/dbhome_2/bin/rman

oracle@sgdcplm01:~> rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Wed Dec 4 11:21:15 2019

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-03000: recovery manager compiler component initialization failed
RMAN-06001: error parsing job step library
RMAN-01009: syntax error: found "identifier": expecting one of: ""
RMAN-01008: the bad identifier was: baschemaversion
RMAN-01007: at line 17 column 1 file: ?/rdbms/admin/recover.bsq

oracle@sgdcplm01:~> /u01/app/oracle/product/12.1.0/dbhome_2/bin/rman target sys/xxxxx@pretaf

Recovery Manager: Release 12.1.0.2.0 - Production on Wed Dec 4 11:22:37 2019

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to target database: SMRRAC (DBID=4255065810)

RMAN>