Search This Blog

Total Pageviews

Friday, 13 December 2024

How to Deinstall Old Clusterware Home Once Upgrade to Newer Version is Complete







How to Deinstall Old Clusterware Home Once Upgrade to Newer Version is Complete (Doc ID 1346305.1)


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

[grid@oragrid ContentsXML]$ pwd
/u01/app/oraInventory/ContentsXML
[grid@oragrid ContentsXML]$ cat inventory.xml





   12.2.0.9.0
   2.1.0.6.0








[grid@oragrid ContentsXML]$


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


export OLD_HOME=/u01/app/19.2.0/grid
export ORACLE_HOME=$OLD_HOME

[grid@oragrid ~]$ echo $ORACLE_HOME
/u01/app/19.2.0/grid

[grid@oragrid ~]$ $OLD_HOME/oui/bin/runInstaller -detachHome -silent ORACLE_HOME=$OLD_HOME
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 6759 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
You can find the log of this install session at:
 /u01/app/oraInventory/logs/DetachHome2024-12-13_12-30-06PM.log
'DetachHome' was successful.



[grid@oragrid ContentsXML]$ cat /u01/app/oraInventory/ContentsXML/inventory.xml





   12.2.0.7.0
   2.1.0.6.0



      <<<< now we are good 







[grid@oragrid ContentsXML]$


$NEW_HOME/OPatch/opatch lsinventory -all  


/u01/app/21.3.0/grid/OPatch/opatch lsinventory -all


/u01/app/21.3.0/grid/OPatch/opatch lsinventory -all
Oracle Interim Patch Installer version 12.2.0.1.26
Copyright (c) 2024, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/19.2.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/19.2.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.26
OUI version       : 12.2.0.7.0
Log file location : /u01/app/19.2.0/grid/cfgtoollogs/opatch/opatch2024-12-13_12-34-42PM_1.log

List of Homes on this system:

  Home name= OraGI21Home1, Location= "/u01/app/21.3.0/grid"
LsInventorySession failed: RawInventory gets null OracleHomeInfo

OPatch failed with error code 73
[grid@oragrid ContentsXML]$



[root@oragrid ~]# export OLD_HOME=/u01/app/19.2.0/grid
[root@oragrid ~]# rm -rf $OLD_HOME
[root@oragrid ~]# ls -ltr /u01/app/19.2.0/grid


Upgrading Oracle Restart from 19c to 21c on centos 8.5



 

Upgrading Oracle Restart from 19c to 21c on centos 8.5 

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


To check resource

crsctl status res | awk -F= '/NAME=/{n=$2}/TYPE=/{t=$2}/TARGET=/{g=$2}/STATE=/{s=$2; printf("%-60s%-30s%-10s%-30s\n", n,t,g,s)}'

 

ora.DATA.dg                                                 ora.diskgroup.type            ONLINE    ONLINE on oragrid

ora.LISTENER.lsnr                                           ora.listener.type             ONLINE    ONLINE on oragrid

ora.asm                                                     ora.asm.type                  ONLINE    ONLINE on oragrid

ora.cssd                                                    ora.cssd.type                 ONLINE    ONLINE on oragrid

ora.diskmon                                                 ora.diskmon.type              OFFLINE   OFFLINE

ora.evmd                                                    ora.evm.type                  ONLINE    ONLINE on oragrid

ora.ons                                                     ora.ons.type                  OFFLINE   OFFLINE

 

[grid@oragrid ~]$ crsctl query has releaseversion

Oracle High Availability Services release version on the local node is [19.0.0.0.0]

 

[grid@oragrid ~]$ crsctl query has softwareversion

Oracle High Availability Services version on the local node is [19.0.0.0.0]

[grid@oragrid ~]$

 

Download

 

LINUX.X64_213000_grid_home.zip

 

mkdir -p /u01/app/21.3.0/grid

 

[grid@oragrid ~]$ cd /u01/app/21.3.0/grid/

[grid@oragrid grid]$ pwd

/u01/app/21.3.0/grid

[grid@oragrid grid]$ unzip -oq /home/grid/LINUX.X64_213000_grid_home.zip

 

 ./runcluvfy.sh stage -pre hacfg

 

This standalone version of CVU is "1253" days old. The latest release of standalone CVU can be obtained from the Oracle support site. Refer to MOS note 2731675.1 for more details.

 

