Oracle And Cloud

Sudipta Bhaskar

Apr 26
3 min

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...

51 views0 comments

Sudipta Bhaskar

Dec 21, 2023
2 min

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...

23 views0 comments

Sudipta Bhaskar

Jun 13, 2023
4 min

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...

59 views0 comments

Sudipta Bhaskar

Feb 16, 2022
26 min

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...

121 views0 comments

Sudipta Bhaskar

Nov 10, 2021
1 min

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/...

21 views0 comments

Sudipta Bhaskar

Nov 10, 2021
1 min

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, 2021
2 min

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...

50 views0 comments

How to upgrade Oracle RAC Database from 12.2.0.1 to 19.8

Sudipta Bhaskar

May 8, 2021
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...

667 views0 comments

Sudipta Bhaskar

May 7, 2021
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...

518 views0 comments

Sudipta Bhaskar

May 7, 2021
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...

43 views0 comments

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

Sudipta Bhaskar

May 3, 2021
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....

1,129 views0 comments

Downgrade 19c Grid to 12.2 in an Oracle RAC environment.

Sudipta Bhaskar

Apr 28, 2021
11 min

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,107 views0 comments

Sudipta Bhaskar

Apr 27, 2021
12 min

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...

893 views0 comments

Sudipta Bhaskar

Apr 26, 2021
23 min

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...

932 views0 comments

Apr 21 12.2 GI PSU fails with "OPATCHAUTO-72141: Grid is installed only on a single node"

Sudipta Bhaskar

Apr 22, 2021
1 min

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....

138 views0 comments

Create Amazon RDS PostgreSQL and Connect using psql and pgadmin

Sudipta Bhaskar

Apr 14, 2021
1 min

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...

36 views0 comments

Install PostgreSQL 13 using yum/dnf in redhat linux 8

Sudipta Bhaskar

Apr 4, 2021
3 min

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...

608 views0 comments

Oracle RAC 12.2 Installation Using Virtualbox

Sudipta Bhaskar

Jul 11, 2020
5 min

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...

516 views0 comments

Home: Blog2

sudipta.bhaskar@gmail.com

Home: Subscribe

CONTACT

sudipta.bhaskar@gmail.com

+919811970620

Home: Contact