Search
Sudipta Bhaskar
Apr 26, 20243 min read
How to Convert Physical Standby To Active DataGuard
Standby database SQL> select open_mode , protection_mode , database_role from v$database; OPEN_MODE Â Â Â PROTECTION_MODE Â DATABASE_ROLE...
134 views0 comments
Sudipta Bhaskar
Dec 21, 20232 min read
ORA-00845: MEMORY_TARGET not supported on this system
srvctl start asm fails with the following error. [oracle@sbstandby ~]$ srvctl start asm PRCR-1079 : Failed to start resource ora.asm...
53 views0 comments
Sudipta Bhaskar
Jun 13, 20234 min read
Patch 35037840 - GI Release Update 19.19.0.0.230418 fails with ORA-00845:MEMORY_TARGET not supported
Patch 35037840 - GI Release Update 19.19.0.0.230418 fails with ORA-00845:MEMORY_TARGET not supported I was applying GI RU 35037840 in 19c...
81 views0 comments
Sudipta Bhaskar
Feb 16, 202226 min read
Sync RAC Standby 19c Database with ASM from RAC Primary Using Service
Due to unavailability of space in Data Diskgroup, standby was out of sync and after adding space it was not able to sync as the required...
132 views0 comments
Sudipta Bhaskar
Nov 10, 20211 min read
1Z0-083 Few Important Links
Following are few important links to prepare for the certification. Oracle® Multitenant Administrator’s Guide https://docs.oracle.com/en/...
22 views0 comments
Sudipta Bhaskar
Nov 10, 20211 min read
Certification Overview
This has been downloaded from oracle website. It contains syllabus and other sample questions for both 082 and 083. Please concentrate on...
17 views0 comments
Sudipta Bhaskar
Nov 3, 20212 min read
ERROR: The home is not clean. This home cannot be used since there was a failed OPatch execution
[oracle@seha1 grid]$ ./gridSetup.sh -silent -applyRU /dboracle/software/33204768 ERROR: The home is not clean. This home cannot be used...
63 views0 comments
Sudipta Bhaskar
May 8, 202126 min read
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...
725 views0 comments
Sudipta Bhaskar
May 7, 20211 min read
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...
631 views0 comments
Sudipta Bhaskar
May 7, 20212 min read
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...
47 views0 comments
Sudipta Bhaskar
May 3, 202123 min read
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....
1,218 views0 comments
Sudipta Bhaskar
Apr 28, 202111 min read
Downgrade 19c Grid to 12.2 in an Oracle RAC environment.
I have upgraded my 2 node RAC to 19.8 from 12.2 using GUI Method. But I want to create a blog post of upgrade using silent method. So, I...
1,221 views0 comments
Sudipta Bhaskar
Apr 27, 202112 min read
Softwarepatch level different in RAC nodes after GI PSU apply
crsctl query crs softwarepatch showing different output in different nodes. [oracle@OEL7N1 ~]$ crsctl query crs softwarepatch Oracle...
1,028 views1 comment
Sudipta Bhaskar
Apr 26, 202123 min read
Apr 21 PSU fails "oracle.opatch.opatchsdk.OPatchException: Re-link fails on target "install_srvm"
While applying 12.2 Apr 21 PSU (12.2.0.1.210420), it fails with "Failed during Patching: oracle.opatch.opatchsdk.OPatchException: Re-link...
1,022 views0 comments
Sudipta Bhaskar
Apr 22, 20211 min read
Apr 21 12.2 GI PSU fails with "OPATCHAUTO-72141: Grid is installed only on a single node"
I have recently faced this issue. While patching my newly built 12.2 RAC in rolling mode using opatchauto, it fails with following error....
146 views0 comments
Sudipta Bhaskar
Apr 14, 20211 min read
Create Amazon RDS PostgreSQL and Connect using psql and pgadmin
Login to Amazon AWS Console and Open Amazon RDS Section Follow the following steps to create a RDS PostgreSQL Database Click on Create...
40 views0 comments
Sudipta Bhaskar
Apr 4, 20213 min read
Install PostgreSQL 13 using yum/dnf in redhat linux 8
This post will explain the installation process of PostgreSQL 13 in redhat linux 8 We are following the yum/dnf method of installation...
759 views0 comments
Sudipta Bhaskar
Jul 11, 20205 min read
Oracle RAC 12.2 Installation Using Virtualbox
This post will give detailed step by step process to install Oracle RAC 12.2 on Oracle Linux 7 using virtualbox. 1. Software Requirement...
552 views0 comments