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

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

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

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

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