Performing following verification checks ...

 

  Physical Memory ...FAILED (PRVF-7530)

  Available Physical Memory ...PASSED

  Swap Size ...PASSED

  Free Space: oragrid:/usr,oragrid:/var,oragrid:/etc,oragrid:/sbin,oragrid:/tmp ...PASSED

  User Existence: grid ...

    Users With Same UID: 1100 ...PASSED

  User Existence: grid ...PASSED

  Group Existence: dba ...PASSED

  Group Existence: oinstall ...PASSED

  Group Membership: dba ...FAILED (PRVG-10460)

  Group Membership: oinstall(Primary) ...PASSED

  Run Level ...PASSED

  Architecture ...PASSED

  OS Kernel Version ...PASSED

  OS Kernel Parameter: semmsl ...PASSED

  OS Kernel Parameter: semmns ...PASSED

  OS Kernel Parameter: semopm ...PASSED

  OS Kernel Parameter: semmni ...PASSED

  OS Kernel Parameter: shmmax ...PASSED

  OS Kernel Parameter: shmmni ...PASSED

  OS Kernel Parameter: shmall ...PASSED

  OS Kernel Parameter: file-max ...PASSED

  OS Kernel Parameter: ip_local_port_range ...PASSED

  OS Kernel Parameter: rmem_default ...PASSED

  OS Kernel Parameter: rmem_max ...PASSED

  OS Kernel Parameter: wmem_default ...PASSED

  OS Kernel Parameter: wmem_max ...PASSED

  OS Kernel Parameter: aio-max-nr ...PASSED

  OS Kernel Parameter: panic_on_oops ...PASSED

  Package: kmod-20-21 (x86_64) ...PASSED

  Package: kmod-libs-20-21 (x86_64) ...PASSED

  Package: binutils-2.30-49.0.2 ...PASSED

  Package: libgcc-8.2.1 (x86_64) ...PASSED

  Package: libstdc++-8.2.1 (x86_64) ...PASSED

  Package: sysstat-10.1.5 ...PASSED

  Package: ksh ...PASSED

  Package: make-4.2.1 ...PASSED

  Package: glibc-2.28 (x86_64) ...PASSED

  Package: glibc-devel-2.28 (x86_64) ...PASSED

  Package: libaio-0.3.110 (x86_64) ...PASSED

  Package: nfs-utils-2.3.3-14 ...PASSED

  Package: smartmontools-6.6-3 ...PASSED

  Package: net-tools-2.0-0.51 ...PASSED

  Package: policycoreutils-2.9-3 ...PASSED

  Package: policycoreutils-python-utils-2.9-3 ...PASSED

  Users With Same UID: 0 ...PASSED

  Current Group ID ...PASSED

  Root user consistency ...PASSED

 

Pre-check for Oracle Restart configuration was unsuccessful.

 

 

Failures were encountered during execution of CVU verification request "stage -pre hacfg".

 

Physical Memory ...FAILED

oragrid: PRVF-7530 : Sufficient physical memory is not available on node

         "oragrid" [Required physical memory = 8GB (8388608.0KB)]

 

Group Membership: dba ...FAILED

oragrid: PRVG-10460 : User "grid" does not belong to group "dba" selected for

         privileges "OSDBA" on node "oragrid".

 

 

CVU operation performed:      stage -pre hacfg

Date:                         12-Dec-2024 13:06:32

CVU home:                     /u01/app/21.3.0/grid

Grid home:                    /u01/app/19.2.0/grid

User:                         grid

Operating system:             Linux4.18.0-348.7.1.el8_5.x86_64

[grid@oragrid grid]$

 

 

 

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

 

 

oragrid: PRVG-10460 : User "grid" does not belong to group "dba" selected for  privileges "OSDBA" on node "oragrid".

 

 

 cat /etc/group|grep -i grid

dba:x:54322:grid  <<<<<--- add grid into dba group

asmdba:x:54327:grid

asmoper:x:54328:grid

asmadmin:x:54329:grid

 

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

 

 

 

./runcluvfy.sh stage -pre hacfg

This standalone version of CVU is "1253" days old. The latest release of standalone CVU can be obtained from the Oracle support site. Refer to MOS note 2731675.1 for more details.

 

