Oracle And Cloud

May 8
26 min

How to upgrade Oracle RAC Database from 12.2.0.1 to 19.8

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

67 views0 comments

Sudipta Bhaskar

May 7
1 min

PRCS-1007 : Server pool orcl already exists

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

11 views0 comments

Sudipta Bhaskar

May 7
2 min

How to enable archivelog mode in Oracle RAC Database

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

8 views0 comments

How To Upgrade RAC Grid Infrastructure from 12.2 to 19.8 in Silent Mode

Sudipta Bhaskar

May 2
23 min

How To Upgrade RAC Grid Infrastructure from 12.2 to 19.8 in Silent Mode

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

137 views0 comments

sudipta.bhaskar@gmail.com

CONTACT

+919811970620