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