Performing following verification checks ...

 

  Physical Memory ...FAILED (PRVF-7530)

  Available Physical Memory ...PASSED

  Swap Size ...PASSED

  Free Space: oragrid:/usr,oragrid:/var,oragrid:/etc,oragrid:/sbin,oragrid:/tmp ...PASSED

  User Existence: grid ...

    Users With Same UID: 1100 ...PASSED

  User Existence: grid ...PASSED

  Group Existence: dba ...PASSED

  Group Existence: oinstall ...PASSED

  Group Membership: dba ...PASSED

  Group Membership: oinstall(Primary) ...PASSED

  Run Level ...PASSED

  Architecture ...PASSED

  OS Kernel Version ...PASSED

  OS Kernel Parameter: semmsl ...PASSED

  OS Kernel Parameter: semmns ...PASSED

  OS Kernel Parameter: semopm ...PASSED

  OS Kernel Parameter: semmni ...PASSED

  OS Kernel Parameter: shmmax ...PASSED

  OS Kernel Parameter: shmmni ...PASSED

  OS Kernel Parameter: shmall ...PASSED

  OS Kernel Parameter: file-max ...PASSED

  OS Kernel Parameter: ip_local_port_range ...PASSED

  OS Kernel Parameter: rmem_default ...PASSED

  OS Kernel Parameter: rmem_max ...PASSED

  OS Kernel Parameter: wmem_default ...PASSED

  OS Kernel Parameter: wmem_max ...PASSED

  OS Kernel Parameter: aio-max-nr ...PASSED

  OS Kernel Parameter: panic_on_oops ...PASSED

  Package: kmod-20-21 (x86_64) ...PASSED

  Package: kmod-libs-20-21 (x86_64) ...PASSED

  Package: binutils-2.30-49.0.2 ...PASSED

  Package: libgcc-8.2.1 (x86_64) ...PASSED

  Package: libstdc++-8.2.1 (x86_64) ...PASSED

  Package: sysstat-10.1.5 ...PASSED

  Package: ksh ...PASSED

  Package: make-4.2.1 ...PASSED

  Package: glibc-2.28 (x86_64) ...PASSED

  Package: glibc-devel-2.28 (x86_64) ...PASSED

  Package: libaio-0.3.110 (x86_64) ...PASSED

  Package: nfs-utils-2.3.3-14 ...PASSED

  Package: smartmontools-6.6-3 ...PASSED

  Package: net-tools-2.0-0.51 ...PASSED

  Package: policycoreutils-2.9-3 ...PASSED

  Package: policycoreutils-python-utils-2.9-3 ...PASSED

  Users With Same UID: 0 ...PASSED

  Current Group ID ...PASSED

  Root user consistency ...PASSED

 

Pre-check for Oracle Restart configuration was unsuccessful.

 

 

Failures were encountered during execution of CVU verification request "stage -pre hacfg".

 

Physical Memory ...FAILED

oragrid: PRVF-7530 : Sufficient physical memory is not available on node

         "oragrid" [Required physical memory = 8GB (8388608.0KB)]

 

 

CVU operation performed:      stage -pre hacfg

Date:                         12-Dec-2024 13:24:10

CVU home:                     /u01/app/21.3.0/grid

Grid home:                    /u01/app/19.2.0/grid

User:                         grid

Operating system:             Linux4.18.0-348.7.1.el8_5.x86_64

[grid@oragrid grid]$

 

 

 

 

unset ORACLE_HOME

unset ORACLE_BASE

unset ORACLE_SID

 

[grid@oragrid grid]$ export CV_ASSUME_DISTID=OEL7.8

[grid@oragrid grid]$ ./gridSetup.sh &

[1] 11065

[grid@oragrid grid]$ ERROR: Unable to verify the graphical display setup. This application requires X display. Make sure that xdpyinfo exist under PATH variable.

Launching Oracle Grid Infrastructure Setup Wizard...

 

The response file for this session can be found at:

 /u01/app/21.3.0/grid/install/response/grid_2024-12-12_03-04-14PM.rsp

 

You can find the log of this install session at:

 /u01/app/oraInventory/logs/GridSetupActions2024-12-12_03-04-14PM/gridSetupActions2024-12-12_03-04-14PM.log

 

 

 

 

[root@oragrid ~]# /u01/app/21.3.0/grid/rootupgrade.sh

