Oracle And Cloud

This post is about upgrading multitenant RAC Database from 12c to 19c. I will attempt this in silent mode. Following are the details of my current RAC. Following are the main steps of upgrade. Install Oracle 19.3 db home binary. Executing preupgrade jar Performing the pre upgrade actions Backing up the database / Create a guaranteed restore point Upgrade the database Perform the post upgrade actions Let's first create the folder structure /dboracle/app/oracle/product/19.0/dbh

This post is about fixing "PRCS-1007 : Server pool orcl already exists" While upgrading my RAC database, i have removed database from oracle restart. But I need to add that back. But, while registering the database again, i got the following errors. [oracle@OEL7N1 ~]$ srvctl add database -d orcl -oraclehome /dboracle/app/oracle/product/12.2.0/dbhome_1 -dbtype RAC -spfile +DATA/ORCL/PARAMETERFILE/spfile.272.1070782447 -pwfile +DATA/ORCL/PASSWORD/pwdorcl.256.1070782021 PRCS-10

I will modify my newly created RAC database from noarchivelog to archivelog mode. SQL> archive log list Database log mode No Archive Mode Automatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 20 Current log sequence 21 [oracle@OEL7N1 admin]$ srvctl config orcl [oracle@OEL7N1 admin]$ srvctl status database -d orcl -v Instance orcl1 is running on node oel7n1 with online services p

I Searched over the internet and couldn't find many post on RAC Grid Upgrade in silent mode. That's why I thought of writing this post. Right now I have a 12.2 RAC Setup and I will upgrade it to 19.8. Following are the network configuration. # Public 192.168.126.11 OEL7N1.localdomain OEL7N1 192.168.126.21 OEL7N2.localdomain OEL7N2 # Private 192.168.100.11 OEL7N1-priv.localdomain OEL7N1-priv 192.168.100.21 OEL7N2-priv.localdomain OEL7N2-priv # Virtual