Mir Sayeed Hassan – Oracle Blog

Apply the Latest OPatch (12.2.0.1.37) for Oracle Database 19C

Check the status of Database

SQL> select instance_name, version, open_mode from V$database, v$instance;

INSTANCE_NAME VERSION OPEN_MODE
---------------- ----------------- --------------------
PEPSTAGE 19.0.0.0.0 READ WRITE

Check the last updated OPatch

[oracle@stagdb... 
Read more..			

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 Oracle Grid Infrastructure using...
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 reserved.
Connected... 
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.,
– To perform the resume database you...
Read more..