Performing root user operation.

 

The following environment variables are set as:

    ORACLE_OWNER= grid

    ORACLE_HOME=  /u01/app/21.3.0/grid

 

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of "dbhome" have not changed. No need to overwrite.

The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)

[n]: y

   Copying oraenv to /usr/local/bin ...

The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)

[n]: y

   Copying coraenv to /usr/local/bin ...

 

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Using configuration parameter file: /u01/app/21.3.0/grid/crs/install/crsconfig_params

The log of current session can be found at:

  /u01/app/grid/crsdata/oragrid/crsconfig/roothas_2024-12-12_03-17-27PM.log

2024/12/12 15:17:30 CLSRSC-595: Executing upgrade step 1 of 12: 'UpgPrechecks'.

2024/12/12 15:17:36 CLSRSC-595: Executing upgrade step 2 of 12: 'GetOldConfig'.

2024/12/12 15:17:40 CLSRSC-595: Executing upgrade step 3 of 12: 'GenSiteGUIDs'.

2024/12/12 15:17:40 CLSRSC-595: Executing upgrade step 4 of 12: 'SetupOSD'.

Redirecting to /bin/systemctl restart rsyslog.service

2024/12/12 15:17:41 CLSRSC-595: Executing upgrade step 5 of 12: 'PreUpgrade'.

2024/12/12 15:18:18 CLSRSC-595: Executing upgrade step 6 of 12: 'UpgradeAFD'.

2024/12/12 15:18:18 CLSRSC-595: Executing upgrade step 7 of 12: 'UpgradeOLR'.

clscfg: EXISTING configuration version 0 detected.

Creating OCR keys for user 'grid', privgrp 'oinstall'..

Operation successful.

2024/12/12 15:18:23 CLSRSC-595: Executing upgrade step 8 of 12: 'UpgradeOCR'.

LOCAL ONLY MODE

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

CRS-4664: Node oragrid successfully pinned.

2024/12/12 15:18:27 CLSRSC-595: Executing upgrade step 9 of 12: 'CreateOHASD'.

2024/12/12 15:18:29 CLSRSC-595: Executing upgrade step 10 of 12: 'ConfigOHASD'.

2024/12/12 15:18:29 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'

2024/12/12 15:18:48 CLSRSC-595: Executing upgrade step 11 of 12: 'UpgradeSIHA'.

 

oragrid     2024/12/12 15:19:45     /u01/app/grid/crsdata/oragrid/olr/backup_20241212_151945.olr     0

 

oragrid     2024/12/10 15:51:48     /u01/app/grid/crsdata/oragrid/olr/backup_20241210_155148.olr     724960844

2024/12/12 15:19:45 CLSRSC-595: Executing upgrade step 12 of 12: 'InstallACFS'.

2024/12/12 15:20:51 CLSRSC-327: Successfully configured Oracle Restart for a standalone server

[root@oragrid ~]#

 

 

 

[grid@oragrid grid]$ crsctl query has releaseversion

Oracle High Availability Services release version on the local node is [21.0.0.0.0]

[grid@oragrid grid]$ crsctl query has softwareversion

Oracle High Availability Services version on the local node is [21.0.0.0.0]

[grid@oragrid grid]$

 

 

[grid@oragrid grid]$ $ORACLE_HOME/OPatch/opatch lspatches

There are no Interim patches installed in this Oracle Home "/u01/app/21.3.0/grid".

 

OPatch succeeded.

[grid@oragrid grid]$

 

====

 

[1]+  Done                    ./gridSetup.sh

[grid@oragrid grid]$

 

 

 

[grid@oragrid grid]$ cluvfy stage -post hacfg

This standalone version of CVU is "1253" days old. The latest release of standalone CVU can be obtained from the Oracle support site. Refer to MOS note 2731675.1 for more details.

 

Performing following verification checks ...

 

  Oracle Restart Integrity ...PASSED

  OLR Integrity ...PASSED

 

Post-check for Oracle Restart configuration was successful.

 

CVU operation performed:      stage -post hacfg

Date:                         12-Dec-2024 15:28:01

CVU home:                     /u01/app/21.3.0/grid

Grid home:                    /u01/app/21.3.0/grid

User:                         grid

Operating system:             Linux4.18.0-348.7.1.el8_5.x86_64

