Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

  • Translate

  • It’s Me






  • My Certificates

  • Links

    My Acclaim Certification : Credly Profile
    My Oracle ACE Pro Profile

  • Achievements

    Awarded Top 100 Oracle Blogs from Worldwide - #RANK 39
  • VISITORS COUNT

  • Verified International Academic Qualification from World Education Service (WES)

    Verified International Academic Qualification from World Education Service (WES)

  • Jobs

Archive for the 'RAC' Category

How to configure the 2 Node RAC Dataguard in Oracle 11gR2(11.2.0.4)

Posted by Mir Sayeed Hassan on 7th May 2020

How to configure the 2 Node RAC Dataguard in Oracle 11gR2(11.2.0.4) I’m going for step by step configuration for the 2 Node RAC Dataguard/Standby in Oracle Linux. Let us take the below environment in this example:

Posted in RAC | Comments Off on How to configure the 2 Node RAC Dataguard in Oracle 11gR2(11.2.0.4)

How to add the ASM DISK into Existing disks in RAC Database on Oracle 11gR2

Posted by Mir Sayeed Hassan on 25th April 2020

How to add the ASM DISK into Existing disks in RAC DB Server In the below scenario, we are going to add the new asm disk into the existing disk in RAC DB Server First Scan the newly added disk into the server [root@rac1-testdb~]# echo “- – -“> /sys/class/scsi_host/host0/scan [root@rac1-testdb… Read more..

Posted in RAC | Comments Off on How to add the ASM DISK into Existing disks in RAC Database on Oracle 11gR2

Re-configuration of the Enterprise Manager in RAC Database for 11gR2

Posted by Mir Sayeed Hassan on 13th May 2019

Re-configuration of the Enterprise Manager in RAC Database for 11gR2 Get the current status of the enterprise manager of RAC database Check the status of the Enterprise Manager in database Error: [oracle(rac_1)@trac1 bin$./emctl status dbconsole OC4J Configuration issue. /u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_An… Read more..

Posted in RAC | Comments Off on Re-configuration of the Enterprise Manager in RAC Database for 11gR2

How to perform manual switchover for RAC DB in Oracle 11gR2 (11.2.0.4)

Posted by Mir Sayeed Hassan on 15th April 2019

How to perform manual switchover for RAC DB in Oracle 11gR2 (11.2.0.4) In brief – The below switchover is to perform manual switchover for RAC DB – Here the primary will act as standby & standby will act as primary. My current RAC Test DB Resources are – 2 Node of Primary Database & 1 Read More

Posted in RAC | Comments Off on How to perform manual switchover for RAC DB in Oracle 11gR2 (11.2.0.4)

How to Install & Configure the OSWATCHER (OSWbb) in RAC Database

Posted by Mir Sayeed Hassan on 16th January 2019

How to Install & COnfigure the OSWATCHER (OSWbb) in RAC Database This Oracle OSWatcher Black Box (OSWbb) is mainly used in RAC Database for collects & archive OS & Network metrics which use to diagnose performance issue & it Should be install in every NODE of RAC DB. It will invoke the unix utilities are Read More

Posted in RAC | Comments Off on How to Install & Configure the OSWATCHER (OSWbb) in RAC Database

RAC DB Command for CRSCTL & SRVCTL in Oracle 11gR2

Posted by Mir Sayeed Hassan on 15th January 2019

RAC DB Command for CRSCTL & SRVCTL in Oracle 11gR2 CRSCTL COMMANDS Database Status SQL> select instance_name,version, status from v$instance; INSTANCE_NAME VERSION STATUS —————- —————– ———— rac_1 11.2.0.4.0 OPEN Login to the grid user… Read more..

Posted in RAC | Comments Off on RAC DB Command for CRSCTL & SRVCTL in Oracle 11gR2