Upgrade 2 Node RAC Oracle Database from 12c to 19c using DBUA

Pre-Upgrade Tasks 1. Execute preupgrade script and resolve error and perform all actions mentioned in log /u101/app/oracle/12cR1/product/db_12c/jdk/bin/java -jar /u101/app/oracle/19CH/product/db_home/rdbms/admin/preupgrade.jar TERMINAL TEXT select object_name, original_name, type, can_undrop as "UND", can_purge as "PUR", droptime from recyclebin; PURGE DBA_RECYCLEBIN; select count(*) from recyclebin; rman target /list archivelog all;delete archivelog all;crosscheck archivelog all; set linesize 500col NAME for a50select name, ROUND(SPACE_LIMIT/1024/1024/1024,2) "Allocated Space(GB)",round(SPACE_USED/1024/1024/1024,2) …

Complete Checklist for Upgrading Oracle Database 12c to 19c

Requirements and Recommendation for source database 1. Ensure that all database components/objects provided by Oracle are VALID in the source database prior to starting the upgrade. Note: - There should be no INVALID objects in SYS/SYSTEM or user schemas before database upgrade. 1.1 Verify users SYS and SYSTEM have assigned default tablespace SYSTEM select  * …

Enable Flashback and create guaranteed restore point in RAC

[oracle@node1 PATCH]$ srvctl status database -d PROD Instance prod1 is running on node node1 Instance prod2 is running on node node2 [oracle@node1 PATCH]$ [oracle@node1 PATCH]$ srvctl stop database -d PROD -o immediate [oracle@node1 PATCH]$ [oracle@node1 PATCH]$ srvctl status database -d PROD Instance prod1 is not running on node node1 Instance prod2 is not running on …

Applying a Grid Infrastructure Patch Before Grid Infrastructure Configuration and before rootupgrade.sh is executed

Note :- 1. Unzip Grid Infrastructure Gold Image/GI upgrade patch 19c to the Desired GI Home Location on the Local Node as the Grid user 2. Download and Install the latest OPatch Version (Patch 6880880) to the extracted GI Gold Image/GI upgrade patch 19c as the Grid user For e.g GI Release Update 19.14.0 (33509923) …

Sequences to Stop and Start RAC Services

1.. Shutdown LISTENER[oragrid@node1 ~]$ srvctl status listener -n node1.askmedawaa.comListener LISTENER is enabled on node(s): node1.askmedawaa.comListener LISTENER is running on node(s): node1.askmedawaa.com[oragrid@node1 ~]$ srvctl stop listener -n node1.askmedawaa.com[oragrid@node1 ~]$[oragrid@node1 ~]$ srvctl status listener -n node1.askmedawaa.comListener LISTENER is enabled on node(s): node1.askmedawaa.comListener LISTENER is not running on node(s): node1.askmedawaa.com1.1 Login in to another node which you have …

Upgrade to Oracle 19c GRID Infrastructure from 12c GRID Bingo !!!!

1.. login to GRID Primary node as GRID Owner 2.. Navigate to 19c_GRID_HOME and execute gridSetup.sh if you have already applied RUP patches. For me i have already applied RUP 19.14.X cd /u101/app/19.3.0/grid/grid_home [oragrid@node1 grid_home]$ [oragrid@node1 grid_home]$ unset ORACLE_BASE [oragrid@node1 grid_home]$ [oragrid@node1 grid_home]$ unset ORACLE_HOME [oragrid@node1 grid_home]$ [oragrid@node1 grid_home]$ unset ORACLE_SID [oragrid@node1 grid_home]$ ./gridSetup.sh 3.. …

When the software home is already registered in the central inventory

Cause :- Before executing gridsetup.sh , the Dry-Run Upgrade  was performed by executing the command: gridSetup.sh -dryRunForUpgrade And The gridSetup.sh -dryRunForUpgrade command updates the Oracle Inventory (oraInventory) with the new Oracle Grid Infrastructure home. Login as grid user :- [oragrid@node1 grid_home]$ /u101/app/19.3.0/grid/grid_home/oui/bin/runInstaller -silent -waitforcompletion -detachHome ORACLE_HOME='/u101/app/19.3.0/grid/grid_home' -local Starting Oracle Universal Installer... Checking swap space: must …

SEVERE: Remote ‘AttachHome’ failed on nodes – 2 Node – RAC Installation

When installing 2 node RAC, you may encountered given below error. Error:- SEVERE: Remote 'AttachHome' failed on nodes: 'node2'. Refer to '/u101/app/oraInventory/logs/installActions2022-03-17_12-37-21PM.log' for details.It is recommended that the following command needs to be manually run on the failed nodes:/u101/app/12cR1/grid/grid_home/oui/bin/runInstaller -attachHome -noClusterEnabled ORACLE_HOME=/u101/app/12cR1/grid/grid_home ORACLE_HOME_NAME=OraGI12Home1 CLUSTER_NODES=node1,node2 -force "INVENTORY_LOCATION=/u101/app/oraInventory" LOCAL_NODE=.Please refer 'AttachHome' logs under central inventory of remote …

Patches to apply before upgrading Oracle GI and DB to 19c or downgrading to previous release

1.. If doing GI Upgrade to 19c then given below patches are mandatory for e.g 28553832 and 21255373 for upgrade from 12.1.0.2 2.. Similarly, if doing DB Upgrades to 19c then given below patches are mandatory for e.g 28553832 and 21255373 for upgrade from 12.1.0.2 3.. Login as GRID owner and RDBMS owner  - node1.askmedawaa.com …

Running dry-run Upgrade for Oracle 19c GRID Infrastructure Bingo !!!!

1.. login to server as GRID owner  and navigate to cd $GRID_HOME unset ORACLE_BASE unset ORACLE_HOME unset ORACLE_SID Note :- Prior running dry run upgrade. Create 19c Grid Home directories in all available nodes. Only in primary Grid Node unzip 19c base release to the 19c Grid Home ./gridSetup.sh –dryRunForUpgrade 2.. Select Upgrade Oracle Grid …