[grid@oragrid grid]$

  

 





























[root@oragrid ~]# /u01/app/21.3.0/grid/rootupgrade.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/21.3.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/21.3.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/grid/crsdata/oragrid/crsconfig/roothas_2024-12-12_03-17-27PM.log
2024/12/12 15:17:30 CLSRSC-595: Executing upgrade step 1 of 12: 'UpgPrechecks'.
2024/12/12 15:17:36 CLSRSC-595: Executing upgrade step 2 of 12: 'GetOldConfig'.
2024/12/12 15:17:40 CLSRSC-595: Executing upgrade step 3 of 12: 'GenSiteGUIDs'.
2024/12/12 15:17:40 CLSRSC-595: Executing upgrade step 4 of 12: 'SetupOSD'.
Redirecting to /bin/systemctl restart rsyslog.service
2024/12/12 15:17:41 CLSRSC-595: Executing upgrade step 5 of 12: 'PreUpgrade'.
2024/12/12 15:18:18 CLSRSC-595: Executing upgrade step 6 of 12: 'UpgradeAFD'.
2024/12/12 15:18:18 CLSRSC-595: Executing upgrade step 7 of 12: 'UpgradeOLR'.
clscfg: EXISTING configuration version 0 detected.
Creating OCR keys for user 'grid', privgrp 'oinstall'..
Operation successful.
2024/12/12 15:18:23 CLSRSC-595: Executing upgrade step 8 of 12: 'UpgradeOCR'.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node oragrid successfully pinned.
2024/12/12 15:18:27 CLSRSC-595: Executing upgrade step 9 of 12: 'CreateOHASD'.
2024/12/12 15:18:29 CLSRSC-595: Executing upgrade step 10 of 12: 'ConfigOHASD'.
2024/12/12 15:18:29 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'
2024/12/12 15:18:48 CLSRSC-595: Executing upgrade step 11 of 12: 'UpgradeSIHA'.

oragrid     2024/12/12 15:19:45     /u01/app/grid/crsdata/oragrid/olr/backup_20241212_151945.olr     0

oragrid     2024/12/10 15:51:48     /u01/app/grid/crsdata/oragrid/olr/backup_20241210_155148.olr     724960844
2024/12/12 15:19:45 CLSRSC-595: Executing upgrade step 12 of 12: 'InstallACFS'.
2024/12/12 15:20:51 CLSRSC-327: Successfully configured Oracle Restart for a standalone server
[root@oragrid ~]#








[grid@oragrid grid]$ crsctl query has releaseversion
Oracle High Availability Services release version on the local node is [21.0.0.0.0]
[grid@oragrid grid]$ crsctl query has softwareversion
Oracle High Availability Services version on the local node is [21.0.0.0.0]
[grid@oragrid grid]$



[grid@oragrid grid]$ cluvfy stage -post hacfg
This standalone version of CVU is "1253" days old. The latest release of standalone CVU can be obtained from the Oracle support site. Refer to MOS note 2731675.1 for more details.

Performing following verification checks ...

  Oracle Restart Integrity ...PASSED
  OLR Integrity ...PASSED

Post-check for Oracle Restart configuration was successful.

CVU operation performed:      stage -post hacfg
Date:                         12-Dec-2024 15:28:01
CVU home:                     /u01/app/21.3.0/grid
Grid home:                    /u01/app/21.3.0/grid
User:                         grid
Operating system:             Linux4.18.0-348.7.1.el8_5.x86_64
[grid@oragrid grid]$





Oracle GI and DB to 19c or downgrading to previous release (Doc ID 2539751.1)



Patches to apply before upgrading Oracle GI and DB to 19c or downgrading to previous release (Doc ID 2539751.1)

GI Upgrade to 19c

From Release

Bug#(s)

Patch

Description

Additional comments

18c

28553832

28553832

LNX-191-EXA:CSSD PROCESS CANNOT GET REAL-TIME PRIORITY

p28553832_183000OCWRU_<platform>.zip

12.2.0.1.0

28553832

28553832

LNX-191-EXA:CSSD PROCESS CANNOT GET REAL-TIME PRIORITY

p28553832_12201190115OCWJAN2019RU_<platform>.zip

12.1.0.2

 

21255373

 

 

Recommended to install latest 12.1.0.2 GI PSU

28553832

28553832

