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 April, 2023

Error occur while detecting ASM as Oracle Grid infrastructure is not configured properly in Oracle Database

Posted by Mir Sayeed Hassan on 29th April 2023

Error occur while detecting ASM as Oracle Grid infrastructure is not configured properly ASMCA needs Oracle Grid Infrastructure to configure ASM in Single Instance ASM Database Brief: – First of all the Grid Infrastructure is install with standalone server only option – Due to this the error occur while adding an ASM Disk into the Read More

Posted in ASM | Comments Off on Error occur while detecting ASM as Oracle Grid infrastructure is not configured properly in Oracle Database

Backup and restore tablespace by using the RMAN ENCRYPTION Method in Oracle 19c

Posted by Mir Sayeed Hassan on 29th April 2023

Backup and restore tablespace by using the RMAN ENCRYPTION Method in Oracle 19c Login to Database. [oracle@testdb ~]$ sqlplus sys/testdb as sysdba SQL*Plus: Release 19.0.0.0.0 – Production on Tue Nov 8 04:03:38 2022 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition… Read more..

Posted in RMAN | Comments Off on Backup and restore tablespace by using the RMAN ENCRYPTION Method in Oracle 19c

How to drop all object from Schema in Oracle Database.

Posted by Mir Sayeed Hassan on 29th April 2023

How to drop all object from Schema in Oracle Database. In this scenario., we are going to drop all the objects under the schema Check the status of database. [oracle@ora21cdb ~]$ sqlplus / as sysdba SQL*Plus: Release 21.0.0.0.0 – Production on Wed Apr 26 16:43:19 2023 Version 21.3.0.0.0 Copyright (c) 1982, 2021, Oracle. All rights Read More

Posted in Oracle SQL | Comments Off on How to drop all object from Schema in Oracle Database.

The Suspended (Resumable) Statement has Timed Out in Oracle Database 11gR2(11.2.0.4)

Posted by Mir Sayeed Hassan on 26th April 2023

The Suspended (Resumable) Statement has Timed Out in Oracle Database 11gR2(11.2.0.4):  ORA-30032: Issue: This issue was occur while doing a transaction in real-time database & it’s was hung for few seconds & get the error SQL> select instance_name, version, status, open_mode from V$database, v$instance; INSTANCE_NAME VERSION… Read more..

Posted in DBA Administration | Comments Off on The Suspended (Resumable) Statement has Timed Out in Oracle Database 11gR2(11.2.0.4)

How to Suspend and Resume a Database stage in Oracle 19c DB

Posted by Mir Sayeed Hassan on 26th April 2023

How to Suspend and Resume a Database stage in Oracle 19c DB – To perform the suspend database you have to use the alter system suspend command at database level., In this stage the datbase is completely suspended and does not any operation on database and database in the state of suspend as shown below., Read More

Posted in DBA Administration | Comments Off on How to Suspend and Resume a Database stage in Oracle 19c DB