LNX-191-EXA:CSSD PROCESS CANNOT GET REAL-TIME PRIORITY

p28553832_12102190115forOCW_<platform>.zip

11.2.0.4

17617807

21255373

GI PSU 22646198

11.2.0.4.160419 (Apr 2016) Grid Infrastructure Patch Set Update (GI PSU)

Recommended to install latest* 11.2.0.4 GI PSU

28553832

28553832

LNX-191-EXA:CSSD PROCESS CANNOT GET REAL-TIME PRIORITY

p28553832_11204190115forOCW_<platform>.zip

DB Upgrades to 19c

Note: following patches needed if you have GI Setup

From Release

Bug#(s)

Patch

Description

Additional comments

18c

28553832

28553832

LNX-191-EXA:CSSD PROCESS CANNOT GET REAL-TIME PRIORITY

p28553832_183000OCWRU_<platform>.zip

12.2.0.1.0

28553832

28553832

LNX-191-EXA:CSSD PROCESS CANNOT GET REAL-TIME PRIORITY

p28553832_12201190115OCWJAN2019RU_<platform>.zip

12.1.0.2

 

21255373

 

 

28553832

28553832

LNX-191-EXA:CSSD PROCESS CANNOT GET REAL-TIME PRIORITY

p28553832_12102190115forOCW_<platform>.zip

11.2.0.4

17617807

21255373

GI PSU 22646198

11.2.0.4.160419 (Apr 2016) Grid Infrastructure Patch Set Update (GI PSU)

28553832

28553832

LNX-191-EXA:CSSD PROCESS CANNOT GET REAL-TIME PRIORITY

p28553832_11204190115forOCW_<platform>.zip

Managing older database with 19c ASM

With Release

Bug#(s)

Patch

Description

Additional comments

18c DB

None

None

None

None

12.2.0.1 DB

None

None

None

None

12.1.0.2 DB

 

21626377

21626377

12.2_150812: DBCA FAILS TO CREATE 12102 DB OVER 12.2 GI/ASM

Install 12.1.0.2.170718 DB PSU or later

Install 12.1.0.2.170117 DB Proactive BP or later

 

21780146

21780146

LNX64-12.2-WLM: MGMTDB FAILED TO BE CREATED DURING POST GI INSTALLATION

11.2.0.4 DB

23519414

23186035

W2K12_122_CMP: CREATE 11204DB WITH 122 ENV AFTER 1120419DBBP HIT ORA-00955

 11.2.0.4.190416 (Apr 2019) GI PSU or later

DB Downgrades from 19c

To Release

Bug#(s)

Patch

Description

Additional comments

18c (CDB, non-CDB, PDB unplug/plug/upgrade/downgrade/unplug/plug/catrelod)

28655784

28655784

Oct 2018 Database Release Update 18.4.0.0.0 or later

Install latest RU

12.2.0.1 (CDB)

28822515

 28822515

Jan 2019 Database Release Update 12.2.0.1.190115 or later 

 Install latest RU

12.1.0.2 (with CDB)

28259833

28259833

Oct 2018 Database Patch Set Update 12.1.0.2.181016 or later

Install latest* DB PSU patch

24438034

24438034

CDB_UPG: 12101 CDB UPGRADE LEFT OBJECT CDB_JAVA_POLICY INVALID

Available on top of 12.1.0.2.170418

20348910

20348910

ALTER TYPE REPLACE IN PRVTAQJI.SQL TO BE REPLACE WITH CREATE OR REPLACE TYPE

Available on top of 12.1.0.2

Available on top of 12.1.0.2.7 Proactive BP

20958816

20958816

INVALID OBJECTS AFTER DOWNGRADE FROM 12.2.0.1 TO 12.1.0.2

Install 12.1.0.2.160719 Proactive BP or later

12.1.0.2.0 (PDB unplug/plug/upgrade/downgrade/unplug/plug/catrelod)

 25869760

 26022196

 Database Proactive Bundle Patch 12.1.0.2.170718 or later

 

19370504

19370504

CDB:ORA-13613 IN NONCDB 12102 UPGRADED APPS DB PLUGIN AS PDB

12.1.0.2.180116 (Jan 2018) Database PSU or later
12.1.0.2.180116 (Jan 2018) Database Proactive BP or later

21388707

21388707

LNX64-12C-UD:ENABLE LOCAL UNDO, PLUG 12.1 NONCDB INTO 12.2CDB FAILED

Available on top of 12.1.0.2.170718 ProactiveBP

27189168

27189168

CATRELOD.SQL HIT ORA-65033 DURING PLUGGABLE DATABASE DOWNGRADE FROM 18C TO 12102

Available on top of 12.1.0.2.170718 ProactiveBP

12.1.0.2(non-CDB)

28259833

28259833

Oct. 2018 DATABASE PATCH SET UPDATE 12.1.0.2.181016

Install latest DB PSU patch

24438034

24438034

CDB_UPG: 12101 CDB UPGRADE LEFT OBJECT CDB_JAVA_POLICY INVALID

Available on top of 12.1.0.2.160719 DB PSU

Available on top of12.1.0.2.170418 DB PSU

Available on top of 12.1.0.2.160719 Proactive BP

20348910

20348910

ALTER TYPE REPLACE IN PRVTAQJI.SQL TO BE REPLACE WITH CREATE OR REPLACE TYPE

Available on top of 12.1.0.2

Available on top of 12.1.0.2.160719 Proactive BP

20958816

20958816

INVALID OBJECTS AFTER DOWNGRADE FROM 12.2.0.1 TO 12.1.0.2

Install 12.1.0.2.160719 Proactive BP or later

 

 

 

 

 

11.2.0.4

28204707

28204707

 Oct. 2018 DB PSU 11.2.0.4.181016

Install latest DB PSU

20898997

20898997

XMLTYPESUP: QCTOXSNLB SHOULD NOT CHECK AGAINST SNAPSHOT SIZE

On top of 11.2.0.4

20348910

20348910

ALTER TYPE REPLACE IN PRVTAQJI.SQL TO BE REPLACE WITH CREATE OR REPLACE TYPE

Available for 11.2.0.4

 

GI Downgrades from 19c

To 12.2.0.1

None

N/A

N/A

 

No additional patches required to downgrade GI (Downgraded to the level using the same GIPSUs they were upgraded from). More patch info is mentioned in the GI upgrade category

 

 

To 12.1.0.2

None

N/A

N/A

To 12.1.0.1

None

N/A

N/A

To 11.2.0.4

None

N/A

N/A

 

Solaris Sparc 64 bit

GI Upgrade to 19c

From Release

Bug#(s)

Patch

Description

Additional comments

18c

NA

NA

NA

NA

12.2.0.1.0

27006180

 

 

Fix included in GI 12.1.0.2.180417 and latest

12.1.0.2

 

21255373

 

 

Recommended to install latest 12.1.0.2 GI PSU

 

17617807

 

GI PSU 22646198

11.2.0.4.160419 (Apr 2016) Grid Infrastructure Patch Set Update (GI PSU)

Fix included in 11.2.0.4.160419 GI PSU

Recommended to install latest* 11.2.0.4 GI PSU

21255373

GI PSU 22646198

11.2.0.4.160419 (Apr 2016) Grid Infrastructure Patch Set Update (GI PSU)

Recommended to install latest* 11.2.0.4 GI PSU

DB Upgrades to 19c

From Release

Bug#(s)

Patch

Description

Additional comments

18c

NA

NA

NA

NA

12.2.0.1.0

27006180

 

LNX-191-EXA:CSSD PROCESS CANNOT GET REAL-TIME PRIORITY

Fix included in GI 12.1.0.2.180417 and latest

12.1.0.2

 

21255373

 

 

11.2.0.4

17617807

 

GI PSU 22646198

11.2.0.4.160419 (Apr 2016) Grid Infrastructure Patch Set Update (GI PSU)

21255373

GI PSU 22646198

11.2.0.4.160419 (Apr 2016) Grid Infrastructure Patch Set Update (GI PSU)

Managing older database with 19c ASM

With Release

Bug#(s)

Patch

Description

Additional comments

18c DB

None

None

None

None

12.2.0.1 DB

None

None

None

None

12.1.0.2 DB

 

21626377

21626377

12.2_150812: DBCA FAILS TO CREATE 12102 DB OVER 12.2 GI/ASM

Install 12.1.0.2.170718 DB PSU or later

Install 12.1.0.2.170117 DB Proactive BP or later

 

21780146

21780146

LNX64-12.2-WLM: MGMTDB FAILED TO BE CREATED DURING POST GI INSTALLATION

11.2.0.4 DB

23519414

23186035

W2K12_122_CMP: CREATE 11204DB WITH 122 ENV AFTER 1120419DBBP HIT ORA-00955

 11.2.0.4.190416 (Apr 2019) GI PSU or later

DB Downgrades from 19c

To Release

Bug#(s)

Patch

Description

Additional comments

18c (CDB and non-CDB, PDB unplug/plug/upgrade/downgrade/unplug/plug/catrelod)

28655784

28655784

Oct 2018 Database Release Update 18.4.0.0.0 or later

Install latest RU

12.2.0.1 (CDB)

28822515

 28822515

Jan 2019 Database Release Update 12.2.0.1.190115 or later 

 Install latest RU

12.1.0.2 (with CDB)

28259833

28259833

Oct 2018 Database Patch Set Update 12.1.0.2.181016 or later

Install latest* DB PSU patch

24438034

24438034

CDB_UPG: 12101 CDB UPGRADE LEFT OBJECT CDB_JAVA_POLICY INVALID

Available on top of 12.1.0.2.170418

20348910

20348910

ALTER TYPE REPLACE IN PRVTAQJI.SQL TO BE REPLACE WITH CREATE OR REPLACE TYPE

Available on top of 12.1.0.2

Available on top of 12.1.0.2.7 Proactive BP

20958816

20958816

INVALID OBJECTS AFTER DOWNGRADE FROM 12.2.0.1 TO 12.1.0.2

Install 12.1.0.2.160719 Proactive BP or later

12.1.0.2.0 (PDB unplug/plug/upgrade/downgrade/unplug/plug/catrelod)

 25869760

 26022196

 Database Proactive Bundle Patch 12.1.0.2.170718 or later

 

19370504

19370504

CDB:ORA-13613 IN NONCDB 12102 UPGRADED APPS DB PLUGIN AS PDB

12.1.0.2.180116 (Jan 2018) Database PSU or later
12.1.0.2.180116 (Jan 2018) Database Proactive BP or later

27189168

27189168

CATRELOD.SQL HIT ORA-65033 DURING PLUGGABLE DATABASE DOWNGRADE FROM 18C TO 12102

Available on top of 12.1.0.2.170718 ProactiveBP

12.1.0.2(non-CDB)

28259833

28259833

Oct 2018 Database Patch Set Update 12.1.0.2.181016 or later

Install latest DB PSU patch

24438034

24438034

CDB_UPG: 12101 CDB UPGRADE LEFT OBJECT CDB_JAVA_POLICY INVALID

Available on top of 12.1.0.2.160719 DB PSU

Available on top of12.1.0.2.170418 DB PSU

Available on top of 12.1.0.2.160719 Proactive BP

20348910

20348910

ALTER TYPE REPLACE IN PRVTAQJI.SQL TO BE REPLACE WITH CREATE OR REPLACE TYPE

Available on top of 12.1.0.2

Available on top of 12.1.0.2.160719 Proactive BP

20958816

20958816

INVALID OBJECTS AFTER DOWNGRADE FROM 12.2.0.1 TO 12.1.0.2

Install 12.1.0.2.160719 Proactive BP or later

12.2.0.1 (non-CDB)

28822515

28822515

DB RU

Install Latest DB RU

 

 

 

 

 

11.2.0.4

28204707

28204707

 Oct 2018 DB PSU

Install latest DB PSU

20898997

20898997

XMLTYPESUP: QCTOXSNLB SHOULD NOT CHECK AGAINST SNAPSHOT SIZE

On top of 11.2.0.4

20348910

20348910

ALTER TYPE REPLACE IN PRVTAQJI.SQL TO BE REPLACE WITH CREATE OR REPLACE TYPE

Available for 11.2.0.4

 

GI Downgrades from 19c

To 12.2.0.1

None

N/A

N/A

 

No additional patches required to downgrade GI (Downgraded to the level using the same GIPSUs they were upgraded from). More patch info is mentioned in the GI upgrade category

 

 

To 12.1.0.2

None

N/A

N/A

To 12.1.0.1

None

N/A

N/A

To 11.2.0.4

None

N/A

N/A

 

 

 


Oracle DBA

anuj blog Archive